I_PurgDocHierarchyLink

DDL: I_PURGDOCHIERARCHYLINK SQL: IHIERDOCLINKS Type: view BASIC Package: VDM_MM_PUR_CCTR
9 Fields 1 Data Sources

Basic View for Hierarchy Document Links

I_PurgDocHierarchyLink is a Basic CDS View that provides data about "Basic View for Hierarchy Document Links" in SAP S/4HANA. It reads from 1 data source (mmdoc_hier_links) and exposes 9 fields with key fields PurchasingSourceDocumentID, PurchasingDocumentCategory, PurchasingHierarchyLinkType, PurchasingTargetDocumentID. Part of development package VDM_MM_PUR_CCTR.

Data Sources (1)

SourceAliasJoin Type
mmdoc_hier_links mmdoc_hier_links from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IHIERDOCLINKS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Basic View for Hierarchy Document Links view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PurchasingSourceDocumentID purchasingsourcedocid Purchasing Doc.
KEY PurchasingDocumentCategory documentcategory Document Category
KEY PurchasingHierarchyLinkType linktype Link Types for Doc.
KEY PurchasingTargetDocumentID purchasingtargetdocid Purchasing Doc.
PurgSourceDocumentSubtype sourcedocumentsubtype Control
PurgTargetDocumentSubtype targetdocumentsubtype Control
PurgTgtDocLastUpdateStatus targetdoclastupdatestatus Doc. Update Status
PurgTgtDocLastUpdateDateTime targetdoclastupdatetimestamp Last Changed
DistrResponseMessageUUID distributionresponseguid GUID

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_PurgDocHierarchyLink.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IHIERDOCLINKS

CREATE VIEW I_PurgDocHierarchyLink AS
SELECT
  purchasingsourcedocid AS PurchasingSourceDocumentID,
  documentcategory AS PurchasingDocumentCategory,
  linktype AS PurchasingHierarchyLinkType,
  purchasingtargetdocid AS PurchasingTargetDocumentID,
  sourcedocumentsubtype AS PurgSourceDocumentSubtype,
  targetdocumentsubtype AS PurgTargetDocumentSubtype,
  targetdoclastupdatestatus AS PurgTgtDocLastUpdateStatus,
  targetdoclastupdatetimestamp AS PurgTgtDocLastUpdateDateTime,
  distributionresponseguid AS DistrResponseMessageUUID
FROM mmdoc_hier_links
;

Learn More