topic Re: Avoiding duplicate entry in an internal table in Application Development and Automation Discussions

Avoiding duplicate entry in an internal table

Former Member — Thu, 14 Aug 2008 09:35:29 GMT

Hi friends,

I want to avoid duplicate validation for a particula key in an internal table .I am updating the table in PAI module . I am using a method to update the table so when it is getting updated I cannot valiadte the data , after updating only I have to validate if there is any duplicate entry or not , iF duplicate then I have to show an errror msg . when I am using the method check_changed_data from cl_gui_alv_grid , Is there any chance to validate the date and them change into internal table ?

Thanks in advance .

Re: Avoiding duplicate entry in an internal table

Subhankar — Thu, 14 Aug 2008 09:44:43 GMT

Hi...

1 . Sort the internal table with the field for which U want to catch the duplicate entry..

2. Use AT NEW statement. With in the AT NEW statement use your normal functionality.

3. After ENDAT means duplicate entry appear ... U can track it as a ERROR record.

Re: Avoiding duplicate entry in an internal table

Former Member — Thu, 14 Aug 2008 09:46:00 GMT

Hi..

use the code of method in a sub-routine or put it in FM

it will be easier way out..

regards

vivek

Re: Avoiding duplicate entry in an internal table

Former Member — Thu, 14 Aug 2008 09:48:33 GMT

Hi..

First sort ur internal table.

Then put loop on this..

use on change of....statment..

sort itab.

loop at itab.

on change of itab-kunnr.

....

endon.

endloop.

Rgds,

Re: Avoiding duplicate entry in an internal table

Former Member — Mon, 18 Aug 2008 07:33:54 GMT

thanks