P_CHGRECDREFBOMBFRDATAMIGRTN

CDS View

Change Record Reference BOM Before Data Migration

P_CHGRECDREFBOMBFRDATAMIGRTN is a CDS View in S/4HANA. Change Record Reference BOM Before 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_ChgRecdRefBOMDataMigrtn view from COMPOSITE Change Record Reference BOM Data Migrtn

Fields (34)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID 1
BillOfMaterial BillOfMaterial 1
BillOfMaterialCategory BillOfMaterialCategory 1
BillOfMaterialVariant BillOfMaterialVariant 1
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
ChangeNumber ChangeNumber 1
ChangeRecord ChangeRecord 1
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus 1
ChangeRecordItemRelevance ChangeRecordItemRelevance 1
ChangeRecordLifecycleStatus ChangeRecordLifecycleStatus 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
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: 'PCHGRECDREFBBDM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_ChgRecdRefBOMBfrDataMigrtn
  as select from           I_ChgRecdRefBOMBsc as reference_bom
    left outer to one join I_MaterialBOMLink  as BOMLink on  reference_bom.ChgRecRefInternalKey1 = BOMLink.BillOfMaterialCategory
                                                         and reference_bom.ChgRecRefInternalKey2 = BOMLink.BillOfMaterial
                                                         and reference_bom.ChgRecRefInternalKey3 = BOMLink.BillOfMaterialVariant
                                                         and BOMLink.IsConfiguredMaterial        = ''

{
  key reference_bom.ChangeRecordReferenceUUID,
      BOMLink.Material,
      BOMLink.Plant,
      BOMLink.BillOfMaterialVariantUsage,
      BOMLink.BillOfMaterialVariant,
      cast( BOMLink.BillOfMaterial as cs_stlnr preserving type ) as BillOfMaterial,
      BOMLink.BillOfMaterialCategory,
      reference_bom.ChangeRecord,
      reference_bom.ChangeRecordUUID,
      reference_bom.ChangeRecordReferenceType,
      reference_bom.ChangeRecordReferenceSubtype,
      reference_bom.ParentChangeRecordRefUUID,
      reference_bom.IsMainReference,
      reference_bom.ChangeRecordReference,
      reference_bom.ChgRecRefInternalKey1,
      reference_bom.ChgRecRefInternalKey2,
      reference_bom.ChgRecRefInternalKey3,
      reference_bom.CreatedByUser,
      reference_bom.CreationDateTime,
      reference_bom.LastChangedByUser,
      reference_bom.LastChangeDateTime,
      reference_bom.ChangeRecordVirtualRefInd,
      reference_bom.ChangeRecordItemRelevance,
      reference_bom.ChangeRecordRefObjectUUID,
      reference_bom.ChangeRecordItemProcgStatus,
      reference_bom.ChgRecdDataMigrationStatus,
      reference_bom.ChangeNumber,
      reference_bom.ChgRecdItmTgtSts,
      reference_bom.ChgRecdItmDSgntr,
      reference_bom.ChgRecdReasonForChange,
      reference_bom.ExpdCompltnDte,
      reference_bom.ChgRecdAuthznGrpText,
      reference_bom.ChgRecdNmbrChgSts,     
      reference_bom.ChangeRecordLifecycleStatus,
      reference_bom.ChangeRecordStatus  
      
      
}
//where

//  BOMLink.IsConfiguredMaterial = ''

Learn More