HR Reporitng

Try using logical databases like PNP.

regards

Hi Rohith

Here's the asnwer for your queries,

1.Last Name of Immediate Supervisor/Manager

call function 'RH_STRUC_GET'

exporting

act_otype = 'O'

act_objid = PA0001-ORGEH

act_wegid = 'BOSSONLY'

act_plvar = '01'

act_begda = sy-datum

act_endda = sy-datum

tables

result_tab = i_result.

delete i_result where otype <> 'P'.

Select nachn into table i_nachn from pa0002 for all entries in i_result where pernr = i_result-objid.

2.JOB_DESC

call function 'RH_STRUC_GET'

exporting

act_otype = 'S'

act_objid = PA0001-PLANS

act_wegid = 'B007'

act_plvar = '01'

act_begda = sy-datum

act_endda = sy-datum

tables

result_objec = i_result_objec.

You i_result_objec-STEXT will hold the job desc.

~ Ranganath

PS : Reward points for all useful answers !

to get Immediate Supervisor

select single sobid into v_sobid1

from hrp1001 where otype = 'O'

and objid = PA0001-ORGEH

and rsign = 'B'

and relat = '012'

and sclas = 'S'.

next ..

select single sobid into v_sobid2

from hrp1001 where otype = 'S'

and objid = v_sobid1

and rsign = 'A'

and relat = '008'

and sclas = 'P'.

Use this SOBID(v_sobid2) to write select single on PA0002 to get NACHN ..

select single sobid v_sobid1

from hrp1001 where otype = 'O'

and objid = PA0001-ORGEH

and rsign = 'B'

and relat = '012'

and sclas = 'S'.

To get JOB_DESC

select single sobid into v_sobid1

from hrp1001 where otype = 'S'

and objid = PA0001-PLANS

and rsign = 'B'

and relat = '007'

and sclas = 'C'.

select single stext into v_stext

from hrp1000 where otype = 'C'

and objid = v_sobid1.

one more query...

thnx