获取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 adrp~date_from adrp~nation adrp~name_last adrp~name_first usr21~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.
"-----------------------------------------@斌将军--------------------------------------------