topic Re: Custom table update problem in Application Development and Automation Discussions

Custom table update problem

Former Member — Mon, 31 May 2010 12:39:26 GMT

Hello,

I created a table maintenance view for a custom table. In test an QA systems it is possible to change or add records without problem. But in the prod. system a certain field, which has RE_BELNR as data element, can not be updated. I can delete the relevant record but when I try to create a new one including this field I receive a dump stating that there are duplicate entries. And when I omit this field, record can be created. Later I try to change the record; it is possible to enter and save but when I re-run SM31 the field is again empty hence not updated at all. This field is not primary key but there is a sec. index including this field. Where should I check? Can the sec. index block data entry?

Thx in advance,

Ali

Edited by: Ali Abbasgil on May 31, 2010 4:58 PM

Re: Custom table update problem

Former Member — Mon, 31 May 2010 14:58:36 GMT

new

Re: Custom table update problem

vinod_vemuru2 — Mon, 31 May 2010 15:13:08 GMT

Hi,

Secondary INDEX wont block any thing. But when ever the table is updated, all the index fields information is updated to seperate tables. There might be some issue with your secondary INDEX. Ask your BASIS team to regenerate the secondary INDEX and see.

Regards,

Vinod.

Re: Custom table update problem

Former Member — Mon, 31 May 2010 15:17:33 GMT

Hi Ali,

You can also try re-generating the table maintenance dialog. Sometimes problems with the TMD also leads to problems while maintaining data in a table.

Re: Custom table update problem

Former Member — Mon, 07 Jun 2010 11:27:06 GMT

A secondary index was defined as unique and that was blocking insert or change. I changed the index and the problem was solved.