I_RequestTypeInt

DDL: I_REQUESTTYPEINT Type: view_entity

Request Type

I_RequestTypeInt is a CDS View that provides data about "Request Type" in SAP S/4HANA. It reads from 3 data sources (bctools_cust, dd07l, dd07t) and exposes 2 fields with key field domvalue_l.

3 data source(s) 2 fields

Data Sources (3)

SourceAliasJoin Type
bctools_cust BctoolsCust left_outer
dd07l Domain from
dd07t DomainText left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Request Type view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY domvalue_l dd07l domvalue_l
TransportRequestTypeText dd07t ddtext 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Request Type'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity I_RequestTypeInt
  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
    left outer join bctools_cust as BctoolsCust on BctoolsCust.id = 'BCFG_TRANSPORT_API'
{
  key Domain.domvalue_l,

      @Semantics.text: true
      DomainText.ddtext as TransportRequestTypeText,

      case when BctoolsCust.value is null then 'X'
           when BctoolsCust.value = 'ABAP_CP' then case Domain.domvalue_l when 'W' then 'X'
                                                                                   else '' end
           else 'X' end as DisplayTransportRequestType
}
where
       Domain.domname        = 'CTO_REQUEST_TYPE'
  and  Domain.as4local       = 'A'
  and  Domain.as4vers        = '0000'
  and  DomainText.ddlanguage = $session.system_language
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BCTOOLS_CUST",
"DD07L",
"DD07T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More