P_ChgRecdRefBITAfterDataMigrtn

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 P_ChgRecdRefBITAfterDataMigrtn.
-- 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: PCHGRECREFBITADM

CREATE VIEW P_ChgRecdRefBITAfterDataMigrtn AS
SELECT
  reference_bit.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  MaterialBOMLink.Material AS Material,
  MaterialBOMLink.Plant AS Plant,
  MaterialBOMLink.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  MaterialBOMLink.BillOfMaterialVariant AS BillOfMaterialVariant,
  BOMItem.BillOfMaterialItemUUID AS BillOfMaterialItemUUID,
  cast( BOMItem.BillOfMaterialItemNumber as cs_sposn preserving type ) AS BillOfMaterialItemNumber,
  BOMItem.BillOfMaterialComponent AS BillOfMaterialComponent,
  cast( BOMItem.BillOfMaterial as cs_stlnr preserving type ) AS BillOfMaterial,
  reference_bit.ChangeRecord AS ChangeRecord,
  reference_bit.ChangeRecordUUID AS ChangeRecordUUID,
  reference_bit.ChangeRecordReferenceType AS ChangeRecordReferenceType,
  reference_bit.ChangeRecordReferenceSubtype AS ChangeRecordReferenceSubtype,
  reference_bit.ChangeRecordReference AS ChangeRecordReference,
  reference_bit.ParentChangeRecordRefUUID AS ParentChangeRecordRefUUID,
  reference_bit.IsMainReference AS IsMainReference,
  reference_bit.ChgRecRefInternalKey1 AS ChgRecRefInternalKey1,
  reference_bit.ChgRecRefInternalKey2 AS ChgRecRefInternalKey2,
  reference_bit.ChgRecRefInternalKey3 AS ChgRecRefInternalKey3,
  reference_bit.ChgRecRefInternalKey4 AS ChgRecRefInternalKey4,
  reference_bit.CreatedByUser AS CreatedByUser,
  reference_bit.CreationDateTime AS CreationDateTime,
  reference_bit.LastChangedByUser AS LastChangedByUser,
  reference_bit.LastChangeDateTime AS LastChangeDateTime,
  reference_bit.ChangeRecordVirtualRefInd AS ChangeRecordVirtualRefInd,
  reference_bit.ChangeRecordItemRelevance AS ChangeRecordItemRelevance,
  reference_bit.ChgRecdDataMigrationStatus AS ChgRecdDataMigrationStatus,
  reference_bit.ChangeRecordItemProcgStatus AS ChangeRecordItemProcgStatus,
  reference_bit.ChgRecdItmTgtSts AS ChgRecdItmTgtSts,
  reference_bit.ChgRecdItmDSgntr AS ChgRecdItmDSgntr,
  reference_bit.ChgRecdReasonForChange AS ChgRecdReasonForChange,
  reference_bit.ExpdCompltnDte AS ExpdCompltnDte,
  reference_bit.ChgRecdAuthznGrpText AS ChgRecdAuthznGrpText,
  reference_bit.ChgRecdNmbrChgSts AS ChgRecdNmbrChgSts,
  reference_bit.ChangeNumber AS ChangeNumber,
  reference_bit.ChgRecdDescription AS ChgRecdDescription,
  reference_bit.ChgRecdEffectivityType AS ChgRecdEffectivityType,
  reference_bit._ChangeRecordBsc AS _ChangeRecordBsc
FROM I_ChgRecdRefBOMItmBsc AS reference_bit
INNER JOIN I_BillOfMaterialItem AS BOMItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaterialBOMLink AS MaterialBOMLink ON /* join condition not captured in parsed metadata */
;