topic Re: tables in Application Development and Automation Discussions

tables

Former Member — Wed, 25 Jul 2007 10:26:26 GMT

Dear All,

I created one table with field matnr,maktx,valid_from,valid_to,with other 5 firlds.In this first i created table with matnr as the key field and also created table maintenance generator.In SM 30 it is showing that matnr is grayed out.

After that i change the table and make VALID_FROM, VALID_TO also key firlds.So toatally now matnr,valid_from,valid_to are the key fields in the table.Then i deleted the existence table maintenance genrator with delete button provided ther and again i created table maintenance generator but in the two cases i maintained same function group.Now in sm 30 totally 3 fields should shaded out but it is showing only for matnr and also order of the fieldsa are similar to the old one.

So what can i do to get the same order as present in se11 in SM30.Is it compulsory to give new function group every time we change order of the table.

Re: tables

varma_narayana — Wed, 25 Jul 2007 10:34:27 GMT

There is no need to give a new Function group Every time.

In Table Maintenance Generator you can use the CHANGE option instead of DELETING.

there You can selection the Objects that you want to regenerate.

This should solve the problem.

But in your case since you have deleted the Existing maintenace screens you may have to create again.

Check out these points

1. Have u activated your table after making changes to the key fields?

2. After generating the Table maintenace are you getting the message "Request completed without errors" . Only then it will be successful.

<b>Reward if helpful.</b>

Re: tables

Former Member — Wed, 25 Jul 2007 10:38:29 GMT

Dear Shoban,

I think I know what is the problem... You did everything right, but there is a SAP problem when you delete the existence table maintenance and create again.

Try this....after deleting the existing table maintenance, exit until SE11 first screen...go in again, and than create the the new table maintenance.

The problem is that after you delete...the function group associated is not refreshed...

Try this out.

Regards,

Marcelo Moreira

Re: tables

Former Member — Wed, 25 Jul 2007 10:40:02 GMT

It's not compulsory to give different Function Group...

Don't why u facing this prob..

I did the same thing.. but this problem didn't occur...

make sure that u have deleted earlier table maintenance properly..

All three fields will be grayed.. If u have created table maintenance properly.

Regards

Prax

Re: tables

Former Member — Wed, 25 Jul 2007 10:44:17 GMT

goto SE14 give u'r table name and press 'activate and adjustdatabase'.

don't forget to reward.

Sameer