Table contents - different languages

[Former Member]

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...

[Former Member]

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

[Former Member]

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

Change the Logon Language there...

[Former Member]

How and where we maitain the German descriptions?

[Former Member]

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

[former_member219399]

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

[Former Member]

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