/ssb/Core_DD_View_Text

DDL: /SSB/CORE_DD_VIEW_TEXT SQL: /ssb/CDDViewText Type: view Package: /SSB/CORE
10 Fields 3 Data Sources

SSB: Core DD View Text

/ssb/Core_DD_View_Text is a CDS View that provides data about "SSB: Core DD View Text" in SAP S/4HANA. It reads from 3 data sources (/ssb/dd_view_t_s, /ssb/dd_views_t, /SSB/SAPCLIENT) and exposes 10 fields with key fields view_id, is_active, Language, is_active, Language. Part of development package /SSB/CORE.

Data Sources (3)

SourceAliasJoin Type
/ssb/dd_view_t_s /ssb/dd_view_t_s from
/ssb/dd_views_t /ssb/dd_views_t 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/CDDViewText view
EndUserText.label SSB: Core DD View Text 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 (10)

KeyFieldSource TableSource FieldDescription
KEY view_id view_id View ID
KEY is_active Truth Value
KEY Language sap_language_key Language
namespace
title title View Title
KEY is_active Truth Value
KEY Language sap_language_key Language
namespace
title title View Title
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_DD_View_Text.
-- 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/CDDViewText
-- Parameters: P_language : abap.lang

CREATE VIEW /ssb/Core_DD_View_Text AS
SELECT
  view_id,
  cast(is_active as abap.numc( 1 )) AS is_active,
  sap_language_key AS Language,
  'S' AS namespace,
  title,
  case when sap_language_key = $parameters.P_language then 1 else 0 end as IsLogonLanguage AS P_languagethen1else0endasIsLogonLanguage
FROM /ssb/dd_view_t_s
INNER JOIN /SSB/SAPCLIENT AS SC ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): /ssb/dd_views_t
;

Learn More