I_DFS_StatusObjectUserStatus

DDL: I_DFS_STATUSOBJECTUSERSTATUS SQL: CDFSSTATOBJUSER Type: view COMPOSITE

Status Object Single Active Status

I_DFS_StatusObjectUserStatus is a Composite CDS View that provides data about "Status Object Single Active Status" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectActiveStatus) and exposes 10 fields with key fields StatusObject, StatusCode. It has 1 association to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectActiveStatus I_StatusObjectActiveStatus from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_UserStatusText _UserStatusText $projection.StatusCode = _UserStatusText.UserStatus and $projection.StatusProfile = _UserStatusText.StatusProfile

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CDFSSTATOBJUSER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Status Object Single Active Status view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY StatusObject StatusObject
KEY StatusCode StatusCode External Status Code
UserStatusName User Ststus Description
UserStatusShortName User Status
StatusProfile StatusProfile
StatusIsActive StatusIsActive
_StatusCode _StatusCode
_StatusObject _StatusObject
_StatusProfile _StatusProfile
_UserStatusText _UserStatusText 
@AbapCatalog.sqlViewName: 'CDFSSTATOBJUSER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Status Object Single Active Status'

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

@VDM.viewType: #COMPOSITE

define view I_DFS_StatusObjectUserStatus
  as select from I_StatusObjectActiveStatus
  association [0..*] to I_UserStatusText as _UserStatusText on  $projection.StatusCode    = _UserStatusText.UserStatus
                                                            and $projection.StatusProfile = _UserStatusText.StatusProfile
{
       @UI.hidden: true
  key  StatusObject,
       @UI:{
       lineItem: [{position: 30, importance: #HIGH,type: #STANDARD, label: 'External Status Code' }],
       identification : [{position: 10}]
        }
       @EndUserText.quickInfo: 'External Status Code'
       @EndUserText.label: 'External Status Code'
  key  StatusCode,
       @UI:{
       lineItem: [{position: 20, importance: #HIGH,type: #STANDARD, label: 'User Status Description' }],
       identification : [{position: 20}]
        }
       @EndUserText.quickInfo:'User Status Description'
       @EndUserText.label: 'User Ststus Description'
       _UserStatusText[1:Language=$session.system_language].UserStatusName,
       @UI:{
       lineItem: [{position: 10, importance: #HIGH,type: #STANDARD, label: 'User Status' }],
       identification : [{position: 30}]
        }
       @EndUserText.quickInfo:'User Status'
       @EndUserText.label: 'User Status'
       _UserStatusText[1:Language=$session.system_language].UserStatusShortName,
       @UI.hidden: true
       StatusProfile,
       //      @UI:{

       //      lineItem: [{position: 40, importance: #HIGH,type: #STANDARD, label: 'Active' }],

       //      identification : [{position: 40}]

       //       }

       @UI.hidden: true
       StatusIsActive,

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

Learn More