topic Re: mainteinace view in Application Development and Automation Discussions

mainteinace view

Former Member — Thu, 05 Oct 2006 08:49:36 GMT

Hi,

I have 2 Z tables, one containing ids (key: id) and the second one containing the descripition in several languages for those ids (key: id, spras).

Is there an easy way to create a manteinance view for both tables at the same time or do we have to create a Z program with table control...?

Rgds,

Jose

Re: mainteinace view

Former Member — Thu, 05 Oct 2006 08:58:14 GMT

Hi Jose

- A) Create a Maintenance View for those two tables by SE11;

- B) Generate for that view the maitenance program for trx SM30

Max

Re: mainteinace view

Former Member — Thu, 05 Oct 2006 11:52:43 GMT

Hi,

I have problems with the maintenance view, it does not let me create new entries unless the id is already in the foreign key table. How can I solve this?.

Rgds,

Jose

Re: mainteinace view

former_member378318 — Thu, 05 Oct 2006 13:16:27 GMT

Your second table that holds the description is definately a text table. In this case you would only need to generate a maintenance view for the key table (Z table 1), the generated maintenance dialog would let you maintain the ID and Description from a single view.

Procedure

To use the functions offered by a text table, create Z table 2 in the ABAP Dictionary with the same key as Z table 1 and an extra field with type SPRAS. Define the text fields as non-key fields in this table. Then define a text foreign key from this text table to Z table 1.

Re: mainteinace view

Former Member — Thu, 05 Oct 2006 13:42:19 GMT

U've have defined in wrong way the foreign key:

If you have two table T1 and T1T where T1T contains the description for T1, if ID is the field key, when u insert the foreing key for field ID in T1T you have specified the foreing key is for text table.

SO the T1T table should have:

FIELD

MANDT foreign key T000-MANDT

SPRAS foreign key T005-SPRAS

ID foreign key T1-ID for TEXT TABLE

So when you define the foreign key for field ID you have to set the option <u><b>Key fields of a text table</b></u>.

Max.