SAIS_TDDAT

DDL: SAIS_TDDAT SQL: SAIS_GET_TDDAT Type: view
4 Fields 1 Data Sources 3 Associations

Get TDDAT Content with Short Texts for Groups

SAIS_TDDAT is a CDS View that provides data about "Get TDDAT Content with Short Texts for Groups" in SAP S/4HANA. It reads from 1 data source (tddat) and exposes 4 fields with key field tabname. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
tddat tddat from

Associations (3)

CardinalityTargetAliasCondition
[0..1] tbrg_autht _sucu_langu_act _sucu_langu_act.brgru = tddat.cclass and _sucu_langu_act.object = 'S_TABU_DIS' and _sucu_langu_act.spras = $session.system_language -- text English
[0..1] tbrg_autht _sucu_langu_en _sucu_langu_en.brgru = tddat.cclass and _sucu_langu_en.object = 'S_TABU_DIS' and _sucu_langu_en.spras = 'E'
[0..1] tbrgt _tbrgt_bezei _tbrgt_bezei.brgru = tddat.cclass and _tbrgt_bezei.brobj = 'S_TABU_DIS' and _tbrgt_bezei.spras = $session.system_language

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SAIS_GET_TDDAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Get TDDAT Content with Short Texts for Groups view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY tabname tddat tabname Table/Constant Value
cclass tddat cclass Class
cclass_tx
cclassS_TABU_DISendasobj_name

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 SAIS_TDDAT.
-- 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: SAIS_GET_TDDAT

CREATE VIEW SAIS_TDDAT AS
SELECT
  tddat.tabname AS tabname,
  tddat.cclass AS cclass,
  coalesce( coalesce( _sucu_langu_act.bezei, _sucu_langu_en.bezei ), _tbrgt_bezei.bezei ) AS cclass_tx,
  case when tddat.cclass = '' then '' else CONCAT( tddat.cclass, '%S_TABU_DIS' ) end as obj_name AS cclassS_TABU_DISendasobj_name
FROM tddat
LEFT OUTER JOIN tbrg_autht AS _sucu_langu_act ON _sucu_langu_act.brgru = tddat.cclass AND _sucu_langu_act.object = 'S_TABU_DIS' AND _sucu_langu_act.spras = $session.system_language  -- association [0..1]
LEFT OUTER JOIN tbrg_autht AS _sucu_langu_en ON _sucu_langu_en.brgru = tddat.cclass AND _sucu_langu_en.object = 'S_TABU_DIS' AND _sucu_langu_en.spras = 'E'  -- association [0..1]
LEFT OUTER JOIN tbrgt AS _tbrgt_bezei ON _tbrgt_bezei.brgru = tddat.cclass AND _tbrgt_bezei.brobj = 'S_TABU_DIS' AND _tbrgt_bezei.spras = $session.system_language  -- association [0..1]
;

Learn More