I_Language

DDL: I_LANGUAGE SQL: ILanguage Type: view BASIC

Language

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 14 OData services (C_SALESORDERMANAGE_SD, EHDGM_UI_SUBSTANCETECHNAME, UI_CREDITMEMOREQUESTMANAGE, ...). It is used in 4 Fiori applications: Manage Technical Names for Substance, My Learning (S/4HANA), Manage Work Views, ....

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 (14)

ServiceBindingVersionContractRelease
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_EHS_FND_CRR_OVERVIEW UI_EHS_FND_CRR_OVERVIEW V2 C1 NOT_RELEASED
UI_HCMMYLEARNING UI_HCMMYLEARNING V2 C1 NOT_RELEASED
UI_HCMSEARCHCOURSES UI_HCMSEARCHCOURSES V2 C1 NOT_RELEASED
UI_INBOUNDDELIVERYMANAGE UI_INBOUNDDELIVERYMANAGE V4 C1 NOT_RELEASED
UI_PPS_PURCHASE_ORDER UI_PPS_PURCHASE_ORDER_V2 V2 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_TRCMDTYCDMANAGE UI_TRCMDTYCDMANAGE V4 C1 NOT_RELEASED
UI_WORKVIEW_MANAGE UI_WORKVIEW_MANAGE_O2 V2 C1 NOT_RELEASED

Fiori Apps (4)

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
F5692 My Learning (S/4HANA) Analytical Fiori app that allows Employee to search access bookings, prebookings, favourites, history and qualifications
F5798 Manage Work Views Transactional
F6195 Search Courses (S/4HANA) Analytical Fiori app that allows Employee to search for trainings, favorite them and see trending courses

Manage Technical Names for Substance

Business Role: Dangerous Goods Specialist - Product Compliance

My Learning (S/4HANA)

Business Role: Employee - HR Info

With the My Learning app, you as an employee can participate in courses that are suitable for you. The app allows you individual, personalized access to your company’s course offering, including classroom trainings, virtual classroom trainings, web-based trainings, online tests and curricula. It offers an overview of current, upcoming and completed learning units. The profile matchup feature provides additional help by comparing the qualifications profile with position requirements.

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.

Search Courses (S/4HANA)

Business Role: Employee - HR Info

With the Search Courses app, you can browse the catalog for suitable courses, learn about course contents, select required courses, book and participate in them. If required, you can rebook or cancel bookings. The app allows you access to your company’s course offerings in the course catalog.

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Language spras
_Text _Text
LanguageISOCode laiso
@AbapCatalog.sqlViewName: 'ILanguage'
@EndUserText.label: 'Language'
@Analytics : {dataCategory: #DIMENSION, dataExtraction.enabled : true}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC 
@ObjectModel.representativeKey: 'Language'
@Search.searchable: true

define view I_Language as select from t002
 association [0..*] to I_LanguageText as _Text 
 on $projection.Language = _Text.LanguageCode
{
 @ObjectModel.text.association: '_Text'
 key spras as Language,
 _Text,
 
 @Search.defaultSearchElement: true
 laiso as LanguageISOCode
 
}