I_RequestsProject

DDL: I_REQUESTSPROJECT SQL: IREQUEST_PROJECT Type: view

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.

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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CTSPROJECT",
"E070",
"E070A"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More