ACESLN1000002 SAP table for – Derivation Rule: Accounts

Here we would like to draw your attention to ACESLN1000002 table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). ACESLN1000002 is a SAP standard transp table used for storing Derivation Rule: Accounts related data in SAP. It comes under the package RE_EX_AL.

SAP ACESLN1000002 table

Table ACESLN1000002 technical data

TableACESLN1000002
Data storingDerivation Rule: Accounts
ModuleRE
Sub ModuleRE-FX-RA
SAP PackageRE_EX_AL
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-FIN
Table CategoryTRANSP

SAP ACESLN1000002 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in ACESLN1000002 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SOUR1_FROM : Accounting Principle
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • SOUR1_TO : Accounting Principle
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • SOUR2_FROM : Transaction in Accrual Engine
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • SOUR2_TO : Transaction in Accrual Engine
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • SOUR3_FROM : Accrual Type
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • SOUR3_TO : Accrual Type
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • VALID_FROM : Lower Range Limit for Current Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TARGET1 : Start Account
    Its data type is CHAR (Character String) with field length 10
  • TARGET2 : Target account
    Its data type is CHAR (Character String) with field length 10
  • DELETE_FLG : Character field,length 1
    Its data type is CHAR (Character String) with field length 1
  • ADDED_BY : Created by
    Its data type is CHAR (Character String) with field length 12
  • ADDED_ON : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8