C_ManageRoutingChangeNumberVH

DDL: C_MANAGEROUTINGCHANGENUMBERVH Type: view_entity CONSUMPTION Package: ODATA_PP_ROUTING_API

Change Number

C_ManageRoutingChangeNumberVH is a Consumption CDS View that provides data about "Change Number" in SAP S/4HANA. It reads from 2 data sources (I_ChangeMaster, I_ChangeMasterStatus) and exposes 9 fields with key field ChangeNumber. It has 1 association to related views. Part of development package ODATA_PP_ROUTING_API.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_ChangeMaster _ChangeMaster from
I_ChangeMasterStatus _ChangeNumberStatus inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ChangeMasterObjTypeAssgmt _ChangeNumberObjectType $projection.ChangeNumber = _ChangeNumberObjectType.ChangeNumber

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey ChangeNumber view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Change Number view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view
Consumption.ranked true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ChangeNumber I_ChangeMaster ChangeNumber
ChangeNumberStatus I_ChangeMaster ChangeNumberStatus
ChangeNumberDescription I_ChangeMaster ChangeNumberDescription
ChangeNumberValidFromDate I_ChangeMaster ChangeNumberValidFromDate
ChangeNumberReleaseKey I_ChangeMaster ChangeNumberReleaseKey
AuthorizationGroup I_ChangeMaster AuthorizationGroup
ChangeNumberFunction I_ChangeMaster ChangeNumberFunction
_ChangeMasterLogAccMActive I_ChangeMaster _ChangeMasterLogAccMActive
_ChangeMstrLogAccMUserAuthzn I_ChangeMaster _ChangeMstrLogAccMUserAuthzn 
@VDM.viewType: #CONSUMPTION
@ObjectModel.representativeKey: 'ChangeNumber'
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Change Number'
@ObjectModel.supportedCapabilities: [#VALUE_HELP_PROVIDER]
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.dataCategory:#VALUE_HELP
@Search.searchable: true
@Consumption.ranked: true
define view entity C_ManageRoutingChangeNumberVH
as select from I_ChangeMaster as _ChangeMaster
  inner join I_ChangeMasterStatus as _ChangeNumberStatus on _ChangeMaster.ChangeNumberStatus = _ChangeNumberStatus.ChangeNumberStatus
  association [0..1] to I_ChangeMasterObjTypeAssgmt as _ChangeNumberObjectType on $projection.ChangeNumber = _ChangeNumberObjectType.ChangeNumber
  //association [0..1] to I_ChangeMasterStatus as _ChangeNumberStatus on $projection.ChangeNumberStatus = _ChangeNumberStatus.ChangeNumberStatus

{
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.8
  @Search.ranking: #HIGH
  key _ChangeMaster.ChangeNumber,
  _ChangeMaster.ChangeNumberStatus,
  _ChangeMaster.ChangeNumberDescription,
  _ChangeMaster.ChangeNumberValidFromDate,
  @Consumption.hidden: true
  _ChangeMaster.ChangeNumberReleaseKey,
  @Consumption.hidden: true
  _ChangeMaster.AuthorizationGroup,
  @Consumption.hidden: true
  _ChangeMaster.ChangeNumberFunction,
  
  @Consumption.hidden: true
  _ChangeMaster._ChangeMasterLogAccMActive,
  @Consumption.hidden: true
  _ChangeMaster._ChangeMstrLogAccMUserAuthzn
  
}
where
  _ChangeNumberStatus.ChangeIsAllowed = 'X' //active status

Learn More