I_ChgRecdRefBOMDataMigrtn

@AbapCatalog.sqlViewName: 'ICHGRECDREFBDM'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #X,
                         dataClass: #MIXED,
                         sizeCategory: #L}
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Change Record Reference BOM Data Migrtn' 
define view I_ChgRecdRefBOMDataMigrtn
  as select from P_ChgRecdRefBOMBfrDataMigrtn as beforeDataMigrtn
    inner join   R_ChgRecdDataMigrationStatus as tf on(
      tf.ChgRecdDataMigrationPhase                                                 = 'X'
    )
                                                    or(
                                                      tf.ChgRecdDataMigrationPhase = 'R'
                                                    )
{
  key beforeDataMigrtn.ChangeRecordReferenceUUID,
      beforeDataMigrtn.Material,
      beforeDataMigrtn.Plant,
      beforeDataMigrtn.BillOfMaterialVariantUsage,
      beforeDataMigrtn.BillOfMaterialVariant,
      beforeDataMigrtn.BillOfMaterial,
      beforeDataMigrtn.BillOfMaterialCategory,
      beforeDataMigrtn.ChangeRecord,
      beforeDataMigrtn.ChangeRecordUUID,
      beforeDataMigrtn.ChangeRecordReferenceType,
      beforeDataMigrtn.ChangeRecordReferenceSubtype,
      beforeDataMigrtn.ParentChangeRecordRefUUID,
      beforeDataMigrtn.IsMainReference,
      beforeDataMigrtn.ChangeRecordReference,
      beforeDataMigrtn.ChgRecRefInternalKey1,
      beforeDataMigrtn.ChgRecRefInternalKey2,
      beforeDataMigrtn.ChgRecRefInternalKey3,
      beforeDataMigrtn.CreatedByUser,
      beforeDataMigrtn.CreationDateTime,
      beforeDataMigrtn.LastChangedByUser,
      beforeDataMigrtn.LastChangeDateTime,
      beforeDataMigrtn.ChangeRecordVirtualRefInd,
      beforeDataMigrtn.ChangeRecordItemRelevance,
      beforeDataMigrtn.ChangeRecordRefObjectUUID,
      beforeDataMigrtn.ChangeRecordItemProcgStatus,
      beforeDataMigrtn.ChangeNumber,
      beforeDataMigrtn.ChgRecdDataMigrationStatus,
      beforeDataMigrtn.ChgRecdItmTgtSts,
      beforeDataMigrtn.ChgRecdItmDSgntr,
      beforeDataMigrtn.ChgRecdReasonForChange,
      beforeDataMigrtn.ExpdCompltnDte,
      beforeDataMigrtn.ChgRecdAuthznGrpText,
      beforeDataMigrtn.ChgRecdNmbrChgSts,
      beforeDataMigrtn.ChangeRecordLifecycleStatus,
      beforeDataMigrtn.ChangeRecordStatus
}
where
  (
    (
         tf.ChgRecdDataMigrationPhase             = 'X'
         // or tf.ChgRecdDataMigrationPhase                = 'R'

          
    )
    and (
         beforeDataMigrtn.ChgRecdDataMigrationStatus is initial
      or beforeDataMigrtn.ChgRecdDataMigrationStatus is null
      or beforeDataMigrtn.ChgRecdDataMigrationStatus = '01'
    )
  )

union all

select from  P_ChgRecdRefBOMAfterDataMigrtn as afterDataMigrtn
  inner join R_ChgRecdDataMigrationStatus   as tf on(
    tf.ChgRecdDataMigrationPhase                                                 = 'F'
  )
                                                  or(
                                                    tf.ChgRecdDataMigrationPhase = 'R'
                                                  )
{
  key afterDataMigrtn.ChangeRecordReferenceUUID,
      afterDataMigrtn.Material,
      afterDataMigrtn.Plant,
      afterDataMigrtn.BillOfMaterialVariantUsage,
      afterDataMigrtn.BillOfMaterialVariant,
      afterDataMigrtn.BillOfMaterial,
      afterDataMigrtn.BillOfMaterialCategory,
      afterDataMigrtn.ChangeRecord,
      afterDataMigrtn.ChangeRecordUUID,
      afterDataMigrtn.ChangeRecordReferenceType,
      afterDataMigrtn.ChangeRecordReferenceSubtype,
      afterDataMigrtn.ParentChangeRecordRefUUID,
      afterDataMigrtn.IsMainReference,
      afterDataMigrtn.ChangeRecordReference,
      afterDataMigrtn.ChgRecRefInternalKey1,
      afterDataMigrtn.ChgRecRefInternalKey2,
      afterDataMigrtn.ChgRecRefInternalKey3,
      afterDataMigrtn.CreatedByUser,
      afterDataMigrtn.CreationDateTime,
      afterDataMigrtn.LastChangedByUser,
      afterDataMigrtn.LastChangeDateTime,
      afterDataMigrtn.ChangeRecordVirtualRefInd,
      afterDataMigrtn.ChangeRecordItemRelevance,
      afterDataMigrtn.ChangeRecordRefObjectUUID,
      afterDataMigrtn.ChangeRecordItemProcgStatus,
      afterDataMigrtn.ChangeNumber,
      afterDataMigrtn.ChgRecdDataMigrationStatus,
      afterDataMigrtn.ChgRecdItmTgtSts,
      afterDataMigrtn.ChgRecdItmDSgntr,
      afterDataMigrtn.ChgRecdReasonForChange,
      afterDataMigrtn.ExpdCompltnDte,
      afterDataMigrtn.ChgRecdAuthznGrpText,
      afterDataMigrtn.ChgRecdNmbrChgSts,
      afterDataMigrtn.ChangeRecordLifecycleStatus,
      afterDataMigrtn.ChangeRecordStatus
}
where
  (
    (
      tf.ChgRecdDataMigrationPhase               = 'F'
      or tf.ChgRecdDataMigrationPhase            = 'R'
    )
    and (
      afterDataMigrtn.ChgRecdDataMigrationStatus = '01'
      or afterDataMigrtn.ChgRecdDataMigrationStatus is initial
      or afterDataMigrtn.ChgRecdDataMigrationStatus is null
    )
  )
  and afterDataMigrtn.ChangeRecordVirtualRefInd  = '' 

union all select from P_ChgRecdRefBOMVirtual
{
  key ChangeRecordReferenceUUID,
      Material,
      Plant,
      BillOfMaterialVariantUsage,
      BillOfMaterialVariant,
      BillOfMaterial,
      BillOfMaterialCategory,
      ChangeRecord,
      ChangeRecordUUID,
      ChangeRecordReferenceType,
      ChangeRecordReferenceSubtype,
      ParentChangeRecordRefUUID,
      IsMainReference,
      ChangeRecordReference,
      ChgRecRefInternalKey1,
      ChgRecRefInternalKey2,
      ChgRecRefInternalKey3,
      CreatedByUser,
      CreationDateTime,
      LastChangedByUser,
      LastChangeDateTime,
      ChangeRecordVirtualRefInd,
      ChangeRecordItemRelevance,
      ChangeRecordRefObjectUUID,
      ChangeRecordItemProcgStatus,
      ChangeNumber,
      ChgRecdDataMigrationStatus,
      ChgRecdItmTgtSts,
      ChgRecdItmDSgntr,
      ChgRecdReasonForChange,
      ExpdCompltnDte,
      ChgRecdAuthznGrpText,
      ChgRecdNmbrChgSts,
      ChangeRecordLifecycleStatus,
      ChangeRecordStatus      
}
where
  ChangeRecordVirtualRefInd = 'X'