I_EHSSubjNameFallbackLanguage

DDL: I_EHSSUBJNAMEFALLBACKLANGUAGE Type: view_entity COMPOSITE Package: EHFND_MASTER_COMN
2 Fields 1 Data Sources

Subject Name with Fallback

I_EHSSubjNameFallbackLanguage is a Composite CDS View that provides data about "Subject Name with Fallback" in SAP S/4HANA. It reads from 1 data source (I_EHSSubject) and exposes 2 fields with key field EHSSubjectUUID. Part of development package EHFND_MASTER_COMN.

Data Sources (1)

SourceAliasJoin Type
I_EHSSubject I_EHSSubject from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Subject Name with Fallback view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #META view
VDM.viewType #COMPOSITE view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY EHSSubjectUUID EHSSubjectUUID Subject Ref Key
EHSSubjectTextendasEHSSubjectText

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 I_EHSSubjNameFallbackLanguage.
-- 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.

CREATE VIEW I_EHSSubjNameFallbackLanguage AS
SELECT
  EHSSubjectUUID,
  min( distinct case when _Text[1: Language = $session.system_language].EHSSubjectText is not null then _Text[1: Language = $session.system_language].EHSSubjectText when _Text[1: Language = 'E'].EHSSubjectText is not null then _Text[1: Language = 'E'].EHSSubjectText else _Text[1: Language is not null].EHSSubjectText end ) as EHSSubjectText AS EHSSubjectTextendasEHSSubjectText
FROM I_EHSSubject
;

Learn More