C_ProductBufferLevelMgmtTP

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_ProductBufferLevelMgmtTP.
-- 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: CPRODBUFLVLMNGTP

CREATE VIEW C_ProductBufferLevelMgmtTP AS
SELECT
  StockProposal.MRPArea AS MRPArea,
  StockProposal.Plant AS Plant,
  StockProposal.Material AS Material,
  cast(StockProposal.ProposalStartDate as pph_dd_proposalrundate preserving type) AS ProposalStartDate,
  StockProposal.ProposalVersion AS ProposalVersion,
  _CalcFields.ProposalStatusChangeDate AS ProposalStatusChangeDate,
  cast('' as abap.sstring(1333)) AS MemoLine,
  _SDMAreaOfResponsibility.UserID AS UserID,
  _MaterialT.MaterialName AS MaterialName,
  StockProposal._BufMatPlant._Plant.PlantName AS PlantName,
  _MRPAreaText.MRPAreaText AS MRPAreaText,
  StockProposal.MaterialBaseUnit AS BaseUnit,
  StockProposal.StockLevelProposalID AS StockLevelProposalID,
  StockProposal.StockLevelProposalStatus AS StockLevelProposalStatus,
  _CalcFields.ProposalRunIsSuspended AS ProposalRunIsSuspended,
  _CalcFields.ProposalRunIsNotSuspended AS ProposalRunIsNotSuspended,
  cast(StockProposal.ProposalRunSuspendedFromDate as pph_susp_prpsl_begda) AS ProposalRunSuspendedFromDate,
  cast(StockProposal.ProposalRunSuspendedToDate as pph_susp_prpsl_endda) AS ProposalRunSuspendedToDate,
  _CalcFields.ProposalMode AS ProposalMode,
  cast (cast(_CalcFields.ProposalModeDescription as char40) as pph_proposal_modetext preserving type) AS ProposalModeDescription,
  cast(cast('' as char40) as pph_proposal_statustext preserving type) AS ProposalStatusDescription,
  cast(0 as abap.sstring(400)) AS PlantName2,
  _CalcFields.IsMinOrderQtyConsidered AS IsMinOrderQtyConsidered,
  _CalcFields.MinOrderQuantityHasChanged AS MinOrderQuantityHasChanged,
  cast(cast('' as abap.char(60)) as pph_dd_minordqtyhaschangedtext preserving type) AS MinOrderQtyHasChangedStsText,
  _CalcFields.AdjustmentType AS AdjustmentType,
  _CurrentBuffer.CurrentRedZone AS CurrentRedZone,
  cast(0 as abap.quan(13,3)) AS RedZoneDifference,
  StockProposal.ProposedRedZone AS ProposedRedZone,
  _CurrentBuffer.CurrentYellowZone AS CurrentYellowZone,
  cast(0 as abap.quan(13,3)) AS YellowZoneDifference,
  StockProposal.ProposedYellowZone AS ProposedYellowZone,
  _CurrentBuffer.CurrentGreenZone AS CurrentGreenZone,
  cast(0 as abap.quan(13,3)) AS GreenZoneDifference,
  StockProposal.ProposedGreenZone AS ProposedGreenZone,
  _CalcFields.MaxStockDifference AS MaxStockDifference,
  _CalcFields.MaxStockDeviationRate AS MaxStockDeviationRate,
  _CalcFields.MaterialMaxStockLevelQuantity AS MaterialMaxStockLevelQuantity,
  _CalcFields.MaterialMaxStockLevelQuantity AS MatlCurrentMaxStock,
  _CalcFields.MatlProposedMaxStock AS MatlProposedMaxStock,
  cast('%' as msehi) AS UnitOfMeasure,
  _CurrentBuffer.CurrentAvgDailyUsage AS CurrentAverageDailyUsage,
  _CalcFields.AverageDailyUsage AS ProposedAverageDailyUsage,
  _CalcFields.AverageDailyUsageMode AS AverageDailyUsageMode,
  _CalcFields.AverageDailyUsageModeDesc AS AverageDailyUsageModeDesc,
  cast(0 as abap.quan(13,3)) AS AvgDailyUsageDifference,
  _CalcFields.AvgDailyUsageDeviationRate AS AvgDailyUsageDeviationRate,
  _CurrentBuffer.CurrentVariabilityFactor AS CurrentVariabilityFactor,
  _CalcFields.VariabilityFactor AS ProposedVariabilityFactor,
  _CalcFields.VariabilityFactorDeviationRate AS VariabilityFactorDeviationRate,
  _CalcFields.VariabilityFactorDifference AS VariabilityFactorDifference,
  _CurrentBuffer.CurrentLeadTime AS CurrentLeadTime,
  _CalcFields.DecoupledLeadTime AS ProposedLeadTime,
  _CalcFields.LeadTimeDeviationRate AS LeadTimeDeviationRate,
  _CalcFields.LeadTimeDifference AS LeadTimeDifference,
  cast('' as abap.char(100)) AS DifferenceInDays,
  cast('' as abap.sstring(200)) AS DifferenceInDaysDesc,
  StockProposal._BufMatPlant._Material.ProductGroup AS MaterialGroup,
  StockProposal.MRPController AS MRPController,
  _SDMAreaOfResponsibility.MRPControllerName AS MRPControllerName,
  _CalcFields.PurchasingGroup AS PurchasingGroup,
  _CalcFields.MRPGroup AS MRPGroup,
  _CalcFields.MatlPrpslAdjmtFctrIsApplied AS MatlPrpslAdjmtFctrIsApplied,
  _CalcFields.NormalizedCurrentGreenZone AS NormalizedCurrentGreenZone,
  _CalcFields.NormalizedCurrentYellowZone AS NormalizedCurrentYellowZone,
  _CalcFields.NormalizedCurrentRedZone AS NormalizedCurrentRedZone,
  _CalcFields.NormalizedProposedGreenZone AS NormalizedProposedGreenZone,
  _CalcFields.NormalizedProposedYellowZone AS NormalizedProposedYellowZone,
  _CalcFields.NormalizedProposedRedZone AS NormalizedProposedRedZone,
  StockProposal._MatMRPArea._MRPArea.MRPAreaCategory AS MRPAreaCategory,
  _CalcFields.HorizonDaysInPast AS HorizonDaysInPast,
  _CalcFields.HorizonDaysInFuture AS HorizonDaysInFuture,
  _CalcFields.ProductProfileHasChanged AS ProductProfileHasChanged,
  cast('' as sydatum) AS ChartZoomHorizonStartDate,
  cast('' as sydatum) AS ChartZoomHorizonEndDate,
  cast(cast('' as abap.char(60)) as pph_hasprodprofilechangedtext preserving type) AS ProductProfileHasChangedText,
  _MicroChartData.MaximumAverageDailyUsage AS MaximumAverageDailyUsage,
  _MicroChartData.MinimumAverageDailyUsage AS MinimumAverageDailyUsage,
  _MicroChartData.MaximumMatlMaxStockLevelQty AS MaximumMatlMaxStockLevelQty,
  _MicroChartData.MinimumMatlMaxStockLevelQty AS MinimumMatlMaxStockLevelQty,
  cast( cast('' as char5) as pph_dd_matlbufferprofilecode preserving type) AS ProposedMaterialBufferProfile,
  cast('' as pph_materialbufferprofiletxt) AS ProposedMatlBufferProfileText,
  _CalcFields.ConsumptionCode AS ConsumptionCode,
  cast('' as val_text) AS ConsumptionDescription,
  _CalcFields.ReplenishmentLeadTimeCode AS ReplenishmentLeadTimeCode,
  _CalcFields.ReplenishmentLeadTimeValue AS ReplenishmentLeadTimeValue,
  cast('' as val_text) AS ReplenishmentLeadTimeDesc,
  _CalcFields.BOMUsageCode AS BOMUsageCode,
  cast('' as val_text) AS BOMUsageDescription,
  _CalcFields.VariabilityCode AS VariabilityCode,
  _CalcFields.VariabilityQuantity AS VariabilityQuantity,
  cast('' as val_text) AS VariabilityDescription,
  _CalcFields.ProcurementType AS ProcurementType,
  cast('' as val_text) AS ProcurementTypeDescription,
  _CalcFields.ProductProfileChangeCategory AS ProductProfileChangeCategory,
  cast('' as val_text) AS ProductProfileChangeCatTxt,
  _CalcFields.BOMExplosionDate AS BOMExplosionDate,
  cast('00000000' as abap.dats) AS BufLvlProposalHorizonStartDate,
  _MicroChartData.HorizonStartDate AS HorizonStartDate,
  _MicroChartData.HorizonEndDate AS HorizonEndDate,
  _CalcFields.IsProposalAdopted AS IsProposalAdopted,
  _CalcFields.IsInProcess AS IsInProcess,
  ProductAuthorizationGroup,
  ProductTypeAuthorizationGroup,
  ProductGroupAuthorizationGroup,
  cast(0 as abap.int1) AS UxFcStockLevelProposalStatus,
  cast(0 as abap.int1) AS UxFcProposalMode,
  StockProposal._DDProduct.PastHorizonDLTMultiplierValue AS PastHorizonDLTMultiplierValue,
  StockProposal._DDProduct.FutureHrznDLTMultiplierValue AS FutureHrznDLTMultiplierValue,
  StockProposal._DDProduct.DecoupledLeadTime AS DecoupledLeadTime,
  CurrentPlantDate,
  _CurrentBuffer.ChangeMode AS ChangeMode,
  StockProposal._BufMatPlant AS _BufMatPlant
