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.Material AS Material,
  _prpsl_hdr.Plant AS Plant,
  MRPArea,
  ProposalStartDate,
  ProposalVersion,
  ProposalEndDate,
  _BufMatPlant._Material.ProductGroup AS MaterialGroup,
  _BufMatPlant.PurchasingGroup AS PurchasingGroup,
  StockLevelProposalID,
  ConsumptionCode,
  ConsumptionValue,
  Currency,
  VariabilityCode,
  VariabilityQuantity,
  VariabilityUnit,
  ReplenishmentLeadTimeCode,
  ProcurementType,
  ReplenishmentLeadTimeValue,
  BOMUsageCode,
  BOMUsageValue,
  IndividualLeadTime,
  DecoupledLeadTime,
  SourceOfSupply,
  SOSType,
  LeadTimeFactor,
  VariabilityFactor,
  StockLevelProposalStatus,
  ProposalStatusChangeDate,
  IsMinOrderQtyConsidered,
  MinimumOrderQuantity,
  MinOrderQtyUnit,
  PrevRedZoneAdjustmentFctr,
  PrevYellowZoneAdjustmentFctr,
  PrevGreenZoneAdjustmentFctr,
  CurRedZoneAdjustmentFctr,
  CurYellowZoneAdjustmentFctr,
  CurGreenZoneAdjustmentFctr,
  OrderCycle,
  BillOfMaterialUUID,
  BOMExplosionDate,
  CreatedByUser,
  LastChangedByUser,
  CreationDateTime,
  LastChangeDateTime,
  (_prpsl_hdr.DecoupledLeadTime * _StockProposalDets.AverageDailyUsage * _prpsl_hdr.LeadTimeFactor) + (_prpsl_hdr.DecoupledLeadTime * _StockProposalDets.AverageDailyUsage * _prpsl_hdr.LeadTimeFactor) * _prpsl_hdr.VariabilityFactor as ProposedRedZone AS VariabilityFactorasProposedRedZone,
  _prpsl_hdr.DecoupledLeadTime * _StockProposalDets.AverageDailyUsage AS ProposedYellowZone,
  _prpsl_hdr.DecoupledLeadTime * _StockProposalDets.AverageDailyUsage * _prpsl_hdr.LeadTimeFactor AS ProposedGreenZone,
  _prpsl_hdr.MinimumOrderQuantity AS ProposedGreenZoneMinOrdQty,
  _StockProposalDets.AverageDailyUsage * _prpsl_hdr.OrderCycle AS ProposedGreenZoneOrdCycle,
  (_prpsl_hdr.DecoupledLeadTime * _StockProposalDets.AverageDailyUsage * _prpsl_hdr.LeadTimeFactor) + (_prpsl_hdr.DecoupledLeadTime * _StockProposalDets.AverageDailyUsage * _prpsl_hdr.LeadTimeFactor) * _prpsl_hdr.VariabilityFactor as OriglProposedRedZone AS VariabilityFactorasOriglProposedRedZone,
  _prpsl_hdr.DecoupledLeadTime * _StockProposalDets.AverageDailyUsage AS OriglProposedYellowZone,
  _prpsl_hdr.DecoupledLeadTime * _StockProposalDets.AverageDailyUsage * _prpsl_hdr.LeadTimeFactor AS OriglProposedGreenZone,
  _prpsl_hdr.MinimumOrderQuantity AS OriglGreenZoneMinOrdQty,
  _StockProposalDets.AverageDailyUsage * _prpsl_hdr.OrderCycle 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 I_ProdBufLvlPrpslData 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]
;