I_CHGRECDREFFUNCLOCBOMBSC

CDS View

Chg Recd Ref FuncLoc BOM Basic

I_CHGRECDREFFUNCLOCBOMBSC is a CDS View in S/4HANA. Chg Recd Ref FuncLoc BOM Basic. It contains 24 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 24 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ChgRecdFuncLocBillOfMatTP_2 view from TRANSACTIONAL Chg Record Functional Location BOM
I_ChgRecdRefFuncLocBOMTP view from TRANSACTIONAL Chg Recd Ref FL BOM Transactional - TP
R_ChgRecdRefFuncLocBOMTP view_entity from TRANSACTIONAL Chg Recd Obj Ref FuncLoc BOM

Fields (24)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID 2
ChangeNumber ChangeNumber 3
ChangeRecord ChangeRecord 1
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus 2
ChangeRecordItemRelevance ChangeRecordItemRelevance 2
ChangeRecordReference ChangeRecordReference 2
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 2
ChangeRecordReferenceType ChangeRecordReferenceType 2
ChangeRecordRefObjectUUID ChangeRecordRefObjectUUID 3
ChangeRecordUUID ChangeRecordUUID 2
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 2
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 1
ChgRecdCurrentItemProcgStatus ChgRecdCurrentItemProcgStatus 2
ChgRecdItmDSgntr ChgRecdItmDSgntr 1
ChgRecdItmTgtSts ChgRecdItmTgtSts 1
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 1
ChgRecdReasonForChange ChgRecdReasonForChange 1
CreatedByUser CreatedByUser 3
CreationDateTime CreationDateTime 3
ExpdCompltnDte ExpdCompltnDte 1
IsMainReference IsMainReference 2
LastChangeDateTime LastChangeDateTime 3
LastChangedByUser LastChangedByUser 3
ParentChangeRecordRefUUID ParentChangeRecordRefUUID 2 
@AbapCatalog.sqlViewName: 'ICRREFFLBOMBSC'
@AbapCatalog.compiler.compareFilter: true
//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #B,
                         dataClass: #TRANSACTIONAL,
                         sizeCategory: #L}
@VDM.viewType:#BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Chg Recd Ref FuncLoc BOM Basic'
define view I_ChgRecdRefFuncLocBOMBsc
  as select from           /iam/d_i_root    as root
    inner join             /iam/d_i_obj_ref as reference     on  root.db_key         = reference.parent_key
                                                             and root.application    = 'CR'
                                                             and root.issue_category = 'CR'

    left outer to one join /plmi/cr_itm_ext as reference_ext on reference.db_key = reference_ext.parent_key
{
  key reference.db_key                                           as ChangeRecordReferenceUUID,
      root.issue_id                                              as ChangeRecord,
      reference.parent_key                                       as ChangeRecordUUID,
      reference.type_cd                                          as ChangeRecordReferenceType,
      reference.subtype_cd                                       as ChangeRecordReferenceSubtype,
      reference.par_objref_uuid                                  as ParentChangeRecordRefUUID,
      reference.main_ref_ind                                     as IsMainReference,
      reference.id                                               as ChangeRecordReference,
      reference.internal_id1                                     as ChgRecRefInternalKey1,
      reference.internal_id2                                     as ChgRecRefInternalKey2,
      reference.internal_id3                                     as ChgRecRefInternalKey3,
      @Semantics.user.createdBy: true
      reference.created_by                                       as CreatedByUser,
      cast( reference.created_on   as tzntstmps preserving type) as CreationDateTime,
      @Semantics.user.lastChangedBy: true
      reference.changed_by                                       as LastChangedByUser,
      cast( reference.changed_on   as tzntstmps preserving type) as LastChangeDateTime,
      reference.virtual_ref_ind                                  as ChangeRecordVirtualRefInd,
      reference.item_rel                                         as ChangeRecordItemRelevance,
      reference.internal_guid                                    as ChangeRecordRefObjectUUID,
      reference_ext.itm_status                                   as ChangeRecordItemProcgStatus,
      reference_ext.itm_status                                   as ChgRecdCurrentItemProcgStatus,
      reference_ext.sdm_status                                   as ChgRecdDataMigrationStatus,
      reference_ext.changenumber                                 as ChangeNumber,
      reference_ext.tgt_proc_status                              as ChgRecdItmTgtSts,
      reference_ext.dig_sign                                     as ChgRecdItmDSgntr,
      reference_ext.reasonforchange                              as ChgRecdReasonForChange,
      reference_ext.expected_comp_dat                            as ExpdCompltnDte,
      reference_ext.auth_group                                   as ChgRecdAuthznGrpText,
      reference_ext.chgstatus                                    as ChgRecdNmbrChgSts

}
where
  reference.type_cd = 'FBM'

Learn More