P_DemandDrivenCalcValues

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_DemandDrivenCalcValues.
-- 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: PDDCALCVAL

CREATE VIEW P_DemandDrivenCalcValues AS
SELECT
  pph_ddl_mat.Plant AS Plant,
  pph_ddl_mat.Material AS Material,
  pph_ddl_mat.MRPArea AS MRPArea,
  pph_ddl_mat.BaseUnitofMeasure AS BaseUnitofMeasure,
  pph_ddl_mat.MaterialBaseUnit AS MaterialBaseUnit,
  pph_ddl_mat.MRPController AS MRPController,
  pph_ddl_mat.MaterialGroup AS MaterialGroup,
  pph_ddl_mat.MRPType AS MRPType,
  pph_ddl_mat.MRPGroup AS MRPGroup,
  coalesce(pph_prod.DecoupledLeadTime,0) AS DecoupledLeadTime,
  pph_prod._ConsumptionText.ConsumptionDescription AS ConsumptionDescription,
  pph_prod._ReplnmtText.ReplenishmentLeadTimeDesc AS ReplenishmentLeadTimeDesc,
  pph_prod._BOMUsgeText.BOMUsageDescription AS BOMUsageDescription,
  pph_prod._VarText.VariabilityDescription AS VariabilityDescription,
  coalesce(pph_prod.ConsumptionCode,'') AS ConsumptionCode,
  pph_prod.ProductConsumptionAmount AS ProductConsumptionAmount,
  pph_prod.Currency AS Currency,
  coalesce(pph_prod.ReplenishmentLeadTimeCode,'') AS ReplenishmentLeadTimeCode,
  pph_prod.ReplenishmentLeadTimeValue AS ReplenishmentLeadTimeValue,
  coalesce(pph_prod.BOMUsageCode,'') AS BOMUsageCode,
  pph_prod.BOMUsageValue AS BOMUsageValue,
  coalesce(pph_prod.VariabilityCode,'') AS VariabilityCode,
  pph_prod.VariabilityQuantity AS VariabilityQuantity,
  coalesce(pph_prod.ProcurementType,'') AS ProcurementType,
  pph_ddl_mat.MaterialSafetyStockQty AS MaterialSafetyStockQty,
  pph_ddl_mat.MaterialSafetyStockTodayQty AS MaterialSafetyStockTodayQty,
  pph_ddl_mat.MaterialMaxStockLevelQuantity AS MaterialMaxStockLevelQuantity,
  pph_ddl_mat.ReorderThresholdQuantity AS ReorderThresholdQuantity,
  pph_ddl_mat.ThresholdPercentage AS ThresholdPercentage,
  _FirstStockOutVal.QualifiedDemandQuantity AS QualifiedDemandQuantity,
  _FirstStockOutVal.NetFlowPositionQuantity AS NetFlowPositionQuantity,
  _FirstStockOutVal.OnHandStockQuantity AS OnHandStockQuantity,
  _FirstStockOutVal.OpenSupplyQuantity AS OpenSupplyQuantity,
  case when pph_ddl_mat.MaterialSafetyStockTodayQty != 0 then division(_FirstStockOutVal.OnHandStockQuantity , pph_ddl_mat.MaterialSafetyStockTodayQty,2) * 100 else fltp_to_dec( 999999.00 as abap.dec( 8, 2 ) ) end as OnHandBufferStatusQuantity AS dec82endasOnHandBufferStatusQuantity,
  case when pph_ddl_mat.MaterialMaxStockLevelQuantity != 0 then division(_FirstStockOutVal.NetFlowPositionQuantity , pph_ddl_mat.MaterialMaxStockLevelQuantity,2) * 100 else fltp_to_dec( 999999.00 as abap.dec( 8, 2 ) ) end as MaterialPlanningPriority AS dec82endasMaterialPlanningPriority,
  case when _FirstStockOutVal.NetFlowPositionQuantity < pph_ddl_mat.ReorderThresholdQuantity then cast(pph_ddl_mat.MaterialMaxStockLevelQuantity - _FirstStockOutVal.NetFlowPositionQuantity as abap.dec(31, 3)) else 0 end as ProposedQuantity AS dec313else0endasProposedQuantity,
  _ExpeditedProduct.ExpeditedDateTime AS ExpeditedDateTime,
  _ExpeditedProduct.ExpeditedOnHandStockStatus AS ExpeditedOnHandStockStatus,
  _ExpeditedProduct.ExpeditedQuantity AS ExpeditedQuantity,
  _FirstStockOutVal.ProjectedOnHandStockStatus AS ProjectedOnHandStockStatus,
  _FirstStockOutVal.IsWithinDLT AS IsWithinDLT,
  _FirstStockOutVal.StockOutAlertIsPresent AS StockOutAlertIsPresent,
  _FirstStockOutVal.FirstStkOutDate AS FirstStkOutDate,
  _FirstStockOutVal.FirstStkOutProjtdStkQty AS FirstStkOutProjtdStkQty,
  _FirstStockOutVal.FirstStkOutProjtdSFTQty AS FirstStkOutProjtdSFTQty,
  _FirstStockOutVal.FirstStkOutProjtdSFTPct AS FirstStkOutProjtdSFTPct,
  _FirstStockOutVal.FirstStkOutFromTodayInDays AS FirstStkOutFromTodayInDays,
  _FirstStockOutVal.ThresholdAlertIsPresent AS ThresholdAlertIsPresent,
  _FirstStockOutVal.FirstBelowThldDate AS FirstBelowThldDate,
  _FirstStockOutVal.FirstBelowThldProjtdStkQty AS FirstBelowThldProjtdStkQty,
  _FirstStockOutVal.FirstBelowThldThldLvlQty AS FirstBelowThldThldLvlQty,
  _FirstStockOutVal.FirstBelowThldProjtdSFTQty AS FirstBelowThldProjtdSFTQty,
  _FirstStockOutVal.FirstBelowThldProjtdSFTPct AS FirstBelowThldProjtdSFTPct,
  _FirstStockOutVal.FirstBelowThldFromTodayInDays AS FirstBelowThldFromTodayInDays,
  _FirstStockOutVal.SafetyStockAlertIsPresent AS SafetyStockAlertIsPresent,
  _FirstStockOutVal.FirstBelowSFTDate AS FirstBelowSFTDate,
  _FirstStockOutVal.FirstBelowSFTProjtdStkQty AS FirstBelowSFTProjtdStkQty,
  _FirstStockOutVal.FirstBelowSFTThldLvlQty AS FirstBelowSFTThldLvlQty,
  _FirstStockOutVal.FirstBelowSFTProjtdSFTQty AS FirstBelowSFTProjtdSFTQty,
  _FirstStockOutVal.FirstBelowSFTProjtdSFTPct AS FirstBelowSFTProjtdSFTPct,
  _FirstStockOutVal.FirstBelowSFTFromTodayInDays AS FirstBelowSFTFromTodayInDays,
  _FirstStockOutVal.ProjectedStockOutStatus AS ProjectedStockOutStatus,
  pph_prod.PastHorizonDLTMultiplierValue AS PastHorizonDLTMultiplierValue,
  pph_prod.FutureHrznDLTMultiplierValue AS FutureHrznDLTMultiplierValue,
  pph_prod.IsBulkMaterial AS IsBulkMaterial,
  pph_prod.IsPhantomItem AS IsPhantomItem,
  coalesce(pph_prod.IndividualLeadTime,0) AS IndividualLeadTime,
  pph_prod.MRPMaterialStatus AS MRPMaterialStatus,
  pph_prod._MatStatus AS _MatStatus
