C_DemandDrivenBOMComponents

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_DemandDrivenBOMComponents.
-- 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: CDDBOMCOMP

CREATE VIEW C_DemandDrivenBOMComponents AS
SELECT
  _DemandDrivenMaterialData.Material AS Material,
  _DemandDrivenMaterialData.Plant AS Plant,
  MRPArea,
  Material AS BillOfMaterialComponent,
  cast('' as maktx) AS MaterialName,
  _MRPType.MRPType AS MRPType,
  cast('' as dibez) AS MRPTypeName,
  _MRPType.MRPProcedure AS MRPProcedure,
  _DemandDrivenMaterialData.MRPController AS MRPController,
  cast(0 as abap.int4) AS BillOfMaterialItemNodeNumber,
  cast(0 as abap.int4) AS BOMExplosionLevel,
  cast(0 as abap.int4) AS ParentNode,
  cast('expanded' as dtinf_hierarchy_drill_state) AS DemandDrivenBOMCompDrillState,
  0 AS BOMItemNodeCount,
  0 AS SolutionRank,
  cast('' as abap.char( 1 )) AS MaterialShortageStatus,
  cast('' as abap.char( 60 )) AS BOMItemReferenceID,
  cast('' as abap.char( 60 )) AS MaterialBOMObjectID,
  0 AS DecoupledLeadTime,
  0 AS IndividualLeadTime,
  IsBulkMaterial,
  IsPhantomItem,
  _DemandDrivenMaterialData.MRPMaterialStatus AS MRPMaterialStatus,
  _DemandDrivenMaterialData._MatStatus[MRPMaterialStatus = _DemandDrivenMaterialData.MRPMaterialStatus].MRPMaterialStatusName AS MRPMaterialStatusName
FROM I_DemandDrivenMaterialData AS _DemandDrivenMaterialData
INNER JOIN I_SDMAreaOfResponsibility AS _SDMAreaOfResponsibility ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_DmndDrivenSupDmndList AS _SupDmndList ON Material = _SupDmndList.Material AND Plant = _SupDmndList.Plant AND MRPArea = _SupDmndList.MRPArea  -- association [0..*]
LEFT OUTER JOIN C_ProductStockRqmtListChart AS _BufferedChart ON Material = _BufferedChart.Material AND Plant = _BufferedChart.Plant AND MRPArea = _BufferedChart.MRPArea  -- association [1..*]
LEFT OUTER JOIN C_DDProjtdStkChart AS _ProjtdStkChart ON Material = _ProjtdStkChart.Material AND Plant = _ProjtdStkChart.Plant AND MRPArea = _ProjtdStkChart.MRPArea  -- association [1..*]
LEFT OUTER JOIN C_ProductPlantTextInfo AS _Note ON Material = _Note.Product AND Plant = _Note.Plant  -- association [0..*]
LEFT OUTER JOIN I_ProductUnitsOfMeasure AS _Unit ON Material = _Unit.Product  -- association [1..*]
LEFT OUTER JOIN C_DDMaterialSOS AS _MatSOS ON Material = _MatSOS.Material AND Plant = _MatSOS.Plant AND MRPArea = _MatSOS.MRPArea  -- association [0..*]
LEFT OUTER JOIN C_ProductInformation AS _ProductInfo ON Material = _ProductInfo.Material AND Plant = _ProductInfo.Plant AND MRPArea = _ProductInfo.MRPArea  -- association [1..1]
LEFT OUTER JOIN C_DmndDrivenSupOrder AS _DDOrderCRUD ON Material = _DDOrderCRUD.Material AND Plant = _DDOrderCRUD.Plant AND MRPArea = _DDOrderCRUD.MRPArea  -- association [0..*]
LEFT OUTER JOIN C_DDOrderDetails AS _DDOrderDetails ON Material = _DDOrderDetails.Material AND Plant = _DDOrderDetails.Plant  -- association [0..*]
;