P_STATUSCODETEXT

CDS View

P_STATUSCODETEXT is a CDS View in S/4HANA. It contains 1 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_StatusCodeText view from BASIC Status Code Text

Fields (1)

KeyField CDS FieldsUsed in Views
IsUserStatus IsUserStatus 1 
@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 



}   
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SYSTEMSTATUSTEXT",
"I_USERSTATUSTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More