I_CHGRECDREFROUTINGBSC

CDS View

Change Record Reference Object Routing

I_CHGRECDREFROUTINGBSC is a CDS View in S/4HANA. Change Record Reference Object Routing. It contains 22 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 22 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ChgRecdRefOrdSpcfcRoutingTP view from TRANSACTIONAL Change Record Reference Object Ord Spcfc Rtg
I_ChgRecdRefRoutingTP view from TRANSACTIONAL Change Record Reference Object Routing TP
I_ChgRecdRefRoutingVersion view from COMPOSITE Change Record Routing with max version
N_ChangeRecordObjPgRouting view from Change Record Object Page Routing

Fields (22)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID 2
KEY ChangeRecordUUID ChangeRecordUUID 4
ChangeNumber ChangeNumber 2
ChangeRecordItemRelevance ChangeRecordItemRelevance 3
ChangeRecordReference ChangeRecordReference 3
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 2
ChangeRecordReferenceType ChangeRecordReferenceType 3
ChangeRecordRefObjectUUID ChangeRecordRefObjectUUID 2
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 2
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 2
ChgRecdCurrentItemProcgStatus ChgRecdCurrentItemProcgStatus 1
ChgRecdItmDSgntr ChgRecdItmDSgntr 1
ChgRecdItmTgtSts ChgRecdItmTgtSts 1
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 2
ChgRecdReasonForChange ChgRecdReasonForChange 2
CreatedByUser CreatedByUser 3
CreationDateTime CreationDateTime 3
ExpdCompltnDte ExpdCompltnDte 2
IsMainReference IsMainReference 2
LastChangeDateTime LastChangeDateTime 3
LastChangedByUser LastChangedByUser 3
ParentChangeRecordRefUUID ParentChangeRecordRefUUID 3 
@AbapCatalog.sqlViewName: 'ICRREFROUTINGBSC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Change Record Reference Object Routing'
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #L}
@VDM.viewType:#BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE


define view I_ChgRecdRefRoutingBsc
  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
  association [1..1] to I_ChangeRecordBsc as _ChangeRecordBsc on $projection.ChangeRecordUUID = _ChangeRecordBsc.ChangeRecordUUID

{
  key      reference.db_key                             as ChangeRecordReferenceUUID,
           root.issue_id                                as ChangeRecord,

           reference.internal_id1                       as ChgRecRefInternalKey1,
           reference.internal_id2                       as ChgRecRefInternalKey2,
           reference.internal_id3                       as ChgRecRefInternalKey3,
           reference.internal_id4                       as ChgRecRefInternalKey4,

           reference.parent_key                         as ChangeRecordUUID,
           reference.type_cd                            as ChangeRecordReferenceType,
           reference.subtype_cd                         as ChangeRecordReferenceSubtype, 
           reference.internal_guid                      as ChangeRecordRefObjectUUID,
           reference.par_objref_uuid                    as ParentChangeRecordRefUUID,
           reference.main_ref_ind                       as IsMainReference,
           reference.id                                 as ChangeRecordReference,

           @Semantics.user.createdBy: true
           reference.created_by                         as CreatedByUser,
           cast( reference.created_on    as tzntstmps ) as CreationDateTime,
           @Semantics.user.lastChangedBy: true
           reference.changed_by                         as LastChangedByUser,
           cast( reference.changed_on    as tzntstmps ) as LastChangeDateTime,
           reference.virtual_ref_ind                    as ChangeRecordVirtualRefInd,
           reference.item_rel                           as ChangeRecordItemRelevance,
           reference_ext.itm_status                     as ChangeRecordItemProcgStatus,
           reference_ext.tgt_proc_status                as ChgRecdItmTgtSts,
           reference_ext.dig_sign                       as ChgRecdItmDSgntr,
           reference_ext.itm_status                     as ChgRecdCurrentItemProcgStatus,
           reference_ext.reasonforchange                as ChgRecdReasonForChange,
           reference_ext.expected_comp_dat              as ExpdCompltnDte,
           reference_ext.auth_group                     as ChgRecdAuthznGrpText,
           reference_ext.chgstatus                      as ChgRecdNmbrChgSts,
           reference_ext.changenumber                   as ChangeNumber,
           _ChangeRecordBsc

}
where
  reference.type_cd = 'ROU'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/IAM/D_I_OBJ_REF",
"/IAM/D_I_ROOT",
"/PLMI/CR_ITM_EXT"
],
"ASSOCIATED":
[
"I_CHANGERECORDBSC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More