ris_adt_executable_objects

DDL: RIS_ADT_EXECUTABLE_OBJECTS SQL: RIS_V_EXECUTABLS Type: view
12 Fields 8 Data Sources

View on executable objects

ris_adt_executable_objects is a CDS View that provides data about "View on executable objects" in SAP S/4HANA. It reads from 8 data sources and exposes 12 fields.

Data Sources (8)

SourceAliasJoin Type
o2appl o2appl union
seoclass seoclass union
tadir tadir from
tadir tadir union
tfdir tfdir union
trdir trdir union
tstc tstc union
wdy_application wdy_application union

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName RIS_V_EXECUTABLS view
EndUserText.label View on executable objects view

Fields (12)

KeyFieldSource TableSource FieldDescription
objtype_tr object TRFM Object
subtype_wb
subtype_wb
subtype_wb
subtype_wb
subtype_wb
subtype_wb
subtype_wb
subtype_wb
subtype_wb
subtype_wb
object_name application_name BRFplus Application

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view ris_adt_executable_objects.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: RIS_V_EXECUTABLS

CREATE VIEW ris_adt_executable_objects AS
SELECT
  object AS objtype_tr,
  'YA' AS subtype_wb,
  application_name AS object_name
FROM tadir
-- UNION with additional select branch(es): tadir, seoclass, trdir, tstc, tfdir, o2appl, wdy_application
;

Learn More