FROM I_ProdBufLvlPrpslTP AS StockProposal
LEFT OUTER JOIN P_MRPAreaByAreaOfRespy2 AS _SDMAreaOfResponsibility ON StockProposal.MRPController = _SDMAreaOfResponsibility.MRPController AND StockProposal.Plant = _SDMAreaOfResponsibility.Plant  -- association [0..1]
LEFT OUTER JOIN C_ProdBufLvlDmndAdjmtFctrTP AS _ProposalDemandTP ON Material = _ProposalDemandTP.Material AND Plant = _ProposalDemandTP.Plant AND MRPArea = _ProposalDemandTP.MRPArea AND ProposalStartDate = _ProposalDemandTP.ProposalStartDate AND ProposalVersion = _ProposalDemandTP.ProposalVersion  -- association [1..*]
LEFT OUTER JOIN C_ProductDailyDemandChartTP AS _DemandChartTP ON Material = _DemandChartTP.Material AND Plant = _DemandChartTP.Plant AND MRPArea = _DemandChartTP.MRPArea AND ProposalStartDate = _DemandChartTP.ProposalStartDate AND ProposalVersion = _DemandChartTP.ProposalVersion  -- association [1..*]
LEFT OUTER JOIN C_ProductBufferLevelChartTP AS _BufferChartTP ON Material = _BufferChartTP.Material AND Plant = _BufferChartTP.Plant AND MRPArea = _BufferChartTP.MRPArea AND ProposalStartDate = _BufferChartTP.ProposalStartDate AND ProposalVersion = _BufferChartTP.ProposalVersion  -- association [1..*]
LEFT OUTER JOIN C_ProdBufLvlZnAdjmtFctrTP AS _ProposalAdjFactorsTP ON Material = _ProposalAdjFactorsTP.Material AND Plant = _ProposalAdjFactorsTP.Plant AND MRPArea = _ProposalAdjFactorsTP.MRPArea AND ProposalStartDate = _ProposalAdjFactorsTP.ProposalStartDate AND ProposalVersion = _ProposalAdjFactorsTP.ProposalVersion  -- association [1..*]
LEFT OUTER JOIN C_ProductBufferLevelMicroChart AS _BufferLevelMicroCht ON Material = _BufferLevelMicroCht.Material AND Plant = _BufferLevelMicroCht.Plant AND MRPArea = _BufferLevelMicroCht.MRPArea AND ProposalStartDate = _BufferLevelMicroCht.ProposalStartDate AND ProposalVersion = _BufferLevelMicroCht.ProposalVersion  -- association [1..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialT ON Material = _MaterialT.Material AND _MaterialT.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN P_ProdBufLvlMgmtCalcFields AS _CalcFields ON Material = _CalcFields.Material AND Plant = _CalcFields.Plant AND MRPArea = _CalcFields.MRPArea AND ProposalStartDate = _CalcFields.ProposalStartDate AND ProposalVersion = _CalcFields.ProposalVersion  -- association [1..1]
LEFT OUTER JOIN P_ProdBufLvlMicroChtAggrgn AS _MicroChartData ON Material = _MicroChartData.Material AND Plant = _MicroChartData.Plant AND MRPArea = _MicroChartData.MRPArea  -- association [1..1]
LEFT OUTER JOIN P_TimeDependentBufferLevels AS _CurrentBuffer ON Material = _CurrentBuffer.Material AND Plant = _CurrentBuffer.Plant AND MRPArea = _CurrentBuffer.MRPArea AND _CurrentBuffer.BufferLevelStartDate <= $session.system_date AND _CurrentBuffer.BufferLevelEndDate >= $session.system_date  -- association [1..1]
LEFT OUTER JOIN I_Indicatortext AS _IndicatorText ON minorderquantityhaschanged = _IndicatorText.IndicatorValue AND _IndicatorText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_MaterialBufferLevelChart AS _MaterialBufferLevelChart ON Material = _MaterialBufferLevelChart.Material AND Plant = _MaterialBufferLevelChart.Plant AND MRPArea = _MaterialBufferLevelChart.MRPArea  -- association [1..*]
LEFT OUTER JOIN C_MaterialDailyDemand AS _MaterialDailyDemand ON Material = _MaterialDailyDemand.Material AND Plant = _MaterialDailyDemand.Plant AND MRPArea = _MaterialDailyDemand.MRPArea  -- association [1..*]
LEFT OUTER JOIN C_ProposedBufferMatlBOM AS _ProposedBOM ON Material = _ProposedBOM.Material AND Plant = _ProposedBOM.Plant AND MRPArea = _ProposedBOM.MRPArea  -- association [1..*]
LEFT OUTER JOIN C_ProdBufPrflAndClassfctn AS _BufferClassifications ON Material = _BufferClassifications.Material AND Plant = _BufferClassifications.Plant AND MRPArea = _BufferClassifications.MRPArea  -- association [1..*]
LEFT OUTER JOIN I_MRPArea AS _MRPAreaText ON MRPArea = _MRPAreaText.MRPArea  -- association [1..1]
;