Database Table where CATS data stored

[Former Member]

Hi Experts,

Anyone pl let me know in which table, the CATS data stored.

1) CAT2-Recorded data

2) CAT4-Approved Data

3) Data with different Processing Statuses 10-Inprocess, 20-Released fro Approval, 30-Approved, 40-Rejected, 50-Changed after Approval, 60-Cancelled).

Thanking you in advance.

Regards

Samanvita

[Former Member · Accepted solution]

Pls Check whether CATSDB table can solve your problem.

[Former Member]

You can in CATSCO table.

Regards

RK

[Former Member]

CAT2 is used by an employee to upload the actual timingsworked against the planned/target working hours in the timesheet, and when released, goes to the Reporting manager's inbox for approval.

When the Manager opens the inbox, uses CAT4 for approve the timesheet. On the approval, the timesheet shall be sent to the administrator, who views the same in CAT6, where the timesheet is stored.

Edited by: Raghunandana Srinivas K N on Aug 9, 2011 4:08 PM

[Former Member]

Hi,

Once the data is transfered to the target component you can see the data in, for example CATSCO (if you do CAT7), CATSPS (if you do CAT5).

Regards

Sreekanth

[ted_dinh]

Also check PTEX2000 where CATS data are stored prior to transferring to IT2001/2002.