ACEDSOH

12 Fields 5 CDS Views

ACEDSOH is an SAP database table in S/4HANA. It contains 12 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 (12)

KeyField CDS FieldsUsed in Views
KEY bukrs bukrs 1
KEY comp comp 1
KEY date_to date_to 1
KEY objid objid 2
KEY ref_subkey ref_subkey 3
KEY subid subid 2
cpudt cpudt 1
cputm cputm 1
date_from date_from 1
uname uname 1
vality_from life_start_date,vality_from 2
vality_to vality_to 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACEDSOH (
    BUKRS,
    COMP,
    DATE_TO,
    OBJID,
    REF_SUBKEY,
    SUBID,
    CPUDT,
    CPUTM,
    DATE_FROM,
    UNAME,
    VALITY_FROM,
    VALITY_TO,
    PRIMARY KEY (BUKRS, COMP, DATE_TO, OBJID, REF_SUBKEY, SUBID)
);

Learn More