SAP根据用户名查姓名

  • A+
所属分类:Notes

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 .

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: