I've been asked to write a report to help track the efficiency of CAT2 time entry. I need to report on how long it takes for a user to input the CAT2 data, how many records were input at once and how many different personnel numbers the entry was done for.
So far I've put together reading the transaction log via FM RSAU_READ_FILE for retrieving the CAT2 transaction starts by users for a given day. Then reading the CATSDB table for entries created on that same day. These separate entries are then read into the same internal table and sorted by user/date/time so that I get a logical time progression of the activity of each user over the day.
Given that some users don't save data when accessing CAT2 I'm currently working on the guts of the report. I've got a design I'm working on, but thought it would be interesting to see what you here in the forums might recommend as a design to collect the required information.
Here is the design of the internal table with some sample data.
ERNAM, ERSDA, ERSTIM, TCODE, PERNR
Emp1, 20101014, 075139, CAT2, 00000000 (from the trans log as tcode is filled)
Emp1, 20101014, 075249, , 11111111 (from CATSDB as pernr is filled)
Emp1, 20101014, 075253, CAT2, 00000000
Emp1, 20101014, 075753, CAT2, 00000000
Emp1, 20101014, 075853, CAT2, 00000000
Emp2, 20101014, 085139, CAT2, 00000000
Emp2, 20101014, 085259, , 11111111
Emp2, 20101014, 085259, , 11111111
Emp2, 20101014, 085259, , 22222222
Emp2, 20101014, 085259, , 22222222
Emp2, 20101014, 085259, , 22222222
Emp2, 20101014, 085259, , 33333333
Emp2, 20101014, 085330, CAT2, 00000000
So from this I would get that emp1 saved 1 record for 1 employee in 70 seconds.
Emp2 saved 6 records for 3 employees in 80 seconds.
Look forward to your expert responses
Wes
|
sapwes
_.____.__ 
