CIC_LanguageRegion

DDL: CIC_LANGUAGEREGION Type: view_entity Package: CIC_COMMON

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. Part of development package CIC_COMMON.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
t002 Language inner
t002x LanguageKey from

Annotations (5)

NameValueLevelField
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #X 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:      #CUSTOMIZING,
     serviceQuality: #X,
     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,
      cast (
        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 cic_language_region preserving type )
         as iso2_country


}
where
  LanguageKey.iso2 is not initial

Learn More