/SSB/UNION_OLD_REPORT_TEXTS

DDL: /SSB/UNION_OLD_REPORT_TEXTS SQL: /SSB/_UOLDRPCT Type: view

Texts for Reports from KPI/Report Design

/SSB/UNION_OLD_REPORT_TEXTS is a CDS View that provides data about "Texts for Reports from KPI/Report Design" in SAP S/4HANA. It reads from 8 data sources and exposes 13 fields with key fields id, is_active, Language, is_active, Language.

Data Sources (8)

SourceAliasJoin Type
/SSB/UNION_REPORT_CONFIGS _ReportConfigTable left_outer
/SSB/UNION_REPORT_CONFIGS _ReportConfigTable left_outer
/ssb/Core_Evaluation_Texts /ssb/Core_Evaluation_Texts left_outer
/ssb/Core_Evaluation_Texts /ssb/Core_Evaluation_Texts inner
/ssb/Core_Indicator_Texts /ssb/Core_Indicator_Texts inner
/ssb/Core_Indicator_Texts /ssb/Core_Indicator_Texts left_outer
/ssb/Union_Evaluations evaluations from
/ssb/Union_Evaluations evaluations union_all

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName /SSB/_UOLDRPCT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Texts for Reports from KPI/Report Design view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY id /ssb/Union_Evaluations id WorklistID
KEY is_active /ssb/Union_Evaluations is_active Truth Value
KEY Language indicators_texts Language Report Text Language
title indicators_texts title View Title
sub_title evaluation_texts title View Title
LanguageISOCode indicators_texts LanguageISOCode Language ISO Code
idasid
KEY is_active /ssb/Union_Evaluations is_active Truth Value
KEY Language evaluation_texts Language Report Text Language
title indicators_texts title View Title
sub_title evaluation_texts title View Title
LanguageISOCode evaluation_texts LanguageISOCode Language ISO Code
IsLogonLanguage evaluation_texts IsLogonLanguage

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 /SSB/UNION_OLD_REPORT_TEXTS.
-- 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: /SSB/_UOLDRPCT

CREATE VIEW /SSB/UNION_OLD_REPORT_TEXTS AS
SELECT
  evaluations.id AS id,
  evaluations.is_active AS is_active,
  indicators_texts.Language AS Language,
  indicators_texts.title AS title,
  evaluation_texts.title AS sub_title,
  indicators_texts.LanguageISOCode AS LanguageISOCode,
  indicators_texts.IsLogonLanguage as IsLogonLanguage AS idasid,
  evaluation_texts.IsLogonLanguage AS IsLogonLanguage
FROM /ssb/Union_Evaluations AS evaluations
LEFT OUTER JOIN /SSB/UNION_REPORT_CONFIGS AS _ReportConfigTable ON /* join condition not captured in parsed metadata */
INNER JOIN /ssb/Core_Indicator_Texts ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ssb/Core_Evaluation_Texts ON /* join condition not captured in parsed metadata */
INNER JOIN /ssb/Core_Evaluation_Texts ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ssb/Core_Indicator_Texts ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): /ssb/Union_Evaluations
;