I_RequestsHeader

DDL: I_REQUESTSHEADER SQL: IREQUEST_HEADER Type: view

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 11 fields with key field TransportRequestID. It has 2 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
e070 e070 from

Associations (2)

CardinalityTargetAliasCondition
[0..*] e07t _Text $projection.TransportRequestID = _Text.trkorr and _Text.as4text is not null
[0..1] e070c _RequestsClient $projection.TransportRequestID = _RequestsClient.trkorr

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName IREQUEST_HEADER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Requests view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY TransportRequestID trkorr
ABAPSourceSystem
TransportRequestSourceClient _RequestsClient client
TransportRequestType trfunction
TransportRequestStatus trstatus
TransportRequestTarget tarsystem
TransportRequestCategory korrdev
TransportRequestOwner as4user
TransportRequestChangedOn as4date
TransportRequestChangedAt as4time
TransportRequestDesc _Text as4text 
@AbapCatalog.sqlViewName: 'IREQUEST_HEADER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Requests'
define view I_RequestsHeader
  as select from e070

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

  association [0..*] 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 trkorr                 as TransportRequestID,
      LEFT(trkorr, 3)        as ABAPSourceSystem,
      _RequestsClient.client as TransportRequestSourceClient,
      trfunction             as TransportRequestType,
      trstatus               as TransportRequestStatus,
      tarsystem              as TransportRequestTarget,
      korrdev                as TransportRequestCategory,
      as4user                as TransportRequestOwner,
      as4date                as TransportRequestChangedOn,
      as4time                as TransportRequestChangedAt,
      _Text.as4text          as TransportRequestDesc
}
where
  (
        trfunction != 'Q'
    and trfunction != 'R'
    and trfunction != 'S'
    and trfunction != 'X'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"E070",
"E070C",
"E07T"
],
"ASSOCIATED":
[
"E070C",
"E07T"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More