I_ChangeRecordRefObjIcons

DDL: I_CHANGERECORDREFOBJICONS Type: view_entity BASIC

Change Record Reference Object Icons

I_ChangeRecordRefObjIcons is a Basic CDS View that provides data about "Change Record Reference Object Icons" in SAP S/4HANA. It reads from 1 data source (/plmi/cr_refob_i) and exposes 4 fields with key fields ChangeRecordUUID, ChangeRecordType, ChangeRecordReferenceType. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
/plmi/cr_refob_i RefObjicon from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ChangeRecordBsc _ChangeRecordObjPg $projection.changerecorduuid = _ChangeRecordObjPg.ChangeRecordUUID and $projection.ChangeRecordType = _ChangeRecordObjPg.ChangeRecordType

Annotations (6)

NameValueLevelField
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Change Record Reference Object Icons view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordUUID _ChangeRecordObjPg ChangeRecordUUID
KEY ChangeRecordType /plmi/cr_refob_i issue_type
KEY ChangeRecordReferenceType /plmi/cr_refob_i ref_obj_type
ref_obj_iconendasChangeRecordRefObjIcon 
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Change Record Reference Object Icons'
@ObjectModel.usageType:{
    serviceQuality: #C,
    sizeCategory: #S,
    dataClass: #MIXED
}
define view entity I_ChangeRecordRefObjIcons
  as select from           /plmi/cr_refob_i as RefObjicon
    left outer to one join /plmi/cr_objtype as ObjType on RefObjicon.ref_obj_type = ObjType.type
  association [1..1] to I_ChangeRecordBsc as _ChangeRecordObjPg on  $projection.changerecorduuid = _ChangeRecordObjPg.ChangeRecordUUID
                                                                and $projection.ChangeRecordType = _ChangeRecordObjPg.ChangeRecordType
{
  key _ChangeRecordObjPg.ChangeRecordUUID,
  key RefObjicon.issue_type   as ChangeRecordType,
  key RefObjicon.ref_obj_type as ChangeRecordReferenceType,

      case when RefObjicon.ref_obj_icon is initial
        then ObjType.ref_obj_icon
        else RefObjicon.ref_obj_icon
        end                   as ChangeRecordRefObjIcon

}
where
  RefObjicon.application = 'CR'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGERECORDBSC",
"/PLMI/CR_OBJTYPE",
"/PLMI/CR_REFOB_I"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More