P_PurOrdItmsForConf

DDL: P_PURORDITMSFORCONF SQL: PPURORDITMFORCNF Type: view COMPOSITE
10 Fields 1 Data Sources

P_PurOrdItmsForConf is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItem) and exposes 10 fields with key fields PurchasingDocument, PurchasingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderItem PurOrderItem from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPURORDITMFORCNF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchaseOrderItem PurchaseOrder Purchasing Document
KEY PurchasingDocumentItem I_PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurchaseRequisition I_PurchaseOrderItem PurchaseRequisition Requisition
PurchaseRequisitionItem I_PurchaseOrderItem PurchaseRequisitionItem Requisn. item
OrderQuantity I_PurchaseOrderItem OrderQuantity Quantity
OrderQuantityUnit I_PurchaseOrderItem PurchaseOrderQuantityUnit Order Unit
Material I_PurchaseOrderItem Material Vehicle Model
PurchasingDocumentItemText I_PurchaseOrderItem PurchaseOrderItemText Short Text
PurOrderItemPlant I_PurchaseOrderItem Plant Valuation Area
PurchaseOrderItemUniqueID I_PurchaseOrderItem PurchaseOrderItemUniqueID Document Item

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 P_PurOrdItmsForConf.
-- 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: PPURORDITMFORCNF

CREATE VIEW P_PurOrdItmsForConf AS
SELECT
  PurOrderItem.PurchaseOrder AS PurchasingDocument,
  PurOrderItem.PurchaseOrderItem AS PurchasingDocumentItem,
  PurOrderItem.PurchaseRequisition AS PurchaseRequisition,
  PurOrderItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurOrderItem.OrderQuantity AS OrderQuantity,
  PurOrderItem.PurchaseOrderQuantityUnit AS OrderQuantityUnit,
  PurOrderItem.Material AS Material,
  PurOrderItem.PurchaseOrderItemText AS PurchasingDocumentItemText,
  PurOrderItem.Plant AS PurOrderItemPlant,
  PurOrderItem.PurchaseOrderItemUniqueID AS PurchaseOrderItemUniqueID
FROM I_PurchaseOrderItem AS PurOrderItem
;

Learn More