I_USERSTATUSTEXT

CDS View

User Status - Text

I_USERSTATUSTEXT is a CDS View in S/4HANA. User Status - Text. It contains 5 fields. 12 CDS views read from this table.

Used by 12 CDS view(s) 5 fields

CDS Views using this table (12)

ViewTypeJoinVDMDescription
A_ProcessOrderStatus view_entity left_outer COMPOSITE API Process Order Status
A_ProductionOrderStatus view_entity left_outer COMPOSITE API Production Order Status
C_InspLotStatus view left_outer CONSUMPTION Status of Inspection Lot Object Page
C_IntOrderOverallUserStatus view_entity inner CONSUMPTION Internal order overall user status
C_Materialsamplestatus view left_outer CONSUMPTION CDS View for Material Sample Statuses
C_MfgOrderObjPgStatus view_entity left_outer CONSUMPTION Manufacturing Order Operations Status
I_IntOrderActiveUserStatus view_entity inner COMPOSITE Internal Order Active User Status
I_MfgOrderObjPgStatus view_entity left_outer COMPOSITE Manufacturing Order Operations Status
P_MfgUserStatusText view_entity from COMPOSITE User status text restriction
P_StatusCodeText view union_all BASIC Status Code Text
R_IntOrderNumberedUserStatusTP view_entity inner TRANSACTIONAL Internal order user status with number
R_IntOrdUnnumberedUserStatusTP view_entity inner TRANSACTIONAL Int. order user status without number

Fields (5)

KeyField CDS FieldsUsed in Views
KEY Language Language 2
KEY StatusProfile StatusProfile 5
KEY UserStatus UserStatus 5
UserStatusName StatusName,UserStatusName 6
UserStatusShortName StatusShortName,UserStatusShortName 6 
@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
}

Learn More