/SSB/UNION_CE_CHIP_TEXTS

DDL: /SSB/UNION_CE_CHIP_TEXTS SQL: /SSB/U_CECHIP_T Type: view Package: /SSB/CORE

SSB: Union of all Cloud Chip Texts

/SSB/UNION_CE_CHIP_TEXTS is a CDS View that provides data about "SSB: Union of all Cloud Chip Texts" in SAP S/4HANA. It reads from 9 data sources and exposes 14 fields with key fields id, language, language, language, language. Part of development package /SSB/CORE.

Data Sources (9)

SourceAliasJoin Type
/ssb/ce_chips_t /ssb/ce_chips_t union_all
/ssb/chips_s_t /ssb/chips_s_t from
/ssb/sacda_tilet /ssb/sacda_tilet union_all
/ssb/sactilet_s /ssb/sactilet_s union_all
boc_story_chip_t boc_story_chip_t union_all
/SSB/SAPCLIENT SC inner
/SSB/SAPCLIENT SC inner
/SSB/SAPCLIENT SC inner
/SSB/SAPCLIENT SC inner

Annotations (9)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName /SSB/U_CECHIP_T view
AbapCatalog.compiler.compareFilter 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 SSB: Union of all Cloud Chip Texts view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY id id WorklistID
KEY language language Language
title title View Title
KEY language language Language
title title View Title
chip_idasid
KEY language language Language
title title View Title
chip_idasid
KEY language language Language
title title View Title
KEY language lang Language
title title View Title
subtitle subtitle Subtitle

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_CE_CHIP_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/U_CECHIP_T

CREATE VIEW /SSB/UNION_CE_CHIP_TEXTS AS
SELECT
  id,
  language,
  title,
  subtitle AS chip_idasid,
  subtitle
FROM /ssb/chips_s_t
INNER JOIN /SSB/SAPCLIENT AS SC ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): /ssb/ce_chips_t, /ssb/sacda_tilet, /ssb/sactilet_s, boc_story_chip_t
;