MMDOC_HIER_LINKS

Transparent Table Application Table
10 Fields 1 CDS Views

Document links of a hierarchy document

MMDOC_HIER_LINKS is an SAP database table in S/4HANA. Document links of a hierarchy document. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PurgDocHierarchyLink view from BASIC Basic View for Hierarchy Document Links

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY purchasingsourcedocid EBELN Purchasing Doc.
KEY documentcategory BSTYP Doc. Category
KEY linktype MMPUR_HIER_DOC_LINK_TYPE Link Types for Doc.
KEY purchasingtargetdocid EBELN Purchasing Doc.
sourcedocumentsubtype BSAKZ Control
targetdocumentsubtype BSAKZ Control
targetdoclastupdatestatus MMPUR_DOCUMENT_UPDATE_STATUS Doc. Update Status
targetdoclastupdatetimestamp CHANGEDATETIME Last Changed
distributionresponseguid GUID16 GUID

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.

-- Document links of a hierarchy document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMDOC_HIER_LINKS (
    CLIENT,                        -- Client [MANDT]
    PURCHASINGSOURCEDOCID,         -- Purchasing Doc. [EBELN]
    DOCUMENTCATEGORY,              -- Doc. Category [BSTYP]
    LINKTYPE,                      -- Link Types for Doc. [MMPUR_HIER_DOC_LINK_TYPE]
    PURCHASINGTARGETDOCID,         -- Purchasing Doc. [EBELN]
    SOURCEDOCUMENTSUBTYPE,         -- Control [BSAKZ]
    TARGETDOCUMENTSUBTYPE,         -- Control [BSAKZ]
    TARGETDOCLASTUPDATESTATUS,     -- Doc. Update Status [MMPUR_DOCUMENT_UPDATE_STATUS]
    TARGETDOCLASTUPDATETIMESTAMP,  -- Last Changed [CHANGEDATETIME]
    DISTRIBUTIONRESPONSEGUID,      -- GUID [GUID16]
    PRIMARY KEY (CLIENT, PURCHASINGSOURCEDOCID, DOCUMENTCATEGORY, LINKTYPE, PURCHASINGTARGETDOCID)
);

Learn More