topic What's function to know working data in specified date range? in Application Development and Automation Discussions

What's function to know working data in specified date range?

Former Member — Mon, 16 Feb 2009 08:30:01 GMT

Dear all:

If i want to input data range and get which day is working day, What's function can do it?

Thanks a lot!!

Re: What's function to know working data in specified date range?

Former Member — Mon, 16 Feb 2009 08:31:20 GMT

Hi Nic,

Please Find the Code Below

PARAMETER :

fdate LIKE kona-datab,

ldate LIKE kona-datab.

DATA: w_days LIKE STANDARD TABLE OF rke_dat .

DATA : cal LIKE t001w-fabkl,

workday TYPE i.

SELECT SINGLE fabkl INTO cal FROM t001w CLIENT

SPECIFIED WHERE mandt = sy-mandt.

CALL FUNCTION 'RKE_SELECT_FACTDAYS_FOR_PERIOD'

EXPORTING

i_datab = fdate

i_datbi = ldate

i_factid = cal

TABLES

eth_dats = w_days

EXCEPTIONS

date_conversion_error = 1

OTHERS = 2.

IF sy-subrc NE 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

DESCRIBE TABLE w_days LINES workday.

WRITE : / 'No of Working days :',

Thanks

Rajani

Re: What's function to know working data in specified date range?

Former Member — Mon, 16 Feb 2009 08:31:48 GMT

Hi Nicole,

try out this table.

T5B72

and this function module

HRWPC_PCR_CHECK_WORKINGDAYS.

Hope it helps!

Much Regards,

Amuktha.

Edited by: Amuktha Naraparaju on Feb 16, 2009 9:32 AM

Edited by: Amuktha Naraparaju on Feb 16, 2009 9:35 AM

Re: What's function to know working data in specified date range?

Former Member — Mon, 16 Feb 2009 08:31:59 GMT

HI Nicole

Use this FM


RKE_SELECT_FACTDAYS_FOR_PERIOD

Pushpraj

Re: What's function to know working data in specified date range?

Former Member — Mon, 16 Feb 2009 08:32:10 GMT

DATE_CHECK_WORKINGDAY u2013 Determines if a single date is a working day

DATE_CHECK_WORKINGDAY_MULIPLE u2013 Checks date across multiple factory calendars

WDKAL_DATE_ADD_FKDAYS u2013 Number of working days in a date range

Re: What's function to know working data in specified date range?

former_member222860 — Mon, 16 Feb 2009 08:33:18 GMT

Hi,

check this

DATE_CHECK_WORKINGDAY

Edited by: Mahesh Reddy on Feb 16, 2009 9:34 AM

Re: What's function to know working data in specified date range?

Former Member — Mon, 16 Feb 2009 08:40:11 GMT

Thanks a lot!!

Re: What's function to know working data in specified date range?

Former Member — Mon, 16 Feb 2009 08:40:47 GMT

Thanks a lot!!