I_ChgRecdRefMBOMDataMigrtn

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_ChgRecdRefMBOMDataMigrtn.
-- 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: ICHGRECREFMBMDM

CREATE VIEW I_ChgRecdRefMBOMDataMigrtn AS
SELECT
  beforeDataMigrtn.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  beforeDataMigrtn.Material AS Material,
  beforeDataMigrtn.Plant AS Plant,
  beforeDataMigrtn.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  beforeDataMigrtn.BillOfMaterialVariant AS BillOfMaterialVariant,
  beforeDataMigrtn.BillOfMaterial AS BillOfMaterial,
  beforeDataMigrtn.BillOfMaterialCategory AS BillOfMaterialCategory,
  beforeDataMigrtn.BillOfMaterialVersion AS BillOfMaterialVersion,
  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,
  beforeDataMigrtn.ChangeRecordItemProcgStatus AS ChangeRecordItemProcgStatus,
  beforeDataMigrtn.ChgRecdItmTgtSts AS ChgRecdItmTgtSts,
  beforeDataMigrtn.ChgRecdItmDSgntr AS ChgRecdItmDSgntr,
  beforeDataMigrtn.ChgRecdReasonForChange AS ChgRecdReasonForChange,
  beforeDataMigrtn.ExpdCompltnDte AS ExpdCompltnDte,
  beforeDataMigrtn.ChgRecdAuthznGrpText AS ChgRecdAuthznGrpText,
  beforeDataMigrtn.ChgRecdNmbrChgSts AS ChgRecdNmbrChgSts,
  beforeDataMigrtn.ChangeNumber AS ChangeNumber
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, P_ChgRecdRefMfgBOMVirtual
;