topic Re: table maintainance in Application Development and Automation Discussions

table maintainance

Former Member — Fri, 06 Apr 2007 13:22:20 GMT

hello everyone,

i created on table XXX with 5 fileds...and also created view maintainance in SM30 but again I need to add one more field to that table 6th field..I added it..and it is there in table.....but if i wanted to enter values in that field in sm30 the filed is not displaying in entering the values....it allows me to enter only 5 fields and 6th one is missing and when i enter 5 fields and click enter it is there in output......

what to do...

Re: table maintainance

pavel_parshenkov2 — Fri, 06 Apr 2007 13:26:28 GMT

hi, regenirate table maintance again.

you should do it every time if change structure of table.

Re: table maintainance

Former Member — Fri, 06 Apr 2007 13:29:47 GMT

how can i regenerate the structure

Re: table maintainance

ferry_lianto — Fri, 06 Apr 2007 13:30:35 GMT

Hi Madhu,

Please regenerate the table maintenance generator (delete the old one and create new one) using SE11.

Also please adjust the table/structure using SE14 (Database utility).

Regards,

Ferry Lianto

Re: table maintainance

pavel_parshenkov2 — Fri, 06 Apr 2007 13:32:33 GMT

se11 , your table

Utilites->Table Maintaince Generator -> Change-> Select All Options -> Save

Re: table maintainance

Former Member — Fri, 06 Apr 2007 13:58:15 GMT

HELLO thanks for ur answers....but i have one more question.........im created

5 fields.....

matnr matnr this is key field

zmatnr matnr this is key field

quantity kwmeng

zpromo zpromo

zinter zinter

zbom zbom

but i want to enter more entries.....with matnr one and zmatnr........it is allowing me only one time with the same material in matnr.....what to do...