current vs previous year

[Former Member]

Hi Guys I am doing a report where I am displaying the sales for this year and last year Please let me know how to calculate the following to get both the data in ALV. also need to calculate the percentage of it. Please help me its urgent.

[Former Member]

Hi,

In the select query u write it as

for example.

select vbeln

from vbak

into table it_tab

where date gt date

and date le date.

and give the table to the alv .

i hope it helps u.

reward points if it helps.

[Former Member]

sure i will reward points if you can help me a coded report it will be verymuch helpful its very very urgent.

[Former Member]

Hi,

Do u want how to display in the alv or getting the sales order numbers from the table in that range.

[Former Member]

Hi,

I need to display sales quantity for the current year and last year target for current year and closing stock, and to calculate the percentage of the target current year and sales for the last year