I_ChgRecdRefBOMSrchSupp

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_ChgRecdRefBOMSrchSupp.
-- 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: ICHGRECDREFBSS

CREATE VIEW I_ChgRecdRefBOMSrchSupp 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.ParentChangeRecordRefUUID AS ParentChangeRecordRefUUID,
  beforeDataMigrtn.IsMainReference AS IsMainReference,
  beforeDataMigrtn.ChangeRecordReference AS ChangeRecordReference,
  beforeDataMigrtn.ChgRecRefInternalKey1 AS ChgRecRefInternalKey1,
  beforeDataMigrtn.ChgRecRefInternalKey2 AS ChgRecRefInternalKey2,
  beforeDataMigrtn.ChgRecRefInternalKey3 AS ChgRecRefInternalKey3,
  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.ChangeRecordRefObjectUUID AS ChangeRecordRefObjectUUID,
  beforeDataMigrtn.ChangeRecordItemProcgStatus AS ChangeRecordItemProcgStatus,
  afterDataMigrtn.ChgRecdDataMigrationStatus AS ChgRecdDataMigrationStatus
FROM P_ChgRecdRefBOMBfrDataMigrtn AS beforeDataMigrtn
INNER JOIN R_ChgRecdDataMigrationStatus AS tf ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_ChgRecdRefBOMAfterDataMigrtn
;