Multiple entries in a Z table with same key fields

[Former Member]

Hi

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?

[Former Member]

Hi

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?

[former_member404244]

Hi,

It seems there is some kind of data inconsistency..try to get all the records and then delete the duplicate entries through program....Now once u r done , from now onwards there won't be any duplicate entiers.,also before updating table use filters to avoid the duplication..

Regards,

Nagaraj