topic looking for FM in Application Development and Automation Discussions

looking for FM

Former Member — Tue, 09 May 2006 18:41:06 GMT

i need a FM that i give the number of month 01,02....

and i get the date start and end date

Re: looking for FM

RichHeilman — Tue, 09 May 2006 18:46:18 GMT

You can do something like this, but you can't just use the month, you must know the year as well. Here you can see that we take the parameter date, and force that date to the 1st day of that month/year, then use this date to find the end of the month.




report zrich_0001 .


parameters: p_datum type sy-datum.

data: begin_date type sy-datum,
      end_date type sy-datum.

begin_date = p_datum.
begin_date+6(2) = '01' .

call function 'LAST_DAY_OF_MONTHS'
     exporting
          day_in            = begin_date
     importing
          last_day_of_month = end_date.


write:/ begin_date, end_date.

Regards,

Rich Heilman

Re: looking for FM

Former Member — Tue, 09 May 2006 18:48:31 GMT

hi,

Check this out

use FM

'LAST_DAY_OF_MONTHS'

Regards,

Santosh

Re: looking for FM

former_member181966 — Tue, 09 May 2006 18:49:40 GMT

FM "HR_JP_MONTH_BEGIN_END_DATE" ( get begin date and end date of a month)

call function 'HR_JP_MONTH_BEGIN_END_DATE'

exporting

iv_date = ld_new_date

importing

ev_month_begin_date = s_begda-low

ev_month_end_date = s_begda-high.

Hope this’ll give you idea!!

P.S award the points.!!! !!!

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"

Re: looking for FM

nablan_umar — Tue, 09 May 2006 18:53:17 GMT

Hi Liat,

Date field in SAP is stored with YYYYMMDD(8 characters field). So to find the month, look at position 5th and 6th of the field.

Month = GV_DATE+4(2).

To get the first date of the month, set position 7th and 8th as '01'.

GV_DATE+6(2) = '01'.

FirstDate = GV_DATE.

To get the last date of the month, add 31 days to the first date of the month, then set position 7th and 8th as '01', lastly deduct the date by 1.

NextMonth = FirstDate + 31.

NextMonth+6(2) = '01'.

LastDate = NextMonth - 1.

Re: looking for FM

former_member181966 — Tue, 09 May 2006 19:46:53 GMT

Please award points !!!

Thanks