SAP ACEPSOIT Line Items for Accrual Item in Accrual Engine Table
Overview
ACEPSOIT is a standard SAP S/4HANA table that stores Line Items for Accrual Item in Accrual Engine data. There are total 22 fields in the ACEPSOIT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ACEPSOIT belongs to Accrual Engine (FI-GL-GL-ACE) module and is located in the package Accrual Engine: Posting Server Basis (ACE-PS).
In addition, following links provide an overview of foreign key relationships, if any, that link ACEPSOIT to other SAP tables and standard CDS views available based on ACEPSOIT table in S/4HANA 2020.
Techincal Settings of ACEPSOIT
Below are technical details of the table ACEPSOIT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ACEPSOIT Fields
The following table gives you an overview of the fields available in ACEPSOIT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| COMP | Accrual Engine Application Component | ACE_COMP | * | CHAR | 4 |
| BUKRS | Company Code | ACE_BUKRS | CHAR | 4 | |
| GJAHR | Fiscal Year in Accrual Engine | ACEPS_GJAHR | * | NUMC | 4 |
| OBJID | Accrual Object (Internal Display in Form of a GUID) | ACE_GUID | * | RAW | 16 |
| ACRTYPE | Accrual Type | ACE_ACRTYPE | TACE_ACRTYPE | CHAR | 6 |
| ACCRULE | Accounting Principle | ACCOUNTING_PRINCIPLE | TACC_PRINCIPLE | CHAR | 4 |
| DOCNR | Document Number of an Accrual Engine Document | ACEPS_DOCNR | CHAR | 15 | |
| VALCUM | Cumulative Amount | ACE_AMOUNT_CUMULATED | CURR | 23 | |
| VALTBP | Amount Currently Posted | ACE_AMOUNT_TBP | CURR | 23 | |
| CURRENCY | Currency Calculated/Posted in the Accrual Amounts | ACEDS_VALCURRENCY | * | CUKY | 5 |
| TRANSTYPE | Transaction in Accrual Engine | ACE_TRANSTYPE | CHAR | 1 | |
| PODATE | Posting Date | ACE_PODATE | DATS | 8 | |
| POPER | Posting Period in Financial Accounting | ACE_POPER | NUMC | 3 | |
| POYEAR | Fiscal Year in Financial Accounting | ACE_POYEAR | NUMC | 4 | |
| RUNID | Number (Run ID) of a Periodic Accrual Run in the Accl Engine | ACEPS_RUNID | CHAR | 10 | |
| AWTYP | Reference procedure | AWTYP | * | CHAR | 5 |
| AWKEY | Reference Key for Accounting Document | ACE_AWKEY | CHAR | 20 | |
| AWSYS | Logical system of source document | AWSYS | * | CHAR | 10 |
| TIMESTMP | Time Added (Greenwich Meantime) | ACE_HZSTMP | DEC | 16 | |
| REVERSAL_DOC | Indicator: Document Is a Reversal Document | ACEPS_FLAG_REVERSAL_DOC | CHAR | 1 | |
| REVERSED_DOC | Number of the Reversed Accrual Engine Document | ACEPS_DOCNR_REVERSED | CHAR | 15 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ACEPSOIT
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| ACEPSOIT | ACCRULE | : | TACC_PRINCIPLE |
| ACEPSOIT | ACRTYPE | : | TACE_ACRTYPE |
| ACEPSOIT | BUKRS | : | * |
| ACEPSOIT | COMP | : | * |
| ACEPSOIT | GJAHR | : | * |
| ACEPSOIT | OBJID | : | * |
| ACEPSOIT | VALID | : | * |