P_CHGRECDREFBOMBFRDATAMIGRTN

CDS View

P_CHGRECDREFBOMBFRDATAMIGRTN is a CDS View in S/4HANA. It contains 34 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 34 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ChgRecdRefBOMDataMigrtn view from COMPOSITE Change Record Reference BOM Data Migrtn
I_ChgRecdRefBOMSrchSupp view from COMPOSITE Change Record Reference BOM Search Supp

Fields (34)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID 2
BillOfMaterial BillOfMaterial 1
BillOfMaterialCategory BillOfMaterialCategory 1
BillOfMaterialVariant BillOfMaterialVariant 2
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 2
ChangeNumber ChangeNumber 1
ChangeRecord ChangeRecord 2
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus 2
ChangeRecordItemRelevance ChangeRecordItemRelevance 2
ChangeRecordLifecycleStatus ChangeRecordLifecycleStatus 1
ChangeRecordReference ChangeRecordReference 2
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 2
ChangeRecordReferenceType ChangeRecordReferenceType 2
ChangeRecordRefObjectUUID ChangeRecordRefObjectUUID 2
ChangeRecordUUID ChangeRecordUUID 2
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 2
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 1
ChgRecdDataMigrationStatus ChgRecdDataMigrationStatus 1
ChgRecdItmDSgntr ChgRecdItmDSgntr 1
ChgRecdItmTgtSts ChgRecdItmTgtSts 1
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 1
ChgRecdReasonForChange ChgRecdReasonForChange 1
ChgRecRefInternalKey1 ChgRecRefInternalKey1 2
ChgRecRefInternalKey2 ChgRecRefInternalKey2 2
ChgRecRefInternalKey3 ChgRecRefInternalKey3 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: '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 = ''

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHGRECDREFBOMBSC",
"I_MATERIALBOMLINK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More