updating ztable from the table maintenance

[Former Member]

hi,

I want to knw how and where to check , whether the records which user has entered in the table control of new entries screen exists in the ztable table or not . if the same record exists then that record should not go for saving it shd be deleted when it is detected that it exists in the ztable . can any one tell me how . where and what code to be written . so that the duplicate entries are deleted and others entries get appended in the database.

thank you.

[Former Member]

Ratna,

By default system doesnt accept to insert duplicate records in database.

regards,

shaik

[Former Member]

Hi

if you have declared some Primary key fields then by default when you enter the records in the Table maintenance using SM30 it will not allow duplicate records with the same key fields

You can check the Table entries in SE16 Tcode

go to Se16 enter table name execute and see the table records

Reward points for useful Answers

Regards

Anji

[Former Member]

hi,

i have one primary key . system does checks for that . but for other 5 fields and have created index (unique combination should exists) . so for that fields it gives dump when i try u insert same duplicate records