on 2007 Mar 14 3:44 PM
Hi,
I am a BW Cons working on the HR.
My requirment is to extract data from HR based on Positions Management
Information Required
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
Can any one brief me on the flow in the position management in HR please
Thanks
Hi BW KING,
use related tables
"HRP1001" for all OM related information
"PA0001" for Organisational Information
"PA0008" for Basic pay & Pay scale structures
this will give you all required inforamtion
Cheers,
TG
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Information Required
1) Position ID ---> Field - PLANS ---> Table - PA0001
2) Position Name ---> Filed - Stext --> Table - HRP1000
3) Position Status (Occ,Unocc,Obsolete) * --check for the relationship Employee holds the position on a given date --- Relation ship between Object type "S" and Object Type "P" and the Relation ship is A 008 (Holder of the Position) in table HRP1001
4) FTE ---???
5) Staff ID --- it may be the employee personnel no ... you may get from table PA0001 --- field PERNR -- it should be the Key field.
6) Staff Name --- Employees First and last name from table PA0002
7)Staff FTE -
???
8)Pay Scale Group --- from table PA0008
9)Pay Scale Level --- from table Pa0008
10)Position Reports To --- Relationship between Object type "S" to "S" in table HRP1001 and the realtionship is A002
11) Organisational Unit --- when u look for the PERNR (Key filed in table PA0001) also look for the filed ORGEH
FLOW -
> Check the Pernr in table PA0001 on a given date -
IF True
you will get his Position ID and Orgunit
Select employees details from like name from PA0002.
Select PSGroup and Level from PA0008 on the given date.
Select the reporting to relation ship in table HRP1001
endif.
Hope this helps u.
User | Count |
---|---|
109 | |
8 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.