CIC_LanguageRegion

DDL: CIC_LANGUAGEREGION Type: view_entity

CIC Projection on Language Key

CIC_LanguageRegion is a CDS View that provides data about "CIC Projection on Language Key" in SAP S/4HANA. It reads from 2 data sources (t002, t002x) and exposes 4 fields with key fields Language, LanguageCode.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
t002 Language inner
t002x LanguageKey from

Annotations (5)

NameValueLevelField
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label CIC Projection on Language Key view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Language t002 spras
KEY LanguageCode t002 laiso
Country t002x country
IsoCode t002x iso2 

@ObjectModel: {
   usageType: {
     dataClass:      #MASTER,
     serviceQuality: #A,
     sizeCategory:   #M
   }
}
@EndUserText.label: 'CIC Projection on Language Key'
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view entity CIC_LanguageRegion   as select from t002x as LanguageKey 
inner join t002 as Language on LanguageKey.laiso = Language.laiso 
{
  key Language.spras as Language,
  key Language.laiso as LanguageCode,
  LanguageKey.country as Country,
  LanguageKey.iso2 as IsoCode,
   case
      when LanguageKey.country = ''
        then cast ( LanguageKey.iso2 as char2 preserving type )
      else 
        cast ( CONCAT( CONCAT( LanguageKey.iso2 ,'-'), LanguageKey.country ) as char5 preserving type )
      end      as iso2_country
      
  
}
where LanguageKey.iso2 is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T002",
"T002X"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More