Select maximum in itab

[Former Member]

How can i keep the records with latest date for every order number in an itab that looks like this.

WADAT_IST VBELN

20060519 |0000268071

20060519 |0000268071

20060524 |0000268071

20060519 |0000268071

Thanks

[Former Member]

SORT ITAB BY VBELN ASCENDING WADAT_IST DESCENDING. 
DELETE ADJACENT DUPLICATES FROM ITAB COMPARING VBELN WADAT_IST.

Hope this helps.

RK.

[Former Member]

Thanks for the help.

But i would like to have only the latest date and this method just deletes same dates and keeps the table with a few dates (different dates) for one vbeln

[Former Member]

SORT ITAB BY VBELN ASCENDING WADAT_IST DESCENDING. 
DELETE ADJACENT DUPLICATES FROM ITAB COMPARING VBELN.

Now this eliminates all the records except the one order with the latest date.

~RK

[Former Member]

Sort the itab with order and date field...

Sort itab by order date descending.

Regards,

JOy.

Edited by: Joyjit Ghosh on Jul 17, 2008 6:44 PM

[Former Member]

To keep the latest record by date try this:

Sort itab by order date descending.

Delete adjacent duplicates from itab comparing order.

Regards,

JOy.

[Former Member]

Thank you joy,

It worked fine !!!

[Former Member]

Hi,

Please refer the code below:

sort itab by WADAT_IST descending.

delete adjacent duplicates from itab comparing WADAT_IST.

Thanks,

Sriram POnna.