Finding employee name based on PERNR

[Former Member]

Hi Experts,

How to find out the

Sales Employee name,

Manager Responsible name and

End customer name

based on the PERNR value in VBPA table.

From where i can get the name field and table???????

Regards,

Navaneeth.

[Former Member · Accepted solution]

Hi...

tables: vbpa, kna1,adrc,pa0002,hrp1001,hrp1000.

parameters:

pernr like pa0002-pernr.

<b>****customer name.</b>

select single kunnr

from vbpa

into vbpa-kunnr

where pernr eq p_pernr.

select single adrnr

from kna1

into adrc-adrnr

where kunnr eq vbpa-kunnr.

<b>****** Sales employee name.</b>

select NACHN

VORNA

from pa0002

into (pa0002-nachn,pa0002-vorna)

where pernr eq p_pernr.

<b>******Managers name.</b>

<b>use ...

RH_GET_LEADER</b> fm to get MAnagers name

or

data:

w_objid type hrp1001-objid.

SELECT SINGLE sobid

FROM hrp1001

INTO w_objid

WHERE subty = 'A002' AND

rsign = 'A' AND

sclas = 'S' AND

otype = 'S' and

objid = w_obj.

if sy-subrc = 0.

select single STEXT MC_STEXT

from hrp1000

into corresponding fields of hrp1000

where objid = w_objid.

write: w_objid, hrp1000-stext, hrp1000-MC_STEXT.

else.

write ' No supervisor'.

endif.

[Former Member · Accepted solution]

Hi,

in PA0002 table there is no records for the field Pernr in VBPA table..

But for that particular PERNR value corresponding Name is there..

Is there any other table is available to store that Name field?

Regards,

Navaneeth...

[Former Member]

Hi all,

Any function Module is available for this?

Regards,

Navaneeth