FROM I_DemandDrivenMaterial AS pph_ddl_mat
LEFT OUTER JOIN I_DemandDrivenProduct1 AS pph_prod ON Material = pph_prod.Material AND Plant = pph_prod.Plant AND MRPArea = pph_prod.MRPArea  -- association [1..1]
LEFT OUTER JOIN I_ExpeditedProduct AS _ExpeditedProduct ON Material = _ExpeditedProduct.Material AND Plant = _ExpeditedProduct.Plant AND MRPArea = _ExpeditedProduct.MRPArea  -- association [0..1]
LEFT OUTER JOIN P_FirstStockOutValues AS _FirstStockOutVal ON Material = _FirstStockOutVal.Material AND Plant = _FirstStockOutVal.Plant AND MRPArea = _FirstStockOutVal.MRPArea  -- association [1..1]
LEFT OUTER JOIN I_ConsumptionText AS _ConsumptionText ON ConsumptionCode = _ConsumptionText.ConsumptionCode AND _ConsumptionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_VariabilityText AS _VarText ON VariabilityCode = _VarText.VariabilityCode AND _VarText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ReplenishmentLeadTimeText AS _ReplnmtText ON ReplenishmentLeadTimeCode = _ReplnmtText.ReplenishmentLeadTimeCode AND _ReplnmtText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BOMUsageText AS _BOMUsgText ON BOMUsageCode = _BOMUsgText.BOMUsageCode AND _BOMUsgText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProcurementTypeText AS _ProcmtText ON ProcurementType = _ProcmtText.ProcurementType AND _ProcmtText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_OnHandStockStatusText AS _OnHandStockStatusText ON OnHandStockStatus = _OnHandStockStatusText.OnHandStockStatusCode AND _OnHandStockStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProdPlngPrioStatusText AS _ProdPlngPrioStatusText ON MaterialPlanningPriorityStatus = _ProdPlngPrioStatusText.ProdPlaningPriorityStatusCode AND _ProdPlngPrioStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DemandDrivenPlanningStatus AS _PlanningStatus ON Material = _PlanningStatus.Material AND Plant = _PlanningStatus.Plant AND _PlanningStatus.UserID = $session.user  -- association [0..1]
LEFT OUTER JOIN I_ProdPlngActionStatusText AS _ProdPlngActionStatusText ON OrderPlanningStatusText = _ProdPlngActionStatusText.ProdPlanningActionStatusCode AND _ProdPlngActionStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProjectedStockOutStatusText AS _ProjectedStockOutStatusText ON projectedstockoutstatus = _ProjectedStockOutStatusText.ProjectedStockOutStatus AND _ProjectedStockOutStatusText.Language = $session.system_language  -- association [0..1]
;