N_StatusObjectStatus

DDL: N_STATUSOBJECTSTATUS SQL: NSTATUSOBJSTATUS Type: view Package: VDM_FND

Status Object Status

N_StatusObjectStatus is a CDS View that provides data about "Status Object Status" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectStatusBasic) and exposes 8 fields with key fields StatusObject, StatusCode. It has 4 associations to related views. Part of development package VDM_FND.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectStatusBasic jest from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_SystemStatus _SystemStatus $projection.StatusCode = _SystemStatus.SystemStatus
[0..1] I_UserStatus _UserStatus $projection.StatusCode = _UserStatus.UserStatus and $projection.StatusProfile = _UserStatus.StatusProfile
[0..1] I_StatusObject _StatusObject $projection.StatusObject = _StatusObject.StatusObject
[0..1] I_StatusProfile _StatusProfile $projection.StatusProfile = _StatusProfile.StatusProfile

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey StatusCode view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.sqlViewName NSTATUSOBJSTATUS view
EndUserText.label Status Object Status view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.auxiliaryEntity.for.entity I_StatusObjectStatus view
AbapCatalog.preserveKey true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY StatusObject I_StatusObjectStatusBasic StatusObject
KEY StatusCode I_StatusObjectStatusBasic StatusCode
StatusProfile jsto StatusProfile
StatusIsInactive I_StatusObjectStatusBasic StatusIsInactive
_SystemStatus _SystemStatus
_UserStatus _UserStatus
_StatusObject _StatusObject
_StatusProfile _StatusProfile 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'StatusCode'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@AbapCatalog.sqlViewName: 'NSTATUSOBJSTATUS'
@EndUserText.label: 'Status Object Status'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.auxiliaryEntity.for.entity: 'I_StatusObjectStatus'
@VDM.auxiliaryEntity.usage.type: [#ENTERPRISE_SEARCH]
@AbapCatalog.preserveKey: true
define view N_StatusObjectStatus
  as select from           I_StatusObjectStatusBasic as jest
    left outer to one join I_StatusObject            as jsto on jest.StatusObject = jsto.StatusObject
    
  association [0..1] to I_SystemStatus  as _SystemStatus  on  $projection.StatusCode    = _SystemStatus.SystemStatus
  association [0..1] to I_UserStatus    as _UserStatus    on  $projection.StatusCode    = _UserStatus.UserStatus
                                                          and $projection.StatusProfile = _UserStatus.StatusProfile
  association [0..1] to I_StatusObject  as _StatusObject  on  $projection.StatusObject  = _StatusObject.StatusObject
  association [0..1] to I_StatusProfile as _StatusProfile on  $projection.StatusProfile = _StatusProfile.StatusProfile
{
      @ObjectModel.foreignKey.association: '_StatusObject'
  key jest.StatusObject,
  key jest.StatusCode,
      @ObjectModel.foreignKey.association: '_StatusProfile'
      jsto.StatusProfile,
      jest.StatusIsInactive,

      _SystemStatus,
      _UserStatus,
      _StatusObject,
      _StatusProfile
}

Learn More