I_Language

DDL: I_LANGUAGE SQL: ILanguage Type: view BASIC Package: STRO

Language

I_Language (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_Language is a Basic CDS View (Dimension) that provides data about "Language" in SAP S/4HANA. It reads from 1 data source (t002) and exposes 3 fields with key field Language. It has 1 association to related views. It is exposed through 148 OData services (ASQL_F0717, ASQL_F0731A, ASQL_F0859, ...). It is used in 2 Fiori applications: Manage Technical Names for Substance, Manage Work Views. Part of development package STRO.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessCross Applications
Application ComponentBC-DOC-TTL
CapabilitiesData Source for Data Extraction
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageCross Applications for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
t002 t002 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_LanguageText _Text $projection.Language = _Text.LanguageCode

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ILanguage view
EndUserText.label Language view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.representativeKey Language view
Search.searchable true view

OData Services (148)

ServiceBindingVersionContractRelease
ASQL_F0717 ASQL_F0717 C2 NOT_RELEASED
ASQL_F0731A ASQL_F0731A C2 NOT_RELEASED
ASQL_F0859 ASQL_F0859 C2 NOT_RELEASED
ASQL_F1426 ASQL_F1426 C2 NOT_RELEASED
ASQL_F1574A ASQL_F1574A C2 NOT_RELEASED
ASQL_F1603A ASQL_F1603A C2 NOT_RELEASED
ASQL_F1605A ASQL_F1605A C2 NOT_RELEASED
ASQL_F1688 ASQL_F1688 C2 NOT_RELEASED
ASQL_F2103 ASQL_F2103 C2 NOT_RELEASED
ASQL_F2331 ASQL_F2331 C2 NOT_RELEASED
ASQL_F2412 ASQL_F2412 C2 NOT_RELEASED
ASQL_F2515 ASQL_F2515 C2 NOT_RELEASED
ASQL_F2516 ASQL_F2516 C2 NOT_RELEASED
ASQL_F2517 ASQL_F2517 C2 NOT_RELEASED
ASQL_F2518 ASQL_F2518 C2 NOT_RELEASED
ASQL_F2564 ASQL_F2564 C2 NOT_RELEASED
ASQL_F2578 ASQL_F2578 C2 NOT_RELEASED
ASQL_F2628 ASQL_F2628 C2 NOT_RELEASED
ASQL_F2632 ASQL_F2632 C2 NOT_RELEASED
ASQL_F2647 ASQL_F2647 C2 NOT_RELEASED
ASQL_F2681 ASQL_F2681 C2 NOT_RELEASED
ASQL_F2699 ASQL_F2699 C2 NOT_RELEASED
ASQL_F2704 ASQL_F2704 C2 NOT_RELEASED
ASQL_F2705 ASQL_F2705 C2 NOT_RELEASED
ASQL_F2705A ASQL_F2705A C2 NOT_RELEASED
ASQL_F2720 ASQL_F2720 C2 NOT_RELEASED
ASQL_F2796 ASQL_F2796 C2 NOT_RELEASED
ASQL_F2872 ASQL_F2872 C2 NOT_RELEASED
ASQL_F2873 ASQL_F2873 C2 NOT_RELEASED
ASQL_F2935 ASQL_F2935 C2 NOT_RELEASED
ASQL_F2945 ASQL_F2945 C2 NOT_RELEASED
ASQL_F3014 ASQL_F3014 C2 NOT_RELEASED
ASQL_F3043 ASQL_F3043 C2 NOT_RELEASED
ASQL_F3044 ASQL_F3044 C2 NOT_RELEASED
ASQL_F3077 ASQL_F3077 C2 NOT_RELEASED
ASQL_F3098 ASQL_F3098 C2 NOT_RELEASED
ASQL_F3122 ASQL_F3122 C2 NOT_RELEASED
ASQL_F3149 ASQL_F3149 C2 NOT_RELEASED
ASQL_F3173 ASQL_F3173 C2 NOT_RELEASED
ASQL_F3232 ASQL_F3232 C2 NOT_RELEASED
ASQL_F3307 ASQL_F3307 C2 NOT_RELEASED
ASQL_F3316 ASQL_F3316 C2 NOT_RELEASED
ASQL_F3401 ASQL_F3401 C2 NOT_RELEASED
ASQL_F3402 ASQL_F3402 C2 NOT_RELEASED
ASQL_F3418 ASQL_F3418 C2 NOT_RELEASED
ASQL_F3423 ASQL_F3423 C2 NOT_RELEASED
ASQL_F3458 ASQL_F3458 C2 NOT_RELEASED
ASQL_F3516 ASQL_F3516 C2 NOT_RELEASED
ASQL_F3625 ASQL_F3625 C2 NOT_RELEASED
ASQL_F3680 ASQL_F3680 C2 NOT_RELEASED
ASQL_F3681 ASQL_F3681 C2 NOT_RELEASED
ASQL_F3794 ASQL_F3794 C2 NOT_RELEASED
ASQL_F3826 ASQL_F3826 C2 NOT_RELEASED
ASQL_F3829 ASQL_F3829 C2 NOT_RELEASED
ASQL_F3924 ASQL_F3924 C2 NOT_RELEASED
ASQL_F3932 ASQL_F3932 C2 NOT_RELEASED
ASQL_F3940 ASQL_F3940 C2 NOT_RELEASED
ASQL_F3966 ASQL_F3966 C2 NOT_RELEASED
ASQL_F3986 ASQL_F3986 C2 NOT_RELEASED
ASQL_F4021 ASQL_F4021 C2 NOT_RELEASED
ASQL_F4051 ASQL_F4051 C2 NOT_RELEASED
ASQL_F4090 ASQL_F4090 C2 NOT_RELEASED
ASQL_F4091 ASQL_F4091 C2 NOT_RELEASED
ASQL_F4095 ASQL_F4095 C2 NOT_RELEASED
ASQL_F4173A ASQL_F4173A C2 NOT_RELEASED
ASQL_F4197 ASQL_F4197 C2 NOT_RELEASED
ASQL_F4274 ASQL_F4274 C2 NOT_RELEASED
ASQL_F4548 ASQL_F4548 C2 NOT_RELEASED
ASQL_F4636 ASQL_F4636 C2 NOT_RELEASED
ASQL_F4637 ASQL_F4637 C2 NOT_RELEASED
ASQL_F4657 ASQL_F4657 C2 NOT_RELEASED
ASQL_F4758 ASQL_F4758 C2 NOT_RELEASED
ASQL_F4760 ASQL_F4760 C2 NOT_RELEASED
ASQL_F4765 ASQL_F4765 C2 NOT_RELEASED
ASQL_F4787 ASQL_F4787 C2 NOT_RELEASED
ASQL_F4788 ASQL_F4788 C2 NOT_RELEASED
ASQL_F4789 ASQL_F4789 C2 NOT_RELEASED
ASQL_F4988 ASQL_F4988 C2 NOT_RELEASED
ASQL_F4989 ASQL_F4989 C2 NOT_RELEASED
ASQL_F4993 ASQL_F4993 C2 NOT_RELEASED
ASQL_F5079 ASQL_F5079 C2 NOT_RELEASED
ASQL_F5134 ASQL_F5134 C2 NOT_RELEASED
ASQL_F5135 ASQL_F5135 C2 NOT_RELEASED
ASQL_F5142 ASQL_F5142 C2 NOT_RELEASED
ASQL_F5261 ASQL_F5261 C2 NOT_RELEASED
ASQL_F5289 ASQL_F5289 C2 NOT_RELEASED
ASQL_F5311 ASQL_F5311 C2 NOT_RELEASED
ASQL_F5312 ASQL_F5312 C2 NOT_RELEASED
ASQL_F5313 ASQL_F5313 C2 NOT_RELEASED
ASQL_F5525 ASQL_F5525 C2 NOT_RELEASED
ASQL_F5716 ASQL_F5716 C2 NOT_RELEASED
ASQL_F5766 ASQL_F5766 C2 NOT_RELEASED
ASQL_F5798 ASQL_F5798 C2 NOT_RELEASED
ASQL_F5980 ASQL_F5980 C2 NOT_RELEASED
ASQL_F5987 ASQL_F5987 C2 NOT_RELEASED
ASQL_F6000 ASQL_F6000 C2 NOT_RELEASED
ASQL_F6097A ASQL_F6097A C2 NOT_RELEASED
ASQL_F6131 ASQL_F6131 C2 NOT_RELEASED
ASQL_F6158 ASQL_F6158 C2 NOT_RELEASED
ASQL_F6164 ASQL_F6164 C2 NOT_RELEASED
ASQL_F6194 ASQL_F6194 C2 NOT_RELEASED
ASQL_F6588 ASQL_F6588 C2 NOT_RELEASED
ASQL_F6597 ASQL_F6597 C2 NOT_RELEASED
ASQL_F6635 ASQL_F6635 C2 NOT_RELEASED
ASQL_F6689 ASQL_F6689 C2 NOT_RELEASED
ASQL_F6742 ASQL_F6742 C2 NOT_RELEASED
ASQL_F6783 ASQL_F6783 C2 NOT_RELEASED
ASQL_F6848 ASQL_F6848 C2 NOT_RELEASED
ASQL_F6852 ASQL_F6852 C2 NOT_RELEASED
ASQL_F6935 ASQL_F6935 C2 NOT_RELEASED
ASQL_F6951 ASQL_F6951 C2 NOT_RELEASED
ASQL_F6990 ASQL_F6990 C2 NOT_RELEASED
ASQL_F7100 ASQL_F7100 C2 NOT_RELEASED
ASQL_F7103 ASQL_F7103 C2 NOT_RELEASED
ASQL_F7191 ASQL_F7191 C2 NOT_RELEASED
ASQL_F7192 ASQL_F7192 C2 NOT_RELEASED
ASQL_F7193 ASQL_F7193 C2 NOT_RELEASED
ASQL_F7308 ASQL_F7308 C2 NOT_RELEASED
ASQL_F7321 ASQL_F7321 C2 NOT_RELEASED
ASQL_F7334 ASQL_F7334 C2 NOT_RELEASED
ASQL_F7339A ASQL_F7339A C2 NOT_RELEASED
ASQL_F7349 ASQL_F7349 C2 NOT_RELEASED
ASQL_F7482 ASQL_F7482 C2 NOT_RELEASED
ASQL_F7795 ASQL_F7795 C2 NOT_RELEASED
ASQL_F7796 ASQL_F7796 C2 NOT_RELEASED
ASQL_F7900 ASQL_F7900 C2 NOT_RELEASED
ASQL_F7959 ASQL_F7959 C2 NOT_RELEASED
ASQL_F8181 ASQL_F8181 C2 NOT_RELEASED
ASQL_F8634 ASQL_F8634 C2 NOT_RELEASED
ASQL_F8654 ASQL_F8654 C2 NOT_RELEASED
ASQL_F8685 ASQL_F8685 C2 NOT_RELEASED
ASQL_F9207 ASQL_F9207 C2 NOT_RELEASED
ASQL_F9360 ASQL_F9360 C2 NOT_RELEASED
C_SALESORDERMANAGE_SD C_SALESORDERMANAGE_SRV V4 C1 NOT_RELEASED
EHDGM_UI_SUBSTANCETECHNAME EHDGM_UI_SUBSTANCETECHNAME V2 C1 NOT_RELEASED
UI_CREDITMEMOREQUESTMANAGE UI_CREDITMEMOREQUESTMANAGE V4 C1 NOT_RELEASED
UI_CUSTOMERRETURNMANAGE UI_CUSTOMERRETURNMANAGE V4 C1 NOT_RELEASED
UI_CUSTPROJSALESORDERMANAGE UI_CUSTPROJSALESORDERMANAGE V4 C1 NOT_RELEASED
UI_DEBITMEMOREQUESTMANAGE UI_DEBITMEMOREQUESTMANAGE V4 C1 NOT_RELEASED
UI_EHS_FND_CRR_OVERVIEW UI_EHS_FND_CRR_OVERVIEW V2 C1 NOT_RELEASED
UI_INBOUNDDELIVERYMANAGE UI_INBOUNDDELIVERYMANAGE V4 C1 NOT_RELEASED
UI_PRELIMBILLINGDOCUMENT_F6990 UI_PRELIMBILLINGDOCUMENT_F6990 V4 C1 NOT_RELEASED
UI_PRODCMPLNCCONFIGNFORLABELS UI_PRODCMPLNCCONFIGNFORLBL V4 C1 NOT_RELEASED
UI_SALESCONTRACTMANAGE UI_SALESCONTRACTMANAGE V4 C1 NOT_RELEASED
UI_SALESQUOTATIONMANAGE UI_SALESQUOTATIONMANAGE V4 C1 NOT_RELEASED
UI_SLSORDERWITHOUTCHARGEMANAGE UI_SLSORDERWITHOUTCHARGEMANAGE V4 C1 NOT_RELEASED
UI_TRCMDTYCDMANAGE UI_TRCMDTYCDMANAGE V4 C1 NOT_RELEASED
UI_WORKVIEW_MANAGE UI_WORKVIEW_MANAGE_O2 V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F5261 Manage Technical Names for Substance Transactional An Application to manage Technical Names for substnaces that have to be shown in the Dangerous Goods Description of product classified as a Dangerous Good
F5798 Manage Work Views Transactional

Manage Technical Names for Substance

Business Role: Dangerous Goods Specialist - Product Compliance

Manage Work Views

Business Role: Product Stewardship Specialist - Product Compliance

With this feature, you can define and provide standard work views for all users. For easy data maintenance, you can organize different basic data and compliance assessments within a work view. These views are maintained centrally and can only be changed by privileged users.

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Language spras Off. Language
_Text _Text
LanguageISOCode laiso 2-Character SAP Language Code

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_Language.
-- 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.
-- SQL view name: ILanguage

CREATE VIEW I_Language AS
SELECT
  spras AS Language,
  laiso AS LanguageISOCode
FROM t002
LEFT OUTER JOIN I_LanguageText AS _Text ON Language = _Text.LanguageCode  -- association [0..*]
;