P_CHGRECDREFBITAFTERDATAMIGRTN

CDS View

Change Record Reference BOM Item After Data Migration

P_CHGRECDREFBITAFTERDATAMIGRTN is a CDS View in S/4HANA. Change Record Reference BOM Item After Data Migration. It contains 34 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 34 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChgRecdRefBOMItmDataMigrtn view union_all COMPOSITE Change Record Reference BIT Data Mgrtn

Fields (34)

KeyField CDS FieldsUsed in Views
BillOfMaterial BillOfMaterial 1
BillOfMaterialComponent BillOfMaterialComponent 1
BillOfMaterialItemNumber BillOfMaterialItemNumber 1
BillOfMaterialItemUUID BillOfMaterialItemUUID 1
BillOfMaterialVariant BillOfMaterialVariant 1
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
ChangeNumber ChangeNumber 1
ChangeRecord ChangeRecord 1
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus 1
ChangeRecordItemRelevance ChangeRecordItemRelevance 1
ChangeRecordReference ChangeRecordReference 1
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 1
ChangeRecordReferenceType ChangeRecordReferenceType 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: 'PCHGRECREFBITADM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_ChgRecdRefBITAfterDataMigrtn
  as select from I_ChgRecdRefBOMItmBsc as reference_bit

    inner join   I_BillOfMaterialItem  as BOMItem         on  reference_bit.ChgRecRefInternalKey2 = BOMItem.BillOfMaterial
                                                          and reference_bit.ChgRecRefInternalKey3 = BOMItem.BillOfMaterialVariant
                                                          and reference_bit.ChgRecRefInternalKey4 = BOMItem.BillOfMaterialItemNumber
                                                          and BOMItem.ValidityStartDate           <= $session.system_date
                                                          and BOMItem.ValidityEndDate             >= $session.system_date

    inner join   I_MaterialBOMLink     as MaterialBOMLink on  MaterialBOMLink.BillOfMaterialCategory = 'M'
                                                          and reference_bit.ChgRecRefInternalKey1    = MaterialBOMLink.Plant
                                                          and reference_bit.ChgRecRefInternalKey2    = MaterialBOMLink.BillOfMaterial
                                                          and reference_bit.ChgRecRefInternalKey3    = MaterialBOMLink.BillOfMaterialVariant

{
  key       reference_bit.ChangeRecordReferenceUUID,
            MaterialBOMLink.Material,
            MaterialBOMLink.Plant,
            MaterialBOMLink.BillOfMaterialVariantUsage,
            MaterialBOMLink.BillOfMaterialVariant,
            BOMItem.BillOfMaterialItemUUID,
            cast( BOMItem.BillOfMaterialItemNumber as cs_sposn preserving type ) as BillOfMaterialItemNumber,
            BOMItem.BillOfMaterialComponent,
            cast( BOMItem.BillOfMaterial as cs_stlnr preserving type )           as BillOfMaterial,
            reference_bit.ChangeRecord,
            reference_bit.ChangeRecordUUID,
            reference_bit.ChangeRecordReferenceType,
            reference_bit.ChangeRecordReferenceSubtype,
            reference_bit.ChangeRecordReference,
            reference_bit.ParentChangeRecordRefUUID,
            reference_bit.IsMainReference,
            reference_bit.ChgRecRefInternalKey1,
            reference_bit.ChgRecRefInternalKey2,
            reference_bit.ChgRecRefInternalKey3,
            reference_bit.ChgRecRefInternalKey4,
            //            reference.internal_guid                             as ChgRecRefInternalGUID,

            //            reference_ext.customer_no         as ChangeRecordReferenceCustNo,

            reference_bit.CreatedByUser,
            reference_bit.CreationDateTime,
            reference_bit.LastChangedByUser,
            reference_bit.LastChangeDateTime,
            reference_bit.ChangeRecordVirtualRefInd,
            reference_bit.ChangeRecordItemRelevance,
            reference_bit.ChgRecdDataMigrationStatus,
            reference_bit.ChangeRecordItemProcgStatus,
            reference_bit.ChgRecdItmTgtSts,
            reference_bit.ChgRecdItmDSgntr,
            reference_bit.ChgRecdReasonForChange,
            reference_bit.ExpdCompltnDte,
            reference_bit.ChgRecdAuthznGrpText,
            reference_bit.ChgRecdNmbrChgSts,
            reference_bit.ChangeNumber,

            @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
            reference_bit._ChangeRecordBsc
}
where
  MaterialBOMLink.IsConfiguredMaterial = ''

Learn More