internal table fetch distinct records.

[Former Member]

i have internal table xtab_lst.

where i have list of records like below.

seqno,compcode, Gsber, ...............

1, 200, 011A

2, 200, 011A

3, 200, 011A

4, 200, 011A

5, 200, 011A

6, 200, 011A

7, 200, 011A

1, 200, 130B

2, 200, 130B

3 200 130B

4 200 130B

5 200 130B

6 200 130B

7 200 130B

From the above list i want to fetch only single

gsber records from group existing. ie) i have two gsber record groups now.

one is 011A and other 130B.

Out of these i want to take only two gsber(011a,130b)in seperate Internal table.

How to do this.(ie.dont want duplication of gsber records)

Ambichan.

[Former Member]

Hello Ambichan,

You have got the best answer to your question. In my opinion, the answer deserves a 10-pointer. If you have any further query on this please do post that. Otherwise, please mark the question as answered and close the thread.

Regards,

Anand Mandalika.

P.S. I do not mean to offend you.

[Former Member]

ytab_lst[] = xtab_lst[].
sort ytab_lst by compcode, gsber.
delete adjacent duplicates from ytab_lst comparing compcode gsber.

Regards,

Subramanian V.