获取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.
"-----------------------------------------@斌将军--------------------------------------------

 

posted @ 2017-10-13 09:31  斌将军  阅读(675)  评论(0编辑  收藏  举报