topic FM required in Application Development and Automation Discussions

FM required

Former Member — Tue, 03 Jul 2007 08:25:49 GMT

Dear Experts,

I need to convert working days into calendar days using calendar key.

The table is TVRO. calendar key TVRO-SPFBK.

Pls provide some FM to convert this. and also provide example to do this

Thanks in advance

karthik

Re: FM required

former_member404244 — Tue, 03 Jul 2007 08:28:54 GMT

Hi,,

Use the FM " DATE_CONVERT_TO_FACTORYDATE"

Regards,

Nagaraj

Re: FM required

Former Member — Tue, 03 Jul 2007 08:32:29 GMT

Try using as below

'DATE_CONVERT_TO_FACTORYDATE'

call function 'DATE_CONVERT_TO_FACTORYDATE'

exporting

correct_option = '-' " Adjustment

date = d1 " Date In

factory_calendar_id = 'P6' " Calendar Id

importing

date = xdate. " Date out

Re: FM required

Former Member — Tue, 03 Jul 2007 08:32:37 GMT

Hi,

Try FM HOLIDAY_GET.

Regards,

Padmam.

Re: FM required

Former Member — Tue, 03 Jul 2007 08:40:31 GMT

Q :How to find out the number of days between a given date, excluding Saturdays and Sundays and public holidays?

A: => DATE_CONVERT_TO_FACTORYDATE

=> HR_HK_DIFF_BT_2_DATES

reward points if it is usefull ...

Girish

Re: FM required

Former Member — Tue, 03 Jul 2007 08:42:04 GMT

Function to return next business day

A function that will return next business day, based on the country.

This function will allow users to specify e.g. 10 business days from now.

Here is the code.

REPORT  ZRM_TEST                      .  

PARAMETERS: DATE_1 LIKE SY-DATUM DEFAULT SY-DATUM,  
            BIZ_DAYS TYPE I DEFAULT 2,  
            FACCALID LIKE SCAL-FCALID DEFAULT 'US'.  

DATA:       FAC_DATE_1 LIKE SCAL-FACDATE,  
            DATE_2 LIKE SY-DATUM,  
            FAC_DATE_2 LIKE SCAL-FACDATE.  

CALL FUNCTION 'DATE_CONVERT_TO_FACTORYDATE'  
     EXPORTING  
          DATE                         = DATE_1  
          FACTORY_CALENDAR_ID          = FACCALID  
     IMPORTING  
       FACTORYDATE                  = FAC_DATE_1 .  
FAC_DATE_2 = ABS( FAC_DATE_1 + BIZ_DAYS ).  

CALL FUNCTION 'FACTORYDATE_CONVERT_TO_DATE'  
  EXPORTING  
    factorydate                        = FAC_DATE_2  
    factory_calendar_id                = FACCALID  
  IMPORTING  
    DATE                               = DATE_2  
.  

WRITE: / DATE_2.

You can also try the function module DAY_ATTRIBUTES_GET.

You need to provide the calendar and a time interval, and the fm returns an internal table showing days with flags holiday / working day.

reward points if it sis usefull ....

Girish