Skip to Content
Former Member
Jun 19, 2014 at 12:23 PM

HCM org data in SAP BW


Hi Gurus,

I wish to extract HR organisational structure to SAP BW. the primary HR tables in use here are HRP1000 and HRP1001. 1000 tables stores the organizational data where as 1001 stores the relationship between two org units. The HR team here have sort of created a hierarchy in terms of relationship for example org unit 1000585 has relationship b002 with org unit 1000586. 1000585 represents the root node which is indication of company.

1000586 represents business. there can be furthers level below this for example 1000586 has relationship with org unit 1000587 which is a legal entity. how can i model this BW to achieve slicing dicing at query level based on these levels.

thanks in advance for your help.