find maximum document number for each document

[Former Member]

HI All,

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

Thks

Shailesh

[Former Member]

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]

but in cluster table aggregate functions are not allowed.

Regds

Shailesh

[Former Member]

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]

ok