ACEDSOI

Transparent Table Application Table
18 Fields 2 CDS Views

Item Data for Accrual Subobject

ACEDSOI is an SAP database table in S/4HANA. Item Data for Accrual Subobject. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
ACE_ACEDSOI_FILTER view from Gather Data from ACEDSOI
ACE_ACEDSOI_LEDGER_GRP view from ACEDSOI has ledger group assigned

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY comp ACE_COMP Component
KEY bukrs ACE_BUKRS Company Code
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 date_to ACE_DATETO To
date_from ACE_DATEFROM From
timestmp ACE_HZSTMP Time Added
amount ACE_TOTAL_AMOUNT Total Amt to Accrue
currency ACE_DS_CURRENCY Accrual Item Crcy
quantity ACE_TOTAL_QUANTITY Total Qty to Accrue
unit ACE_UNIT Unit of Measure
acrmethod ACEDS_ACRMETHOD Accr/Defrl Method
svality_from ACE_SVALDATE_FROM Start of Life
svality_to ACE_SVALDATE_TO End of Life
xobsolete ACEDS_XOBSOLETE Obsolete

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.

-- Item Data for Accrual Subobject
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACEDSOI (
    MANDT,         -- Client [MANDT]
    COMP,          -- Component [ACE_COMP]
    BUKRS,         -- Company Code [ACE_BUKRS]
    OBJID,         -- Accrual Object [ACE_GUID]
    SUBID,         -- Accrual Subobj. [ACE_SUBID]
    ACRTYPE,       -- Accrual Type [ACE_ACRTYPE]
    ACCRULE,       -- Accounting Principle [ACCOUNTING_PRINCIPLE]
    DATE_TO,       -- To [ACE_DATETO]
    DATE_FROM,     -- From [ACE_DATEFROM]
    TIMESTMP,      -- Time Added [ACE_HZSTMP]
    AMOUNT,        -- Total Amt to Accrue [ACE_TOTAL_AMOUNT]
    CURRENCY,      -- Accrual Item Crcy [ACE_DS_CURRENCY]
    QUANTITY,      -- Total Qty to Accrue [ACE_TOTAL_QUANTITY]
    UNIT,          -- Unit of Measure [ACE_UNIT]
    ACRMETHOD,     -- Accr/Defrl Method [ACEDS_ACRMETHOD]
    SVALITY_FROM,  -- Start of Life [ACE_SVALDATE_FROM]
    SVALITY_TO,    -- End of Life [ACE_SVALDATE_TO]
    XOBSOLETE,     -- Obsolete [ACEDS_XOBSOLETE]
    PRIMARY KEY (MANDT, COMP, BUKRS, OBJID, SUBID, ACRTYPE, ACCRULE, DATE_TO)
);

Learn More