topic Re: Number of days in month excluding Sunday's. in Application Development and Automation Discussions

Number of days in month excluding Sunday's.

Former Member — Sun, 14 Sep 2008 07:08:43 GMT

Dear All,

I searched lot on sdn for number or Sunday's in month but i unable to find that FM.

Please tell me the FM for the same.

Actually i want to get number of working days excluding Sunday's from the month.If any holidays is coming in month that should not minus from the total days.

If in month 30 days are there and in that 4 sunday is there and 2 holidays suppose for diwali.

In this case only that 4 sunday have to remove from 30 days means working days comes to 30 - 4 = 26.(26 days).

Thanks & Regards,

Sanket.

Re: Number of days in month excluding Sunday's.

Former Member — Sun, 14 Sep 2008 07:24:26 GMT

Hi Sanket,

Try this FM:

FIMA_DAY_CONVERT_TO_WORKINGDAY

Cheers,

Heinz

Re: Number of days in month excluding Sunday's.

Former Member — Sun, 14 Sep 2008 07:30:06 GMT

which parameter i have to pass only date or more.

Re: Number of days in month excluding Sunday's.

Former Member — Sun, 14 Sep 2008 07:39:56 GMT

Re: Number of days in month excluding Sunday's.

Former Member — Sun, 14 Sep 2008 17:09:05 GMT

Hi Sanket,

In addition to my first recommendation, please try this:

DATA: it_days LIKE STANDARD TABLE OF rke_dat .
 
  SELECT SINGLE fabkl INTO calendar_code FROM t001w CLIENT          
  SPECIFIED  WHERE mandt = sy-mandt AND werks = plant.
 
  CALL FUNCTION 'RKE_SELECT_FACTDAYS_FOR_PERIOD'
    EXPORTING
      i_datab               = first_date 
      i_datbi               =  last_date
      i_factid              = calendar_code
    TABLES
      eth_dats              = it_days
    EXCEPTIONS
      date_conversion_error = 1
      OTHERS                = 2.
  IF sy-subrc  0.
    MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
            WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
  ENDIF.
 
  DESCRIBE TABLE it_days LINES working_days.

FABKL is the company's calendar-code - some holidays are company-specific.

Heinz

Re: Number of days in month excluding Sunday's.

Former Member — Mon, 15 Sep 2008 07:08:43 GMT

Hi Heinz,

thanks for your reply but it is not suitable for my requirement.

thanks,

Sanket.

Re: Number of days in month excluding Sunday's.

Former Member — Mon, 15 Sep 2008 07:09:07 GMT

closed