topic Re: code to display error msg if duplicate entry in Application Development and Automation Discussions

code to display error msg if duplicate entry

Former Member — Sat, 26 Jul 2008 13:48:30 GMT

I have an upload program to upload csv file to itab, and i need a sample code for the employee id to give me an error message if a duplicate employee id is found during execution.

Re: code to display error msg if duplicate entry

Former Member — Sat, 26 Jul 2008 13:52:52 GMT

rather than this it is better to delete the duplicate entries after data coming to the internal table .......

Re: code to display error msg if duplicate entry

Former Member — Sat, 26 Jul 2008 13:53:03 GMT

DELETE ADJACENT DUPLICATES FROM itab COMPARING <yourempid>.

if sy-subrc = 0.

message.

endif.

Re: code to display error msg if duplicate entry

Former Member — Sat, 26 Jul 2008 13:53:43 GMT

After Upload you can delete the Duplicates comparing the employee Id.

It Will be Possible only when you use OLE and read the file records line by Line. I am not sure of the error Handling with OLE control. It may lead to some performance issues..