P_CHGRECDREFEBMAFTERDATAMIGRTN

CDS View

Change Record Reference EBOM After Data Migration

P_CHGRECDREFEBMAFTERDATAMIGRTN is a CDS View in S/4HANA. Change Record Reference EBOM After Data Migration. It contains 35 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 35 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ChgRecdRefEBOMDataMigrtn view union_all COMPOSITE Change Record Reference EBOM Data Mgrtn
I_ChgRecdRefEBOMSrchSupp view union_all COMPOSITE Change Record Reference EBOM Search Supp

Fields (35)

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

    left outer to one join I_MaterialBOMLink as BOMLink on  reference_ebm.ChgRecRefInternalKey1 = BOMLink.Plant
                                                        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._ChangeRecord
}
where reference_ebm.ChgRecRefInternalKey1 <> 'M' //required as left outer join is used

Learn More