No of Jobs Per Org Unit

Hi Guys

I want to count number of employees related to a job in an organizational unit. So whats the relation between organizational unit and job. How it can be calculated.

I think Tables for this pupose are.

HRP1000.

HRp1001.

I am trying to use query given below but its not working.

SELECT *

FROM HRP1001

INTO ZIT1001

WHERE PLVAR = '01'

AND OTYPE = 'O'

AND SUBTY = 'B003'.

APPEND ZIT1001.

ENDSELECT.

Please note that I have to count number of employees in for all jobs in all departments. e.g

Departments -

Managers--

Information Trech -

3 -

10 -

5

HR -

5 -

0 -

10

A detailed answer is appreciated.

Thnx