P_CntrlPurOrderItemMonitor

DDL: P_CNTRLPURORDERITEMMONITOR SQL: PMMCPOIMONI Type: view CONSUMPTION
37 Fields 1 Data Sources 2 Associations

P_CntrlPurOrderItemMonitor is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_CNTRLPURORDERITEMMONITOR1) and exposes 37 fields with key fields PurchaseOrder, PurchaseOrderItem, ExtSourceSystem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_CNTRLPURORDERITEMMONITOR1 P_CNTRLPURORDERITEMMONITOR1 from

Parameters (1)

NameTypeDefault
P_DisplayCurrency displaycurrency

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ProcmtShippingStatus _DeliveryStatusText $projection.DeliveryStatus = _DeliveryStatusText.DeliveryStatus
[0..1] I_ProcmtDelivSchedDate _DeliveryPeriodText $projection.PlannedDeliveryDuration = _DeliveryPeriodText.PlannedDeliveryDuration

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PMMCPOIMONI view
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrderItem PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY ExtSourceSystem PurchaseOrderItem ExtSourceSystem Connected System ID
PurchaseOrderItemText PurchaseOrderItem PurchaseOrderItemText Short Text
Supplier Supplier Supplier
SupplyingPlant SupplyingPlant Supplying Plant
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
PurchaseOrderDate PurchaseOrderDate PO Date
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
PurchaseOrderType PurchaseOrderType PO Type
PurchaseOrderItemCategory PurchaseOrderItem PurchaseOrderItemCategory Item Category
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
MaterialGroup PurchaseOrderItem MaterialGroup Product Group
Material PurchaseOrderItem Material Vehicle Model
Plant PurchaseOrderItem Plant Valuation Area
CompanyCode PurchaseOrderItem CompanyCode Receiver Company Code
StorageLocation PurchaseOrderItem StorageLocation StorageLocation
IsReturnsItem IsReturnsItem Returns Item
ServicePerformer PurchaseOrderItem ServicePerformer Service Performer
ProductType PurchaseOrderItem ProductType Product Type Group
PurchaseRequisition PurchaseOrderItem PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseOrderItem PurchaseRequisitionItem Requisn. item
DocumentCurrency PurchaseOrderItem DocumentCurrency Document Currency
NumberOfPurchaseOrderItems NumberOfPurchaseOrderItems Number of PO Items
PurchaseOrderQuantityUnit PurchaseOrderItem PurchaseOrderQuantityUnit Order Unit
DisplayCurrency
NetPriceAmount NetPriceAmount Net Price
OrderQuantity
NetPriceQuantity PurchaseOrderItem NetPriceQuantity Price Unit
OrderPriceUnit PurchaseOrderItem OrderPriceUnit Order Price Un.
ScheduleLine ScheduleLine Schedule Line
ScheduleLineOrderQuantity
RoughGoodsReceiptQty
_DeliveryStatusText _DeliveryStatusText
_DeliveryPeriodText _DeliveryPeriodText

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_CntrlPurOrderItemMonitor.
-- 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: PMMCPOIMONI
-- Parameters: P_DisplayCurrency : displaycurrency

CREATE VIEW P_CntrlPurOrderItemMonitor AS
SELECT
  PurchaseOrderItem.PurchaseOrder AS PurchaseOrder,
  PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  PurchaseOrderItem.ExtSourceSystem AS ExtSourceSystem,
  PurchaseOrderItem.PurchaseOrderItemText AS PurchaseOrderItemText,
  Supplier,
  SupplyingPlant,
  PurchasingOrganization,
  PurchasingGroup,
  PurchaseOrderDate,
  CreatedByUser,
  CreationDate,
  PurchaseOrderType,
  PurchaseOrderItem.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  AccountAssignmentCategory,
  PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  PurchaseOrderItem.Material AS Material,
  PurchaseOrderItem.Plant AS Plant,
  PurchaseOrderItem.CompanyCode AS CompanyCode,
  PurchaseOrderItem.StorageLocation AS StorageLocation,
  IsReturnsItem,
  PurchaseOrderItem.ServicePerformer AS ServicePerformer,
  PurchaseOrderItem.ProductType AS ProductType,
  PurchaseOrderItem.PurchaseRequisition AS PurchaseRequisition,
  PurchaseOrderItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurchaseOrderItem.DocumentCurrency AS DocumentCurrency,
  NumberOfPurchaseOrderItems,
  PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  NetPriceAmount,
  cast( ReturnItems * PurchaseOrderItem.OrderQuantity as bstmg) AS OrderQuantity,
  PurchaseOrderItem.NetPriceQuantity AS NetPriceQuantity,
  PurchaseOrderItem.OrderPriceUnit AS OrderPriceUnit,
  ScheduleLine,
  PurchaseOrderItem.ReturnItems * ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  PurchaseOrderItem.ReturnItems * RoughGoodsReceiptQty AS RoughGoodsReceiptQty
FROM P_CNTRLPURORDERITEMMONITOR1
LEFT OUTER JOIN I_ProcmtShippingStatus AS _DeliveryStatusText ON DeliveryStatus = _DeliveryStatusText.DeliveryStatus  -- association [0..1]
LEFT OUTER JOIN I_ProcmtDelivSchedDate AS _DeliveryPeriodText ON PlannedDeliveryDuration = _DeliveryPeriodText.PlannedDeliveryDuration  -- association [0..1]
;

Learn More