fetch category 1 to 7 from table too1
Nachn and vorna from table pa0002 and concatenate and seperate this will give you name of employee and fetch the total hours booked hours for the employee table
Where candidate_id field add total duration.
Show ALV below list.
Sorry, I can't understand the question.