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(
         beforeDataMigrtn.ChgRecdDataMigrationStatus is initial
      or beforeDataMigrtn.ChgRecdDataMigrationStatus is null
    )
  )

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(
      afterDataMigrtn.ChgRecdDataMigrationStatus = '01'
    )
  )
  and 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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CHGRECDREFBOMAFTERDATAMIGRTN",
"P_CHGRECDREFBOMBFRDATAMIGRTN",
"P_CHGRECDREFBOMVIRTUAL",
"R_CHGRECDDATAMIGRATIONSTATUS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/