I_SYSTEMSTATUSTEXT

CDS View

System Status - Text

I_SYSTEMSTATUSTEXT is a CDS View in S/4HANA. System Status - Text. It contains 4 fields. 31 CDS views read from this table.

Used by 31 CDS view(s) 4 fields

CDS Views using this table (31)

ViewTypeJoinVDMDescription
C_CapPlngOrderConfStatusVH view from CONSUMPTION Order Confirmation Status
C_FldLogsSystemStatusVH view_entity from CONSUMPTION System Status
C_IntOrderSystemStatusNameVH view from CONSUMPTION Int. order system status name value help
C_IntOrdOvrlSystemStatusTextVH view from CONSUMPTION Overall system status value help
C_NtwkActivitySystemStatusVH view from CONSUMPTION Value Help: Project System Status
C_SchedProdnOrderConfStatusVH view from CONSUMPTION Value help for Order Confirmation Status
I_ACMApplicationDocumentStatus view_entity inner BASIC Application Document Status
I_ACMObjectStatusCostRevCkpt view_entity inner COMPOSITE Interface Entity for Object Status of CRC
I_ACMSettlementStatus view_entity inner BASIC Application document settlement status
I_ACMStorageStatus view_entity inner BASIC Storage statuses for ACM
I_ACMSystemStatus view inner BASIC ACM Specific Status
I_CmmdtyHdgCnstltnTskListStsT view_entity from COMPOSITE Constellation Task List Status - Text
I_CmmdtyHdgCntrdealReqStsText view_entity from COMPOSITE Counter Deal Status - Text
I_CmmdtyHdgDdsgntnReqStsText view_entity from COMPOSITE Dedesignation Request Status - Text
I_CmmdtyHdgHdggArVersStsText view_entity from COMPOSITE Hedging Area Status - Text
I_CmmdtyHdgMigrtnReqStatusText view_entity from COMPOSITE Migration Request Status - Text
I_CmmdtyHdgPlanExposureStatusT view_entity from COMPOSITE CMDTY HDG Plan Exposure Status - Text
I_CmmdtyHdgPlanningDataStatusT view_entity from COMPOSITE CMDTY HDG PLN Data Status - Text
I_CmmdtyHdgRclassfctnReqStsTxt view_entity from COMPOSITE Reclassification Request Status - Text
I_CmmdtyHedgeRequestStatusText view from COMPOSITE Commodity Hedge Requests Status - Text
I_DfsCapbltSystemStatus view from BASIC System Status for Capability
I_DfsScenarioSystemStatus view from BASIC Interface View for Scenario Status
I_InspLotApprovalStatusVH view_entity from COMPOSITE Inspection Lot with Approval Status
I_IntOrderActiveSystemStatus view_entity inner COMPOSITE Internal Order Active System Status
I_MsnEsnlTskSystemStatus view from BASIC System Status for Capability
I_PrepaymentAgrmtPostingStatus view from BASIC Prepayment Aggrement Posting Status
I_PrepaymentAgrmtStatus view from COMPOSITE Prepayment Aggrement Status
P_ACMSettlementStatus view_entity inner BASIC Application document settlement status
P_ACMStorageStatus view_entity inner BASIC Storage statuses for ACM
P_StatusCodeText view from BASIC
R_IntOrdOverallSystemStatusTP view_entity inner TRANSACTIONAL Overall system status

Fields (4)

KeyField CDS FieldsUsed in Views
KEY Language Language 1
KEY SystemStatus StatusCode,SystemStatus 3
SystemStatusName ACMStorageStatusText,StatusName,SystemStatusName 10
SystemStatusShortName SystemStatusShortName 2 
    @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