P_CHGRECDREFBITBFRDATAMIGRTN

CDS View

P_CHGRECDREFBITBFRDATAMIGRTN is a CDS View in S/4HANA. 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_ChgRecdRefBOMItmDataMigrtn view from COMPOSITE Change Record Reference BIT Data Mgrtn

Fields (35)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID 1
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: 'PCHGRECREFBITBDM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_ChgRecdRefBITBfrDataMigrtn
  as select from I_ChgRecdRefBOMItmBsc    as reference_bit
    inner join   I_ChgRecdRefBOMComponent as BOMItem on  reference_bit.ChgRecRefInternalKey1 = BOMItem.BillOfMaterialCategory
                                                     and reference_bit.ChgRecRefInternalKey2 = BOMItem.BillOfMaterial
                                                     and reference_bit.ChgRecRefInternalKey3 = BOMItem.BillOfMaterialVariant
                                                     and reference_bit.ChgRecRefInternalKey4 = BOMItem.BillOfMaterialItemNumber

{
  key       reference_bit.ChangeRecordReferenceUUID,
            BOMItem._MaterialBOMLink.Material,
            BOMItem._MaterialBOMLink.Plant,
            BOMItem._MaterialBOMLink.BillOfMaterialVariantUsage,
            BOMItem._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_bit.ChgRecdReasonForChange,
            reference_bit.ExpdCompltnDte,
            reference_bit.ChgRecdAuthznGrpText,
            reference_bit.ChgRecdNmbrChgSts,

            //            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.ChangeNumber,
            @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
            reference_bit._ChangeRecordBsc
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHGRECDREFBOMCOMPONENT",
"I_CHGRECDREFBOMITMBSC",
"I_MATERIALBOMLINK"
],
"ASSOCIATED":
[
"I_CHANGERECORDBSC"
],
"BASE":
[
"I_CHGRECDREFBOMITMBSC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More