设中国护士网为首页 | 中国护士网专注于知识的分享,因为专注,所以更好!
分享到:

SAP ABAP 取用户姓名全称

来源:中国护士网  作者:www.512test.com

问题:根据SAP的登陆账号取SU01中维护的用户姓名全称。

方法:

[UNAME为SAP登陆账号]

SELECT SINGLE NAME_FIRST NAME_LAST INTO (NAME_FIRST,NAME_LAST)
FROM ADRP INNER JOIN USR21 ON ADRP~PERSNUMBER = USR21~PERSNUMBER
INNER JOIN USR02 ON USR21~BNAME = USR02~BNAME
WHERE USR02~BNAME = UNAME.