C_PRItemDetails

DDL: C_PRITEMDETAILS SQL: CPRITEMDETAILS Type: view COMPOSITE
30 Fields 4 Data Sources

PR Items for GR

C_PRItemDetails is a Composite CDS View that provides data about "PR Items for GR" in SAP S/4HANA. It reads from 4 data sources (P_PurOrdItmsWithSglSchedLine, P_PurOrdsForConfirmation, P_PurOrdItmsForConf, P_PurReqnItmsForConf) and exposes 30 fields with key fields PurchaseRequisition, PurchaseRequisitionItem, PurchasingDocument, PurchasingDocumentItem.

Data Sources (4)

SourceAliasJoin Type
P_PurOrdItmsWithSglSchedLine POItemConfirmedQuantity inner
P_PurOrdsForConfirmation PurOrder inner
P_PurOrdItmsForConf PurOrderItem inner
P_PurReqnItmsForConf PurRequisitionItem from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CPRITEMDETAILS view
VDM.viewType #COMPOSITE view
EndUserText.label PR Items for GR view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition P_PurReqnItmsForConf PurchaseRequisition Requisition
KEY PurchaseRequisitionItem P_PurReqnItmsForConf PurchaseRequisitionItem Requisn. item
KEY PurchasingDocument P_PurOrdItmsForConf PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem P_PurOrdItmsForConf PurchasingDocumentItem Purchasing Doc. Item
PurReqnItemCurrency P_PurReqnItmsForConf PurReqnItemCurrency Currency
CreatedByUser P_PurReqnItmsForConf CreatedByUser User Name
PurchasingGroup P_PurReqnItmsForConf PurchasingGroup Purchasing Group
CreationDate P_PurReqnItmsForConf CreationDate Time Stamp
PurReqnDescription P_PurReqnItmsForConf PurReqnDescription PurReqn Description
PurchaseRequisitionType P_PurReqnItmsForConf PurchaseRequisitionType Order Type
ItemNetAmount
Plant P_PurReqnItmsForConf Plant Valuation Area
PurchasingOrganization P_PurReqnItmsForConf PurchasingOrganization Purchasing Organization
PurReqnSSPRequestor P_PurReqnItmsForConf PurReqnSSPRequestor Requestor
PurReqnSSPAuthor P_PurReqnItmsForConf PurReqnSSPAuthor Author
ProcurementHubSourceSystem P_PurReqnItmsForConf ProcurementHubSourceSystem Connected System ID
ExtCompanyCodeForPurg P_PurReqnItmsForConf ExtCompanyCodeForPurg Company Code
ExtPlantForPurg P_PurReqnItmsForConf ExtPlantForPurg Plant
PurReqnIsValdInCntrlReqnProcg P_PurReqnItmsForConf PurReqnIsValdInCntrlReqnProcg Is Central PR Procg.
PurchaseReqnItemUniqueID P_PurReqnItmsForConf PurchaseReqnItemUniqueID Purch. Doc. ID
OrderQuantity P_PurOrdItmsForConf OrderQuantity Quantity
OrderQuantityUnit P_PurOrdItmsForConf OrderQuantityUnit Sales Unit
Material P_PurOrdItmsForConf Material Vehicle Model
PurchasingDocumentItemText P_PurOrdItmsForConf PurchasingDocumentItemText Short Text
Supplier P_PurOrdsForConfirmation Supplier Supplier
PurchaseOrderType P_PurOrdsForConfirmation PurchaseOrderType PO Type
PurOrdPurchasingGroup P_PurOrdsForConfirmation PurOrdPurchasingGroup Purchasing Group
PurOrdPurchasingOrganization P_PurOrdsForConfirmation PurOrdPurchasingOrganization Purchasing Organization
PurOrderItemPlant P_PurOrdItmsForConf PurOrderItemPlant Valuation Area
RoughGoodsReceiptQty P_PurOrdItmsWithSglSchedLine RoughGoodsReceiptQty Delivered

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_PRItemDetails.
-- 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: CPRITEMDETAILS

CREATE VIEW C_PRItemDetails AS
SELECT
  PurRequisitionItem.PurchaseRequisition AS PurchaseRequisition,
  PurRequisitionItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurOrderItem.PurchasingDocument AS PurchasingDocument,
  PurOrderItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  PurRequisitionItem.PurReqnItemCurrency AS PurReqnItemCurrency,
  PurRequisitionItem.CreatedByUser AS CreatedByUser,
  PurRequisitionItem.PurchasingGroup AS PurchasingGroup,
  PurRequisitionItem.CreationDate AS CreationDate,
  PurRequisitionItem.PurReqnDescription AS PurReqnDescription,
  PurRequisitionItem.PurchaseRequisitionType AS PurchaseRequisitionType,
  PurRequisitionItem.RequestedQuantity * PurRequisitionItem.PurchaseRequisitionPrice AS ItemNetAmount,
  PurRequisitionItem.Plant AS Plant,
  PurRequisitionItem.PurchasingOrganization AS PurchasingOrganization,
  PurRequisitionItem.PurReqnSSPRequestor AS PurReqnSSPRequestor,
  PurRequisitionItem.PurReqnSSPAuthor AS PurReqnSSPAuthor,
  PurRequisitionItem.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  PurRequisitionItem.ExtCompanyCodeForPurg AS ExtCompanyCodeForPurg,
  PurRequisitionItem.ExtPlantForPurg AS ExtPlantForPurg,
  PurRequisitionItem.PurReqnIsValdInCntrlReqnProcg AS PurReqnIsValdInCntrlReqnProcg,
  PurRequisitionItem.PurchaseReqnItemUniqueID AS PurchaseReqnItemUniqueID,
  PurOrderItem.OrderQuantity AS OrderQuantity,
  PurOrderItem.OrderQuantityUnit AS OrderQuantityUnit,
  PurOrderItem.Material AS Material,
  PurOrderItem.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  PurOrder.Supplier AS Supplier,
  PurOrder.PurchaseOrderType AS PurchaseOrderType,
  PurOrder.PurOrdPurchasingGroup AS PurOrdPurchasingGroup,
  PurOrder.PurOrdPurchasingOrganization AS PurOrdPurchasingOrganization,
  PurOrderItem.PurOrderItemPlant AS PurOrderItemPlant,
  POItemConfirmedQuantity.RoughGoodsReceiptQty AS RoughGoodsReceiptQty
FROM P_PurReqnItmsForConf AS PurRequisitionItem
INNER JOIN P_PurOrdItmsForConf AS PurOrderItem ON /* join condition not captured in parsed metadata */
INNER JOIN P_PurOrdsForConfirmation AS PurOrder ON /* join condition not captured in parsed metadata */
INNER JOIN P_PurOrdItmsWithSglSchedLine AS POItemConfirmedQuantity ON /* join condition not captured in parsed metadata */
;

Learn More