I_ProdBufPositioning

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_ProdBufPositioning.
-- 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: IPRODBUFPOS

CREATE VIEW I_ProdBufPositioning AS
SELECT
  Material,
  Plant,
  cast(MRPArea as berid preserving type) AS MRPArea,
  _DDProduct.DecoupledLeadTime AS DecoupledLeadTime,
  I_ProductPlantMRPArea._Material.BaseUnit AS MaterialBaseUnit,
  case when _ProdBufPositioning.AvgDailyUsgeChgdOn < $session.system_date then -9999 when _ProdBufPositioning.AvgDailyUsgeChgdByUsr is null then -9999 else _ProdBufPositioning.AverageDailyUsage end as AverageDailyUsage AS AverageDailyUsageendasAverageDailyUsage,
  _ProdBufPositioning.CreatedByUser AS CreatedByUser,
  _ProdBufPositioning.AvgDailyUsgeChgdByUsr AS AvgDailyUsgeChgdByUsr,
  _ProdBufPositioning.CreationTime AS CreationTime,
  _ProdBufPositioning.AvgDailyUsgeChgdOn AS AvgDailyUsgeChgdOn,
  _ProdBufPositioning.DecoupledLeadTmeChgdByUsr AS DecoupledLeadTmeChgdByUsr,
  _ProdBufPositioning.DecoupledLeadTmeChgdOn AS DecoupledLeadTmeChgdOn,
  cast( '' as dismm ) AS BufferedMRPType,
  cast( '' as dismm ) AS NonBufferedMRPType,
  MRPController,
  MRPGroup,
  MRPType,
  _Material.ProductGroup AS MaterialGroup,
  _Material.ProductType AS MaterialType,
  MRPProcedure,
  PlanningTimeFence,
  LotSizingProcedure,
  MaterialMaxStockLevelQuantity,
  MinimumLotSizeQuantity,
  ReorderThresholdQuantity,
  SafetyStockQuantity,
  IsMRPAreaExisting,
  ProductIsBuffered,
  _Product.AuthorizationGroup AS ProductAuthorizationGroup,
  _Product._ProductType.AuthorizationGroup AS ProductTypeAuthorizationGroup,
  _Product._ProductGroup.AuthorizationGroup AS ProductGroupAuthorizationGroup,
  _DDProduct.ProcurementType AS ProcurementType,
  _DDProduct.VariabilityCode AS VariabilityCode,
  _DDProduct.ReplenishmentLeadTimeCode AS ReplenishmentLeadTimeCode,
  case when _DDProduct.DDScopeProduct is null then '' else _DDProduct.DDScopeProduct end as DDScopeProduct AS DDScopeProductendasDDScopeProduct,
  _DDProduct.BOMUsageCode AS BOMUsageCode,
  _DDProduct.ConsumptionCode AS ConsumptionCode
FROM I_ProductPlantMRPArea
LEFT OUTER JOIN I_ProdBufPositioningCache AS _ProdBufPositioning ON Material = _ProdBufPositioning.Material AND Plant = _ProdBufPositioning.Plant AND MRPArea = _ProdBufPositioning.MRPArea  -- association [1..1]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [1..*]
LEFT OUTER JOIN I_DemandDrivenExtdProduct AS _DDProduct ON Material = _DDProduct.Material AND Plant = _DDProduct.Plant AND MRPArea = _DDProduct.MRPArea  -- association [1..1]
LEFT OUTER JOIN I_ProcurementTypeText AS _ProcmtText ON procurementtype = _ProcmtText.ProcurementType AND _ProcmtText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProdBufVariabilityIndicatorT AS _VarLongTxt ON variabilitycode = _VarLongTxt.VariabilityIndicator AND _VarLongTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProdBufLeadTimeIndicatorT AS _ReplnmtLongTxt ON replenishmentleadtimecode = _ReplnmtLongTxt.ReplenishmentLeadTimeCode AND _ReplnmtLongTxt.Language = $session.system_language  -- association [0..1]
;