RFM_E_theme_T

DDL: RFM_THEME_T SQL: RFM_V_THEMES_T Type: view
5 Fields 2 Data Sources

FSH_COLLECTIONS_TCompatibility view

RFM_E_theme_T is a CDS View that provides data about "FSH_COLLECTIONS_TCompatibility view" in SAP S/4HANA. It reads from 2 data sources (rfm_seasons, rfm_seasons_t) and exposes 5 fields with key fields fsh_season, fsh_theme, spras.

Data Sources (2)

SourceAliasJoin Type
rfm_seasons R1 from
rfm_seasons_t R2 inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName RFM_V_THEMES_T view
AbapCatalog.compiler.compareFilter true view
EndUserText.label FSH_COLLECTIONS_TCompatibility view view
DataAging.noAgingRestriction false view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #AUTOMATED view
AccessControl.authorizationCheck #NOT_ALLOWED view
AbapCatalog.viewEnhancementCategory #PROJECTION_LIST view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY fsh_season rfm_seasons fsh_season Season
KEY fsh_theme rfm_seasons fsh_theme Theme
KEY spras rfm_seasons_t spras Off. Language
text rfm_seasons_t text User Group
long_text rfm_seasons_t long_text Text Line

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 RFM_E_theme_T.
-- 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: RFM_V_THEMES_T

CREATE VIEW RFM_E_theme_T AS
SELECT
  R1.fsh_season AS fsh_season,
  R1.fsh_theme AS fsh_theme,
  R2.spras AS spras,
  R2.text AS text,
  R2.long_text AS long_text
FROM rfm_seasons AS R1
INNER JOIN rfm_seasons_t AS R2 ON /* join condition not captured in parsed metadata */
;

Learn More