I_TransportObjectsDescription

DDL: I_TRANSPORTOBJECTSDESCRIPTION SQL: ITROBJTYP_T Type: view

Transport Objects Description

I_TransportObjectsDescription is a CDS View that provides data about "Transport Objects Description" in SAP S/4HANA. It reads from 4 data sources (objt, I_RequestObjectLangText, I_TRObjectLangDescription, trsyst_objtyp_t) and exposes 5 fields with key fields TransportRequestObjectPgmID, TransportRequestObjectType, TransportRequestObjectType, TransportRequestObjectType.

4 data source(s) 5 fields

Data Sources (4)

SourceAliasJoin Type
objt objt from
I_RequestObjectLangText rolt inner
I_TRObjectLangDescription trobjlangdesc union
trsyst_objtyp_t trsyst_objtyp_t union

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ITROBJTYP_T view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Transport Objects Description view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY TransportRequestObjectPgmID
KEY TransportRequestObjectType objectname
KEY TransportRequestObjectType object
KEY TransportRequestObjectType I_TRObjectLangDescription Objectname
TransportRequestObjectTypeDesc 
@AbapCatalog.sqlViewName: 'ITROBJTYP_T'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Transport Objects Description'
define view I_TransportObjectsDescription
  as select from objt
{
  key 'R3TR' as TransportRequestObjectPgmID,
  key objectname as TransportRequestObjectType,
      cast( ddtext  as abap.char( 75 ) ) as TransportRequestObjectTypeDesc
}
where
      language   = $session.system_language
  and objecttype = 'L'
union select from trsyst_objtyp_t
{
  key pgmid  as TransportRequestObjectPgmID,
  key object as TransportRequestObjectType,
      cast( ddtext as abap.char( 75 ) )as TransportRequestObjectTypeDesc
}
where
  spras = $session.system_language
union select from I_TRObjectLangDescription as trobjlangdesc inner join 
 I_RequestObjectLangText as rolt on trobjlangdesc.TransportRequestObjectPgmID = rolt.TransportRequestObjectType {
  key 'LANG' as TransportRequestObjectPgmID,
  key trobjlangdesc.Objectname as TransportRequestObjectType,
      cast( concat_with_space( concat( rolt.TransportRequestObjectTypeDesc, ':'),trobjlangdesc.TransportRequestObjectTypeDesc,1) as abap.char( 75 )) as TransportRequestObjectTypeDesc 
      }
where  
      trobjlangdesc.Language   = $session.system_language
  and trobjlangdesc.Objecttype = 'L'     
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_REQUESTOBJECTLANGTEXT",
"I_TROBJECTLANGDESCRIPTION",
"OBJT",
"TRSYST_OBJTYP_T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More