how to get username from customer email id.

[Former Member]

Hi experts,

How to get username from customer email id.I am using transaction XD02.

I would be thankful for your kind replies .

Regards,

Sachin Hada

[Former Member]

Hi sachin,

Regards,

Sravanthi

[Former Member]

Hi,

Slect single adrnr from kna1 into v_adrnr where kunnr = kunnr(already u get the customer number).

Select single SMTP_ADDR from adr6 into v_user where addrnumber = v_adrnr.

In 'v_user' u can get the user name of the customer.

[Former Member]

ADR6 table, the field is SMTP_ADDR based on the kna1-adrnr number