I_RequestsHeader

DDL: I_REQUESTSHEADER Type: view_entity Package: SCTS_REQ_APP

Requests

I_RequestsHeader is a CDS View that provides data about "Requests" in SAP S/4HANA. It reads from 1 data source (e070) and exposes 12 fields with key field TransportRequestID. It has 3 associations to related views. Part of development package SCTS_REQ_APP.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
e070 _RequestHeader from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_SoftwareComponentRepos _SoftwareComponentRepos _RequestHeader.tarsystem = _SoftwareComponentRepos.vsid
[0..1] e07t _Text $projection.TransportRequestID = _Text.trkorr and _Text.as4text is not null
[0..1] e070c _RequestsClient $projection.TransportRequestID = _RequestsClient.trkorr

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Requests view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY TransportRequestID e070 trkorr
ABAPSourceSystem
TransportRequestSourceClient _RequestsClient client
TransportRequestType e070 trfunction
TransportRequestStatus e070 trstatus
TransportRequestTarget e070 tarsystem
TransportRequestCategory e070 korrdev
TransportRequestOwner e070 as4user
TransportRequestChangedOn e070 as4date
TransportRequestChangedAt e070 as4time
TransportRequestDesc _Text as4text
repoidendasRepositoryId 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Requests'
define view entity I_RequestsHeader
  as select from e070 as _RequestHeader

  // A request is assigned one repo

  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to I_SoftwareComponentRepos as _SoftwareComponentRepos on  _RequestHeader.tarsystem = _SoftwareComponentRepos.vsid


  // Table E07T is language-dependent but not translation relevant

  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to e07t                     as _Text                   on  $projection.TransportRequestID = _Text.trkorr
                                                                            and _Text.as4text                  is not null

  association [0..1] to e070c                    as _RequestsClient         on  $projection.TransportRequestID = _RequestsClient.trkorr

{
      //e070

  key _RequestHeader.trkorr          as TransportRequestID,
      left(_RequestHeader.trkorr, 3) as ABAPSourceSystem,
      _RequestsClient.client         as TransportRequestSourceClient,
      _RequestHeader.trfunction      as TransportRequestType,
      _RequestHeader.trstatus        as TransportRequestStatus,
      _RequestHeader.tarsystem       as TransportRequestTarget,
      _RequestHeader.korrdev         as TransportRequestCategory,
      _RequestHeader.as4user         as TransportRequestOwner,
      _RequestHeader.as4date         as TransportRequestChangedOn,
      _RequestHeader.as4time         as TransportRequestChangedAt,
      _Text.as4text                  as TransportRequestDesc,
      case when _RequestsClient.repoid is null then _SoftwareComponentRepos.rid
           when _RequestsClient.repoid = ''    then _SoftwareComponentRepos.rid
      else _RequestsClient.repoid
      end                            as RepositoryId
}
where
  (
        _RequestHeader.trfunction != 'Q'
    and _RequestHeader.trfunction != 'R'
    and _RequestHeader.trfunction != 'S'
    and _RequestHeader.trfunction != 'X'
  )

Learn More