I_RecordedObjectTableKeys

DDL: I_RECORDEDOBJECTTABLEKEYS SQL: IRECORDED_OBJKEY Type: view Package: SCTS_REQ_APP

Objects

I_RecordedObjectTableKeys is a CDS View that provides data about "Objects" in SAP S/4HANA. It reads from 3 data sources (e071, e071k, dd02l) and exposes 11 fields with key fields TransportRequestID, TransportRequestObjectLineItem, TransportRequestObjectPgmID, TransportRequestObjTypeMaster, TransportRequestObjMasterName. Part of development package SCTS_REQ_APP.

3 data source(s) 11 fields

Data Sources (3)

SourceAliasJoin Type
e071 RecordedObjects from
e071k RecordedObjectTableKeys inner
dd02l Tables left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName IRECORDED_OBJKEY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Objects view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY TransportRequestID e071 trkorr
KEY TransportRequestObjectLineItem e071 as4pos
KEY TransportRequestObjectPgmID e071k pgmid
KEY TransportRequestObjTypeMaster e071k mastertype
KEY TransportRequestObjMasterName e071k mastername
KEY TransportRequestTabKeyLineItem e071k as4pos
TransportRequestObjectType e071k object
TransportRequestObjectName e071k objname
TransportRequestObjViewName e071k viewname
TransportRequestObjTableKey e071k tabkey
tabkeyendasTableKeyWithoutClient 
@AbapCatalog.sqlViewName: 'IRECORDED_OBJKEY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Objects'
define view I_RecordedObjectTableKeys
  as select from    e071  as RecordedObjects
    inner join      e071k as RecordedObjectTableKeys on  RecordedObjects.trkorr   = RecordedObjectTableKeys.trkorr
                                                     and RecordedObjects.pgmid    = RecordedObjectTableKeys.pgmid
                                                     and RecordedObjects.object   = RecordedObjectTableKeys.mastertype
                                                     and RecordedObjects.obj_name = RecordedObjectTableKeys.mastername
    left outer join dd02l as Tables                  on  RecordedObjectTableKeys.objname = Tables.tabname
                                                     and Tables.as4local                 = #AS4LOCAL.'A'
                                                     and Tables.as4vers                  = '0000'
                                                     and Tables.tabclass                 = #TABCLASS.'TRANSP'

{
  key RecordedObjects.trkorr             as TransportRequestID,
  key RecordedObjects.as4pos             as TransportRequestObjectLineItem,
  key RecordedObjectTableKeys.pgmid      as TransportRequestObjectPgmID,
  key RecordedObjectTableKeys.mastertype as TransportRequestObjTypeMaster,
  key RecordedObjectTableKeys.mastername as TransportRequestObjMasterName,
  key RecordedObjectTableKeys.as4pos     as TransportRequestTabKeyLineItem,
      RecordedObjectTableKeys.object     as TransportRequestObjectType,
      RecordedObjectTableKeys.objname    as TransportRequestObjectName,
      RecordedObjectTableKeys.viewname   as TransportRequestObjViewName,
      RecordedObjectTableKeys.tabkey     as TransportRequestObjTableKey,
      case Tables.clidep when 'X' then substring( RecordedObjectTableKeys.tabkey, 4, 117 )
                         else RecordedObjectTableKeys.tabkey
                         end             as TableKeyWithoutClient
}

Learn More