P_StatusCode

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

define view P_StatusCode as select from I_SystemStatus  

{ 
  key $session.client as mandt,
  key I_SystemStatus.SystemStatus as StatusCode, 
  key cast('' as j_stsma) as StatusProfile,
  
  cast('' as vdm_j_isuserstatus) as IsUserStatus,
  I_SystemStatus.StatusIsHidden,
  cast ('' as vdm_j_status_auth_key ) as StatusAuthorizationKey,
  cast( '00' as vdm_j_statussequencenumber ) as StatusSequenceNumber,
  cast ( '99' as j_linep) as StatusDisplayPosition,
  cast( '99' as j_statp) as StatusDisplayPriority
}

union all 

select from I_UserStatus
{ 
  key I_UserStatus.UserStatus as StatusCode, 
  key I_UserStatus.StatusProfile,
  
  cast('X' as vdm_j_isuserstatus) as IsUserStatus,
  '' as StatusIsHidden,
  I_UserStatus.StatusAuthorizationKey as StatusAuthorizationKey, 
  I_UserStatus.StatusSequenceNumber as StatusSequenceNumber ,
  StatusDisplayPosition,
  StatusDisplayPriority
} 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SYSTEMSTATUS",
"I_USERSTATUS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/