topic Re: Any Function Module to find Difference between two Monyr's in Application Development and Automation Discussions

Any Function Module to find Difference between two Monyr's

Former Member — Sun, 23 Mar 2008 04:32:33 GMT

Hello friends,

Is there any Function Module to find the difference between

two Monyr Variables

For.Eg Difference

between 01.2008 & 11.2007 = 2.

Re: Any Function Module to find Difference between two Monyr's

Former Member — Sun, 23 Mar 2008 04:39:57 GMT

Check out this related thread ... hope it helps ..

Re: Any Function Module to find Difference between two Monyr's

vinod_vemuru2 — Sun, 23 Mar 2008 06:30:07 GMT

Hi Hari,

I am not sure of any FM available for this requirement. But u can write a simple code and use FM HR_99S_INTERVAL_BETWEEN_DATES for getting difference in months. Check below logic

DATA: p1(7) TYPE c VALUE '01.2008',

p2(7) TYPE c VALUE '11.2007',

w_date1 TYPE d,

w_date2 TYPE d,

w_result TYPE i.

CONCATENATE:p13(4) p10(2) '01' INTO w_date1,

p23(4) p20(2) '01' INTO w_date2.

CALL FUNCTION 'HR_99S_INTERVAL_BETWEEN_DATES'

EXPORTING

BEGDA = w_date2

endda = w_date1

TAB_MODE = ' '

IMPORTING

DAYS =
C_WEEKS =

C_MONTHS = w_result

C_YEARS =
WEEKS =
MONTHS =
YEARS =
D_MONTHS =
MONTH_TAB =

WRITE w_result.

Now u will get difference in months in the importing parameter c_months/d_months.

Thanks,

Vinod.

Re: Any Function Module to find Difference between two Monyr's

Former Member — Sun, 23 Mar 2008 07:08:05 GMT

Hi,

Without the day we cant calculate the difference. So make the day as 01 in both the inputs and use the function module as RTP_US_API_DATES_TO_AGE. Hope your expected output will be produced.

Reward points if useful.

Regards,

Sankar.

Re: Any Function Module to find Difference between two Monyr's

Former Member — Sun, 23 Mar 2008 08:30:02 GMT

The below Function Modules are helpfull

CMO_DATETIME_DIFFERENCE Calculates difference between two dates/timestamps.

CMO_TIME_DIFF_GET Calculate the time difference in seconds

HR_HK_DIFF_BT_2_DATES HR-HK: Calculate the days, months and years between 2 dates.

HR99L00_GET_RETRO_MONTH_DIFF Get retroactive result differences by month

HR_PDC_CALCULATE_TIME_DIFF

SCSM_TIME_DIFF_GET