Skip to Content
avatar image
Former Member

customer e-mail address table and field

hi All,

i have one requirement,

I need to show the customer and theere e-mail addresses.

From where i can get the e-mail address of custome ,

plz give me the table and field name for customer and e+mail address

regards,

amit

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Nov 29, 2007 at 07:55 AM

    Hi,

    ADR6-->Table..

    SMTP_ADDR-->Field Name..

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 29, 2007 at 08:04 AM

    go to KNA1. take the ADRNR field for that Customer(KUNNR).

    now go to ADR6 and take the data using ADDRNUMBER = KNA1-ADRNR and PERSNUMBER = SPACE.

    SMTP_ADDR filed will contain e-mail address.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 29, 2007 at 08:19 AM

    Hi

    Please get ADRNR from KNA1 fro the customer and then use ADDR_SELECT_ADR6_SINGLE or ADDR_SELECT_ADR6_ARRAY(for multiple), SMTP_ADDR field will contain the email address...

    REgards

    Arun

    Add comment
    10|10000 characters needed characters exceeded