topic Re: current vs previous year in Application Development and Automation Discussions

current vs previous year

Former Member — Mon, 17 Dec 2007 07:23:27 GMT

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.

Re: current vs previous year

Former Member — Mon, 17 Dec 2007 07:28:49 GMT

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.

Re: current vs previous year

Former Member — Mon, 17 Dec 2007 07:45:31 GMT

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

Re: current vs previous year

Former Member — Mon, 17 Dec 2007 08:02:48 GMT

Hi,

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

Re: current vs previous year

Former Member — Mon, 17 Dec 2007 08:17:23 GMT

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