I_IntOrderActiveSystemStatus

DDL: I_INTORDERACTIVESYSTEMSTATUS Type: view_entity COMPOSITE

Internal Order Active System Status

I_IntOrderActiveSystemStatus is a Composite CDS View that provides data about "Internal Order Active 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 StatusObject, 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
AccessControl.authorizationCheck #CHECK view
EndUserText.label Internal Order Active System Status view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY StatusObject I_StatusObjectStatusBasic StatusObject
KEY SystemStatus I_SystemStatusText SystemStatus
StatusIsInactive I_StatusObjectStatusBasic StatusIsInactive
SystemStatusShortName I_SystemStatusText SystemStatusShortName
SystemStatusName I_SystemStatusText SystemStatusName
ControllingArea I_InternalOrder ControllingArea
OrderType I_InternalOrder OrderType 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Internal Order Active System Status'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #M,
  dataClass: #MIXED
}
@VDM: {
  viewType: #COMPOSITE
}
define view entity I_IntOrderActiveSystemStatus
  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
{
  key I_StatusObjectStatusBasic.StatusObject,

      @ObjectModel.text.association:null
  key _SystemStatusText.SystemStatus,
      
      @Semantics.booleanIndicator: true 
      I_StatusObjectStatusBasic.StatusIsInactive,

      _SystemStatusText.SystemStatusShortName,

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

Learn More