C_POItemNextDeliveryCalc

DDL: C_POITEMNEXTDELIVERYCALC SQL: CPOINXTDELCALC Type: view CONSUMPTION Package: ODATA_MM_PUR_POITEMS_MONI
12 Fields 2 Data Sources 4 Associations

PO Item Next Delivery Calc Fields

C_POItemNextDeliveryCalc is a Consumption CDS View that provides data about "PO Item Next Delivery Calc Fields" in SAP S/4HANA. It reads from 2 data sources (P_POItemOpenSchedLine, I_PurchaseOrderItem) and exposes 12 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 4 associations to related views. Part of development package ODATA_MM_PUR_POITEMS_MONI.

Data Sources (2)

SourceAliasJoin Type
P_POItemOpenSchedLine NextScheduleLine left_outer
I_PurchaseOrderItem PurchaseOrderItem from

Associations (4)

CardinalityTargetAliasCondition
[0..1] P_POItemDeliveryDuration DeliveryDuration DeliveryDuration.PurchaseOrder = NextScheduleLine.PurchaseOrder and DeliveryDuration.PurchaseOrderItem = NextScheduleLine.PurchaseOrderItem and DeliveryDuration.ScheduleLine = NextScheduleLine.ScheduleLine
[0..1] P_SuplrDeliveryPredictionCache _PredictedDelivery PurchaseOrderItem.PurchaseOrder = _PredictedDelivery.PurchaseOrder and PurchaseOrderItem.PurchaseOrderItem = _PredictedDelivery.PurchaseOrderItem and NextScheduleLine.ScheduleLine = _PredictedDelivery.ScheduleLine
[0..1] I_ProcmtShippingStatusText _DeliveryStatusText _DeliveryStatusText.DeliveryStatus=$projection.DeliveryStatus and _DeliveryStatusText.Language = $session.system_language
[0..1] I_ProcmtSuplrDelivForecastText _DeliveryForecastTxt _DeliveryForecastTxt.PredictedDelDaysRltnPOPostDate=$projection.DeliveryStatus and _DeliveryForecastTxt.Language = $session.system_language

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CPOINXTDELCALC view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label PO Item Next Delivery Calc Fields view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrderItem PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
ScheduleLine P_POItemOpenSchedLine ScheduleLine Schedule Line
PurchaseOrderQuantityUnit
PurchaseOrderType
PurchasingGroup
PurchasingOrganization
Plant I_PurchaseOrderItem Plant Valuation Area
PredictedDelivDte _PredictedDelivery PredictedDelivDte
SuplrNextDeliveryPredictionDte _PredictedDelivery SuplrNextDeliveryPredictionDte
PredictedDaysOfDelivDeviation _PredictedDelivery PredictedDaysOfDelivDeviation
_DeliveryStatusText _DeliveryStatusText

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_POItemNextDeliveryCalc.
-- 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: CPOINXTDELCALC

CREATE VIEW C_POItemNextDeliveryCalc AS
SELECT
  PurchaseOrderItem.PurchaseOrder AS PurchaseOrder,
  PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  NextScheduleLine.ScheduleLine AS ScheduleLine,
  DeliveryDuration(P_Date: $session.system_date).PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  PurchaseOrderItem._PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  PurchaseOrderItem._PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrderItem._PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrderItem.Plant AS Plant,
  _PredictedDelivery.PredictedDelivDte AS PredictedDelivDte,
  _PredictedDelivery.SuplrNextDeliveryPredictionDte AS SuplrNextDeliveryPredictionDte,
  _PredictedDelivery.PredictedDaysOfDelivDeviation AS PredictedDaysOfDelivDeviation
FROM I_PurchaseOrderItem AS PurchaseOrderItem
LEFT OUTER JOIN P_POItemOpenSchedLine AS NextScheduleLine ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_POItemDeliveryDuration AS DeliveryDuration ON DeliveryDuration.PurchaseOrder = NextScheduleLine.PurchaseOrder AND DeliveryDuration.PurchaseOrderItem = NextScheduleLine.PurchaseOrderItem AND DeliveryDuration.ScheduleLine = NextScheduleLine.ScheduleLine  -- association [0..1]
LEFT OUTER JOIN P_SuplrDeliveryPredictionCache AS _PredictedDelivery ON PurchaseOrderItem.PurchaseOrder = _PredictedDelivery.PurchaseOrder AND PurchaseOrderItem.PurchaseOrderItem = _PredictedDelivery.PurchaseOrderItem AND NextScheduleLine.ScheduleLine = _PredictedDelivery.ScheduleLine  -- association [0..1]
LEFT OUTER JOIN I_ProcmtShippingStatusText AS _DeliveryStatusText ON _DeliveryStatusText.DeliveryStatus=DeliveryStatus AND _DeliveryStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProcmtSuplrDelivForecastText AS _DeliveryForecastTxt ON _DeliveryForecastTxt.PredictedDelDaysRltnPOPostDate=DeliveryStatus AND _DeliveryForecastTxt.Language = $session.system_language  -- association [0..1]
;

Learn More