I_ChgRecdRefMBOMSrchSupp

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_ChgRecdRefMBOMSrchSupp.
-- 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: ICHGRECDREFMBSS

CREATE VIEW I_ChgRecdRefMBOMSrchSupp AS
SELECT
  beforeDataMigrtn.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  beforeDataMigrtn.Material AS Material,
  beforeDataMigrtn.Plant AS Plant,
  beforeDataMigrtn.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  beforeDataMigrtn.BillOfMaterialVariant AS BillOfMaterialVariant,
  beforeDataMigrtn.ChangeRecord AS ChangeRecord,
  beforeDataMigrtn.ChangeRecordUUID AS ChangeRecordUUID,
  beforeDataMigrtn.ChangeRecordReferenceType AS ChangeRecordReferenceType,
  beforeDataMigrtn.ChangeRecordReferenceSubtype AS ChangeRecordReferenceSubtype,
  beforeDataMigrtn.ChangeRecordRefObjectUUID AS ChangeRecordRefObjectUUID,
  beforeDataMigrtn.ParentChangeRecordRefUUID AS ParentChangeRecordRefUUID,
  beforeDataMigrtn.IsMainReference AS IsMainReference,
  beforeDataMigrtn.ChangeRecordReference AS ChangeRecordReference,
  beforeDataMigrtn.ChgRecRefInternalKey1 AS ChgRecRefInternalKey1,
  beforeDataMigrtn.ChgRecRefInternalKey2 AS ChgRecRefInternalKey2,
  beforeDataMigrtn.ChgRecRefInternalKey3 AS ChgRecRefInternalKey3,
  beforeDataMigrtn.ChgRecRefInternalKey4 AS ChgRecRefInternalKey4,
  beforeDataMigrtn.CreatedByUser AS CreatedByUser,
  beforeDataMigrtn.CreationDateTime AS CreationDateTime,
  beforeDataMigrtn.LastChangedByUser AS LastChangedByUser,
  beforeDataMigrtn.LastChangeDateTime AS LastChangeDateTime,
  beforeDataMigrtn.ChangeRecordVirtualRefInd AS ChangeRecordVirtualRefInd,
  beforeDataMigrtn.ChangeRecordItemRelevance AS ChangeRecordItemRelevance,
  beforeDataMigrtn.ChgRecdDataMigrationStatus AS ChgRecdDataMigrationStatus,
  afterDataMigrtn._ChangeRecordBsc AS _ChangeRecordBsc
FROM P_ChgRecdRefMBMBfrDataMigrtn AS beforeDataMigrtn
INNER JOIN R_ChgRecdDataMigrationStatus AS tf ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_ChgRecdRefMBMAfterDataMigrtn
;