I_RequestStatus

DDL: I_REQUESTSTATUS SQL: IREQUEST_STATUS Type: view Package: SCTS_REQ_APP

Request/Task: Status

I_RequestStatus is a CDS View that provides data about "Request/Task: Status" in SAP S/4HANA. It reads from 2 data sources (dd07l, dd07t) and exposes 2 fields with key field domvalue_l. Part of development package SCTS_REQ_APP.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
dd07l Domain from
dd07t DomainText left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName IREQUEST_STATUS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.resultSet.sizeCategory #XS view
EndUserText.label Request/Task: Status view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY domvalue_l dd07l domvalue_l
TransportRequestStatusText dd07t ddtext 
@AbapCatalog.sqlViewName: 'IREQUEST_STATUS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.resultSet.sizeCategory: #XS
@EndUserText.label: 'Request/Task: Status'
define view I_RequestStatus
  as select from    dd07l as Domain
    left outer join dd07t as DomainText on  Domain.domname  = DomainText.domname
                                        and Domain.as4local = DomainText.as4local
                                        and Domain.valpos   = DomainText.valpos
                                        and Domain.as4vers  = DomainText.as4vers
{
  key Domain.domvalue_l,

      @Semantics.text: true
      DomainText.ddtext as TransportRequestStatusText
}
where
  (
       Domain.domname        = 'TRSTATUS'
    or Domain.domname        = 'ATO_CMN_REQUEST_CHECK_STATE'
  )
  and  Domain.as4local       = 'A'
  and  Domain.as4vers        = '0000'
  and  DomainText.ddlanguage = $session.system_language

Learn More