MMDOC_HIER_LINKS
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PurgDocHierarchyLink | view | from | BASIC | Basic View for Hierarchy Document Links |
Fields (10)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA