Skip to Content
Former Member
Dec 01, 2008 at 08:31 AM

multiple entries with key fields same in a ZTABLE



I do have a ZTABLE, with 3 key fields defined earlier. It consists of around 1 lakh records. Later onwards, two of the non keyfields have been made to key fields.

This table is being populated with records at the time of saving a ztransaction.

But some times, the system is updating the same records, some times twice, sometimes thrice, etc. I got to know that all fields (both key fields and non-key fields) of the record are same. That is, records are being updated in to the database table n number of times may be depending of some false logic in the program.

If I tried to enter the same using SM30, it is showing me an error message stating that the record is already existing.

What can be the reson?