I_CHGRECDREFMBOM

CDS View

Change Record Reference MBOM

I_CHGRECDREFMBOM is a CDS View in S/4HANA. Change Record Reference MBOM. It contains 27 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 27 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
A_ChgRecdRefMfgBOM view_entity from COMPOSITE Change Record Ref Manufacturing BOM
I_ChgImpactMBOMAssg view from COMPOSITE Manufacturing BOM Assignment
I_ChgRecdRefMfgBOMTP view from TRANSACTIONAL Change Record Reference MBOM
P_ChgRecdRefMfgBOM view from TRANSACTIONAL Private view for Mfg. BOM Reference
P_VersMfgBOMwithCRAssgd view inner COMPOSITE Mfg BOM and Change Record Assigned
P_VersMfgBOMwithOpenCRAssgd view inner COMPOSITE Version Controlled Mfg BOM With Their Change Records
R_ChgRecdObjPgMfgBOMTP view_entity from TRANSACTIONAL Chg Recd Obj Pg Mfg BOM

Fields (27)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 5
KEY BillOfMaterialCategory BillOfMaterialCategory 5
KEY BillOfMaterialVariant BillOfMaterialVariant 4
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID,ChgRecdRefMfgBillOfMatlUUID 3
KEY ChgRecRefInternalKey4 ChgRecRefInternalKey4 2
KEY Plant Plant 4
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 2
BillOfMaterialVersion BillOfMaterialVersion 1
ChangeNumber ChangeNumber 1
ChangeRecordItemRelevance ChangeRecordItemRelevance 1
ChangeRecordReference ChangeRecordReference 1
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 1
ChangeRecordReferenceType ChangeRecordReferenceType 1
ChangeRecordRefObjectUUID BillOfMaterialHeaderUUID,ChangeRecordRefObjectUUID 3
ChangeRecordUUID ChangeRecordUUID 1
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 1
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 1
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 1
ChgRecdReasonForChange ChgRecdReasonForChange 1
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 1
ExpdCompltnDte ExpdCompltnDte 1
IsMainReference IsMainReference 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 2
Material Material 2
ParentChangeRecordRefUUID ParentChangeRecordRefUUID 1 
@AbapCatalog.sqlViewName: 'ICHGRECDREFMBOM'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #L}
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Change Record Reference MBOM'
define view I_ChgRecdRefMBOM
  as select from I_ChgRecdRefMBOMDataMigrtn
{
  key ChangeRecordReferenceUUID,

      Material,
      Plant,
      BillOfMaterialVariantUsage,
      BillOfMaterialVariant,
      BillOfMaterial,
      BillOfMaterialCategory,
      BillOfMaterialVersion,
      ChangeRecord,
      ChangeRecordUUID,
      ChangeRecordReferenceType,
      ChangeRecordReferenceSubtype,
      ChangeRecordRefObjectUUID,
      ParentChangeRecordRefUUID,
      IsMainReference,
      ChangeRecordReference,
      ChgRecRefInternalKey1,
      ChgRecRefInternalKey2,
      ChgRecRefInternalKey3,
      ChgRecRefInternalKey4,
      CreatedByUser,
      CreationDateTime,
      LastChangedByUser,
      LastChangeDateTime,
      ChangeRecordVirtualRefInd,
      ChangeRecordItemRelevance,
      ChgRecdReasonForChange,
      ExpdCompltnDte,
      ChgRecdAuthznGrpText,
      ChgRecdNmbrChgSts,
      ChangeNumber,
      ChangeRecordItemProcgStatus,
      ChgRecdItmTgtSts,
      ChgRecdItmDSgntr,
      ChangeRecordItemProcgStatus as ChgRecdCurrentItemProcgStatus,

      /* Associations */
      _ChangeRecordBsc
}

Learn More