I_UserStatusText

DDL: I_USERSTATUSTEXT SQL: IUSERSTATUSTEXT Type: view BASIC

User Status - Text

I_UserStatusText is a Basic CDS View that provides data about "User Status - Text" in SAP S/4HANA. It reads from 1 data source (tj30t) and exposes 8 fields with key fields UserStatus, StatusProfile, Language. It has 3 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
tj30t tj30t from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_UserStatus _UserStatus $projection.StatusProfile = _UserStatus.StatusProfile and $projection.UserStatus = _UserStatus.UserStatus
[0..1] I_StatusProfile _StatusProfile $projection.StatusProfile = _StatusProfile.StatusProfile
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey UserStatus view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
AbapCatalog.sqlViewName IUSERSTATUSTEXT view
AbapCatalog.preserveKey true view
EndUserText.label User Status - Text view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY UserStatus tj30t estat
KEY StatusProfile tj30t stsma
KEY Language tj30t spras
UserStatusName tj30t txt30
UserStatusShortName tj30t txt04
_StatusProfile _StatusProfile
_UserStatus _UserStatus
_Language _Language 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'UserStatus'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@AbapCatalog.sqlViewName: 'IUSERSTATUSTEXT'
@AbapCatalog.preserveKey:true
@EndUserText.label: 'User Status - Text'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #LANGUAGE_DEPENDENT_TEXT, #EXTRACTION_DATA_SOURCE  ]
@Analytics: {
    dataExtraction: {
        enabled: true,
        delta.changeDataCapture: {
            mapping:[
                {
                    table: 'tj30t',role:#MAIN,
                    viewElement:  ['StatusProfile', 'UserStatus', 'Language'],
                    tableElement: ['stsma', 'estat', 'spras']
                }
            ]
        }
    }
    }
define view I_UserStatusText
  as select from tj30t

  association [0..1] to I_UserStatus    as _UserStatus    on  $projection.StatusProfile = _UserStatus.StatusProfile
                                                          and $projection.UserStatus    = _UserStatus.UserStatus

  association [0..1] to I_StatusProfile as _StatusProfile on  $projection.StatusProfile = _StatusProfile.StatusProfile

  association [0..1] to I_Language      as _Language      on  $projection.Language = _Language.Language

{
      @ObjectModel.foreignKey.association: '_UserStatus'
  key tj30t.estat as UserStatus,

      @ObjectModel.foreignKey.association: '_StatusProfile'
  key tj30t.stsma as StatusProfile,

      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key tj30t.spras as Language,

      @Semantics.text: true
      tj30t.txt30 as UserStatusName,

      @Semantics.text: true
      tj30t.txt04 as UserStatusShortName,


      _StatusProfile,
      _UserStatus,
      _Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TJ30T"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_STATUSPROFILE",
"I_USERSTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More