I_StatusObjectActiveStatus

DDL: I_STATUSOBJECTACTIVESTATUS SQL: ISTATOBJSTATACT Type: view COMPOSITE

Status Object Active Status

I_StatusObjectActiveStatus is a Composite CDS View that provides data about "Status Object Active Status" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectStatus) and exposes 8 fields with key fields StatusObject, StatusCode.

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectStatus I_StatusObjectStatus from

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey StatusCode view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName ISTATOBJSTATACT view
AbapCatalog.preserveKey true view
EndUserText.label Status Object Active Status view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #COMPOSITE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY StatusObject StatusObject
KEY StatusCode StatusCode
StatusProfile StatusProfile
IsUserStatus IsUserStatus
StatusIsActive StatusIsActive
_StatusObject _StatusObject
_StatusProfile _StatusProfile
_StatusCode _StatusCode
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'StatusCode'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.sqlViewName: 'ISTATOBJSTATACT'
@AbapCatalog.preserveKey:true
@EndUserText.label: 'Status Object Active Status'
@Analytics : {dataExtraction.enabled : true}
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType: #COMPOSITE

define view I_StatusObjectActiveStatus as select from I_StatusObjectStatus
//association to I_StatusObject as _StatusObject on

//    $projection.StatusObject = _StatusObject.StatusObject

//

//association [0..1] to I_StatusCode as _StatusCode on

//    $projection.StatusCode = _StatusCode.StatusCode and

//    $projection.StatusProfile = _StatusCode.StatusProfile

//association [0..1] to I_StatusProfile as _StatusProfile on

//    $projection.StatusProfile = _StatusProfile.StatusProfile

{
  @ObjectModel.foreignKey.association: '_StatusObject'
  key StatusObject,
  @ObjectModel.foreignKey.association: '_StatusCode'
  key StatusCode,
  @ObjectModel.foreignKey.association: '_StatusProfile'
  StatusProfile,
  IsUserStatus,
  StatusIsActive,
//  _StatusCode.StatusIsHidden,

//  _StatusCode.StatusSequenceNumber,

//  _StatusCode.StatusDisplayPosition,

//  _StatusCode.StatusDisplayPriority,

    
  _StatusObject,
  _StatusProfile ,
  _StatusCode
} where StatusIsInactive = '' 
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STATUSOBJECTSTATUS"
],
"ASSOCIATED":
[
"I_STATUSCODE",
"I_STATUSOBJECT",
"I_STATUSPROFILE"
],
"BASE":
[
"I_STATUSOBJECTSTATUS"
],
"ANNO_REF":
[],
"VERSION":0
}
}*/