P_PurgOrdItemSchLine

DDL: P_PURGORDITEMSCHLINE SQL: PPORDITMSCH Type: view CONSUMPTION Package: ODATA_MM_PUR_SUPLRCONF_MNTR
9 Fields 1 Data Sources

View for PO Item Schedule Line

P_PurgOrdItemSchLine is a Consumption CDS View that provides data about "View for PO Item Schedule Line" in SAP S/4HANA. It reads from 1 data source (P_PurgOrdSchKeyDate) and exposes 9 fields with key fields PurchasingDocument, PurchasingDocumentItem, ScheduleLine, SupplierConfirmationCategory. Part of development package ODATA_MM_PUR_SUPLRCONF_MNTR.

Data Sources (1)

SourceAliasJoin Type
P_PurgOrdSchKeyDate P_PurgOrdSchKeyDate from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PPORDITMSCH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label View for PO Item Schedule Line view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
KEY ScheduleLine ScheduleLine Schedule Line
KEY SupplierConfirmationCategory SupplierConfirmationCategory Confirm. Cat.
OrderQuantity OrderQuantity Quantity
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Delivery Date
OrderedQuantity ScheduledQuantity Scheduled Qty
KeyDate KeyDate Maturity Key Date
OrderUnit OrderUnit Commercial

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_PurgOrdItemSchLine.
-- 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: PPORDITMSCH

CREATE VIEW P_PurgOrdItemSchLine AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  ScheduleLine,
  SupplierConfirmationCategory,
  OrderQuantity,
  ScheduleLineDeliveryDate,
  ScheduledQuantity AS OrderedQuantity,
  KeyDate,
  OrderUnit
FROM P_PurgOrdSchKeyDate
;

Learn More