I_RSAU_META_DATA

DDL: I_RSAU_META_DATA Type: view_entity Package: SECU
10 Fields 1 Data Sources 7 Associations

Event Definiton Releated Data

I_RSAU_META_DATA is a CDS View that provides data about "Event Definiton Releated Data" in SAP S/4HANA. It reads from 1 data source (tsl1d) and exposes 10 fields with key fields area, subid. It has 7 associations to related views. Part of development package SECU.

Data Sources (1)

SourceAliasJoin Type
tsl1d tsl1d from

Associations (7)

CardinalityTargetAliasCondition
[0..1] tsl1t _tx_active tsl1d.area = _tx_active.area and tsl1d.subid = _tx_active.subid and _tx_active.spras = $session.system_language
[0..1] tsl1t _tx_en tsl1d.area = _tx_en.area and tsl1d.subid = _tx_en.subid and _tx_en.spras = 'E'
[0..1] I_RSAU_SUBCLAS_TX _tx_subclas _tx_subclas.subclasid = tsl1d.subclasid and _tx_subclas.ddlanguage = $session.system_language
[0..1] I_RSAU_SUBCLAS_TX _tx_subclas_en _tx_subclas_en.subclasid = tsl1d.subclasid and _tx_subclas_en.ddlanguage = 'E'
[0..1] I_RSAU_SEVE_TX _tx_seve _tx_seve.severity = tsl1d.severity and _tx_seve.ddlanguage = $session.system_language
[0..1] I_RSAU_SEVE_TX _tx_seve_en _tx_seve_en.severity = tsl1d.severity and _tx_seve_en.ddlanguage = 'E'
[0..1] tsl1d_attr attr tsl1d.area = attr.area and tsl1d.subid = attr.subid

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Event Definiton Releated Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY area tsl1d area Settings Area
KEY subid tsl1d subid Topic ID
var_set_1 attr var_set_1
msg
txt
subclasid tsl1d subclasid Subgroup
txsubclsid
severity tsl1d severity Thresh.Val. Severity
txseverity
severity5thenMelseLendasseverity_s

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 I_RSAU_META_DATA.
-- 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.

CREATE VIEW I_RSAU_META_DATA AS
SELECT
  tsl1d.area AS area,
  tsl1d.subid AS subid,
  attr.var_set_1 AS var_set_1,
  concat(tsl1d.area, tsl1d.subid ) AS msg,
  coalesce( _tx_active.txt, _tx_en.txt) AS txt,
  tsl1d.subclasid AS subclasid,
  coalesce( _tx_subclas.ddtext, _tx_subclas_en.ddtext) AS txsubclsid,
  tsl1d.severity AS severity,
  coalesce( _tx_seve.ddtext, _tx_seve_en.ddtext) AS txseverity,
  case when tsl1d.severity = 9 then 'H' when tsl1d.severity = 5 then 'M' else 'L' end as severity_s AS severity5thenMelseLendasseverity_s
FROM tsl1d
LEFT OUTER JOIN tsl1t AS _tx_active ON tsl1d.area = _tx_active.area AND tsl1d.subid = _tx_active.subid AND _tx_active.spras = $session.system_language  -- association [0..1]
LEFT OUTER JOIN tsl1t AS _tx_en ON tsl1d.area = _tx_en.area AND tsl1d.subid = _tx_en.subid AND _tx_en.spras = 'E'  -- association [0..1]
LEFT OUTER JOIN I_RSAU_SUBCLAS_TX AS _tx_subclas ON _tx_subclas.subclasid = tsl1d.subclasid AND _tx_subclas.ddlanguage = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RSAU_SUBCLAS_TX AS _tx_subclas_en ON _tx_subclas_en.subclasid = tsl1d.subclasid AND _tx_subclas_en.ddlanguage = 'E'  -- association [0..1]
LEFT OUTER JOIN I_RSAU_SEVE_TX AS _tx_seve ON _tx_seve.severity = tsl1d.severity AND _tx_seve.ddlanguage = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RSAU_SEVE_TX AS _tx_seve_en ON _tx_seve_en.severity = tsl1d.severity AND _tx_seve_en.ddlanguage = 'E'  -- association [0..1]
LEFT OUTER JOIN tsl1d_attr AS attr ON tsl1d.area = attr.area AND tsl1d.subid = attr.subid  -- association [0..1]
;

Learn More