P_ProductBufferLevelChartFutr

DDL: P_PRODUCTBUFFERLEVELCHARTFUTR SQL: PDDPRODBUFCHART Type: view COMPOSITE Package: PPH_DD_VDM_STLM
24 Fields 2 Data Sources 4 Associations

Bufferl Level Chart for Future

P_ProductBufferLevelChartFutr is a Composite CDS View that provides data about "Bufferl Level Chart for Future" in SAP S/4HANA. It reads from 2 data sources (P_DDMRPChartHorizon, I_ProdBufLvlPrpsl) and exposes 24 fields with key fields Material, Plant, MRPArea, ProposalStartDate, ProposalVersion. It has 4 associations to related views. Part of development package PPH_DD_VDM_STLM.

Data Sources (2)

SourceAliasJoin Type
P_DDMRPChartHorizon _cald from
I_ProdBufLvlPrpsl _ProposalHeader inner

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_ProdBufLvlPrpslZnAdjmtFctr _ZnFctrfut _ZnFctrfut.Material = _ProposalHeader.Material and _ZnFctrfut.Plant = _ProposalHeader.Plant and _ZnFctrfut.MRPArea = _ProposalHeader.MRPArea and _ZnFctrfut.ProposalStartDate = _ProposalHeader.ProposalStartDate and _ZnFctrfut.ProposalVersion = _ProposalHeader.ProposalVersion and _cald.CalendarDate >= _ZnFctrfut.BufPrpslZoneAdjmtFctrStartDate and _cald.CalendarDate <= _ZnFctrfut.BufPrpslZoneAdjmtFctrEndDate and _ZnFctrfut.BufPrpslZoneAdjmtFctrEndDate >= $session.system_date
[1..1] I_ProdBufLvlPrpslDemand _dmndfut _dmndfut.Material = _ProposalHeader.Material and _dmndfut.Plant = _ProposalHeader.Plant and _dmndfut.MRPArea = _ProposalHeader.MRPArea and _dmndfut.ProposalStartDate = _ProposalHeader.ProposalStartDate and _dmndfut.ProposalVersion = _ProposalHeader.ProposalVersion and _cald.CalendarDate >= _dmndfut.ProposalRecordDetailsStartDate and _cald.CalendarDate <= _dmndfut.ProposalRecordDetailsEndDate and _dmndfut.ProposalRecordDetailsEndDate >= $session.system_date
[1..1] I_ProdBufLvlPrpslDemandFctr _dadjfut _dadjfut.Material = _ProposalHeader.Material and _dadjfut.Plant = _ProposalHeader.Plant and _dadjfut.MRPArea = _ProposalHeader.MRPArea and _dadjfut.ProposalStartDate = _ProposalHeader.ProposalStartDate and _dadjfut.ProposalVersion = _ProposalHeader.ProposalVersion and _cald.CalendarDate >= _dadjfut.ProposalDmndAdjmtFctrStartDate and _cald.CalendarDate <= _dadjfut.ProposalDmndAdjmtFctrEndDate and _dadjfut.ProposalDmndAdjmtFctrEndDate >= $session.system_date
[1..1] I_TimeDependentStockBuffer _defstk _defstk.Material = _ProposalHeader.Material and _defstk.Plant = _ProposalHeader.Plant and _defstk.MRPArea = _ProposalHeader.MRPArea and _defstk.ProposalStartDate = _ProposalHeader.ProposalStartDate and _defstk.ProposalVersion = _ProposalHeader.ProposalVersion and _cald.CalendarDate >= _defstk.BufferLevelStartDate and _cald.CalendarDate <= _defstk.BufferLevelEndDate and _defstk.BufferLevelEndDate >= $session.system_date

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PDDPRODBUFCHART view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY Material I_ProdBufLvlPrpsl Material Vehicle Model
KEY Plant I_ProdBufLvlPrpsl Plant Valuation Area
KEY MRPArea I_ProdBufLvlPrpsl MRPArea MRP Area
KEY ProposalStartDate I_ProdBufLvlPrpsl ProposalStartDate
KEY ProposalVersion I_ProdBufLvlPrpsl ProposalVersion
KEY BufPrpslZonePostingDate P_DDMRPChartHorizon CalendarDate Calendar Date
VariabilityFactorendasProposedRedZone
LeadTimeFactorendasProposedGreenZone
ProposedGreenZoneMinOrdQty I_ProdBufLvlPrpsl MinimumOrderQuantity Minimum Order Quantity
DecoupledLeadTime I_ProdBufLvlPrpsl DecoupledLeadTime
LeadTimeFactor I_ProdBufLvlPrpsl LeadTimeFactor
VariabilityFactor I_ProdBufLvlPrpsl VariabilityFactor
ProposedGreenZoneOrdCycle
StockLevelProposalStatus I_ProdBufLvlPrpsl StockLevelProposalStatus
DemandAdjustmentFactor _dadjfut DemandAdjustmentFactor
AverageDailyUsage _dmndfut AverageDailyUsage
AvgDailyUsageUnit _dmndfut AvgDailyUsageUnit
MaterialBaseUnit I_ProdBufLvlPrpsl MaterialBaseUnit Valuation Unit
UnitOfMeasureNumberOfDecimals I_ProdBufLvlPrpsl UnitOfMeasureNumberOfDecimals
ProductAuthorizationGroup I_ProdBufLvlPrpsl ProductAuthorizationGroup
ProductTypeAuthorizationGroup I_ProdBufLvlPrpsl ProductTypeAuthorizationGroup
ProductGroupAuthorizationGroup I_ProdBufLvlPrpsl ProductGroupAuthorizationGroup
IsMinOrderQtyConsidered I_ProdBufLvlPrpsl IsMinOrderQtyConsidered
MinOrdQtyIsConsideredGreenZone MinOrdQtyIsConsideredGreenZone

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_ProductBufferLevelChartFutr.
-- 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: PDDPRODBUFCHART

