SEPM_I_ShortTextGroup

DDL: SEPM_I_SHORTTEXTGROUP SQL: SEPM_ISHRTTXTGRP Type: view

EPM Demo: Short Text Group

SEPM_I_ShortTextGroup is a CDS View of category Dimension that provides data about "EPM Demo: Short Text Group" in SAP S/4HANA. It reads from 1 data source (snwd_text_key) and exposes 4 fields with key field ShortTextGroupUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
snwd_text_key snwd_text_key from

Associations (2)

CardinalityTargetAliasCondition
[0..1] SEPM_I_Language _OriginalLanguage $projection.OriginalLanguage = _OriginalLanguage.Language
[1..*] SEPM_I_ShortText _ShortText $projection.ShortTextGroupUUID = _ShortText.ShortTextGroupUUID

Annotations (9)

NameValueLevelField
EndUserText.label EPM Demo: Short Text Group view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName SEPM_ISHRTTXTGRP view
ObjectModel.representativeKey ShortTextGroupUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ShortTextGroupUUID node_key Tree Model: Node Key
OriginalLanguage original_langu Original Language
_ShortText _ShortText
_OriginalLanguage _OriginalLanguage

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 SEPM_I_ShortTextGroup.
-- 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: SEPM_ISHRTTXTGRP

CREATE VIEW SEPM_I_ShortTextGroup AS
SELECT
  node_key AS ShortTextGroupUUID,
  original_langu AS OriginalLanguage
FROM snwd_text_key
LEFT OUTER JOIN SEPM_I_Language AS _OriginalLanguage ON OriginalLanguage = _OriginalLanguage.Language  -- association [0..1]
LEFT OUTER JOIN SEPM_I_ShortText AS _ShortText ON ShortTextGroupUUID = _ShortText.ShortTextGroupUUID  -- association [1..*]
;