Delete duplicates in Field Groups

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Thanq very much John.

Ram