I_ChangeRecordBillOfMaterial_2

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_ChangeRecordBillOfMaterial_2.
-- 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_ChangeRecordBillOfMaterial_2 AS
SELECT
  BOM_old.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  BOM_old.ChangeRecordUUID AS ChangeRecordUUID,
  case when BOMLink.Material is null then cast(substring( BOM_old.ChangeRecordReference, 1, 40) as matnr) else cast(BOMLink.Material as matnr) end as Material AS MaterialasmatnrendasMaterial,
  case when BOMLink.Plant is null then cast(substring( BOM_old.ChangeRecordReference, 41, 4) as werks_d) else cast(BOMLink.Plant as werks_d) end as Plant AS Plantaswerks_dendasPlant,
  BOM.BillOfMaterial AS BillOfMaterial,
  BOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  BOM.Material AS Material,
  BOM.Plant AS Plant,
  BOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  BOM.BillOfMaterialCategory AS BillOfMaterialCategory
FROM I_ChangeRecordItemDetail AS BOM_old
INNER JOIN R_ChgRecDataMigrationStatus AS tf ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChgRecHdrExtension AS _HeaderExtension ON _HeaderExtension.ParentChangeRecordUUID = BOM_old.ChangeRecordUUID  -- association [1..1]
-- UNION ALL with additional select branch(es): I_ChangeRecordMaterialBOM_2
;