fetch category 1 to 7 from table too1
And fetch
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.
Employee id
Category 1....7
Name
