P_StatusCodeText

DDL: P_STATUSCODETEXT SQL: PSTATUSCODETEXT Type: view BASIC

P_StatusCodeText is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_SystemStatusText, I_UserStatusText) and exposes 12 fields with key fields mandt, StatusCode, StatusProfile, Language, StatusProfile.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
I_SystemStatusText I_SystemStatusText from
I_UserStatusText I_UserStatusText union_all

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PSTATUSCODETEXT view
VDM.viewType #BASIC view
VDM.private true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY mandt
KEY StatusCode I_SystemStatusText SystemStatus
KEY StatusProfile
KEY Language I_SystemStatusText Language
IsUserStatus
StatusName I_SystemStatusText SystemStatusName
UserStatusasStatusCode
KEY StatusProfile I_UserStatusText StatusProfile
KEY Language I_UserStatusText Language
IsUserStatus
StatusName I_UserStatusText UserStatusName
StatusShortName I_UserStatusText UserStatusShortName 
@AbapCatalog.sqlViewName: 'PSTATUSCODETEXT'
//@EndUserText.label: 'Status Code Text'

//@Analytics : { dataExtraction.enabled : true}

@VDM.viewType : #BASIC
@VDM.private : true
@AbapCatalog.preserveKey:true 
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_StatusCodeText as select from I_SystemStatusText {
  key $session.client as mandt,
  key I_SystemStatusText.SystemStatus as StatusCode, 
  key cast('' as j_stsma) as StatusProfile,
  key I_SystemStatusText.Language, 
  
  cast('' as vdm_j_isuserstatus) as IsUserStatus,

  I_SystemStatusText.SystemStatusName as StatusName,
  I_SystemStatusText.SystemStatusShortName as StatusShortName
  /* Associations */
  //I_SystemStatusText._Language 

 
}

union all select from I_UserStatusText

{

key I_UserStatusText.UserStatus  as StatusCode ,
 
key I_UserStatusText.StatusProfile, 
key I_UserStatusText.Language,
cast('X' as vdm_j_isuserstatus) as IsUserStatus,
 
I_UserStatusText.UserStatusName as StatusName,
I_UserStatusText.UserStatusShortName as StatusShortName
//I_UserStatusText._Language 



}

Learn More