Logic for checking if the input has SAP Account/ID

[walkerist]

Hi, user wants a program that if they input a sample name or username, it will check if that is related to a sap account.

Example: If they input WANEW13, they want the program to check if that has an existing SAP ACCOUNT or SAPID.

Is it possible? Thank you

[ankush_yadav · Accepted solution]

Hi Wane,

You can refer to the Table : USER_ADDR.

The table contains the field bname (User Name), name_first (First Name), name_last (Last Name), name_textc (Full Name) and other personal info details.

You can fetch it from there.

Reward all helpful answers.

Regards,

Ankush Yadav

[walkerist · Accepted solution]

BNAME contains the SAP ID? thanks ankush_yadav