topic Re: sy-datum problem in Application Development and Automation Discussions

sy-datum problem

Former Member — Mon, 04 Jun 2007 18:52:44 GMT

hello friends,

i have a scenario, where , when the entered period as parameter is

YYYYMM the last date for that particular month MM

should be calculated ( i dont know how), and should be attached to this period

YYYYMMDD

how do i calculate this DD (ie. last day of the moth) for the

given month and year.

like yyyymm is 200404 then i should output 20040431

if 200510 then output sould be 20051031

if 200302 then output should be 20030228.

can some one help.

thank you.

Re: sy-datum problem

learnsap — Mon, 04 Jun 2007 19:05:30 GMT

Hi Saritha,

Check this function module "BKK_GET_MONTH_LASTDAY" or "FKK_LAST_DAY_OF_MONTH"

Pass the date to the function module and it will give the last day of the month.

Search in SE37 with lastday* and you will get lots of function modules for your requirement.

Regards,

Ramesh Babu

*Award points if reply found useful

Re: sy-datum problem

RichHeilman — Mon, 04 Jun 2007 19:10:30 GMT

Try this.



report zrich_0001.


data: yyyymm(6) type c value '200704'.
data: datum type sy-datum.
data: last_datum type sy-datum.

datum = yyyymm.
datum+6(2) = '01'.

call function 'LAST_DAY_OF_MONTHS'
     exporting
          day_in            = datum
     importing
          last_day_of_month = last_datum.


write:/ last_datum.

Regards,

RIch Heilman

Re: sy-datum problem

Former Member — Mon, 04 Jun 2007 19:31:49 GMT

thanks friends.

i tried rich's code its working , thanks.