SHDM_RELATION

Transparent Table Application Table
10 Fields 1 CDS Views

Object Node Instance Document

SHDM_RELATION is an SAP database table in S/4HANA. Object Node Instance Document. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_HDMRelation view_entity from BASIC HDM Relation Entity

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY sapobjectnodetype sbo_node_type SAP Obj Node Type
KEY linkedsapobjectkey shdm_linkedsapobjectkey
KEY baseobjecttype shdm_baseobjecttype
KEY baseobjectkey shdm_baseobjectkey
relationshipstatus shdm_relationshipstatus
createdby shdm_createdby
createdat timestampl Time Stamp
changedby shdm_changedby
changedat timestampl Time Stamp

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.

-- Object Node Instance Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SHDM_RELATION (
    MANDT,               -- Client [mandt]
    SAPOBJECTNODETYPE,   -- SAP Obj Node Type [sbo_node_type]
    LINKEDSAPOBJECTKEY,  -- shdm_linkedsapobjectkey
    BASEOBJECTTYPE,      -- shdm_baseobjecttype
    BASEOBJECTKEY,       -- shdm_baseobjectkey
    RELATIONSHIPSTATUS,  -- shdm_relationshipstatus
    CREATEDBY,           -- shdm_createdby
    CREATEDAT,           -- Time Stamp [timestampl]
    CHANGEDBY,           -- shdm_changedby
    CHANGEDAT,           -- Time Stamp [timestampl]
    PRIMARY KEY (MANDT, SAPOBJECTNODETYPE, LINKEDSAPOBJECTKEY, BASEOBJECTTYPE, BASEOBJECTKEY)
);

Learn More