ESH_N_RTCODE

DDL: ESH_N_RTCODE SQL: VESH_N_RTCODE Type: view
3 Fields 1 Data Sources 2 Associations

Transactions without Apps

ESH_N_RTCODE is a CDS View that provides data about "Transactions without Apps" in SAP S/4HANA. It reads from 1 data source (tstc) and exposes 3 fields with key field tcode. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
tstc tstc from

Associations (2)

CardinalityTargetAliasCondition
[1..*] tstct _TSTC2TXT $projection.tcode = _TSTC2TXT.tcode
[0..*] ESH_APP_KEYWORDT_CDS _tcode_to_app $projection.tcode = _tcode_to_app.keywords

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName VESH_N_RTCODE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #INHERITED view
EndUserText.label Transactions without Apps view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY tcode tcode Undefined range (can be used for patch levels)
keywordsthenXelseendashas_app
_TSTC2TXT _TSTC2TXT

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 ESH_N_RTCODE.
-- 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: VESH_N_RTCODE

CREATE VIEW ESH_N_RTCODE AS
SELECT
  tcode,
  case tcode when _tcode_to_app.keywords then 'X' else ' ' end as has_app AS keywordsthenXelseendashas_app
FROM tstc
LEFT OUTER JOIN tstct AS _TSTC2TXT ON tcode = _TSTC2TXT.tcode  -- association [1..*]
LEFT OUTER JOIN ESH_APP_KEYWORDT_CDS AS _tcode_to_app ON tcode = _tcode_to_app.keywords  -- association [0..*]
;

Learn More