Custom table update problem

[Former Member]

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

[Former Member]

new

[vinod_vemuru2]

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.

[Former Member]

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.

[Former Member]

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