I_ProdBufLvlPrpslTP

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_ProdBufLvlPrpslTP.
-- 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: IPRODBUFPRPSLTP

CREATE VIEW I_ProdBufLvlPrpslTP AS
SELECT
  Material,
  Plant,
  MRPArea,
  ProposalStartDate,
  ProposalVersion,
  LastChangeDateTime,
  ProposalEndDate,
  StockLevelProposalID,
  MRPController,
  StockLevelProposalStatus,
  ProposalStatusChangeDate,
  ProposalRunIsSuspended,
  ProposalRunSuspendedFromDate,
  ProposalRunSuspendedToDate,
  ProposedRedZone,
  ProposedYellowZone,
  ProposedGreenZone,
  MinOrdQtyIsConsideredGreenZone,
  AverageDailyUsage,
  DecoupledLeadTime,
  LeadTimeCalculationMethod,
  MaterialBaseUnit,
  _DDProduct.DDScopeProduct AS DDScopeProduct,
  ProposalMode,
  cast(' ' as char1) AS DmndAdjmtFctrIsUpdtd,
  cast(' ' as char1) AS ZoneAdjmtFctrIsUpdtd,
  ProductAuthorizationGroup,
  ProductTypeAuthorizationGroup,
  ProductGroupAuthorizationGroup,
  AverageDailyUsageMode,
  cast( ' ' as pph_dd_extbufhndlgisenabled ) AS ExtBufHndlgIsEnabled,
  case when _Plant._Address.AddressTimeZone is not initial then tstmp_to_dats( tstmp_current_utctimestamp(), _Plant._Address.AddressTimeZone, $session.client, 'NULL' ) else cast($session.system_date as abap.dats) end as CurrentPlantDate AS datsendasCurrentPlantDate
FROM I_ProdBufLvlPrpsl
LEFT OUTER JOIN I_ProdBufLvlPrpslDmndTP 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 I_ProdBufLvlPrpslZnAdjmtFctrTP 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 I_ProdDailyDemandChartTP 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 I_ProdBufLvlChartTP 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 E_Product AS _ProductExt ON Material = _ProductExt.Product  -- association [1..1]
LEFT OUTER JOIN E_Productplant AS _ProductPlantExt ON Material = _ProductPlantExt.Product AND Plant = _ProductPlantExt.Plant  -- association [1..1]
LEFT OUTER JOIN I_DemandDrivenProduct1 AS _DDProduct ON Material = _DDProduct.Material AND Plant = _DDProduct.Plant AND MRPArea = _DDProduct.MRPArea  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
;