◆◆1

[代码]如何根据SAP登录用户名取得电话号码，电子邮件地址和全名

石头 11月 10, 2017 Report 13,457 views 0

tcode：SU3中可以查看SAP登录用户的电话号码，电子邮件以及用户全名，如下：

代码：

REPORT ztest_get_user.

DATA: l_sname      TYPE adrp-name_text,  "Name
      l_email      TYPE ad_smtpadr,      "Service leader email
      l_telno      TYPE adr2-tel_number, "Sales office telno
      l_tel_extens TYPE adr2-tel_extens. "Sales office tel ext
SELECT SINGLE adrp~name_text    "Name of
              adr2~tel_number   "Tel
              adr2~tel_extens   "Extension
              adr6~smtp_addr    "Email
  INTO ( l_sname,l_telno,l_tel_extens,l_email )
  FROM usr21
 INNER JOIN adrp ON adrp~persnumber = usr21~persnumber
  LEFT OUTER JOIN adr2 ON adr2~persnumber = usr21~persnumber
  LEFT OUTER JOIN adr6 ON adr6~persnumber = usr21~persnumber
 WHERE usr21~bname    = sy-uname
   AND adrp~date_from = '00010101'
   AND adrp~nation    = space.

WRITE:/ l_sname,
      / l_telno,
      / l_tel_extens,
      / l_email.