Shulou(Shulou.com)06/01 Report--

SAP MM how to get the basic information of User through SAP User ID, I believe many inexperienced people are helpless about this, for this reason this article summarizes the causes and solutions of the problem, through this article I hope you can solve this problem.

How does SAP MM get the basic information of User through SAP User ID?

Project D, where the author works, has a functional requirement that after receiving the purchase order, an email needs to be sent to the person in the business department who requested to purchase these materials, that is, the creator of the purchase requisition corresponding to the purchase order needs to send an email. When I wrote the function specification, I found the purchase requisition number through the purchase order number, found the created by field value in the purchase requisition form, and got the user id of the purchase requisition creator. In this case, you need to use this user ID to find its email address. It looks simple, but it takes a bit of effort.

1. Try to press F1 Help button at Email field in SU01D interface, but get a structure, and fail to find corresponding Table.

Using transaction codes such as SE84 and SE11, it is not clear which tables the structure is related to.

Function Module: SUSR_USER_ADDRESS_READ.

Using my own user id as a parameter, execute this FM ,

This FM execution result can get basic information such as the user's name. However, the email address information in the user's main data could not be retrieved.

Finally, I found some useful tables, such as table usr01/usr03/usr21 etc. After investigation, you can get the person number / address number of the user from USR21 table, and then get the email address information from ADR6 table through Person number.

Then get PERSNUMBER from USR21 table where USR21-BNAME = PR creator;

Then goto table ADR6 to get ADR6-SMTP_ADDR (email) where ADR6-PERSNUMBER = USR21-PERSNUMBER.

ADR* is a series of tables used to store address information of users, suppliers, customers, etc., including telephone numbers, fax numbers, zip codes, etc.

After reading the above, do you know how SAP MM can get basic information of User through SAP User ID? If you still want to learn more skills or want to know more related content, welcome to pay attention to the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.