Activate option translate(sm30) in ZTABLE maintenance object

[Former Member]

Hi everybody,

I'm need to know, how to activate the option "translate" using the SM30 transaction, for my table maintenance object, somebody who know if: is it an attribute for the table or the maintenance object, i'm checking with another standard maintenance objects and some of tableviews have activated this option.

The first table is ZTABL1 with fields X, Y keys and another field Z(no key field).

I define a text table ZTABL2 to translate the field Z : mandt, spras, text_Z.

To make the connection between the 2 tables you must define in my text table a foreign key for field Z.

But the option GOTO-> Translate is not available.

i'm gonna be gratefully for some help.

greetings and good luck.

GLT.

Edited by: GLT on Feb 24, 2009 4:17 PM

[ThomasZloch]

Are you trying to translate ZTABL1? This cannot work, as there is no SPRAS field in the key.

Or ZTABL2?

This should be the normal scenario:

ZTAB: Key, Field 1, Field 2, etc.

ZTABT: Spras, Key, Text (where Key is defined as foreign key to ZTAB and type "Text table")

Now a maintenance dialog for ZTAB will have translation option. Compare this with your scenario.

Thomas

[Former Member]

Thanks for your help.

But in my scenario :

The field key is not a primary key of my table ZTAB and i have the maintenance dialog for ZTAB.

And the option is not available.

Can you help me ?

[ThomasZloch]

Well, it's not available in this case because it is logically not possible to translate without a SPRAS field in the primary key. I think you need a separate maintenance dialog for that check table and maintain the translations there, or maybe domain values will do, these can be translated as well.

Thomas

[Former Member]

No in the table ZTABT i have spras but :

ZTAB: Key(field not in a primary key), Field 1, Field 2, etc.

ZTABT: Spras, Key(it's in the primary key), Text (where Key is defined as foreign key to ZTAB and type "Text table").

The difference is in my scenario is in the table ZTAB the field "Key" is not in the primary key of the table ZTAB.

But in the table ZTABT i have Spras, key in the primary key.

Can i have the translation ?

[ThomasZloch]

Yes, but not for ZTAB. Create a separate maintenance dialog for the check table and translate there. You might need an additional table with just the key field though to make it work.

To make it clear, hopefully:

main table: ZTAB

check table: ZTAB1

text table for the check table: ZTAB1T

-> create a separate maintenance dialog for ZTAB1.

Thomas

[Former Member]

Hello,

it doesn't work : Can you explain the all step "create a separate maintenance dialog for ZTAB1."

Or you create a maintenance view ?

And Have you a foreign key on the field of the key ZTAB1 ?

Thanks for your help.

Géraldine