I_DFS_StatusObjectActiveStatus

DDL: I_DFS_STATUSOBJECTACTIVESTATUS SQL: IDFSSTATOBJACT Type: view COMPOSITE

System Status

I_DFS_StatusObjectActiveStatus is a Composite CDS View that provides data about "System Status" in SAP S/4HANA.

8 fields

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IDFSSTATOBJACT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label System Status view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY StatusObject StatusObject
StatusCode StatusCode
StatusProfile StatusProfile
IsUserStatus IsUserStatus
StatusIsActive StatusIsActive
_StatusCode _StatusCode
_StatusObject _StatusObject
_StatusProfile _StatusProfile 
@AbapCatalog.sqlViewName: 'IDFSSTATOBJACT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'System Status'

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.viewType: #COMPOSITE

define view I_DFS_StatusObjectActiveStatus as select distinct from I_StatusObjectActiveStatus {
key StatusObject,
StatusCode,
StatusProfile,
IsUserStatus,
StatusIsActive,
        case
          when( StatusCode = 'IDFS0') then 2
          when( StatusCode = 'IDFS1') then 0
          when( StatusCode = 'IDFS2') then 0
          when( StatusCode = 'IDFS3') then 1
          when( StatusCode = 'IDFS4') then 3
          when( StatusCode = 'IDFS5') then 1
        end    as StatusCriticality,

/* Associations */
//I_StatusObjectActiveStatus

_StatusCode,
_StatusObject,
_StatusProfile

} where StatusIsActive = 'X' and IsUserStatus = '' and StatusObject like 'DF%'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STATUSOBJECTACTIVESTATUS"
],
"ASSOCIATED":
[
"I_STATUSCODE",
"I_STATUSOBJECT",
"I_STATUSPROFILE"
],
"BASE":
[
"I_STATUSOBJECTACTIVESTATUS"
],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More