C_ChgeRecdNextUserStatusAction

DDL: C_CHGERECDNEXTUSERSTATUSACTION Type: view_entity CONSUMPTION Package: VDM_PLMB_CR_RAP

Next User Status Action

C_ChgeRecdNextUserStatusAction is a Consumption CDS View that provides data about "Next User Status Action" in SAP S/4HANA. It reads from 4 data sources (I_ChgRecdFeatureToggleEnabled, I_ChgRecdFeatureToggleDisabled, I_ChangeRecordNextStatus, I_ChangeRecordNextStatusVH) and exposes 11 fields with key fields ChangeRecordType, ChangeRecordActionConditionCtr, ChangeRecordStatus, ChangeRecordStatusNext, ChangeRecordStatusAction. 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) 11 fields

Data Sources (4)

SourceAliasJoin Type
I_ChgRecdFeatureToggleEnabled _ftg inner
I_ChgRecdFeatureToggleDisabled _ftg inner
I_ChangeRecordNextStatus user_status from
I_ChangeRecordNextStatusVH user_status1 union_all

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Next User Status Action view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

OData Services (1)

ServiceBindingVersionContractRelease
UI_CHANGERECORD_MANAGE UI_CHANGERECORD_MANAGE V4 C1 NOT_RELEASED

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordType I_ChangeRecordNextStatus ChangeRecordType Record Type
KEY ChangeRecordActionConditionCtr I_ChangeRecordNextStatus ChangeRecordActionConditionCtr Counter
KEY ChangeRecordStatus I_ChangeRecordNextStatus ChangeRecordStatus Current Status
KEY ChangeRecordStatusNext I_ChangeRecordNextStatus ChangeRecordStatusNext Target Status
KEY ChangeRecordStatusAction I_ChangeRecordNextStatus ChangeRecordStatusAction Status Action
ChangeRecordType
KEY ChangeRecordActionConditionCtr
KEY ChangeRecordStatus I_ChangeRecordNextStatusVH ChangeRecordStatus
KEY ChangeRecordStatusNext I_ChangeRecordNextStatusVH ChangeRecordNextStatus
KEY ChangeRecordStatusAction I_ChangeRecordNextStatusVH ChangeRecordStatusAction
ChangeRecordStatusActionText I_ChangeRecordNextStatusVH ChangeRecordStatusActionText 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Next User Status Action'
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable: true
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #CUSTOMIZING
}


define view entity C_ChgeRecdNextUserStatusAction as select from I_ChangeRecordNextStatus as user_status
inner join I_ChgRecdFeatureToggleEnabled as _ftg on _ftg.ChangeRecordFeatureToggleID =  'PLM_SAM'

{
          @Search.defaultSearchElement: true
          @EndUserText.label: 'Record Type'
          @Consumption.filter.hidden: true
  key     user_status.ChangeRecordType,
          @EndUserText.label: 'Counter'
          @Consumption.filter.hidden: true
  key     user_status.ChangeRecordActionConditionCtr,  
          @Search.defaultSearchElement: true
          @Search.ranking: #HIGH
          @Search.fuzzinessThreshold: 0.8
          @EndUserText.label: 'Current Status'
  key     user_status.ChangeRecordStatus,
          @EndUserText.label: 'Target Status'
  key     user_status.ChangeRecordStatusNext,
          @EndUserText.label: 'Status Action'
  key     user_status.ChangeRecordStatusAction,
          user_status.ChangeRecordStatusActionText
          }
          
union all select from I_ChangeRecordNextStatusVH  as user_status1
inner join I_ChgRecdFeatureToggleDisabled as _ftg on _ftg.ChangeRecordFeatureToggleID =  'PLM_SAM'
{


  key     user_status1.ChangeRecordType,
  key     '000' as ChangeRecordActionConditionCtr,  
  key     user_status1.ChangeRecordStatus,
  key     user_status1.ChangeRecordNextStatus as ChangeRecordStatusNext,
  key     user_status1.ChangeRecordStatusAction,
          user_status1.ChangeRecordStatusActionText
     }

Learn More