CIC_LanguageRegion

DDL: CIC_LANGUAGEREGION Type: view_entity Package: CIC_COMMON
4 Fields 2 Data Sources

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.

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 Off. Language
KEY LanguageCode t002 laiso Language Code
Country t002x country Venue: Ctry/Reg
IsoCode t002x iso2 ISO2 language

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 CIC_LanguageRegion.
-- 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 CIC_LanguageRegion AS
SELECT
  Language.spras AS Language,
  Language.laiso AS LanguageCode,
  LanguageKey.country AS Country,
  LanguageKey.iso2 AS IsoCode
FROM t002x AS LanguageKey
INNER JOIN t002 AS Language ON /* join condition not captured in parsed metadata */
;

Learn More