P_CHGRECDREFMBMBFRDATAMIGRTN

CDS View

Change Record Reference MBOM Before Data Migration

P_CHGRECDREFMBMBFRDATAMIGRTN is a CDS View in S/4HANA. Change Record Reference MBOM Before Data Migration. It contains 35 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 35 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChgRecdRefMBOMDataMigrtn view from COMPOSITE Change Record Reference MBOM Data Mgrtn

Fields (35)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID 1
BillOfMaterial BillOfMaterial 1
BillOfMaterialCategory BillOfMaterialCategory 1
BillOfMaterialVariant BillOfMaterialVariant 1
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
BillOfMaterialVersion BillOfMaterialVersion 1
ChangeNumber ChangeNumber 1
ChangeRecord ChangeRecord 1
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus 1
ChangeRecordItemRelevance ChangeRecordItemRelevance 1
ChangeRecordReference ChangeRecordReference 1
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 1
ChangeRecordReferenceType ChangeRecordReferenceType 1
ChangeRecordRefObjectUUID ChangeRecordRefObjectUUID 1
ChangeRecordUUID ChangeRecordUUID 1
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 1
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 1
ChgRecdDataMigrationStatus ChgRecdDataMigrationStatus 1
ChgRecdItmDSgntr ChgRecdItmDSgntr 1
ChgRecdItmTgtSts ChgRecdItmTgtSts 1
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 1
ChgRecdReasonForChange ChgRecdReasonForChange 1
ChgRecRefInternalKey1 ChgRecRefInternalKey1 1
ChgRecRefInternalKey2 ChgRecRefInternalKey2 1
ChgRecRefInternalKey3 ChgRecRefInternalKey3 1
ChgRecRefInternalKey4 ChgRecRefInternalKey4 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
ExpdCompltnDte ExpdCompltnDte 1
IsMainReference IsMainReference 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
Material Material 1
ParentChangeRecordRefUUID ParentChangeRecordRefUUID 1
Plant Plant 1 
@AbapCatalog.sqlViewName: 'PCHGRECREFMBMBDM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_ChgRecdRefMBMBfrDataMigrtn
  as select from I_ChgRecdRefMfgBOMBsc as reference_ebm
       // Left outer join is used here to display deleted MBOMs

       left outer to one join I_MaterialBOMLink  as BOMLink  on  reference_ebm.ChgRecRefInternalKey1 = BOMLink.BillOfMaterialCategory
                                                             and reference_ebm.ChgRecRefInternalKey2 = BOMLink.BillOfMaterial
                                                             and reference_ebm.ChgRecRefInternalKey3 = BOMLink.BillOfMaterialVariant
                                                              
{
  key reference_ebm.ChangeRecordReferenceUUID,
      BOMLink.Material,
      BOMLink.Plant,
      BOMLink.BillOfMaterialVariantUsage,
      BOMLink.BillOfMaterialVariant,
      cast( BOMLink.BillOfMaterial as cs_stlnr preserving type ) as BillOfMaterial,
      BOMLink.BillOfMaterialCategory,
      cast(reference_ebm.ChgRecRefInternalKey4 as cs_versn)      as BillOfMaterialVersion,
      reference_ebm.ChangeRecord,
      reference_ebm.ChangeRecordUUID,
      reference_ebm.ChangeRecordReferenceType,
      reference_ebm.ChangeRecordReferenceSubtype,
      reference_ebm.ChangeRecordRefObjectUUID,
      reference_ebm.ChgRecRefInternalKey1,
      reference_ebm.ChgRecRefInternalKey2,
      reference_ebm.ChgRecRefInternalKey3,
      reference_ebm.ChgRecRefInternalKey4,
      reference_ebm.ParentChangeRecordRefUUID,
      reference_ebm.IsMainReference,
      reference_ebm.ChangeRecordReference,
      reference_ebm.CreatedByUser,
      reference_ebm.CreationDateTime,
      reference_ebm.LastChangedByUser,
      reference_ebm.LastChangeDateTime,
      reference_ebm.ChangeRecordVirtualRefInd,
      reference_ebm.ChangeRecordItemRelevance,
      reference_ebm.ChgRecdDataMigrationStatus,
      reference_ebm.ChangeRecordItemProcgStatus,
      reference_ebm.ChgRecdItmTgtSts,
      reference_ebm.ChgRecdItmDSgntr,
      reference_ebm.ChgRecdReasonForChange,
      reference_ebm.ExpdCompltnDte,
      reference_ebm.ChgRecdAuthznGrpText,
      reference_ebm.ChgRecdNmbrChgSts,
      reference_ebm.ChangeNumber,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      reference_ebm._ChangeRecordBsc
}
where reference_ebm.ChgRecRefInternalKey1 = 'M' //required as left outer join is used

Learn More