P_PurOrdItmOverview

DDL: P_PURORDITMOVERVIEW SQL: PPOITMOVW Type: view CONSUMPTION
20 Fields 1 Data Sources 1 Associations

Purchase Order Item Overview

P_PurOrdItmOverview is a Consumption CDS View that provides data about "Purchase Order Item Overview" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItem) and exposes 20 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderItem I_PurchaseOrderItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] P_PurOrdItemNextDeliveryCalc _POItemNextDeliveryCalc _POItemNextDeliveryCalc.PurchaseOrder = $projection.PurchaseOrder and _POItemNextDeliveryCalc.PurchaseOrderItem = $projection.PurchaseOrderItem

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PPOITMOVW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Purchase Order Item Overview view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
Supplier _PurchaseOrder Supplier Supplier
SupplierName
MaterialGroup MaterialGroup Product Group
PurchasingGroup _PurchaseOrder PurchasingGroup Purchasing Group
Plant Plant Valuation Area
ObjectType
Material Material Vehicle Model
PurchasingOrganization _PurchaseOrder PurchasingOrganization Purchasing Organization
ServicePerformer ServicePerformer Service Performer
CostCenter CostCenter Cost Center
PurchasingDocument PurchaseOrder Purchasing Document
SupplyingPlant _PurchaseOrder SupplyingPlant Supplying Plant
PurchaseOrderItemText PurchaseOrderItemText Short Text
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
WorkItem
PurchasingDocumentType _PurchaseOrder PurchaseOrderType PO Type
PurgDocExternalItemCategory
PurchaseOrderType _PurchaseOrder PurchaseOrderType PO 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 P_PurOrdItmOverview.
-- 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: PPOITMOVW

CREATE VIEW P_PurOrdItmOverview AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  _PurchaseOrder.Supplier AS Supplier,
  _PurchaseOrder._Supplier.SupplierName AS SupplierName,
  MaterialGroup,
  _PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  Plant,
  cast('1' as numc1) AS ObjectType,
  Material,
  _PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  ServicePerformer,
  CostCenter,
  PurchaseOrder AS PurchasingDocument,
  _PurchaseOrder.SupplyingPlant AS SupplyingPlant,
  PurchaseOrderItemText,
  AccountAssignmentCategory,
  cast('' as /cpd/pfp_workitem_id) AS WorkItem,
  _PurchaseOrder.PurchaseOrderType AS PurchasingDocumentType,
  _PurgDocumentItemCategory._Text[1:Language=$session.system_language].PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
  _PurchaseOrder.PurchaseOrderType AS PurchaseOrderType
FROM I_PurchaseOrderItem
LEFT OUTER JOIN P_PurOrdItemNextDeliveryCalc AS _POItemNextDeliveryCalc ON _POItemNextDeliveryCalc.PurchaseOrder = PurchaseOrder AND _POItemNextDeliveryCalc.PurchaseOrderItem = PurchaseOrderItem  -- association [1..1]
;

Learn More