topic Re: restrict duplicate entry in Application Development and Automation Discussions

restrict duplicate entry

naveenvishal — Sat, 12 Apr 2008 08:26:50 GMT

how to restrict duplicate entries to be entered in a table control...

thanx,

naveen vishal

Re: restrict duplicate entry

naveen1241 — Sat, 12 Apr 2008 09:17:37 GMT

hi..

after ur PAI table control loop, write another module.

in tht u can declare one temporary int table and copy the original int table to the temp table.

then sort this new internal table and delete adjacent duplicates comparing your key fields.

if sy-subrc = 0.

give some error msg.

else.

do nothing..

endif.

hope this helps...

regards,

naveen

Re: restrict duplicate entry

uwe_schieferstein — Sat, 12 Apr 2008 09:19:40 GMT

Hello Naveen

You have to evaluate at PAI (i.e. after having entered possible duplicated entries) whether your itab contains duplicates or not.

You see the same behaviour with maintenance views. You can always enter duplicated entries but if you push ENTER or the SAVE button the system throws an error due to the duplicated entries.

Regards

Uwe

Re: restrict duplicate entry

naveenvishal — Fri, 04 Jul 2008 07:14:07 GMT

well, the solution to it is like this:

a pointer needs to move from 1st row of table control till the current row, for each table control read.

that is, reading the rows only above it, not below ones. That will throw error at appropriate place.

Thanx for msg postings..

Naveen Vishal