cancel
Showing results for 
Search instead for 
Did you mean: 

BW-HR Master Data Extract

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Can not you use the stnadard cube 0PAOS_C01 and it's DS to give this report?

If so , whats the problem?

With rgds,

Anil Kumar Sharma .P

Former Member
0 Kudos

Hi Anil & Vijay,

First thats for the update provided.

Vijay as you suggested to use 0EMPLOYEE_ATTR,you said that all fields are avaliable,But the problem is i am supposed report on the field MOVAG:HRP1011 (Monthly Work Hours) and WOSTD:PA0007 (weekly Work Hours) but i can find them in 0EMPLOYEE_ATTR

Thease are the KF i need to use in calculated kf in bex

Anil as you said to use 0PAOS_C01

But i can't find the KFs i mentioned above

PLease help me guys as this is my first BW project

Thanks

Former Member
0 Kudos

Hi,

To provide you with further information

i need the following data in my BW report

HRP1000 - OBJID, OTYPE, STEXTBEGDA

HRP1007-STATUS

HRP1011-SOBID, RELAT

HRP1005-TRFGL

PA0002 –NACHN, VORNA

<b>PA0007 - WOSTD ( Number of hours per week)

HRP1011 - MOVAG (Number of hours per month)</b>

Some one in HR Fourms told me that these tables are master data tables and i am reporting on master data

So Anil,Quick question if the data i need is master data can i use the cube u suggested

Please update me on this

Thanks a lot

Former Member
0 Kudos

Hi,

Take a look on the cube 0PT_C01.And check whether Multiprovider on this cube and 0PAOS_C01 could help you.

Even though we have no of cubes in BIW-HR, but actually data in those cubes is comming from Master tables of R/3.

With rgds,

Anil Kumar Sharma .P

Message was edited by:

Anil Kumar Sharma

Former Member
0 Kudos

Anil,

Thanks for the info

are these 2 fields

PA0007 - WOSTD ( Number of hours per week)

HRP1011 - MOVAG (Number of hours per month)

are avaliable in those cubes u mentioned....bcaz i can find them any where

Please update me

Thanks

Former Member
0 Kudos

Update me please.......

Former Member
0 Kudos

Hi,

I guess, you can use 0PLHRS KF of the cube 0PT_C01 with restrictions to get your required hours. And I would like to request you to study the standard reports on this cube.

http://help.sap.com/saphelp_nw2004s/helpdata/en/08/84c739cc7c991ae10000000a11402f/frameset.htm

With rgds,

Anil Kumar Shama .P

Message was edited by:

Anil Kumar Sharma

Former Member
0 Kudos

Hi Anil,

Thanks for the info provided greatly appriciated.

The KF -0PLHRS i can get the information of FTE for Hours.

But my requirment is to get FTE & Staff FTE I am not sure how exactly they differ

Can you please provide me any help.

Thaks

Former Member
0 Kudos

Hi Anil,

Please update me on this

Thanks a lot

Former Member
0 Kudos

Hi,

It is Better to Use Standard Datasource and Enhance the Standard one with required fields.almost all the objects you mentioned above are avaliable in 0EMPLOYEE_ATTR.

Thanks,

-Vijay