Table of Email address field in customer master

[Former Member]

Hi,

I want to know the table in which the email address of contact person is maintained (field in customer master > general data > contact persons tab.

I am not able to find out as it says that it is maintained in a structure.

Let me know please.

Thanks,

Shankar

[alpesh_saparia3 · Accepted solution]

Hi,

In table KNVK you will get Contact person no (PRSNR) assigned to customer.

From KNA1 you will get the adress no (ADRNR).

You have pass this both combination to ADR6 table in (ADDRNUMBER and PERSNUMBER).

[Former Member · Accepted solution]

Thanks Lakshmipathi, Ravi, Alpesh.

[Former Member]

Hi,

Email address is stored in Table ADR6

Regs,

Ravi Duggirala

[Lakshmipathi]

Dear Shankar

The field name for email address is SMTP_ADDR which is stored in Table ADR6

thanks

G. Lakshmipathi

[Former Member]

hi,

The field name which stores the email add is : SMTP_ADDR.

This is a field in the structure:SZA1_D0100.

Cheerzz..

Subbzz