I_CHGRECDREFEBOM

CDS View

Change Record Reference EBOM

I_CHGRECDREFEBOM is a CDS View in S/4HANA. Change Record Reference EBOM. It contains 16 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 16 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
A_ChgRecdRefEngBOM view_entity from COMPOSITE Change Record ref Engineering BOM
C_EngSnpshtChgNtcForEBOMVH view inner CONSUMPTION Eng Snapshot Change Notice Change Records for EBOM
I_ChgImpactEBOMAssg view from COMPOSITE Engineering BOM Assignment
I_ChgRecdRefEngBOMTP view from TRANSACTIONAL Change Record Reference Object EBOM
I_PlngScopeDetsAssgdToChgRecd view left_outer COMPOSITE Details of Planning Scopes Assigned to Change Record
P_ChgRecdRefEngBOM view from TRANSACTIONAL
P_EngBOMAndPlngScpAssgd view inner COMPOSITE
P_EngBOMAssgdToChgRecd view from COMPOSITE

Fields (16)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterialVariant BillOfMaterialVariant 3
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage 2
KEY BillOfMaterialVersion BillOfMaterialVersion 1
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID,ChgRecdRefEngBillOfMatlUUID 3
KEY Material Material 2
KEY Plant Plant 3
BillOfMaterial BillOfMaterial 3
BillOfMaterialCategory BillOfMaterialCategory 3
ChangeRecord ChangeRecord 2
ChangeRecordUUID ChangeRecordUUID 1
ChgRecRefInternalKey1 ChgRecdRefInternalKey1EngBOM 1
ChgRecRefInternalKey2 ChgRecdRefInternalKey2EngBOM 1
ChgRecRefInternalKey3 ChgRecdRefInternalKey3EngBOM 1
ChgRecRefInternalKey4 ChgRecdRefInternalKey4EngBOM 1
CreatedByUser CreatedByUser 1
LastChangedByUser LastChangedByUser 1 
@AbapCatalog.sqlViewName: 'ICHGRECDREFEBOM'
@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 EBOM'
define view I_ChgRecdRefEBOM
  as select from I_ChgRecdRefEBOMDataMigrtn
  association [0..1] to I_ChangeRecordItemValidity as _ChgRecord    on $projection.ChangeRecordUUID = _ChgRecord.ChangeRecordUUID
  association [0..1] to I_ChangeMaster             as _ChangeMaster on $projection.ChangeNumber = _ChangeMaster.ChangeNumber // Line item Change Number

  association [0..1] to I_CalendarDate             as _calendar     on _calendar.CalendarDate = $session.system_date
{
  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,
      ChangeRecordItemProcgStatus,
      ChgRecdItmTgtSts,
      ChgRecdItmDSgntr,
      ChangeRecordItemProcgStatus as ChgRecdCurrentItemProcgStatus,
      ChangeNumber,
      case
         when _ChangeMaster.ChangeNumber is not initial
         then _ChangeMaster.ChangeNumberValidFromDate
         when _ChgRecord.ChangeNumber is not initial
         then _ChgRecord.ChangeNumberValidFromDate
         else _calendar.CalendarDate
         end                      as ChangeNumberValidFromDate,

      /* Associations */
      _ChangeRecord
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE",
"I_CHANGEMASTER",
"I_CHANGERECORDITEMVALIDITY",
"I_CHGRECDREFEBOMDATAMIGRTN"
],
"ASSOCIATED":
[
"I_CALENDARDATE",
"I_CHANGEMASTER",
"I_CHANGERECORDBSC",
"I_CHANGERECORDITEMVALIDITY"
],
"BASE":
[
"I_CHGRECDREFEBOMDATAMIGRTN"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More