Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

C_PurdocItemOpenQty

DDL: C_PURDOCITEMOPENQTY SQL: CPOITEMOPENQTY Type: view CONSUMPTION
9 Fields 1 Data Sources 1 Associations

Open Quantity on Next Schedule Delivery

C_PurdocItemOpenQty is a Consumption CDS View that provides data about "Open Quantity on Next Schedule Delivery" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderScheduleLine) and exposes 9 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderScheduleLine _NextSchDelDate from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrderScheduleLine _PurchaseOrderScheduleLine _NextSchDelDate.PurchaseOrder = _PurchaseOrderScheduleLine.PurchaseOrder and _NextSchDelDate.PurchaseOrderItem = _PurchaseOrderScheduleLine.PurchaseOrderItem and _NextSchDelDate.ScheduleLine = _PurchaseOrderScheduleLine.ScheduleLine

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPOITEMOPENQTY view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Open Quantity on Next Schedule Delivery view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrderScheduleLine PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_PurchaseOrderScheduleLine PurchaseOrderItem Purchasing Document Item
OpenPurchaseOrderQuantity _PurchaseOrderScheduleLine OpenPurchaseOrderQuantity Open Purchase Order Quantity
PurchaseOrderQuantityUnit _PurchaseOrderScheduleLine PurchaseOrderQuantityUnit Order Unit
ScheduleLineDeliveryDate _PurchaseOrderScheduleLine ScheduleLineDeliveryDate Delivery Date
PurchaseOrderType
PurchasingOrganization
PurchasingGroup
Plant

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 C_PurdocItemOpenQty.
-- 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: CPOITEMOPENQTY

CREATE VIEW C_PurdocItemOpenQty AS
SELECT
  _NextSchDelDate.PurchaseOrder AS PurchaseOrder,
  _NextSchDelDate.PurchaseOrderItem AS PurchaseOrderItem,
  _PurchaseOrderScheduleLine.OpenPurchaseOrderQuantity AS OpenPurchaseOrderQuantity,
  _PurchaseOrderScheduleLine.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  _PurchaseOrderScheduleLine.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  _PurchaseOrderScheduleLine._PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  _PurchaseOrderScheduleLine._PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrderScheduleLine._PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  _PurchaseOrderScheduleLine._PurchaseOrderItem.Plant AS Plant
FROM I_PurchaseOrderScheduleLine AS _NextSchDelDate
LEFT OUTER JOIN I_PurchaseOrderScheduleLine AS _PurchaseOrderScheduleLine ON _NextSchDelDate.PurchaseOrder = _PurchaseOrderScheduleLine.PurchaseOrder AND _NextSchDelDate.PurchaseOrderItem = _PurchaseOrderScheduleLine.PurchaseOrderItem AND _NextSchDelDate.ScheduleLine = _PurchaseOrderScheduleLine.ScheduleLine  -- association [1..1]
;

Learn More