[转载]SAP 根据用户名查姓名

转载 https://blog.csdn.net/zhongguomao/article/details/53836655

SU01 / SU01D 的用户查中文姓名：

SELECT SINGLE ADRP~NAME_FIRST ADRP~NAME_LAST
    INTO (LV_NAME_FIRST,LV_NAME_LAST)
    FROM ADRP
    INNER JOIN USR21
    ON ADRP~PERSNUMBER = USR21~PERSNUMBER
    WHERE USR21~BNAME = SY-UNAME .
​

另有视图 V_USERNAME

select ADRP~NAME_FIRST ADRP~NAME_LAST 
into (LV_NAME_FIRST,LV_NAME_LAST)
from  V_USERNAME
where BNAME = SY-UNAME 
​