I_DfsScenarioSystemStatus

DDL: I_DFSSCENARIOSYSTEMSTATUS SQL: IDFSSCNSYSTATUS Type: view BASIC

Interface View for Scenario Status

I_DfsScenarioSystemStatus is a Basic CDS View that provides data about "Interface View for Scenario Status" in SAP S/4HANA. It reads from 2 data sources (I_SystemStatusText, tj05) and exposes 6 fields with key fields SystemStatus, Language.

Data Sources (2)

SourceAliasJoin Type
I_SystemStatusText _DfsScenarioSystemStatus from
tj05 _Mapping inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IDFSSCNSYSTATUS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Interface View for Scenario Status view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
Search.searchable true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SystemStatus SystemStatus
KEY Language Language
SystemStatusName SystemStatusName System Status Description
SystemStatusShortName SystemStatusShortName System Status
_SystemStatus _SystemStatus
_Language _Language
@AbapCatalog.sqlViewName:            'IDFSSCNSYSTATUS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:            true
@EndUserText.label:                  'Interface View for Scenario Status'

@AccessControl.authorizationCheck: #CHECK

@VDM.viewType: #BASIC

@Search.searchable: true

@ObjectModel.usageType: { dataClass:      #MASTER,
                          serviceQuality: #A,
                          sizeCategory:   #L }

@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_DfsScenarioSystemStatus
  as select from I_SystemStatusText as _DfsScenarioSystemStatus
    inner join   tj05               as _Mapping on _DfsScenarioSystemStatus.SystemStatusShortName = _Mapping.vrgng
{
      @Search.defaultSearchElement: true
      @Search.ranking:              #HIGH
      key SystemStatus,
  
      @Semantics.text: true
      key Language,
  
      @Semantics.text:    true
      @EndUserText.label: 'System Status Description'
      SystemStatusName,
      
      @Consumption.filter.hidden: true
      @Semantics.text:            true
      @EndUserText.label:         'System Status'
      SystemStatusShortName,
      
      // Associations

      _SystemStatus,
      _Language
}
where
      Language = $session.system_language
  and obtyp    = 'SCN'