P_PurOrdExpectedQty

DDL: P_PURORDEXPECTEDQTY SQL: PMMPOEXPEQTY Type: view CONSUMPTION
13 Fields 1 Data Sources

Purchase Order Expected Quantity

P_PurOrdExpectedQty is a Consumption CDS View that provides data about "Purchase Order Expected Quantity" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderScheduleLine) and exposes 13 fields with key fields PurchaseOrder, PurchaseOrderItem.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderScheduleLine ScheduleLine from

Parameters (2)

NameTypeDefault
P_StartDate bedat
P_EndDate bedat

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMMPOEXPEQTY view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Order Expected Quantity view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrderScheduleLine PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_PurchaseOrderScheduleLine PurchaseOrderItem Purchasing Document Item
PurchaseOrderDate
PurchasingOrganization
PurchasingGroup
Supplier
CompanyCode
Material
MaterialGroup
Plant
BaseUnit
PurchaseOrderQuantityUnit I_PurchaseOrderScheduleLine PurchaseOrderQuantityUnit Order Unit
TotalOrderQuantity _PurchaseOrderItem OrderQuantity Quantity

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_PurOrdExpectedQty.
-- 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: PMMPOEXPEQTY
-- Parameters: P_StartDate : bedat, P_EndDate : bedat

CREATE VIEW P_PurOrdExpectedQty AS
SELECT
  ScheduleLine.PurchaseOrder AS PurchaseOrder,
  ScheduleLine.PurchaseOrderItem AS PurchaseOrderItem,
  ScheduleLine._PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  ScheduleLine._PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  ScheduleLine._PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  ScheduleLine._PurchaseOrder.Supplier AS Supplier,
  ScheduleLine._PurchaseOrder.CompanyCode AS CompanyCode,
  ScheduleLine._PurchaseOrderItem.Material AS Material,
  ScheduleLine._PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  ScheduleLine._PurchaseOrderItem.Plant AS Plant,
  ScheduleLine._PurchaseOrderItem.BaseUnit AS BaseUnit,
  ScheduleLine.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  _PurchaseOrderItem.OrderQuantity AS TotalOrderQuantity
FROM I_PurchaseOrderScheduleLine AS ScheduleLine
;

Learn More