topic Table contents - different languages in Application Development and Automation Discussions

Table contents - different languages

Former Member — Fri, 22 Jun 2007 12:46:06 GMT

Hello all,

I have a custom table with two columns. Code and Description. I have two entries in it right now like -

Code Description

1000 Product

2000 Material

If a user logs in other language say German, I want to see German descriptions. Where and how we can maitain the German descriptions to achieve this? Any ideas...

Re: Table contents - different languages

Former Member — Fri, 22 Jun 2007 12:52:55 GMT

Goto User Settings as : Systems -> User Profile -> Own Data -> Defaults (Tab)

Change the Logon Language there...

Re: Table contents - different languages

Former Member — Fri, 22 Jun 2007 12:55:55 GMT

How and where we maitain the German descriptions?

Re: Table contents - different languages

Former Member — Fri, 22 Jun 2007 12:57:40 GMT

First you should have a language field also in your table. You need to enter the values in german language against the entries along with your english values. Depending on the user logon screen,the entries will be displayed in transaction.

hope this helps

Krishna

Re: Table contents - different languages

former_member219399 — Fri, 22 Jun 2007 13:00:40 GMT

Hi,

the table shd contain one more field SPRAS language key. it shd be part of primary key.

During creation of table entries you have to enter the values in various languages.

Based on lagon language you can retrieve the corresponding code.

with regards,

Vamsi

Re: Table contents - different languages

Former Member — Fri, 22 Jun 2007 13:04:55 GMT

In order to achieve that functionality you need to change a little the structure of your table and include a new field (SPRAS - language key) and afterwards you will have to maintain the descriptions in all the languages that you need. The table will look something like this:

The key of the table will be the code and the language.

Code Language Description

1000 EN Description in english

1000 DE Description in german

2000 EN Description in english

Also, search the forums about information regarding 'text table' , or go to tranzaction SE11 , choose a standard table (for example MARA - material master), and afterwards, use the GoTo -> Text table and you will find an example.

Regards,

Alex