ACEPSOIT
Line Items for Accrual Item in Accrual Engine
ACEPSOIT is an SAP database table in S/4HANA. Line Items for Accrual Item in Accrual Engine. It contains 24 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| ACE_ACEPSOIT_ACEPSOITV_UNION | view | from | Union ACEPSOIT and view ACEPSOIT | |
| ACE_ACEPSOIT_BASIC | view | from | basic view for ACEPSOIT | |
| ACE_ACEPSOIT_SUM_01 | view | from | Calculate amount of each year |
Fields (24)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | comp | ACE_COMP | Component | |||
| KEY | bukrs | ACE_BUKRS | Company Code | |||
| KEY | gjahr | ACEPS_GJAHR | Fiscal Year | |||
| KEY | objid | ACE_GUID | Accrual Object | |||
| KEY | subid | ACE_SUBID | Accrual Subobj. | |||
| KEY | acrtype | ACE_ACRTYPE | Accrual Type | |||
| KEY | accrule | ACCOUNTING_PRINCIPLE | Accounting Principle | |||
| KEY | docnr | ACEPS_DOCNR | Document Number | |||
| valcum | ACE_AMOUNT_CUMULATED | Cumltv Amt | ||||
| valtbp | ACE_AMOUNT_TBP | Posted | ||||
| currency | ACEDS_VALCURRENCY | Currency PostAm | ||||
| transtype | ACE_TRANSTYPE | ACE Transaction | ||||
| effdate | ACE_EFFDATE | Key Date for Accrls | ||||
| podate | ACE_PODATE | Posting Date | ||||
| poper | ACE_POPER | FI Period | ||||
| poyear | ACE_POYEAR | FI Fiscal Year | ||||
| runid | ACEPS_RUNID | Run ID | ||||
| awtyp | AWTYP | Ref. procedure | ||||
| awkey | ACE_AWKEY | RefKey GJE | ||||
| awsys | AWSYS | Logical System | ||||
| timestmp | ACE_HZSTMP | Time Added | ||||
| reversal_doc | ACEPS_FLAG_REVERSAL_DOC | Reversal Document | ||||
| reversed_doc | ACEPS_DOCNR_REVERSED | Reversed Document |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Line Items for Accrual Item in Accrual Engine
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACEPSOIT (
MANDT, -- Client [MANDT]
COMP, -- Component [ACE_COMP]
BUKRS, -- Company Code [ACE_BUKRS]
GJAHR, -- Fiscal Year [ACEPS_GJAHR]
OBJID, -- Accrual Object [ACE_GUID]
SUBID, -- Accrual Subobj. [ACE_SUBID]
ACRTYPE, -- Accrual Type [ACE_ACRTYPE]
ACCRULE, -- Accounting Principle [ACCOUNTING_PRINCIPLE]
DOCNR, -- Document Number [ACEPS_DOCNR]
VALCUM, -- Cumltv Amt [ACE_AMOUNT_CUMULATED]
VALTBP, -- Posted [ACE_AMOUNT_TBP]
CURRENCY, -- Currency PostAm [ACEDS_VALCURRENCY]
TRANSTYPE, -- ACE Transaction [ACE_TRANSTYPE]
EFFDATE, -- Key Date for Accrls [ACE_EFFDATE]
PODATE, -- Posting Date [ACE_PODATE]
POPER, -- FI Period [ACE_POPER]
POYEAR, -- FI Fiscal Year [ACE_POYEAR]
RUNID, -- Run ID [ACEPS_RUNID]
AWTYP, -- Ref. procedure [AWTYP]
AWKEY, -- RefKey GJE [ACE_AWKEY]
AWSYS, -- Logical System [AWSYS]
TIMESTMP, -- Time Added [ACE_HZSTMP]
REVERSAL_DOC, -- Reversal Document [ACEPS_FLAG_REVERSAL_DOC]
REVERSED_DOC, -- Reversed Document [ACEPS_DOCNR_REVERSED]
PRIMARY KEY (MANDT, COMP, BUKRS, GJAHR, OBJID, SUBID, ACRTYPE, ACCRULE, DOCNR)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA