P_ProductBufferMicroChart1

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_ProductBufferMicroChart1.
-- 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: PPRDBUFMICHT1

CREATE VIEW P_ProductBufferMicroChart1 AS
SELECT
  _ProposalHeader.Material AS Material,
  _ProposalHeader.Plant AS Plant,
  _ProposalHeader.MRPArea AS MRPArea,
  _ProposalHeader.ProposalStartDate AS ProposalStartDate,
  _ProposalHeader.ProposalVersion AS ProposalVersion,
  _Cald.CalendarDate AS BufPrpslZonePostingDate,
  cast(fltp_to_dec(1.0 as abap.dec( 4, 2 )) as pph_adj_factor_red_zone) AS RedZoneAdjustmentFactor,
  cast(fltp_to_dec(1.0 as abap.dec( 4, 2 )) as pph_adj_factor_yellow_zone) AS YellowZoneAdjustmentFactor,
  cast(fltp_to_dec(1.0 as abap.dec( 4, 2 )) as pph_adj_factor_green_zone) AS GreenZoneAdjustmentFactor,
  cast(fltp_to_dec(1.0 as abap.dec( 4, 2 )) as pph_demand_adj_factor) AS DemandAdjustmentFactor,
  MaterialSafetyStockQty AS ProposedRedZone,
  MaterialSafetyStockQty,
  ReorderThresholdQuantity - MaterialSafetyStockQty AS ProposedYellowZone,
  ReorderThresholdQuantity,
  MaterialMaxStockLevelQuantity - ReorderThresholdQuantity AS ProposedGreenZone,
  MaterialMaxStockLevelQuantity,
  cast(fltp_to_dec(0.00 as abap.dec(4,2)) as pph_proposedgreenzone) AS ProposedGreenZoneMinOrdQty,
  cast(fltp_to_dec(0.00 as abap.dec(4,2)) as pph_proposedgreenzone) AS ProposedGreenZoneOrdCycle,
  cast(0 as pph_decoupled_leadtime) AS DecoupledLeadTime,
  cast(fltp_to_dec(0.00 as abap.dec(4,2)) as pph_variability_factor) AS VariabilityFactor,
  cast(fltp_to_dec(0.00 as abap.dec(4,2)) as pph_leadtime_factor) AS LeadTimeFactor,
  _dmndpast.AverageDailyUsage AS AverageDailyUsage,
  cast('' as meins) AS AvgDailyUsageUnit,
  MaterialBaseUnit
FROM P_ProdBufMicroChtIntervalDays AS _Cald
LEFT OUTER JOIN I_ProdBufLvlPrpsl AS _ProposalHeader ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TimeDependentStockBuffer AS _TimeStkBuffer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProdBufLvlPrpslDemand AS _dmndpast ON _dmndpast.Material = _TimeStkBuffer.Material AND _dmndpast.Plant = _TimeStkBuffer.Plant AND _dmndpast.MRPArea = _TimeStkBuffer.MRPArea AND _dmndpast.ProposalStartDate = _TimeStkBuffer.ProposalStartDate AND _dmndpast.ProposalVersion = _TimeStkBuffer.ProposalVersion AND _dmndpast.ProposalRecordDetailsStartDate <= _Cald.CalendarDate AND _dmndpast.ProposalRecordDetailsEndDate >= _Cald.CalendarDate AND _dmndpast.ProposalRecordDetailsStartDate <= $session.system_date  -- association [1..1]
-- UNION ALL with additional select branch(es): P_ProdBufMicroChartFuture
;