I_CHGRECORDUSERSTATUSTEXT
Change Record user status - Text
I_CHGRECORDUSERSTATUSTEXT is a CDS View in S/4HANA. Change Record user status - Text. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_ChgRecordUserStatusText | view_entity | projection | BASIC | Change Record User Status Text |
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Change Record user status - Text'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #A,
sizeCategory: #S,
dataClass: #CUSTOMIZING
}
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE,
#CDS_MODELING_ASSOCIATION_TARGET,
#SQL_DATA_SOURCE ]
@ObjectModel.representativeKey: 'ChangeRecordStatus'
@VDM.viewType: #BASIC
@ObjectModel.dataCategory: #TEXT
@Search.searchable: true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
define view entity I_ChgRecordUserStatusText
as select from /iam/c_stat_t
association to parent I_ChgRecordUserStatus as _ChangeRecordUserStatus on $projection.ChangeRecordStatus = _ChangeRecordUserStatus.ChangeRecordStatus
association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
@Semantics.language: true
@ObjectModel.foreignKey.association: '_Language'
key langu as Language,
key status as ChangeRecordStatus,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.8
@Search.ranking: #LOW
@Semantics.text: true
description as ChangeRecordStatusDescription,
_Language,
_ChangeRecordUserStatus
}
where
status_field = '01'