Sunday, May 19, 2024

SAP Table ACEPSOIT – Line Items for Accrual Item in Accrual Engine

ACEPSOIT is a standard SAP table in SAP ECC (or) S/4HANA which stores Line Items for Accrual Item in Accrual Engine data. There are total 22 fields in ACEPSOIT table.This blog post provides key technical details of SAP table ACEPSOIT, including its availability across SAP S/4HANA versions and the list of CDS views for ACEPSOIT table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package Accrual Engine: Posting Server Basis (ACE-PS)
Technical Component Accrual Engine (FI-GL-GL-ACE)

SAP ACEPSOIT Table Fields

The following is the list of fields that are available in SAP ACEPSOIT table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
MANDT Client MANDT MANDT * CLNT (3)
COMP Accrual Engine Application Component ACE_COMP ACE_COMP * CHAR (4)
BUKRS Company Code ACE_BUKRS BUKRS CHAR (4)
GJAHR Fiscal Year in Accrual Engine ACEPS_GJAHR GJAHR * NUMC (4)
OBJID Accrual Object (Internal Display in Form of a GUID) ACE_GUID ACE_GUID * RAW (16)
ACRTYPE Accrual Type ACE_ACRTYPE ACE_ACRTYPE TACE_ACRTYPE CHAR (6)
ACCRULE Accounting Principle ACCOUNTING_PRINCIPLE ACCOUNTING_PRINCIPLE TACC_PRINCIPLE CHAR (4)
DOCNR Document Number of an Accrual Engine Document ACEPS_DOCNR CHAR15 CHAR (15)
VALCUM Cumulative Amount ACE_AMOUNT_CUMULATED AFLE15D2O20N_TO_23D2O30N CURR (23)
VALTBP Amount Currently Posted ACE_AMOUNT_TBP AFLE15D2O20N_TO_23D2O30N CURR (23)
CURRENCY Currency Calculated/Posted in the Accrual Amounts ACEDS_VALCURRENCY WAERS * CUKY (5)
TRANSTYPE Transaction in Accrual Engine ACE_TRANSTYPE ACE_TRANSTYPE CHAR (1)
PODATE Posting Date ACE_PODATE DATUM DATS (8)
POPER Posting Period in Financial Accounting ACE_POPER POPER NUMC (3)
POYEAR Fiscal Year in Financial Accounting ACE_POYEAR GJAHR NUMC (4)
RUNID Number (Run ID) of a Periodic Accrual Run in the Accl Engine ACEPS_RUNID ACEPS_RUNID CHAR (10)
AWTYP Reference procedure AWTYP AWTYP * CHAR (5)
AWKEY Reference Key for Accounting Document ACE_AWKEY AWKEY CHAR (20)
AWSYS Logical system of source document AWSYS LOGSYS * CHAR (10)
TIMESTMP Time Added (Greenwich Meantime) ACE_HZSTMP ACE_TSTMP DEC (16)
REVERSAL_DOC Indicator: Document Is a Reversal Document ACEPS_FLAG_REVERSAL_DOC FLAG CHAR (1)
REVERSED_DOC Number of the Reversed Accrual Engine Document ACEPS_DOCNR_REVERSED CHAR15 CHAR (15)

Availability

The SAP table ACEPSOIT is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Available?
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for ACEPSOIT table

There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.