I_MDOLanguageCode

DDL: I_MDOLANGUAGECODE SQL: IMDOLANGUAGECODE Type: view

Language codes

I_MDOLanguageCode is a CDS View that provides data about "Language codes" in SAP S/4HANA. It reads from 2 data sources (t002, t002t) and exposes 3 fields with key field SapLanguageCode.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
t002 code from
t002t text left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName IMDOLANGUAGECODE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Language codes view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY SapLanguageCode t002 spras
IsoLanguageCode t002 laiso
Text t002t sptxt 
@AbapCatalog.sqlViewName: 'IMDOLANGUAGECODE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Language codes'
define view I_MDOLanguageCode as select from t002 as code 
  left outer join t002t as text on text.sprsl = code.spras and text.spras = $session.system_language 
{ 
// currently we have only 1 character SAP code in $session.system_language for displaying right language text  

  key code.spras as SapLanguageCode,  
  code.laiso     as IsoLanguageCode,
  text.sptxt     as Text   
}

Learn More