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.

CREATE VIEW I_ProdBufPositioning AS
SELECT
  Material,
  Plant,
  cast(MRPArea as berid preserving type) AS MRPArea,
  _ProdBufPositioning.DecoupledLeadTime AS SimulatedDecoupledLeadTime,
  _ProdBufPositioning.IsYesNoValueSelected AS IsYesNoValueSelected,
  _DDProduct.DecoupledLeadTime AS DecoupledLeadTime,
  BaseUnit AS MaterialBaseUnit,
  _ProdBufPositioning.CreatedByUser AS CreatedByUser,
  _ProdBufPositioning.CreationTime AS CreationTime,
  _ProdBufPositioning.DecoupledLeadTmeChgdByUsr AS DecoupledLeadTmeChgdByUsr,
  _ProdBufPositioning.DecoupledLeadTmeChgdOn AS DecoupledLeadTmeChgdOn,
  cast( '' as dismm ) AS BufferedMRPType,
  cast( '' as dismm ) AS NonBufferedMRPType,
  MRPController,
  MRPGroup,
  MRPType,
  ProductGroup AS MaterialGroup,
  ProductType AS MaterialType,
  MRPProcedure,
  PlanningTimeFence,
  LotSizingProcedure,
  MaterialMaxStockLevelQuantity,
  MinimumLotSizeQuantity,
  ReorderThresholdQuantity,
  SafetyStockQuantity,
  IsMRPAreaExisting,
  ProductIsBuffered,
  AuthorizationGroup AS ProductAuthorizationGroup,
  ProductTypeAuthorizationGroup,
  ProductGroupAuthorizationGroup,
  _DDProduct.ProcurementType AS ProcurementType,
  _DDProduct.VariabilityCode AS VariabilityCode,
  _DDProduct.ReplenishmentLeadTimeCode AS ReplenishmentLeadTimeCode,
  _DDProduct.BOMUsageCode AS BOMUsageCode,
  _DDProduct.ConsumptionCode AS ConsumptionCode,
  IsBulkMaterial,
  IsPhantomItem
FROM P_ProdBufPositining
LEFT OUTER JOIN I_ProdBufPositioningCache AS _ProdBufPositioning ON Material = _ProdBufPositioning.Material AND Plant = _ProdBufPositioning.Plant AND MRPArea = _ProdBufPositioning.MRPArea AND _ProdBufPositioning.DecoupledLeadTmeChgdOn = $session.system_date AND _ProdBufPositioning.DecoupledLeadTmeChgdByUsr is not null AND ( IsBulkMaterial = '' OR IsBulkMaterial is null ) AND ( IsPhantomItem = '' OR IsPhantomItem is null )  -- association [1..1]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [1..*]
LEFT OUTER JOIN I_DemandDrivenProduct 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]
LEFT OUTER JOIN I_DDBufPosBufferProfileDetail AS _ProfileText ON _ProfileText.Plant = Plant AND _ProfileText.Language = $session.system_language AND _ProfileText.VariabilityCode = variabilitycode AND _ProfileText.ProcurementType = procurementtype AND _ProfileText.ReplenishmentLeadTimeCode = replenishmentleadtimecode AND _ProfileText.IsMinOrderQtyConsidered = ' '  -- association [0..1]
;