I_CHANGERECORDUSERSTATUSVH

CDS View

Change Record User Status

I_CHANGERECORDUSERSTATUSVH is a CDS View in S/4HANA. Change Record User Status. It contains 1 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 1 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_ChangeRecordUserStatusVH view_entity from CONSUMPTION Change Record User Status
I_ChangeRecordUserStatus_3 view_entity union_all COMPOSITE Change Record Status

Fields (1)

KeyField CDS FieldsUsed in Views
ChangeRecordStatusDescription ChangeRecordStatusDescription 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Change Record User Status'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'ChangeRecordStatus'
//this need not be a value help 

define view entity I_ChangeRecordUserStatusVH
  as select from /iam/c_stat   as status
    inner join   /iam/c_stat_t as statustext on  status.status_field = statustext.status_field
                                             and status.status       = statustext.status
{
  key status.status          as ChangeRecordStatus,
      status.status_field    as ChangeRecordStatusField,
      statustext.langu       as Language,
      statustext.description as ChangeRecordDetailDescription,
      statustext.description as ChangeRecordStatusDescription
}
where status.status_field =  '01'
  and status.inactive     <> 'X'
  and statustext.langu    = $session.system_language

Learn More