I_UserStatus

DDL: I_USERSTATUS SQL: IUSERSTATUS Type: view BASIC

User Status

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

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
tj30 tj30 from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_UserStatusText _UserStatusText $projection.UserStatus = _UserStatusText.UserStatus and $projection.StatusProfile = _UserStatusText.StatusProfile
[0..1] I_StatusProfile _StatusProfile $projection.StatusProfile = _StatusProfile.StatusProfile

Annotations (14)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY UserStatus tj30 estat
KEY StatusProfile tj30 stsma
StatusAuthorizationKey tj30 bersl
StatusSequenceNumber tj30 stonr
StatusDisplayPosition tj30 linep
StatusDisplayPriority tj30 statp
_UserStatusText _UserStatusText
_StatusProfile _StatusProfile 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'UserStatus'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@AbapCatalog.sqlViewName: 'IUSERSTATUS'
@AbapCatalog.preserveKey:true 
@EndUserText.label: 'User Status'
@Analytics : {dataCategory: #DIMENSION, dataExtraction.enabled : true}
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]

define view I_UserStatus as select from tj30

association [0..*] to I_UserStatusText as _UserStatusText
  on  $projection.UserStatus    = _UserStatusText.UserStatus
  and $projection.StatusProfile = _UserStatusText.StatusProfile

association [0..1] to    I_StatusProfile as _StatusProfile
  on $projection.StatusProfile = _StatusProfile.StatusProfile
{
  @ObjectModel.text.association: '_UserStatusText'
  key tj30.estat as UserStatus,
  
  @ObjectModel.foreignKey.association: '_StatusProfile'
  key tj30.stsma  as StatusProfile,

  tj30.bersl as StatusAuthorizationKey,

  tj30.stonr as StatusSequenceNumber,
  
  tj30.linep as StatusDisplayPosition,
  
  tj30.statp as StatusDisplayPriority ,

  _UserStatusText,
  _StatusProfile

}

Learn More