topic Re: Delete duplicates in Field Groups in Application Development and Automation Discussions

Delete duplicates in Field Groups

Former Member — Fri, 11 Nov 2005 14:07:03 GMT

Friends,

I have a problem in field groups where one of them contains the duplicate entries. How to catch it and delete the duplicates. Please guide me.

Thanx and regards in advance,

ram

Re: Delete duplicates in Field Groups

Former Member — Fri, 11 Nov 2005 14:36:32 GMT

Hi Ram;

The best option may be to catch it before you insert the data into the table, if you can. If you are in a select loop and doing the insert there, you can use the "SELECT DISTINCT" option to make sure you are pulling unique records back from the data base.

If that is not possible, you may need to use an internal table instead of the field group. Either way, this option will get rid of duplicate entries in either field groups or tables:

FIELD-GROUPS: header.

delete adjacent duplicates from header.

or:

DATA: int_mara TYPE STANDARD TABLE OF mara.

delete adjacent duplicates from int_mara.

Cheers,

John

Re: Delete duplicates in Field Groups

Former Member — Fri, 11 Nov 2005 14:51:36 GMT

Thanq very much John.

Ram