获取sap登陆用户名的中文描述

一、业务场景：

 

当通过MKPF-USNAM查找ADRP-NAME_LAST时，中间缺少一个表，即USR21.否则，MKPF-USNAM不能和ADRP-PERSNUMBER直接对等。

二、解决方法：

 1 DATA:L_NAME_LAST LIKE ADRP-NAME_LAST,
 2      L_NAME_FIRST LIKE ADRP-NAME_FIRST.
 3 
 4 CLEAR:L_NAME_LAST,L_NAME_FIRST.
 5 
 6 SELECT
 7     adrp~persnumber
 8     date_from
 9     nation
10     name_last
11     name_first
12     bname
13 FROM adrp
14 INNER JOIN usr21 ON adrp~persnumber = usr21~persnumber
15 INTO TABLE it_adrp
16 FOR ALL ENTRIES IN it_mkpf
17 WHERE usr21~bname = it_mkpf-usnam.

 

转载于:https://www.cnblogs.com/BinGeneral/p/7659505.html