Skip to Content
0
Former Member
Sep 10, 2009 at 03:36 PM

Internal table issue.

11 Views

Hi Experts,

i have an internal table eg t_final.

with fields

State

plant

qty

Now i sorted the table as -


>>>

sort t_final1 by  state ASCENDING
                           plant DESCENDING .

Now data in t_final is as follows---

state   plant    qty
20       1015    10  
20       1015     8
20       1001     5
25       1555    100  
25       1555    100
25       1550     88
23       1441     86

i need the 1st record every state and plant which should look as follows.

state   plant    qty
20       1015    10  
25       1555    100  
23       1441     86

above should be the data in the t_final.

How can i do this, please help.

Thanks and Regards,

Akash Rana