C_SOMU_TEXTT

DDL: C_SOMU_TEXTT SQL: COMTEXTT Type: view Package: S_APS_OM_ODATA_FT_PARTS
9 Fields 1 Data Sources 2 Associations

Consumption view for text content

C_SOMU_TEXTT is a CDS View that provides data about "Consumption view for text content" in SAP S/4HANA. It reads from 1 data source (I_SOMU_TEXTT) and exposes 9 fields with key fields FormTemplateTextName, TextLanguage. It has 2 associations to related views. Part of development package S_APS_OM_ODATA_FT_PARTS.

Data Sources (1)

SourceAliasJoin Type
I_SOMU_TEXTT I_SOMU_TEXTT from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_SOMU_TEXT _Text _Text.FormTemplateTextName = $projection.FormTemplateTextName
[0..1] I_Language _TextLanguage _TextLanguage.Language = $projection.TextLanguage

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName COMTEXTT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption view for text content view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.semanticKey FormTemplateTextName view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY FormTemplateTextName FormTemplateTextName Zone name
KEY TextLanguage TextLanguage Report Text Language
FormTemplateTextContent FormTemplateTextContent Trusted Site Content
CreatedByUser CreatedByUser User Name
TextCreationDateTime TextCreationDateTime Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
_Text _Text
_TextLanguage _TextLanguage

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 C_SOMU_TEXTT.
-- 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: COMTEXTT

CREATE VIEW C_SOMU_TEXTT AS
SELECT
  FormTemplateTextName,
  TextLanguage,
  FormTemplateTextContent,
  CreatedByUser,
  TextCreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM I_SOMU_TEXTT
LEFT OUTER JOIN C_SOMU_TEXT AS _Text ON _Text.FormTemplateTextName = FormTemplateTextName  -- association [1..1]
LEFT OUTER JOIN I_Language AS _TextLanguage ON _TextLanguage.Language = TextLanguage  -- association [0..1]
;

Learn More