on 12-11-2006 9:49 AM
based on the current date i want to display present fiscal year
for eg.
now current date is 11.12.2006 then i want to get the data from april 2006 to march 2007
Hi Anitha,
There is a FM "GM_GET_FISCAL_YEAR"
Enter the date and the PERIV field. This field might depend on based on ur system.
I put T3 in PERIV. -This is maintained in table T009.
It gives the year 2006 for today's date and for 11.03.2006 it gives 2005
Regards,
Vivek.
Reward points if this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks for all
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
First use FM GM_GET_FISCAL_YEAR to get the fiscal year...So when u pass the date it will return the fiscal year.
Take a variable V1 & calculate as V1 = fiscal year / 4.
Now go to FM GM_GET_FISCAL_YEAR_START and pass the fiscal year thru which u will get the start date of the fiscal year into date1.
Now, check whether V1 = 0. if so, date2 = date1 + 366.
if V1 <> 0, then date2 = date1 + 365.
So, u have values in date1 & date2 thru which u can get the appropriate data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.