ACEDSOH

Transparent Table Application Table
14 Fields 5 CDS Views

Accrual Subobject Header Data

ACEDSOH is an SAP database table in S/4HANA. Accrual Subobject Header Data. It contains 14 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
ACE_ACEDSOH_STATUS_F_01 view from Finilize status field in ACEDSOH table
ACE_ACEDSOI_LEDGER_GRP view inner ACEDSOI has ledger group assigned
ACE_ACEPSOIT_BASIC view left_outer basic view for ACEPSOIT
ACE_ACESOBJ view inner view ACESOBJ
ACE_CHK_ACEDSOH_INITIAL_DATE view from Entries with Date From 01010001

Fields (14)

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 date_to ACE_DATETO To
date_from ACE_DATEFROM From
vality_from ACE_VALDATE_FROM Start of Life
vality_to ACE_VALDATE_TO End of Life
uname ACE_UNAME User Name
cpudt ACE_CREATEDATE Date
cputm ACE_CREATETIME Time
ref_subkey ACE_REF_SUBKEY Ext Ref of Subobject
status ACEDS_HEADER_STATUS Lifecycle status

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.

-- Accrual Subobject Header Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACEDSOH (
    MANDT,        -- Client [MANDT]
    COMP,         -- Component [ACE_COMP]
    BUKRS,        -- Company Code [ACE_BUKRS]
    OBJID,        -- Accrual Object [ACE_GUID]
    SUBID,        -- Accrual Subobj. [ACE_SUBID]
    DATE_TO,      -- To [ACE_DATETO]
    DATE_FROM,    -- From [ACE_DATEFROM]
    VALITY_FROM,  -- Start of Life [ACE_VALDATE_FROM]
    VALITY_TO,    -- End of Life [ACE_VALDATE_TO]
    UNAME,        -- User Name [ACE_UNAME]
    CPUDT,        -- Date [ACE_CREATEDATE]
    CPUTM,        -- Time [ACE_CREATETIME]
    REF_SUBKEY,   -- Ext Ref of Subobject [ACE_REF_SUBKEY]
    STATUS,       -- Lifecycle status [ACEDS_HEADER_STATUS]
    PRIMARY KEY (MANDT, COMP, BUKRS, OBJID, SUBID, DATE_TO)
);

Learn More