How to show the employee's organizational unit in remuneration statement?

[Former Member]

Hi experts,

I'm working on a payslip,and there are two questions to ask:

1.How to show the employee's organizational unit in remuneration statement? I didn't find a right table and right field to realize it.

2.I tried to show the notification in payslip by infotype 0128, but it didn't work. Is there any tips?

Any help will be appreciated.Thanks in advance!

Alex

[Former Member · Accepted solution]

1. You can use table P0001 to show the employee's organization info. There are severl fileds you can use. If there's no the field you want, you can use TCode: PE51_CHECKTAB to insert the field you want. But make sure that the filed is in P0001.

2. I am not sure whether IT 0128 could be insert into the payslip. But also you can try to use PE51_CHECKTAB to see if it works for you.

Good luck!

[Former Member]

Hi,

You can get orgunit from Orgassignment table (pa0001-orgeh).

Otherwise you can get it from hrp1001 table. querying like

*get position of pernr.

select single sobid into v_pos

from hrp1001

where otype = 'P'

and objid = pernr

and plvar = '01'

and rsign = 'B'

and relat = '008.

and istat = '1'

and begda le sy-datum

and endda ge sy-datum

and sclas = 'S'.

*Get org unit

select single sobid into v_orgunit

from hrp1001

where otype = 'S'

and objid = v_pos

and plvar = '01'

and rsign = 'A'

and relat = '003'

and istat = '1'

and begda le sy-datum

and endda ge sy-datum

and sclas = 'O'.