问题:根据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.