I_ChangeRecordReferenceItem

DDL: I_CHANGERECORDREFERENCEITEM Type: view_entity COMPOSITE Package: VDM_PLMB_CR_RAP

ChangeRecord Item types

I_ChangeRecordReferenceItem is a Composite CDS View that provides data about "ChangeRecord Item types" in SAP S/4HANA. It reads from 4 data sources (I_ChgRecdFeatureToggleEnabled, I_ChgRecdFeatureToggleDisabled, I_ChangeRecordRefObj, I_ChgRecdRefObjVisibility_2) and exposes 5 fields with key fields ChangeRecordType, ChangeRecordItemType, ChangeRecordItemType. It has 2 associations to related views. It is exposed through 1 OData service (UI_CHANGERECORD_MANAGE). Part of development package VDM_PLMB_CR_RAP.

4 data source(s) Exposed by 1 service(s) 5 fields

Data Sources (4)

SourceAliasJoin Type
I_ChgRecdFeatureToggleEnabled _ftg inner
I_ChgRecdFeatureToggleDisabled _ftg inner
I_ChangeRecordRefObj v1 union_all
I_ChgRecdRefObjVisibility_2 v2 from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_SAPObjectNodeType_2 _NONT v2.ChgRecordItemTypeInUpperCase = _NONT.SAPObjectNodeTypeInUppercase
[0..1] I_SAPObjectNodeTypeText_2 _NONT_Txt v2.ChgRecordItemTypeInUpperCase = _NONT_Txt.SAPObjectNodeTypeInUppercase and _NONT_Txt.Language = $session.system_language

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label ChangeRecord Item types view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey ChangeRecordType view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_CHANGERECORD_MANAGE UI_CHANGERECORD_MANAGE V4 C1 NOT_RELEASED

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordType I_ChgRecdRefObjVisibility_2 ChangeRecordType
KEY ChangeRecordItemType I_ChgRecdRefObjVisibility_2 ChangeRecordItemType
ChangeRecordType
KEY ChangeRecordItemType I_ChangeRecordRefObj ChangeRecordReferenceType
ChangeRecordReferenceTypeText I_ChangeRecordRefObj ChangeRecordReferenceTypeText 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'ChangeRecord Item types'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #CUSTOMIZING
}
@VDM.viewType:#COMPOSITE
@ObjectModel.dataCategory:#VALUE_HELP
@ObjectModel.representativeKey: 'ChangeRecordType'
@Search.searchable: true
define view entity I_ChangeRecordReferenceItem  as select from I_ChgRecdRefObjVisibility_2   as v2
  inner join I_ChgRecdFeatureToggleEnabled as _ftg on _ftg.ChangeRecordFeatureToggleID = '/PLMI/CHANGERECORD_CONFIG'
  association [0..1] to I_SAPObjectNodeType_2 as _NONT on v2.ChgRecordItemTypeInUpperCase = _NONT.SAPObjectNodeTypeInUppercase
  association [0..1] to I_SAPObjectNodeTypeText_2 as _NONT_Txt on  v2.ChgRecordItemTypeInUpperCase = _NONT_Txt.SAPObjectNodeTypeInUppercase
                                                               and _NONT_Txt.Language            = $session.system_language

{
  key v2.ChangeRecordType,
      @Search.defaultSearchElement: true
      @Search.ranking: #MEDIUM
      @Search.fuzzinessThreshold: 0.8
      @ObjectModel.foreignKey.association: '_NONT'
  key v2.ChangeRecordItemType,
      @Search.defaultSearchElement: true
      @Search.ranking: #MEDIUM
      @Search.fuzzinessThreshold: 0.8
      _NONT_Txt.SAPObjectNodeTypeDescription as ChangeRecordReferenceTypeText

}
union all select from I_ChangeRecordRefObj           as v1
  inner join          I_ChgRecdFeatureToggleDisabled as _ftg on _ftg.ChangeRecordFeatureToggleID = '/PLMI/CHANGERECORD_CONFIG'
{
  key  v1.ChangeRecordType,
  key  v1.ChangeRecordReferenceType as ChangeRecordItemType,
       v1.ChangeRecordReferenceTypeText
}

Learn More