R_IntOrdOverallSystemStatusTP

DDL: R_INTORDOVERALLSYSTEMSTATUSTP Type: view_entity TRANSACTIONAL

Overall system status

R_IntOrdOverallSystemStatusTP is a Transactional CDS View that provides data about "Overall system status" in SAP S/4HANA. It reads from 4 data sources (I_InternalOrder, I_SystemStatus, I_SystemStatusText, I_StatusObjectStatusBasic) and exposes 7 fields with key fields InternalOrder, InternalOrderDraftInternalUUID, SystemStatus.

4 data source(s) 7 fields

Data Sources (4)

SourceAliasJoin Type
I_InternalOrder _InternalOrder inner
I_SystemStatus _SystemStatus inner
I_SystemStatusText _SystemStatusText inner
I_StatusObjectStatusBasic I_StatusObjectStatusBasic from

Annotations (7)

NameValueLevelField
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Overall system status view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY InternalOrder I_InternalOrder InternalOrder
KEY InternalOrderDraftInternalUUID
KEY SystemStatus I_SystemStatusText SystemStatus
StatusIsInactive I_StatusObjectStatusBasic StatusIsInactive
SystemStatusShortName I_SystemStatusText SystemStatusShortName
SystemStatusName I_SystemStatusText SystemStatusName
_InternalOrderTP _InternalOrderTP 
@ObjectModel: {
  usageType: {
    serviceQuality: #C,
    sizeCategory: #M,
    dataClass: #MIXED
  }
}

@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}

@AccessControl: {
  authorizationCheck: #CHECK
}
@EndUserText.label: 'Overall system status'
define view entity R_IntOrdOverallSystemStatusTP
  as select from I_StatusObjectStatusBasic
    inner join   I_InternalOrder    as _InternalOrder   on  I_StatusObjectStatusBasic.StatusObject = _InternalOrder.ControllingObject
    inner join   I_SystemStatus     as _SystemStatus     on I_StatusObjectStatusBasic.StatusCode = _SystemStatus.SystemStatus
    inner join   I_SystemStatusText as _SystemStatusText on  I_StatusObjectStatusBasic.StatusCode = _SystemStatusText.SystemStatus
                                                         and _SystemStatusText.Language           = $session.system_language

  association to parent R_InternalOrderTP as _InternalOrderTP  on  $projection.InternalOrder                  = _InternalOrderTP.InternalOrder
                                                               and $projection.InternalOrderDraftInternalUUID = _InternalOrderTP.InternalOrderDraftInternalUUID

{
  key _InternalOrder.InternalOrder,
  key cast('00000000000000000000000000000000' as sysuuid_c32) as InternalOrderDraftInternalUUID,
      @ObjectModel.text.association:null
  key _SystemStatusText.SystemStatus,
      I_StatusObjectStatusBasic.StatusIsInactive,

      _SystemStatusText.SystemStatusShortName,

      _SystemStatusText.SystemStatusName,
      
      _InternalOrderTP
}
where _SystemStatus.StatusIsHidden = ''
  and I_StatusObjectStatusBasic.StatusIsInactive = '' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INTERNALORDER",
"I_STATUSOBJECTSTATUSBASIC",
"I_SYSTEMSTATUS",
"I_SYSTEMSTATUSTEXT"
],
"ASSOCIATED":
[
"R_INTERNALORDERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More