HR Reporting

[RahulKeshav]

Hi all i am first time working on HR report .....

my requirment are as follows

1.Last Name of Immediate Supervisor/Manager

Use PA0001-ORGEH as OBJID to read HRP1001with OTYPE 'O'. Find related object HRP1001-SOBID where SCLAS='S' and RSIGN='B' and RELAT='012'. Use SOBID as OBJID to read table HRP1001 with OTYPE='S'. Find related object HRP1001-SOBID where SCLAS='P' and RSIGN='A' and RELAT='008'. Use SOBID to output PA002-NACHN.

2.JOB_DESC

Use PA0001-PLANS as OBJID to read HRP1001with OTYPE 'S'. Find related object HRP1001-SOBID where SCLAS='C' and RSIGN='B' and RELAT='007'. Use SOBID as OBJID to read table HRP1000 with OTYPE='C'. HRP1000-STEXT is Job Desc.

i am unable to write the query...

Remember no 'SELECT' query..

plz help me

Thnx

Rohit

[amit_khare]

Use logical Database PNP.

do Get PERNR.

Do rp-provide-from-last p0000

Call FM HRCM_ORGUNIT_MANAGER_GET using p0001-orgeh.

Then call FM HR_INFOTYPE_GETDETAIL for the SOBID returned from previous ID using Infotype 0002. Use NACHN from the return structure as Last name of manager.

PLANS is use for Positions. Job comes from P0001-STELL. Text is stored in Text Table.

For finding Positions use this FM - HR_HCP_GET_POSITION_FOR_EMPL

For finding jobs on positions use this -

HR_HCP_GET_JOB_FOR_POSITION

Regards,

Amit

Reward all helpful replies.

[RahulKeshav]

thnx

[Former Member]

hi,

i am sending the select query. this is help full for u .

select single sobid

from hrp1001

into w-super "work area

where otyp = 'o'

and relat = '012'

and rsign = 'b'

and sclas = 's'

and begda < = sy-datum

and endda >= sydatum.

in tis program u use ldb as PCH.

tables: objec

above code is for sequential repoting in om

once u check the syntax.