CREATE VIEW P_ProductBufferLevelChartFutr 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,
  case when _ProposalHeader.StockLevelProposalStatus = 'A' then _defstk.MaterialSafetyStockQty else (_ProposalHeader.DecoupledLeadTime * _dmndfut.AverageDailyUsage * _dadjfut.DemandAdjustmentFactor * _ProposalHeader.LeadTimeFactor) + (_ProposalHeader.DecoupledLeadTime * _dmndfut.AverageDailyUsage *_dadjfut.DemandAdjustmentFactor * _ProposalHeader.LeadTimeFactor * _ProposalHeader.VariabilityFactor) end as ProposedRedZone AS VariabilityFactorendasProposedRedZone,
  case when _ProposalHeader.StockLevelProposalStatus = 'A' then _defstk.MaterialMaxStockLevelQuantity - _defstk.ReorderThresholdQuantity else _ProposalHeader.DecoupledLeadTime * _dmndfut.AverageDailyUsage * _dadjfut.DemandAdjustmentFactor * _ProposalHeader.LeadTimeFactor end as ProposedGreenZone AS LeadTimeFactorendasProposedGreenZone,
  _ProposalHeader.MinimumOrderQuantity AS ProposedGreenZoneMinOrdQty,
  _ProposalHeader.DecoupledLeadTime AS DecoupledLeadTime,
  _ProposalHeader.LeadTimeFactor AS LeadTimeFactor,
  _ProposalHeader.VariabilityFactor AS VariabilityFactor,
  _dmndfut.AdjustedAverageDailyUsage * _ProposalHeader.OrderCycle AS ProposedGreenZoneOrdCycle,
  _ProposalHeader.StockLevelProposalStatus AS StockLevelProposalStatus,
  _dadjfut.DemandAdjustmentFactor AS DemandAdjustmentFactor,
  _dmndfut.AverageDailyUsage AS AverageDailyUsage,
  _dmndfut.AvgDailyUsageUnit AS AvgDailyUsageUnit,
  _ProposalHeader.MaterialBaseUnit AS MaterialBaseUnit,
  _ProposalHeader.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  _ProposalHeader.ProductAuthorizationGroup AS ProductAuthorizationGroup,
  _ProposalHeader.ProductTypeAuthorizationGroup AS ProductTypeAuthorizationGroup,
  _ProposalHeader.ProductGroupAuthorizationGroup AS ProductGroupAuthorizationGroup,
  _ProposalHeader.IsMinOrderQtyConsidered AS IsMinOrderQtyConsidered,
  MinOrdQtyIsConsideredGreenZone
