/SAPAPO/CHNBOD

Transparent Table Application Table
12 Fields 1 CDS Views

Edges in Location Hierarchies History

/SAPAPO/CHNBOD is an SAP database table in S/4HANA. Edges in Location Hierarchies History. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BillOfDistributionEdgeVers view_entity from BASIC Version of the BOD

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt /SAPAPO/CLNTAPO_MANDT Client
KEY relid /SAPAPO/RELID Hierarchy ID
KEY pnodeid /SAPAPO/LOCID_PARENT Parent Location
KEY cnodeid /SAPAPO/LOCID_CHILD Child Location
KEY chngnum AENNR Change Number
clevid /SAPAPO/RELLEVID Level ID
relvcnode /SAPAPO/RELVCNLOC Virt. Child Location
relnodeseq /SAPAPO/RELNODESEQ Sequence Number
created_by /SAPAPO/REL_CREATED_BY Created By User
created_at /SAPAPO/REL_CREATED_AT Created at
changed_by /SAPAPO/REL_CHANGED_BY Changed By User
changed_at /SAPAPO/REL_CHANGED_AT Changed at

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.

-- Edges in Location Hierarchies History
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SAPAPO/CHNBOD (
    MANDT,       -- Client [/SAPAPO/CLNTAPO_MANDT]
    RELID,       -- Hierarchy ID [/SAPAPO/RELID]
    PNODEID,     -- Parent Location [/SAPAPO/LOCID_PARENT]
    CNODEID,     -- Child Location [/SAPAPO/LOCID_CHILD]
    CHNGNUM,     -- Change Number [AENNR]
    CLEVID,      -- Level ID [/SAPAPO/RELLEVID]
    RELVCNODE,   -- Virt. Child Location [/SAPAPO/RELVCNLOC]
    RELNODESEQ,  -- Sequence Number [/SAPAPO/RELNODESEQ]
    CREATED_BY,  -- Created By User [/SAPAPO/REL_CREATED_BY]
    CREATED_AT,  -- Created at [/SAPAPO/REL_CREATED_AT]
    CHANGED_BY,  -- Changed By User [/SAPAPO/REL_CHANGED_BY]
    CHANGED_AT,  -- Changed at [/SAPAPO/REL_CHANGED_AT]
    PRIMARY KEY (MANDT, RELID, PNODEID, CNODEID, CHNGNUM)
);

Learn More