How to find the relation between BNAME of USR DB tables and PERNR of PA DB tables ?

[masna_7]

Hi, I am trying to find and print the details of employee using his SAP Username

I am thinking of giving the input as BNAME (sap username) and I need to print this PERNR (personnel Number or Employee Id) via an ABAP report.

I searched various sources, but, I am unclear of the relation between these two fields, Can anyone please help me in this requirement ?

Thanks in Advance !

[Sandra_Rossi]

I searched various sources... in fact only one, what do you think? https://community.sap.com/t5/application-development-discussions/derive-user-name-bname-using-pernr/...

[xiaosanyu · Accepted solution]

1. USE TCODE: PA20 maintain the relation between BNAME  and PERNR 

    infotype: 0105  subtype 0001

2.  Fetch data by SQL

SELECT PERNR,
       USRID
  FROM PA0105
  WHERE SUBTY = '0001' AND
        BEGDA <= @SY-datum AND
        ENDDA >= @SY-datum.