topic Re: Select maximum in itab in Application Development and Automation Discussions

Select maximum in itab

Former Member — Thu, 17 Jul 2008 16:38:12 GMT

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

20060524 |0000268071

20060519 |0000268071

Thanks

Re: Select maximum in itab

Former Member — Thu, 17 Jul 2008 16:40:21 GMT



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

Hope this helps.

RK.

Re: Select maximum in itab

Former Member — Thu, 17 Jul 2008 16:42:21 GMT

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

Re: Select maximum in itab

Former Member — Thu, 17 Jul 2008 16:47:34 GMT

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

Re: Select maximum in itab

Former Member — Thu, 17 Jul 2008 16:53:06 GMT

Hi,

Please refer the code below:


sort itab by WADAT_IST descending.

delete adjacent duplicates from itab comparing WADAT_IST.

Thanks,

Sriram POnna.

Re: Select maximum in itab

Former Member — Thu, 17 Jul 2008 16:56:04 GMT

To keep the latest record by date try this:

Sort itab by order date descending.

Delete adjacent duplicates from itab comparing order.

Regards,

JOy.

Re: Select maximum in itab

Former Member — Thu, 17 Jul 2008 16:59:09 GMT

Thank you joy,

It worked fine !!!

Re: Select maximum in itab

Former Member — Thu, 17 Jul 2008 17:01:12 GMT


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