topic Re: Abap General in Application Development and Automation Discussions

Abap General

Former Member — Fri, 10 Aug 2007 09:58:07 GMT

Hi all,

Please help me to find function module.

I want last date of previous month.when i write today date as input.

Thanking you in advance.

Re: Abap General

Former Member — Fri, 10 Aug 2007 10:00:00 GMT

OIL_LAST_DAY_OF_PREVIOUS_MONTH

Regards

Peram

Re: Abap General

Former Member — Fri, 10 Aug 2007 10:01:49 GMT

Hi,

You can use FM RP_LAST_DAY_OF_MONTHS.

DATA: WA_DATE LIKE SY-DATUM,

WA_LDATE LIKE SY-DATUM.

WA_DATE = SY-DATUM - 30.

CALL FUNCTION 'RP_LAST_DAY_OF_MONTHS'

EXPORTING

DAY_IN = WA_DATE

IMPORTING

LAST_DAY_OF_MONTH = WA_LDATE

EXCEPTIONS

DAY_IN_NO_DATE = 1

OTHERS = 2.

WRITE: / WA_LDATE.

OR

data: last_month_last_day type sy-datum.

last_month_last_day = sy-datum.

last_month_last_day+6(2) = '01'.

last_month_last_day = last_month_last_day - 1.

write:/ last_month_last_day.

Yes, it works, all the time. Even in January.

reward if it helps..

Regards,

Omkar.

Re: Abap General

Former Member — Fri, 10 Aug 2007 10:04:06 GMT

You can get the previous month by using FM CCM_GO_BACK_MONTHS

and its last day by using FM SG_PS_GET_LAST_DAY_OF_MONTH, BKK_GET_MONTH_LASTDAY.

Regards,

Pavan

Re: Abap General

Former Member — Fri, 10 Aug 2007 10:04:55 GMT

u can make the code work like this.

data: date like sy-datum,

date1 like sy-datum.

date = sy-datum.

CALL FUNCTION 'RP_LAST_DAY_OF_MONTHS'

EXPORTING

day_in = date

IMPORTING

LAST_DAY_OF_MONTH = date1

EXCEPTIONS

DAY_IN_NO_DATE = 1

OTHERS = 2

add 1 to date1.

write:/ 'next month start date:', date1.

*to fetch the march month last date.

date1+4(2) = 03.

CALL FUNCTION 'RP_LAST_DAY_OF_MONTHS'

EXPORTING

day_in = date1

IMPORTING

LAST_DAY_OF_MONTH = date1

EXCEPTIONS

DAY_IN_NO_DATE = 1

OTHERS = 2

write:/ 'last date of march:', date1.

Regards,

Pavan