I_RequestsProject

DDL: I_REQUESTSPROJECT SQL: IREQUEST_PROJECT Type: view Package: SCTS_REQ_APP

Request Project Details

I_RequestsProject is a CDS View that provides data about "Request Project Details" in SAP S/4HANA. It reads from 3 data sources (e070a, ctsproject, e070) and exposes 3 fields with key field TransportRequestID. Part of development package SCTS_REQ_APP.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
e070a Attributes inner
ctsproject Project inner
e070 Requests from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName IREQUEST_PROJECT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Request Project Details view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY TransportRequestID e070 trkorr
ProjectID ctsproject externalid
ProjectDescription ctsproject descriptn 
@AbapCatalog.sqlViewName: 'IREQUEST_PROJECT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Request Project Details'
define view I_RequestsProject
  as select from    e070         as Requests
    inner join      e070a        as Attributes  on  Attributes.trkorr    = Requests.trkorr
                                                and Attributes.attribute = 'SAP_CTS_PROJECT'
    inner join      ctsproject   as Project     on  Project.trkorr     = Attributes.reference
                                                and Project.externalps = 'SAP_IMG_PS'
{
  key Requests.trkorr    as TransportRequestID,
      Project.externalid as ProjectID,
      Project.descriptn  as ProjectDescription
}

Learn More