CLMS_V_TM_TR_OBJ

DDL: CLMS_V_TM_TR_OBJ SQL: CLMSV_TMTROBJ Type: view

Objects of transport requests

CLMS_V_TM_TR_OBJ is a CDS View that provides data about "Objects of transport requests" in SAP S/4HANA. It reads from 1 data source (e071) and exposes 4 fields.

Data Sources (1)

SourceAliasJoin Type
e071 object left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName CLMSV_TMTROBJ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientDependent false view
EndUserText.label Objects of transport requests view

Fields (4)

KeyFieldSource TableSource FieldDescription
trkorr request trkorr
pgmid e071 pgmid
object e071 object
obj_name e071 obj_name
@AbapCatalog.sqlViewName: 'CLMSV_TMTROBJ'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientDependent: false
@EndUserText.label: 'Objects of transport requests'
define view CLMS_V_TM_TR_OBJ as 

  select distinct from e070 as request
  
  left outer join e071 as object
    on object.trkorr = request.trkorr

  {
    request.trkorr,
    object.pgmid,
    object.object,
    object.obj_name
  }
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"E070",
"E071"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/