topic Re: Problem: Adjust the Custom table in Application Development and Automation Discussions

Problem: Adjust the Custom table

Former Member — Mon, 23 Apr 2007 07:39:22 GMT

Hi,

I am getting one problem when i try to adjust the custom database table.

The exising table fields as follows

MANDT (Key field)

ZADVG (Key field)

STEXT (Non-Key Field).

Now i have to add one more field (MOLGA) as a key in between MANDT and ZADVG. when i do this, its not getting added and giving the message the position should not be changed...

Even i tried to adjust the table using database utility but there is no use.

How to solve this. any ideas on this will be awarded.

Thanks

Eswar

Re: Problem: Adjust the Custom table

Former Member — Mon, 23 Apr 2007 07:49:24 GMT

Hi Eswar ...

here add the field MOLGA between ZADVG and STEXT..

the table will get activated...

Regards,

Suresh........

Re: Problem: Adjust the Custom table

Former Member — Mon, 23 Apr 2007 07:51:09 GMT

Hi Suresh,

The req here is i have to add between the specified fields. I can add the field as you specified thats not a problem.

Thanks

eswar

Re: Problem: Adjust the Custom table

Former Member — Mon, 23 Apr 2007 08:00:00 GMT

Hi Eswar,

Just add the field MOLGA at the last and cut and paste it to the second position.

Insert one row between MANDT and ZADVG and paste it to that position and <b>check the Key checkbox</b>.It will work.

Thanks & Regards

Santhosh

Message was edited by:

santhosh ds

Re: Problem: Adjust the Custom table

former_member632991 — Mon, 23 Apr 2007 08:00:05 GMT

Hi,

Try using SE14.

Regards,

Sonika

Re: Problem: Adjust the Custom table

Former Member — Mon, 23 Apr 2007 08:09:50 GMT

Hi Eswar....

your table is not activated because it is acting as a check table for some other tables..

so first identify all the tables that are referring to this table with help of where-used-list.

Remove all the foreign key relations, then activate the table and then establish the foreign key relations...

Regards,

Suresh............