R_PurOrdExternalReference

DDL: R_PURORDEXTERNALREFERENCE Type: view_entity BASIC Package: VDM_MM_PUR_PO
9 Fields 2 Data Sources

PO External References

R_PurOrdExternalReference is a Basic CDS View that provides data about "PO External References" in SAP S/4HANA. It reads from 2 data sources (I_ExternalRefForPurgDoc, R_PurchaseOrder) and exposes 9 fields with key fields PurchaseOrder, LinkType, PurgExtRefSequenceNumber. Part of development package VDM_MM_PUR_PO.

Data Sources (2)

SourceAliasJoin Type
I_ExternalRefForPurgDoc ExtRef from
R_PurchaseOrder PO inner

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label PO External References view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder R_PurchaseOrder PurchaseOrder Purchasing Document
KEY LinkType I_ExternalRefForPurgDoc LinkType Link Types for Doc.
KEY PurgExtRefSequenceNumber I_ExternalRefForPurgDoc SequenceNumber Sort sequence
PurgDocExternalReference I_ExternalRefForPurgDoc PurgDocExternalReference Ext. Reference ID
PurgDocExternalSystem I_ExternalRefForPurgDoc PurgDocExternalSystem Ext. Ref. System
PurgDocExtReferenceNodeType I_ExternalRefForPurgDoc PurgDocExtReferenceNodeType Ext. Doc. Type
PurchaseOrderType R_PurchaseOrder PurchaseOrderType PO Type
PurchasingOrganization R_PurchaseOrder PurchasingOrganization Purchasing Organization
PurchasingGroup R_PurchaseOrder PurchasingGroup Purchasing Group

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 R_PurOrdExternalReference.
-- 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.

CREATE VIEW R_PurOrdExternalReference AS
SELECT
  PO.PurchaseOrder AS PurchaseOrder,
  ExtRef.LinkType AS LinkType,
  ExtRef.SequenceNumber AS PurgExtRefSequenceNumber,
  ExtRef.PurgDocExternalReference AS PurgDocExternalReference,
  ExtRef.PurgDocExternalSystem AS PurgDocExternalSystem,
  ExtRef.PurgDocExtReferenceNodeType AS PurgDocExtReferenceNodeType,
  PO.PurchaseOrderType AS PurchaseOrderType,
  PO.PurchasingOrganization AS PurchasingOrganization,
  PO.PurchasingGroup AS PurchasingGroup
FROM I_ExternalRefForPurgDoc AS ExtRef
INNER JOIN R_PurchaseOrder AS PO ON /* join condition not captured in parsed metadata */
;

Learn More