I_EDCPurchaseOrderRecords

DDL: I_EDCPURCHASEORDERRECORDS Type: view_entity BASIC
16 Fields 2 Data Sources

EDC Relevant Purchase Order Records

I_EDCPurchaseOrderRecords is a Basic CDS View that provides data about "EDC Relevant Purchase Order Records" in SAP S/4HANA. It reads from 2 data sources (I_EDCPurchaseDocumentRelation, I_PurchaseOrder) and exposes 16 fields with key fields EDCType, EDCCompany, EDCCommonKey.

Data Sources (2)

SourceAliasJoin Type
I_EDCPurchaseDocumentRelation _EDCRelation from
I_PurchaseOrder _PurchaseOrder inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label EDC Relevant Purchase Order Records view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY EDCType I_EDCPurchaseDocumentRelation EDCType
KEY EDCCompany I_EDCPurchaseDocumentRelation EDCCompany
KEY EDCCommonKey I_EDCPurchaseDocumentRelation EDCCommonKey
PurchaseOrder I_EDCPurchaseDocumentRelation PurchaseOrder Purchasing Document
EDCRepresentationKey I_EDCPurchaseDocumentRelation EDCRepresentationKey
EDCRepresentationType I_EDCPurchaseDocumentRelation EDCRepresentationType
EDCRecordUUID I_EDCPurchaseDocumentRelation EDCRecordUUID
EDCCreatedOnDateTime I_EDCPurchaseDocumentRelation EDCCreatedOnDateTime
PurchaseOrderDate I_PurchaseOrder PurchaseOrderDate PO Date
PurchaseOrderType I_PurchaseOrder PurchaseOrderType PO Type
CompanyCode I_PurchaseOrder CompanyCode Receiver Company Code
PurchasingOrganization I_PurchaseOrder PurchasingOrganization Purchasing Organization
PurchasingGroup I_PurchaseOrder PurchasingGroup Purchasing Group
Supplier I_PurchaseOrder Supplier Supplier
SupplyingPlant I_PurchaseOrder SupplyingPlant Supplying Plant
Customer I_PurchaseOrder Customer Sold-to Party

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_EDCPurchaseOrderRecords.
-- 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 I_EDCPurchaseOrderRecords AS
SELECT
  _EDCRelation.EDCType AS EDCType,
  _EDCRelation.EDCCompany AS EDCCompany,
  _EDCRelation.EDCCommonKey AS EDCCommonKey,
  _EDCRelation.PurchaseOrder AS PurchaseOrder,
  _EDCRelation.EDCRepresentationKey AS EDCRepresentationKey,
  _EDCRelation.EDCRepresentationType AS EDCRepresentationType,
  _EDCRelation.EDCRecordUUID AS EDCRecordUUID,
  _EDCRelation.EDCCreatedOnDateTime AS EDCCreatedOnDateTime,
  _PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  _PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  _PurchaseOrder.CompanyCode AS CompanyCode,
  _PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  _PurchaseOrder.Supplier AS Supplier,
  _PurchaseOrder.SupplyingPlant AS SupplyingPlant,
  _PurchaseOrder.Customer AS Customer
FROM I_EDCPurchaseDocumentRelation AS _EDCRelation
INNER JOIN I_PurchaseOrder AS _PurchaseOrder ON /* join condition not captured in parsed metadata */
;

Learn More