need table name for email id

[Former Member]

Hi experts,

I got employee id BNAME from table crmd_orderadm_i. Based on that field i need to get the Email ID for that user. Can anyone please tell me the table where it is stored in.

regards,

venkatesh.

[Former Member · Accepted solution]

Hi Venkatesh,

Another way to find out email id is:

Go to table USR21. Pass the BNAME and get the value for PERSNUMBER.

Now pass this PERSNUMBER in the table ADR6 and get the email-id in the field SMTP_ADDR.

Thanks,

Pradeep.

[Former Member · Accepted solution]

Hi Pradeep,

Thanks a lot. It is really helpful.I got one more option using the table law_unique.Can i proceed with that table.

regards,

venkatesh.

[Former Member · Accepted solution]

Hi Venkatesh,

I dont think you can use the LAW_UNIQUE table. I checked the table in my system and found that there was no data was present in the table.

Please check your table and see whether the data is present for all the usernames???

This table comes under License administration workbench.

Thanks,

Pradeep

[Former Member · Accepted solution]

Hi Pradeep,

I too checked it and is not giving correct results.I followed your procedure only.thanks a lot.

regards,

venkatesh.

[Former Member]

table SZA5_D0700

field SMTP_ADDR

BR

Dinesh

[Former Member]

Hi Dinesh,

Thanks for your reply.Actually i need relation with the table usr02 through the field BNAME so that i can retrieve the data based on BNAME field.

thanks,

venkatesh.