/ssb/Core_Indicator_Texts

DDL: /SSB/CORE_INDICATOR_TEXTS SQL: /SSB/_CINTS Type: view
13 Fields 5 Data Sources

SSB: Core Indicator Texts

/ssb/Core_Indicator_Texts is a CDS View that provides data about "SSB: Core Indicator Texts" in SAP S/4HANA. It reads from 5 data sources (/ssb/Languages, /ssb/Languages, /ssb/indicat_t_s, /ssb/indicator_t, /SSB/SAPCLIENT) and exposes 13 fields with key fields id, is_active, Language, is_active, Language.

Data Sources (5)

SourceAliasJoin Type
/ssb/Languages /ssb/Languages inner
/ssb/Languages /ssb/Languages inner
/ssb/indicat_t_s IndicatorTexts from
/ssb/indicator_t IndicatorTexts union_all
/SSB/SAPCLIENT SC inner

Parameters (1)

NameTypeDefault
P_language abap.lang

Annotations (9)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName /SSB/_CINTS view
EndUserText.label SSB: Core Indicator Texts 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

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY id id WorklistID
KEY is_active is_active Truth Value
KEY Language Languages Language Report Text Language
title title View Title
description description Well Code Des.
LanguageISOCode LanguageISOCode Language ISO Code
Languagekeyid
KEY is_active is_active Truth Value
KEY Language Languages Language Report Text Language
title title View Title
description description Well Code Des.
LanguageISOCode LanguageISOCode Language ISO Code
P_languagethen1else0endasIsLogonLanguage

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/Core_Indicator_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/_CINTS
-- Parameters: P_language : abap.lang

CREATE VIEW /ssb/Core_Indicator_Texts AS
SELECT
  id,
  is_active,
  Languages.Language AS Language,
  title,
  description,
  LanguageISOCode,
  case when Languages.Language = $parameters.P_language then 1 else 0 end as IsLogonLanguage AS Languagekeyid,
  case when Languages.Language = $parameters.P_language then 1 else 0 end as IsLogonLanguage AS P_languagethen1else0endasIsLogonLanguage
FROM /ssb/indicat_t_s AS IndicatorTexts
INNER JOIN /SSB/SAPCLIENT AS SC ON /* join condition not captured in parsed metadata */
INNER JOIN /ssb/Languages ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): /ssb/indicator_t
;

Learn More