I_StockLevelProposalZones

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 I_StockLevelProposalZones.
-- 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: IDDSTKLVLPRPSLZN

CREATE VIEW I_StockLevelProposalZones AS
SELECT
  _prpsl_hdr.matnr AS Material,
  _prpsl_hdr.werks AS Plant,
  berid AS MRPArea,
  prop_date_from AS ProposalStartDate,
  prop_ver AS ProposalVersion,
  prop_date_to AS ProposalEndDate,
  _BufMatPlant._Material.ProductGroup AS MaterialGroup,
  _BufMatPlant.PurchasingGroup AS PurchasingGroup,
  proposal_id AS StockLevelProposalID,
  abc_ind AS ConsumptionCode,
  abc_value AS ConsumptionValue,
  abc_curr AS Currency,
  xyz_ind AS VariabilityCode,
  xyz_qty AS VariabilityQuantity,
  xyz_unit AS VariabilityUnit,
  efg_ind AS ReplenishmentLeadTimeCode,
  efg_proctype AS ProcurementType,
  efg_value AS ReplenishmentLeadTimeValue,
  pqr_ind AS BOMUsageCode,
  pqr_value AS BOMUsageValue,
  lead_time AS IndividualLeadTime,
  decoupled_lead_time AS DecoupledLeadTime,
  source_of_supply AS SourceOfSupply,
  source_type AS SOSType,
  factor_lead_time AS LeadTimeFactor,
  factor_variability AS VariabilityFactor,
  proposal_status AS StockLevelProposalStatus,
  prop_stat_chng_time AS ProposalStatusChangeDate,
  moq_considerd AS IsMinOrderQtyConsidered,
  moq_qty AS MinimumOrderQuantity,
  moq_unit AS MinOrderQtyUnit,
  adj_factor_red AS PrevRedZoneAdjustmentFctr,
  adj_factor_yellow AS PrevYellowZoneAdjustmentFctr,
  adj_factor_green AS PrevGreenZoneAdjustmentFctr,
  adj_factor_red_chng AS CurRedZoneAdjustmentFctr,
  adj_factor_yellow_chng AS CurYellowZoneAdjustmentFctr,
  adj_factor_green_chng AS CurGreenZoneAdjustmentFctr,
  order_cycle AS OrderCycle,
  bom_id AS BillOfMaterialUUID,
  bom_expl_date AS BOMExplosionDate,
  created_by AS CreatedByUser,
  changed_by AS LastChangedByUser,
  created_time AS CreationDateTime,
  changed_time AS LastChangeDateTime,
  (_prpsl_hdr.decoupled_lead_time * _StockProposalDets.AverageDailyUsage * _prpsl_hdr.factor_lead_time) + (_prpsl_hdr.decoupled_lead_time * _StockProposalDets.AverageDailyUsage * _prpsl_hdr.factor_lead_time) * _prpsl_hdr.factor_variability as ProposedRedZone AS factor_variabilityasProposedRedZone,
  _prpsl_hdr.decoupled_lead_time * _StockProposalDets.AverageDailyUsage AS ProposedYellowZone,
  _prpsl_hdr.decoupled_lead_time * _StockProposalDets.AverageDailyUsage * _prpsl_hdr.factor_lead_time AS ProposedGreenZone,
  _prpsl_hdr.moq_qty AS ProposedGreenZoneMinOrdQty,
  _StockProposalDets.AverageDailyUsage * _prpsl_hdr.order_cycle AS ProposedGreenZoneOrdCycle,
  (_prpsl_hdr.decoupled_lead_time * _StockProposalDets.AverageDailyUsage * _prpsl_hdr.factor_lead_time) + (_prpsl_hdr.decoupled_lead_time * _StockProposalDets.AverageDailyUsage * _prpsl_hdr.factor_lead_time) * _prpsl_hdr.factor_variability as OriglProposedRedZone AS factor_variabilityasOriglProposedRedZone,
  _prpsl_hdr.decoupled_lead_time * _StockProposalDets.AverageDailyUsage AS OriglProposedYellowZone,
  _prpsl_hdr.decoupled_lead_time * _StockProposalDets.AverageDailyUsage * _prpsl_hdr.factor_lead_time AS OriglProposedGreenZone,
  _prpsl_hdr.moq_qty AS OriglGreenZoneMinOrdQty,
  _StockProposalDets.AverageDailyUsage * _prpsl_hdr.order_cycle AS OriglGreenZoneOrdCycle,
  _StockProposalDets.AverageDailyUsage AS AverageDailyUsage,
  _StockProposalDets.AvgDailyUsageUnit AS AvgDailyUsageUnit,
  _BufMatPlant._Material.BaseUnit AS MaterialBaseUnit,
  case _BufMatPlant.IsMRPAreaExisting when 'X' then case when _BufMatPlant.Plant <> _MatMRPArea.MRPArea then _MatMRPArea.MRPGroup else _BufMatPlant.MRPGroup end else _BufMatPlant.MRPGroup end as MRPGroup AS MRPGroupendasMRPGroup,
  case _BufMatPlant.IsMRPAreaExisting when 'X' then case when _BufMatPlant.Plant <> _MatMRPArea.MRPArea then _MatMRPArea.MRPController else _BufMatPlant.MRPController end else _BufMatPlant.MRPController end as MRPController AS MRPControllerendasMRPController,
  _BufMatPlant._Material._BaseUnitOfMeasure.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals
FROM pph_dd_stpr_hdr AS _prpsl_hdr
LEFT OUTER JOIN I_BufferedMaterialPlant AS _BufMatPlant ON Material = _BufMatPlant.Material AND Plant = _BufMatPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_MaterialMRPArea AS _MatMRPArea ON Material = _MatMRPArea.Material AND Plant = _MatMRPArea.Plant AND MRPArea = _MatMRPArea.MRPArea  -- association [1..1]
LEFT OUTER JOIN I_StockLevelPrpslDets AS _StockProposalDets ON Material = _StockProposalDets.Material AND Plant = _StockProposalDets.Plant AND MRPArea = _StockProposalDets.MRPArea AND ProposalStartDate = _StockProposalDets.ProposalStartDate AND ProposalVersion = _StockProposalDets.ProposalVersion AND ProposalStartDate = _StockProposalDets.AvgDailyUsageCalcdForDate  -- association [1..1]
LEFT OUTER JOIN I_ProposalStatusText AS _StatusText ON StockLevelProposalStatus = _StatusText.StockLevelProposalStatus AND _StatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MinOrdQtyConsideredText AS _MinOrdQtyConsText ON IsMinOrderQtyConsidered = _MinOrdQtyConsText.IsMinOrderQtyConsidered AND _MinOrdQtyConsText.Language = $session.system_language  -- association [0..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_ProcurementTypeText AS _ProcmtText ON ProcurementType = _ProcmtText.ProcurementType AND _ProcmtText.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_SOSTypeText AS _SOSText ON SOSType = _SOSText.SOSType AND _SOSText.Language = $session.system_language  -- association [0..1]
;