I_PurchaseContractExtReference

DDL: I_PURCHASECONTRACTEXTREFERENCE SQL: IPCHDREXTREF Type: view COMPOSITE
4 Fields 1 Data Sources 1 Associations

External References of Pur Contract Hdr

I_PurchaseContractExtReference is a Composite CDS View that provides data about "External References of Pur Contract Hdr" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContract) and exposes 4 fields with key field PurchaseContract. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContract CTR from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PurContrHdrExtReference Ext Ext.PurchaseContract = CTR.PurchaseContract and Ext.LinkType = 'PS'

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPCHDREXTREF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label External References of Pur Contract Hdr view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract Purchasing Doc.
PurgDocExternalSystem Ext PurgDocExternalSystem
PurchasingDocumentOrigin PurchasingDocumentOrigin Status
PurgDocExtReferenceNodeType Ext PurgDocExtReferenceNodeType Ext. Doc. Type

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_PurchaseContractExtReference.
-- 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: IPCHDREXTREF

CREATE VIEW I_PurchaseContractExtReference AS
SELECT
  PurchaseContract,
  Ext.PurgDocExternalSystem AS PurgDocExternalSystem,
  PurchasingDocumentOrigin,
  Ext.PurgDocExtReferenceNodeType AS PurgDocExtReferenceNodeType
FROM I_PurchaseContract AS CTR
LEFT OUTER JOIN I_PurContrHdrExtReference AS Ext ON Ext.PurchaseContract = CTR.PurchaseContract AND Ext.LinkType = 'PS'  -- association [0..1]
;

Learn More