ACEPSOH

9 Fields 5 CDS Views

ACEPSOH is an SAP database table in S/4HANA. It contains 9 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
ACE_ACEDSOH_STATUS_F_01 view inner Finilize status field in ACEDSOH table
ACE_ACESOBJ view left_outer view ACESOBJ
ACE_ACESOBJ_ASSGMT view inner View From ACEOBJ ACEPSOH ACEDSASSGMT
ACE_ACESOBJ_PARAM view inner View From ACEOBJ ACEPSOH ACEDSOP
ACE_CHK_ACEPSOH_VS_VACEPSOH view from Check ACEPSOH with view ACEPSOH

Fields (9)

KeyField CDS FieldsUsed in Views
KEY bukrs bukrs 1
KEY comp comp 1
KEY mandt mandt 1
KEY objid objid 1
KEY ref_subkey ref_subkey 2
KEY subid subid 1
deactdate PREMTRE_FDATE 1
firstyear firstyear 1
lastyear lastyear 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 ACEPSOH (
    BUKRS,
    COMP,
    MANDT,
    OBJID,
    REF_SUBKEY,
    SUBID,
    DEACTDATE,
    FIRSTYEAR,
    LASTYEAR,
    PRIMARY KEY (BUKRS, COMP, MANDT, OBJID, REF_SUBKEY, SUBID)
);

Learn More