SAP table ACEPSOIT (Line Items for Accrual Item in Accrual Engine)

SAP table ACEPSOIT has 9 primary key fields being MANDT,COMP,BUKRS,GJAHR,OBJID,SUBID,ACRTYPE,ACCRULE,DOCNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
COMP Accrual Engine Application Component CHAR 4 0 * ACE_COMP
BUKRS Company Code CHAR 4 0 ACE_BUKRS
GJAHR Fiscal Year in Accrual Engine NUMC 4 0 * ACEPS_GJAHR
OBJID Accrual Object (Internal Display in Form of a GUID) RAW 16 0 * ACE_GUID
SUBID Accrual Subobject (Internal Display, Sequence Number) NUMC 5 0 ACE_SUBID
ACRTYPE Accrual Type CHAR 6 0 TACE_ACRTYPE ACE_ACRTYPE
ACCRULE Accounting Principle CHAR 4 0 TACC_PRINCIPLE ACCOUNTING_PRINCIPLE
DOCNR Document Number of an Accrual Engine Document CHAR 15 0 ACEPS_DOCNR
VALCUM Cumulative Amount CURR 23 2 ACE_AMOUNT_CUMULATED
VALTBP Amount Currently Posted CURR 23 2 ACE_AMOUNT_TBP
CURRENCY Currency Calculated/Posted in the Accrual Amounts CUKY 5 0 * ACEDS_VALCURRENCY
TRANSTYPE Transaction in Accrual Engine CHAR 1 0 ACE_TRANSTYPE
C Transfer of Periodic Recognition
F Completion
I Inception
P Periodic Recognition
U Change of the Inception
EFFDATE Key Date/Posting Date for Accruals DATS 8 0 ACE_EFFDATE
PODATE Posting Date DATS 8 0 ACE_PODATE
POPER Posting Period in Financial Accounting NUMC 3 0 ACE_POPER
POYEAR Fiscal Year in Financial Accounting NUMC 4 0 ACE_POYEAR
RUNID Number (Run ID) of a Periodic Accrual Run in the Accl Engine CHAR 10 0 ACEPS_RUNID
AWTYP Reference procedure CHAR 5 0 * AWTYP
AWKEY Reference Key for Accounting Document CHAR 20 0 ACE_AWKEY
AWSYS Logical system of source document CHAR 10 0 * AWSYS
TIMESTMP Time Added (Greenwich Meantime) DEC 16 0 ACE_HZSTMP
REVERSAL_DOC Indicator: Document Is a Reversal Document CHAR 1 0 ACEPS_FLAG_REVERSAL_DOC
REVERSED_DOC Number of the Reversed Accrual Engine Document CHAR 15 0 ACEPS_DOCNR_REVERSED

ACEPSOIT foreign key relationships

Table Field Check Table Check Field
0 ACEPSOIT ACCRULE TACC_PRINCIPLE Accounting Principle MANDT
0 ACEPSOIT ACCRULE TACC_PRINCIPLE Accounting Principle ACC_PRINCIPLE
1 ACEPSOIT ACRTYPE TACE_ACRTYPE Accrual Types MANDT
1 ACEPSOIT ACRTYPE TACE_ACRTYPE Accrual Types COMP
1 ACEPSOIT ACRTYPE TACE_ACRTYPE Accrual Types ACRTYPE