C_PurchaseOrderGR

DDL: C_PURCHASEORDERGR SQL: CDOCLPOGR Type: view CONSUMPTION Package: ODATA_MM_PUR_DOCLIST
19 Fields 2 Data Sources

View for GR and Purchase Order

C_PurchaseOrderGR is a Consumption CDS View that provides data about "View for GR and Purchase Order" in SAP S/4HANA. It reads from 2 data sources (I_PurchaseOrderEnhanced, I_PurchaseorderItemEnhanced) and exposes 19 fields with key fields PurchaseOrder, PurchaseOrderItem. Part of development package ODATA_MM_PUR_DOCLIST.

Data Sources (2)

SourceAliasJoin Type
I_PurchaseOrderEnhanced EKKO inner
I_PurchaseorderItemEnhanced EKPO from

Annotations (6)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CDOCLPOGR view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.private true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseorderItemEnhanced PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_PurchaseorderItemEnhanced PurchaseOrderItem Purchasing Document Item
PurchasingGroup I_PurchaseOrderEnhanced PurchasingGroup Purchasing Group
SupplyingPlant I_PurchaseOrderEnhanced SupplyingPlant Supplying Plant
PurchaseOrderType I_PurchaseOrderEnhanced PurchaseOrderType PO Type
PurchaseOrderQty I_PurchaseorderItemEnhanced PurchaseOrderQty Purchase Order Quantity
PurchasingDocumentCategory I_PurchaseorderItemEnhanced PurchaseOrderItemCategory Item Category
PurchaseOrderItemNetAmount I_PurchaseorderItemEnhanced PurchaseOrderNetAmount Net Value
Currency I_PurchaseOrderEnhanced DocumentCurrency Document Currency
Plant I_PurchaseorderItemEnhanced Plant Valuation Area
PurchaseOrderItemText I_PurchaseorderItemEnhanced PurchaseOrderItemText Short Text
Material I_PurchaseorderItemEnhanced Material Vehicle Model
ManufacturerMaterial I_PurchaseorderItemEnhanced ManufacturerMaterial MPN: Material
MaterialGroup I_PurchaseorderItemEnhanced MaterialGroup Product Group
PurchaseOrderQuantityUnit I_PurchaseorderItemEnhanced PurchaseOrderQuantityUnit Order Unit
Supplier I_PurchaseOrderEnhanced Supplier Supplier
PurchasingOrganization I_PurchaseOrderEnhanced PurchasingOrganization Purchasing Organization
CompanyCode I_PurchaseorderItemEnhanced CompanyCode Receiver Company Code
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.

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 C_PurchaseOrderGR.
-- 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: CDOCLPOGR

CREATE VIEW C_PurchaseOrderGR AS
SELECT
  EKPO.PurchaseOrder AS PurchaseOrder,
  EKPO.PurchaseOrderItem AS PurchaseOrderItem,
  EKKO.PurchasingGroup AS PurchasingGroup,
  EKKO.SupplyingPlant AS SupplyingPlant,
  EKKO.PurchaseOrderType AS PurchaseOrderType,
  EKPO.PurchaseOrderQty AS PurchaseOrderQty,
  EKPO.PurchaseOrderItemCategory AS PurchasingDocumentCategory,
  EKPO.PurchaseOrderNetAmount AS PurchaseOrderItemNetAmount,
  EKKO.DocumentCurrency AS Currency,
  EKPO.Plant AS Plant,
  EKPO.PurchaseOrderItemText AS PurchaseOrderItemText,
  EKPO.Material AS Material,
  EKPO.ManufacturerMaterial AS ManufacturerMaterial,
  EKPO.MaterialGroup AS MaterialGroup,
  EKPO.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  EKKO.Supplier AS Supplier,
  EKKO.PurchasingOrganization AS PurchasingOrganization,
  EKPO.CompanyCode AS CompanyCode,
  IsEndOfPurposeBlocked
FROM I_PurchaseorderItemEnhanced AS EKPO
INNER JOIN I_PurchaseOrderEnhanced AS EKKO ON /* join condition not captured in parsed metadata */
;

Learn More