Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

regarding calender year/month

Former Member
0 Kudos

hi friends,

In BI data source the column calender year/month is coming i have to write the logic for payroll data in the user exit on the basis of FISCAL YEAR ,and on the basis of this BI - calender year/month i need to get fiscal year.

is there any FM to get fiscal year from caleder year/month plz help me as i already searched the forum and i did nt get any FM .

kindly send any FM or logic.

5 REPLIES 5

Former Member
0 Kudos

Hi,

Use the function module GM_GET_FISCAL_YEAR.

Pass date and fiscal year variant to the above function module.

Check the fiscal year variants in table T009.

Regards,

Kumar Bandanadham

Former Member
0 Kudos

hi,

Make use of the FM - GM_GET_FISCAL_YEAR

you need to pass the date and fiscal year variant for this FM.

It gives you the fiscal year.

Former Member
0 Kudos

Hi,

To find Fiscal year easily without using FM, you can try the below code;

IF sy-datum+4(2) LE '03'.
  p_fisyr = sy-datum+0(4) - 1.
ELSE.
  p_fisyr = sy-datum+0(4).
ENDIF.

Just substitute SY-DATUM with the date you want.

Regards

Karthik D

Former Member
0 Kudos

Hi

check T009b table, u will get periods and starting date of a period for a given fiscal year.

hope this will help u....

Former Member
0 Kudos

solved by own