Customer code Email Address Field data from which table can i get?

[Former Member]

Hi Everyone,

From which table i can get email address of multiple customer?

Table KNA1 shows only field of Email address maintained where values marked "X".

But i need actual email address customer...

[former_member212707 · Accepted solution]

Check table ADR6 to get the email id of the customer. The link between KNA1 and ADR6 is the field ADRNR field. Pass that value and obtain all the desired parameters from ADR6.

Thanks,

Ravin

[Former Member · Accepted solution]

hi Ravin,

Thank you, i get it.

Regards,

Narendra

[srinu_s1]

Hi,

First please clarify what is the input field to fetch the email address?

For example if your input is VBAK-VBELN  then by entering the sales order number you can take KUNNR field and pass this to KNA1 table

Input KUNNR field in KNA1 table and take ADRNR field pass this ADR6 table(as indicated by Ravin,)

There you can get email address by entering ADRNR field in ADDRNUMBER field.

thanks,

Srinu.

[siva_vasireddy2]

Hi,

Fetch the Address number data from KNA1-ADRNR and pass the data along with zero's in table ADR6

the email id's can be obtained.