Skip to Content
0
Former Member
Nov 24, 2012 at 10:50 AM

How to compare dates and accordingly store orders' values in separate columns of ALV report ?

36 Views

Hi experts,

I have to generate an ALV report in which I have an internal table with data of dispatch orders with their delivery dates. Now in the ALV output I have to segregate these order values according to their delivery dates in 4 different columns according to below conditions.

A) 1st column has current month's and all previous months' orders' value (i.e.. all orders value upto November 2012)

B) 2nd column has only next month's orders' value (i.e. December 2012)

C) 3rd column has next to next month's orders' value (i.e. January 2013)

D) 4th column has next to next to next month's orders' value and all orders' value after that month (i.e. February 2013 orders and all orders beyond )

I have tried alot but havent found an exact solution for this.

So please help me if anyone knows how to achieve this logic...

Thanks,

Vishal