CATS Issue VERY Urgent..

[Former Member]

HI ALL,

BiW PROD is placing CATS data for 2007 in to week 52 2006.  Can advise why?

Please advise what would be the error.

Cheers,

Sri

[Former Member]

Hi All,

We have a problem for 0CALWEEK in CATS.

FOR 0CALQUARTER

20061 means 1st quarter

20062 means 2ND quarter

20063 means 3RD quarter

20064 means 4TH quarter

FOR 0calweeK:

20061 means 1st WEEK

20062 means 2ND WEEK

20063 means 3RD WEEK

20064 means 4TH WEEK

0CALWEEK is giving problem IN CUBE.

It shows wrongly.

0CALQUARTER 0CAL WEEk

2007 1 2006 52 ( 52 week)

2007 1 2006 52

<b>0CAL WEEk should show 2007 1 instead of 2006 52.</b>

It should show :

0CALQUARTER 0CAL WEEk

2007 1 2007 1 (ist week in 2007)

2007 1 2007 1

we have a routine on 0CAL_week

=====

PROGRAM UPDATE_ROUTINE.

$$ begin of global - insert your declaration only below this line -

• TABLES: ...

• DATA: ...

data: employee_md like /bi0/memployee,

employee_wa like /bi0/memployee,

person_md like /bi0/mperson,

PERSON_WA LIKE /BI0/MPERSON.

DATA: G_RECORD_NO LIKE SY-TABIX.

INCLUDE RS_BCT_HR_UPDATE_RULES_GENERAL.

INCLUDE RS_BCT_HR_PAPA_UPDATE_RULES.

$$ end of global - insert your declaration only before this line -

FORM compute_characteristics

TABLES MONITOR STRUCTURE RSMONITOR "user defined monitoring

USING COMM_STRUCTURE LIKE /BIC/CS0CATS_IS_1

RECORD_NO LIKE SY-TABIX

RECORD_ALL LIKE SY-TABIX

SOURCE_SYSTEM LIKE RSUPDSIMULH-LOGSYS

CHANGING RESULT LIKE /BIC/VZCATST-CALWEEK

RETURNCODE LIKE SY-SUBRC

ABORT LIKE SY-SUBRC. "set ABORT <> 0 to cancel update

*

$$ begin of routine - insert your code only below this line -

• fill the internal table "MONITOR", to make monitor entries

data: w_date type d.

data: w_date_check type d.

data: w_numberofdays type p decimals 2.

data: w_numberofweeks type i.

data: w_dayofweek type p.

data: w_first_day_of_sap_calendar type d value '19790101'.

data: check type i.

data: w_year(4) type c.

data: w_weekno(2) type c.

***********

w_date_check = COMM_STRUCTURE-CALDAY.

w_date = w_date_check.

w_date+04(04) = '0101'. " beginning of the year

do.

w_dayofweek = ( ( w_date - w_first_day_of_sap_calendar ) mod 7 ) + 1.

if w_dayofweek = 7. " First sunday(7) of the Current year

exit.

endif.

add 01 to w_date+07(01).

enddo.

w_numberofdays = ( w_date_check - w_date ) + 1.

w_numberofweeks = ceil( w_numberofdays / 7 ).

*

w_year = w_date_check+0(4).

if w_numberofweeks = 53.

w_numberofweeks = 1.

w_year = w_date_check+0(4) + 1.

endif.

if w_numberofweeks = 0.

w_numberofweeks = 52.

w_year = w_date_check+0(4) - 1.

endif.

w_weekno = w_numberofweeks.

call function 'CONVERSION_EXIT_ALPHA_INPUT'

exporting

input = w_weekno

importing

output = w_weekno.

concatenate w_year w_weekno into RESULT.

• result value of the routine

• RESULT = .

• if the returncode is not equal zero, the result will not be updated

RETURNCODE = 0.

• if abort is not equal zero, the update process will be canceled

ABORT = 0.

$$ end of routine - insert your code only before this line -

*

ENDFORM.

========

This is giving problem from 2007 year only.

We need to check with FI or HR teams , Is there any configuration settings in R/3 side for 0Calweek?

This is production ISSUE. Help me on very Urgent BASIS!!

Thanks & Regards,

Sri.