P_CntrlPOItemNextDelivery

DDL: P_CNTRLPOITEMNEXTDELIVERY SQL: PMMCPOINXTDEL Type: view CONSUMPTION
5 Fields 2 Data Sources

Central PO Item Next Delivery

P_CntrlPOItemNextDelivery is a Consumption CDS View that provides data about "Central PO Item Next Delivery" in SAP S/4HANA. It reads from 2 data sources (P_CntrlPOItemNextDelivery1, I_CntrlPurOrderScheduleLine) and exposes 5 fields with key fields PurchaseOrder, PurchaseOrderItem, ExtSourceSystem.

Data Sources (2)

SourceAliasJoin Type
P_CntrlPOItemNextDelivery1 NextDelivery from
I_CntrlPurOrderScheduleLine ScheduleLine inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMMCPOINXTDEL view
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Central PO Item Next Delivery view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder P_CntrlPOItemNextDelivery1 PurchaseOrder Purchasing Document
KEY PurchaseOrderItem P_CntrlPOItemNextDelivery1 PurchaseOrderItem Purchasing Document Item
KEY ExtSourceSystem P_CntrlPOItemNextDelivery1 ExtSourceSystem Connected System ID
ScheduleLineDeliveryDate P_CntrlPOItemNextDelivery1 ScheduleLineDeliveryDate Delivery Date
ScheduleLine

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_CntrlPOItemNextDelivery.
-- 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: PMMCPOINXTDEL

CREATE VIEW P_CntrlPOItemNextDelivery AS
SELECT
  NextDelivery.PurchaseOrder AS PurchaseOrder,
  NextDelivery.PurchaseOrderItem AS PurchaseOrderItem,
  NextDelivery.ExtSourceSystem AS ExtSourceSystem,
  NextDelivery.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  min(ScheduleLine) AS ScheduleLine
FROM P_CntrlPOItemNextDelivery1 AS NextDelivery
INNER JOIN I_CntrlPurOrderScheduleLine AS ScheduleLine ON /* join condition not captured in parsed metadata */
;

Learn More