topic Re: find maximum document number for each document in Application Development and Automation Discussions

find maximum document number for each document

Former Member — Tue, 24 Feb 2009 10:37:25 GMT

HI All,

How to find date wise maximum document number for each document (purchase,sales,Finance) .

Thks

Shailesh

Former Member — Tue, 24 Feb 2009 11:30:08 GMT

Hi Shailesh,

you may try using "max" and "group by" in your select.

i.e you'd be selecting the max(<field name for document no.>) from ... group by <date field>.

regards

Former Member — Tue, 24 Feb 2009 11:48:37 GMT

Hi Shailesh,

I am assuming you have data already selected.

Once you select the data, sort internal table as follows.

sort itab by doc_type descending date.

delete adjacent duplicates from itab comapring doc_type.

This will give each latest document no.

Hope ti will help you.

Regards,

Anil

Former Member — Tue, 24 Feb 2009 13:17:45 GMT

but in cluster table aggregate functions are not allowed.

Regds

Shailesh

Former Member — Wed, 25 Mar 2009 11:49:19 GMT