12345; xyz; orgunit 1; 10 days planned; 11 days worked
12345; xyz; orgunit 2; 15 days planned; 9 days worked
12345; xyz; orgunit 3; 5 days planned; 3 days worked
I know when I go to staffing profile and click the button compare to workplan I get the same result. But I need more Information like Costcenter of the project, start_date, finish_date, Busines Unit, and so on... I get these information but cannot write the query for the planned / actual efforts.