FROM P_DDMRPChartHorizon AS _cald
INNER JOIN I_ProdBufLvlPrpsl AS _ProposalHeader ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProdBufLvlPrpslZnAdjmtFctr AS _ZnFctrfut ON _ZnFctrfut.Material = _ProposalHeader.Material AND _ZnFctrfut.Plant = _ProposalHeader.Plant AND _ZnFctrfut.MRPArea = _ProposalHeader.MRPArea AND _ZnFctrfut.ProposalStartDate = _ProposalHeader.ProposalStartDate AND _ZnFctrfut.ProposalVersion = _ProposalHeader.ProposalVersion AND _cald.CalendarDate >= _ZnFctrfut.BufPrpslZoneAdjmtFctrStartDate AND _cald.CalendarDate <= _ZnFctrfut.BufPrpslZoneAdjmtFctrEndDate AND _ZnFctrfut.BufPrpslZoneAdjmtFctrEndDate >= $session.system_date  -- association [1..1]
LEFT OUTER JOIN I_ProdBufLvlPrpslDemand AS _dmndfut ON _dmndfut.Material = _ProposalHeader.Material AND _dmndfut.Plant = _ProposalHeader.Plant AND _dmndfut.MRPArea = _ProposalHeader.MRPArea AND _dmndfut.ProposalStartDate = _ProposalHeader.ProposalStartDate AND _dmndfut.ProposalVersion = _ProposalHeader.ProposalVersion AND _cald.CalendarDate >= _dmndfut.ProposalRecordDetailsStartDate AND _cald.CalendarDate <= _dmndfut.ProposalRecordDetailsEndDate AND _dmndfut.ProposalRecordDetailsEndDate >= $session.system_date  -- association [1..1]
LEFT OUTER JOIN I_ProdBufLvlPrpslDemandFctr AS _dadjfut ON _dadjfut.Material = _ProposalHeader.Material AND _dadjfut.Plant = _ProposalHeader.Plant AND _dadjfut.MRPArea = _ProposalHeader.MRPArea AND _dadjfut.ProposalStartDate = _ProposalHeader.ProposalStartDate AND _dadjfut.ProposalVersion = _ProposalHeader.ProposalVersion AND _cald.CalendarDate >= _dadjfut.ProposalDmndAdjmtFctrStartDate AND _cald.CalendarDate <= _dadjfut.ProposalDmndAdjmtFctrEndDate AND _dadjfut.ProposalDmndAdjmtFctrEndDate >= $session.system_date  -- association [1..1]
LEFT OUTER JOIN I_TimeDependentStockBuffer AS _defstk ON _defstk.Material = _ProposalHeader.Material AND _defstk.Plant = _ProposalHeader.Plant AND _defstk.MRPArea = _ProposalHeader.MRPArea AND _defstk.ProposalStartDate = _ProposalHeader.ProposalStartDate AND _defstk.ProposalVersion = _ProposalHeader.ProposalVersion AND _cald.CalendarDate >= _defstk.BufferLevelStartDate AND _cald.CalendarDate <= _defstk.BufferLevelEndDate AND _defstk.BufferLevelEndDate >= $session.system_date  -- association [1..1]
;

Learn More