topic Re: Function Modules for Date in Application Development and Automation Discussions

Function Modules for Date

Former Member — Wed, 06 Dec 2006 06:33:42 GMT

Hi ALL,

I would like to know the various function modules that can be used for calculating dates.Like first day of month,last day.....etc etc.

Please give me a list of the FM's and not the F4 help option info.

Cheers

Re: Function Modules for Date

jayanthi_jayaraman — Wed, 06 Dec 2006 06:36:00 GMT

Hi,

CONCATENATE sy-datum+0(4) '0101' INTO p_begda.

l_month = sy-datum+4(2) - 1.

UNPACK l_month TO l_month.

CONCATENATE sy-datum0(4) l_month sy-datum6(2) INTO l_date.

Getting last day of previous month

CALL FUNCTION 'BKK_GET_MONTH_LASTDAY'

EXPORTING

i_date = l_date

IMPORTING

e_date = p_endda.

Re: Function Modules for Date

former_member69765 — Wed, 06 Dec 2006 06:45:33 GMT

1st day of any month is always 01

for last day of month use - RP_LAST_DAY_OF_MONTHS Pass any date of that month to that FM it will return u the last date.

Re: Function Modules for Date

Former Member — Wed, 06 Dec 2006 06:48:02 GMT

Check these,they may help u

FIMA_DAYS_AND_MONTHS_AND_YEARS:Difference in dates

CONVERSION_EXIT_IDATE_OUTPUT:Date formatting

HR_IN_GET_DATE_COMPONENTS

DATE_CONVERT_TO_WORKINGDAY

DAYS_BETWEEN_TWO_DATES

LAST_DAY_OF_MONTHS

RP_CALC_DATE_IN_INTERVAL :Calculate the previous date

Regards

Re: Function Modules for Date

anversha_s — Wed, 06 Dec 2006 06:58:51 GMT

hi,

some more...

SG_PS_GET_LAST_DAY_OF_MONTH

RE_LAST_DAY_OF_MONTH

HR_HCP_GET_LAST_DAY_OF_MONTH

HRVE_LAST_DAY_OF_MONTH

RP_LAST_DAY_OF_MONTHS

SLS_MISC_GET_LAST_DAY_OF_MONTH

LAST_DAY_OF_MONTHS

WSAF_GET_LAST_DAY_OF_MONTH

use this FM - > 

***********

CALL FUNCTION 'LAST_DAY_OF_MONTHS'
EXPORTING
DAY_IN = sy-datum
IMPORTING
LAST_DAY_OF_MONTH = v_lastdate. <--Gives you the last day of a Month


data:f_date type sy-datum,
l_date type sydatum.


CALL FUNCTION 'HR_JP_MONTH_BEGIN_END_DATE'
EXPORTING
iv_date = sy-datum
IMPORTING
EV_MONTH_BEGIN_DATE = f_date  
EV_MONTH_END_DATE = l_date.

rgds

Anver

Re: Function Modules for Date

Former Member — Wed, 06 Dec 2006 07:03:38 GMT

chk this link for some of those

http://www.geocities.com/victorav15/sapr3/abapfun.html#date

Re: Function Modules for Date

Former Member — Wed, 06 Dec 2006 08:27:23 GMT

Hi ,

Here are a few FM used for date manipulation

DATE_IN_FUTURE Add / Substract days from a given date

HR_SGPBS_ADD_TIME_TO_DATE Find the next date based on input date , addition / sub and month , year ,date

CONVERT_DATE_TO_EXTERNAL Convert date to External format

SG_PS_ADD_MONTH_TO_DATE Find the next date based on input date , addition / sub and month , year ,date

DATE_COMPUTE_DATE For a input date gives the day of the week

DATE_GET_WEEKFor an input date ,gives the week as output

WEEK_GET_FIRST_DAY Input year and week output is the first day of the week

WEEKDAY_GET Gives the day range , Monday , Tuesday ,…..

RP_CALC_DATE_IN_INTERVAL Calculate Future Date

CALCULATE_DATE Calculate Future Date

FIMA_DAYS_AND_MONTHS_AND_YEARS Difference between two dates

CONVERSION_EXIT_PDATE_INPUT It checks if the date is in future , if yes an error is displayed

Reagrds

Arun