I_StatusProfileUserStatus

DDL: I_STATUSPROFILEUSERSTATUS Type: view_entity BASIC

User statuses of a status profile

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

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
tj30 tj30 from

Associations (2)

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

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label User statuses of a status profile view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY StatusProfile stsma
KEY UserStatus estat
StatusAuthorizationKey bersl
StatusSequenceNumber stonr
StatusDisplayPosition linep
StatusDisplayPriority statp
StsMgmtTransTriggeredByUsrSts crm_vrgng
_StatusProfile _StatusProfile
_UserStatusText _UserStatusText 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'User statuses of a status profile'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #CUSTOMIZING
}
@VDM.viewType: #BASIC
define view entity I_StatusProfileUserStatus
  as select from tj30
  association [0..1] to I_StatusProfile as _StatusProfile    on  $projection.StatusProfile = _StatusProfile.StatusProfile
  association [0..*] to I_UserStatusText as _UserStatusText  on  $projection.UserStatus    = _UserStatusText.UserStatus
                                                             and $projection.StatusProfile = _UserStatusText.StatusProfile
{
  @ObjectModel.foreignKey.association: '_StatusProfile'
  key stsma      as StatusProfile,
  @ObjectModel.text.association: '_UserStatusText'
  key estat      as UserStatus,
      bersl      as StatusAuthorizationKey,
      stonr      as StatusSequenceNumber,
      linep      as StatusDisplayPosition,
      statp      as StatusDisplayPriority,
      crm_vrgng  as StsMgmtTransTriggeredByUsrSts,
  _StatusProfile,
  _UserStatusText

} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TJ30"
],
"ASSOCIATED":
[
"I_STATUSPROFILE",
"I_USERSTATUSTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More