C_ProductDailyDemandChartTP

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_ProductDailyDemandChartTP.
-- 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: CPRODDMNDCHARTTP

CREATE VIEW C_ProductDailyDemandChartTP AS
SELECT
  Material,
  Plant,
  MRPArea,
  ProposalStartDate,
  ProposalVersion,
  DemandPostingDate,
  DemandAdjustmentFactor,
  AverageDailyUsage,
  AdjustedAverageDailyUsage,
  AvgDailyUsageUnit,
  _ProposalHeader.AverageDailyUsageMode AS AverageDailyUsageMode,
  cast('' as sydatum) AS AvgDailyUsageHorizonStartDate,
  cast('' as sydatum) AS AvgDailyUsageHorizonEndDate,
  _MatDailyDemand.QuantityInBaseUnit AS QuantityInBaseUnit,
  _MatDailyDemand.PlndIndepRqmtQuantity AS PlndIndepRqmtQuantity,
  _MatDailyDemand.DailyPlndIndepRqmtQuantity AS DailyPlndIndepRqmtQuantity,
  _MatDailyDemand.WeeklyPlndIndepRqmtQtyPerDay AS WeeklyPlndIndepRqmtQtyPerDay,
  _MatDailyDemand.MonthlyPlndIndepRqmtQtyPerDay AS MonthlyPlndIndepRqmtQtyPerDay,
  _MatDailyDemand.TotalWeeklyPlndIndepRqmtQty AS TotalWeeklyPlndIndepRqmtQty,
  _MatDailyDemand.TotalMonthlyPlndIndepRqmtQty AS TotalMonthlyPlndIndepRqmtQty,
  _MatDailyDemand.MaterialBaseUnit AS MaterialBaseUnit,
  I_ProdDailyDemandChartTP.ProductAuthorizationGroup AS ProductAuthorizationGroup,
  I_ProdDailyDemandChartTP.ProductGroupAuthorizationGroup AS ProductGroupAuthorizationGroup,
  I_ProdDailyDemandChartTP.ProductTypeAuthorizationGroup AS ProductTypeAuthorizationGroup
FROM I_ProdDailyDemandChartTP
LEFT OUTER JOIN C_ProductBufferLevelMgmtTP AS _ProposalHeaderTP ON Material = _ProposalHeaderTP.Material AND Plant = _ProposalHeaderTP.Plant AND MRPArea = _ProposalHeaderTP.MRPArea AND ProposalStartDate = _ProposalHeaderTP.ProposalStartDate AND ProposalVersion = _ProposalHeaderTP.ProposalVersion  -- association [1..1]
LEFT OUTER JOIN C_MaterialDailyDemand AS _MatDailyDemand ON Material = _MatDailyDemand.Material AND Plant = _MatDailyDemand.Plant AND MRPArea = _MatDailyDemand.MRPArea AND DemandPostingDate = _MatDailyDemand.PostingDate  -- association [1..1]
LEFT OUTER JOIN I_ProdBufLvlPrpsl AS _ProposalHeader ON Material = _ProposalHeader.Material AND Plant = _ProposalHeader.Plant AND MRPArea = _ProposalHeader.MRPArea AND ProposalStartDate = _ProposalHeader.ProposalStartDate AND ProposalVersion = _ProposalHeader.ProposalVersion  -- association [1..1]
;