topic Re: Table maintenance with language key in Application Development and Automation Discussions

Table maintenance with language key

Former Member — Mon, 20 Nov 2006 12:59:06 GMT

Hello All...

I have to create a table for master data with language key...

The table should be delivery class type W - (System table, contents transportable via separate TR objects)

and with Display (maintenance allowed)

I have create the following:

Table 1 - (master data)

MANDT - type mandt

ZCODE -(20) type c

ZOTHERFIELD (40) typec

Table 2 (language keys)

MANDT - type MANDT

ZCODE - (20) type c.

SPRAS - type SPRAS

ZDESCRIP -(60) type c

For maintenance I have created a VIEW joining two tables, but maintenance not allowed for the view.

I have tried removing MANDT from tables for make them mandant- independet, but DIALOG for maintenance for both at the same time using views doesnt work...

QUESTION: How to create one standard maintenance dialog using master data and its language texts, using sy-langu as default ?

thanks in advance,

Ibrahim Andres.

Re: Table maintenance with language key

Former Member — Mon, 20 Nov 2006 13:03:20 GMT

it is better to create this way...Create first table & then from SE11 goto TEXT table from menu & create it where u can include SPRAS as additional field...Now do a table maintenance for the first table and from SM30 u can view this table which will also show language key as the field.

Re: Table maintenance with language key

michael-john_turner — Mon, 20 Nov 2006 13:06:45 GMT

Hi,

If you create the view as a maintenance view and then create a viewcluster for the maintenance view (SE54), you should be able to do what you want.

For a good example of creating a viewcluster, take a look at APPL_LOG in SE54 - it's maintained using transaction SLG0.

Re: Table maintenance with language key

Former Member — Mon, 20 Nov 2006 14:34:02 GMT

Thank yoy very much, Now it works !