C_BOMUpstreamAndDownstream

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_BOMUpstreamAndDownstream.
-- 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 C_BOMUpstreamAndDownstream AS
SELECT
  Material,
  Plant,
  MRPArea,
  Material AS BillOfMaterialComponent,
  MRPController,
  _Product._MRPArea.MRPAreaText AS MRPAreaText,
  cast( 0 as pph_decoupled_leadtime) AS SimulatedDecoupledLeadTime,
  _DDProduct.DecoupledLeadTime AS DecoupledLeadTime,
  1 AS DecoupledLeadTimeCompression,
  cast('X' as abap.char(1)) AS IsCriticalPath,
  cast('X' as abap.char(1)) AS ProdIsOnLongestUnprotectedPath,
  cast(0 as abap.int4) AS UpstreamHierNodeID,
  cast(0 as abap.int4) AS NetworkOriginNodeID,
  cast(0 as abap.int4) AS UpstreamHierParentID,
  cast(0 as abap.int4) AS BOMUsageValue,
  cast('' as nfmat) AS UpstreamHierParentName,
  cast(1 as abap.int1) AS ProductBOMExpandState,
  cast(0 as abap.int2) AS HierarchyNodeLevel,
  cast('' as plantname) AS PlantName,
  MRPType,
  _MRPType.MRPTypeName AS MRPTypeName,
  MRPProcedure,
  ProductIsBuffered,
  _BufferText._BufferStatusText[1:Language = $session.system_language].BufferStatusText AS BufferStatusText,
  cast('' as maktx) AS MaterialName,
  cast('' as pph_dd_buffer_status) AS BufferStatus,
  IsMRPAreaExisting,
  cast('' as abap.char( 1 )) AS NodeCategory,
  _Product._Material.ProductType AS MaterialType,
  cast('' as producttypename) AS ProductTypeName,
  cast('' as pph_materialbufferprofile) AS MaterialBufferProfile,
  cast('' as pph_materialbufferprofiletxt) AS MaterialBufferProfileText,
  _DDProduct.BOMUsageCode AS BOMUsageCode,
  _DDProduct._BOMUsgeText.BOMUsageDescription AS BOMUsageDescription,
  _DDProduct.ConsumptionCode AS ConsumptionCode,
  _DDProduct._ConsumptionText.ConsumptionDescription AS ConsumptionDescription,
  _DDProduct.ReplenishmentLeadTimeCode AS ReplenishmentLeadTimeCode,
  _DDProduct._ReplnmtText.ReplenishmentLeadTimeDesc AS ReplenishmentLeadTimeDesc,
  _DDProduct.VariabilityCode AS VariabilityCode,
  _DDProduct._VarText.VariabilityDescription AS VariabilityDescription,
  _DDProduct.ProcurementType AS ProcurementType,
  _DDProduct._ProcmtText.ProcurementTypeDescription AS ProcurementTypeDescription,
  _DDProduct.DDScopeProduct AS DDScopeProduct,
  IsBulkMaterial,
  IsPhantomItem,
  cast('' as xfeld) AS ProductIsInMyAreaOfRespy
FROM I_ProductPlantMRPArea AS _Product
LEFT OUTER JOIN C_ProdBOMUpstreamMRPAreaExtn AS _ProductMRPArea ON Material = _ProductMRPArea.Material AND Plant = _ProductMRPArea.Plant  -- association [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_MRPTypeText AS _MRPType ON MRPType = _MRPType.MRPType AND _MRPType.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_BufferStatus AS _BufferText ON ProductIsBuffered = _BufferText.BufferStatus  -- association [1..1]
LEFT OUTER JOIN P_LastFallBackLeadTime AS _ILT ON Material = _ILT.Material AND Plant = _ILT.ProductionPlant AND MRPArea = _ILT.MRPArea  -- association [1..1]
LEFT OUTER JOIN E_Product AS _MatExtension ON Material = _MatExtension.Product  -- association [0..1]
LEFT OUTER JOIN E_Productplant AS _PlantExtension ON Material = _PlantExtension.Product AND Plant = _PlantExtension.Plant  -- association [0..1]
;