BW-HR Master Data Extract

Hi Experts,

As per my BW report requirment i need to extract

Position ID

Position Name

Position Status (Occ,Unocc,Obsolete) *

FTE

Staff ID

Staff Name

Staff FTE

Pay Scale Group

Pay Scale Level

Position Reports To

Organisational Unit

Date Selection

Start Date

Posts Reporting To Position

from HRP1011,HRP1001,HRP1000,PA0002 & PA0007 Tables

Taking all those fields from HRP1000,HRP1001.......etc these are all the tables of Organizational master data which is one of the HR structures where HR people will design the organizational structure of the define and in that organizational structure they define org unit (org id which is represented by object type O),

Position id (position which is represented by object type S,

staffing is when they do the reporting then who is subordinate of whom

if you see tcode ppome (r/3) you can see all these fields this belongs organizational master data. i hope i cleared your doubt

So my question is if i extract this data by developing a custom defined data source based on view to which object (Org,Position,Staff) i need to lood this data

I mean as attributes

Thanks