P_ProdBufLvlMgmtCalcFields

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_ProdBufLvlMgmtCalcFields.
-- 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: PBUFLVLMNGCF

CREATE VIEW P_ProdBufLvlMgmtCalcFields AS
SELECT
  Material,
  Plant,
  MRPArea,
  ProposalStartDate,
  ProposalVersion,
  ProposalStatusChangeDate,
  ProposalMode,
  ProposalModeDescription,
  IsMinOrderQtyConsidered,
  AverageDailyUsage,
  AverageDailyUsageMode,
  AverageDailyUsageModeDesc,
  VariabilityFactor,
  DecoupledLeadTime,
  PurchasingGroup,
  MRPGroup,
  HorizonDaysInPast,
  HorizonDaysInFuture,
  ConsumptionCode,
  ReplenishmentLeadTimeCode,
  ReplenishmentLeadTimeValue,
  BOMUsageCode,
  VariabilityCode,
  VariabilityQuantity,
  ProcurementType,
  BOMExplosionDate,
  cast(cast(MaxStockDifference as abap.quan(13,3)) as pph_maxstockdifference preserving type) AS MaxStockDifference,
  cast(cast(MatlProposedMaxStock as abap.quan(13,3)) as pph_proposedmaxstock preserving type) AS MatlProposedMaxStock,
  MaterialMaxStockLevelQuantity,
  _CalFields.MinOrderQuantityHasChanged AS MinOrderQuantityHasChanged,
  _CalFields.ProductProfileChangeCategory AS ProductProfileChangeCategory,
  _CalFields.ProductProfileHasChanged AS ProductProfileHasChanged,
  _CalFields.AdjustmentType AS AdjustmentType,
  cast(_CalFields.DifferenceInDays as val_text) AS DifferenceInDays,
  cast(cast(division(LeadTimeDifference, 1, 2) as abap.dec(7,2)) as pph_leadtimedifference preserving type ) AS LeadTimeDifference,
  division(VariabilityFactorDifference, 1, 2) AS VariabilityFactorDifference,
  fltp_to_dec(VariabilityFactorDeviationRate as abap.dec( 12, 2 )) AS VariabilityFactorDeviationRate,
  cast(fltp_to_dec(LeadTimeDeviationRate as abap.dec( 7, 2 )) as pph_leadtimedifference preserving type ) AS LeadTimeDeviationRate,
  cast(cast(0 as abap.quan(13,3)) as pph_avgdailyusagedifference preserving type) AS AvgDailyUsageDeviationRate
FROM P_ProdBufLvlMgmtCalcFields1 AS _CalFields
LEFT OUTER JOIN I_HasMinOrderQtyChangedText AS _MinOrdQtyText ON _MinOrdQtyText.MinOrderQuantityHasChanged = _CalFields.MinOrderQuantityHasChanged AND _MinOrdQtyText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ProductProfileChangeCatText AS _ProductProfileChangeCatText ON ProductProfileChangeCategory = _ProductProfileChangeCatText.ProductProfileChangeCategory AND _ProductProfileChangeCatText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ProductProfileHasChangedText AS _HasProfileChangedT ON ProductProfileHasChanged = _HasProfileChangedT.ProductProfileHasChanged AND _HasProfileChangedT.Language = $session.system_language  -- association [1..1]
;