I_SystemStatusText

DDL: I_SYSTEMSTATUSTEXT SQL: ISYSSTATTEXT Type: view BASIC

System Status - Text

I_SystemStatusText is a Basic CDS View that provides data about "System Status - Text" in SAP S/4HANA. It reads from 1 data source (tj02t) and exposes 6 fields with key fields SystemStatus, Language. It has 1 association to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
tj02t tj02t from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey SystemStatus view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label System Status - Text view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName ISYSSTATTEXT view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SystemStatus tj02t istat
KEY Language tj02t spras
SystemStatusName tj02t txt30
SystemStatusShortName tj02t txt04
_SystemStatus _SystemStatus
_Language _Language 
    @ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'SystemStatus'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M 
@EndUserText.label: 'System Status - Text'
@VDM.viewType: #BASIC 
@AbapCatalog.sqlViewName: 'ISYSSTATTEXT'
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck:#NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #LANGUAGE_DEPENDENT_TEXT, #EXTRACTION_DATA_SOURCE ]
@Analytics: {
    dataExtraction: {
        enabled: true,
        delta.changeDataCapture: {
            mapping:[
                {
                    table: 'tj02t',role:#MAIN,
                    viewElement:  ['SystemStatus', 'Language'],
                    tableElement: ['istat', 'spras']
                }
            ]
        }
    }
    }
define view I_SystemStatusText as select from tj02t 
association[0..1] to I_SystemStatus as _SystemStatus on $projection.SystemStatus = _SystemStatus.SystemStatus
association [0..1] to I_Language as _Language on $projection.Language = _Language.Language 
 {
  @ObjectModel.foreignKey.association: '_SystemStatus'
  key tj02t.istat as SystemStatus, 
  
  @Semantics.language: true
  @ObjectModel.foreignKey.association: '_Language' 
  key tj02t.spras as Language, 
  
  @Semantics.text: true
  tj02t.txt30 as SystemStatusName,
  
  @Semantics.text: true
  tj02t.txt04 as SystemStatusShortName, 
  
  _SystemStatus,
  _Language
}

Learn More