Reading Catsdb into a timesheet

[Former Member]

Hi,

We are working on making a custom timesheet application

How to make out if the catshours stored in the catsdb fall in the same row of the timesheet?

e.g

TIMESHEET

Costcenter | wbs | activity | monday | tuesday | wed | thurs | friday

600015 | WB1 | KTL | 8 | 8 | 8 | 2 | 4

600015 | WB1 | KTL | 0 | 0 | 0 | 0 | 7

600015 | WB1 | KTL | 0 | 4 | 0 | 0 | 8

CATSDB

COUNTER Costcenter wbs activity catshours workdate

12343 600015 WB1 KTL 8 08/15/2010

12344 600015 WB1 KTL 8 08/16/2010

12345 600015 WB1 KTL 8 08/17/2010

12346 600015 WB1 KTL 2 08/18/2010

12347 600015 WB1 KTL 4 08/19/2010

12349 600015 WB1 KTL 7 08/19/2010

12350 600015 WB1 KTL 4 08/16/2010

12357 600015 WB1 KTL 8 08/19/2010

QUESTION : - How to make out from the above record .. which records falls in the same row and vice versa...

Thanks alot!!

Edited by: Akshay on Aug 21, 2010 8:14 AM

[Former Member]

We could resolve the issue by reading the values on the left and considering that as unique combination. Though is has some catches but still acceptable by our user community as data is read and inserted without issues.

Thanks everyone for your help.

thanks,

Akshay..

[siddharthrajora]

This is kinda tricky, You need to ensure first all the records from CATSDB have unique attributes

you need to use exits like cats002 and combine all the records

like cats_read_catsdb therre are Fm from reading from CATSDB and displaying

[Former Member]

thanks for the response. we have already tried this - but this leaves us to have only 1 row with all unique attributes... in our case the the users create more than 2 rows with the same unique attributes as already in the timesheet

e.g

costcenter wbs act positon day1 day2 day .. day7

65300 KT1 TV 456005 1 3 0 1

65300 KT1 TV 456005 3 7 1 6

So cannnot figure a way to determine which hours belong to which cell ... the upper cell or the lower cell ...

Is there anyhitng in catsdb which gets stored different for different rows ... like the line number of the value

[Former Member]

Hello Akshay,

I am not sure on your requirement but If you could, you can try to hide the fields which are not used by a profile via CAC2 and use the CATS0003 and CATS0006 (and CATS0002 if needed) to manipulate the data on the Timesheet.

Regards,

Bentow.

[Former Member]

We have similar but slightly different requirement to display Short text field on time sheet. My understanding is that each entry in CATSDB represent single cell (one day for one selected WBS or attendance type) entry. Now we want to display and capture short text field along with these day entries.. like

Monday Monday text	Tuesday Tuesday text
7.5 Offsite work	7.0 US office

If this can be done on the webdynpro application side or we have to use custom enhancement cats0005 to use them as a custom field.

Tx for your inputs.

Cheers,

Sudhir