C_ProductBOMUpstream

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_ProductBOMUpstream.
-- 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: CPRODBOMUPSTREAM

CREATE VIEW C_ProductBOMUpstream AS
SELECT
  Material,
  Plant,
  Material AS BillOfMaterialComponent,
  MRPArea,
  cast('' as dismm) AS MRPType,
  cast('' as disvf) AS MRPProcedure,
  cast(0 as pph_ind_lead_time) AS IndividualLeadTime,
  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 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 pph_dd_buffer_status) AS BufferStatus,
  cast('' as diber) AS IsMRPAreaExisting,
  cast('' as abap.char( 1 )) AS NodeCategory,
  cast('' as maktx) AS MaterialName,
  cast('' as plantname) AS PlantName,
  cast('' as bertx) AS MRPAreaText,
  cast('' as abap.sstring(20)) AS BufferStatusText,
  cast('' as dibez) AS MRPTypeName,
  _Material.AuthorizationGroup AS ProductAuthorizationGroup,
  _Material._ProductType.AuthorizationGroup AS ProductTypeAuthorizationGroup,
  _Material._ProductGroup.AuthorizationGroup AS ProductGroupAuthorizationGroup,
  IsBulkMaterial
FROM I_ProductPlantMRPArea
LEFT OUTER JOIN C_ProdBOMUpstreamMRPAreaExtn AS _ProductMRPArea ON Material = _ProductMRPArea.Material AND Plant = _ProductMRPArea.Plant  -- association [1..*]
LEFT OUTER JOIN I_DemandDrivenExtdProduct AS _DDProduct ON Material = _DDProduct.Material AND Plant = _DDProduct.Plant AND MRPArea = _DDProduct.MRPArea  -- association [1..1]
;