ACEPSOIT

Transparent Table Application Table

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)

ViewTypeJoinVDMDescription
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)

KeyField Data ElementDescription DomainTypeLength
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)
);