I_BOMItemLinksWithPhantom

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_BOMItemLinksWithPhantom.
-- 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_BOMItemLinksWithPhantom AS
SELECT
  link AS BOMLinkUUID,
  ebom_stlty AS EngBillOfMaterialCategory,
  cast( ebom_stlnr as cs_stlnr preserving type ) AS EngBillOfMaterial,
  ebom_stlal AS EngBillOfMaterialVariant,
  ebom_versn AS EngBillOfMaterialVersion,
  ebom_stvkn AS EngBOMItmInhtdNodeNmbr,
  mbom_stlty AS MfgBillOfMaterialCategory,
  cast( mbom_stlnr as cs_stlnr preserving type ) AS MfgBillOfMaterial,
  mbom_stlal AS MfgBillOfMaterialVariant,
  mbom_versn AS MfgBillOfMaterialVersion,
  mbom_stvkn AS MfgBOMItmInhtdNodeNmbr,
  node AS SourceBOMPhantomNodeUUID
FROM stpo_links
;