Skip to Content

Field name for e-mail id

What is the field name for e-mail id? Eg. to list out e-mail ids of all customers.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 12:41 PM

    fieldname : SMTP_ADDR

    tablename is ADR6

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 12:42 PM

    Hi,

    You can look at the Data Elements

    SO_REC_EXT

    SO_SMTP_F

    SX_ESMTP

    SX_NODETYP

    SX_NOTYTXT

    Regards

    Sudheer

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 12:42 PM

    Please check the table <b>ADR6</b>

    the Field name is SMTP_ADDR

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 12:47 PM

    Table ADR6 , field SMTP_ADDR

    Regards,

    Rolf

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 10, 2007 at 12:49 PM

    Hi Sultan,

    The field name for e-mail id is SMTP_ADDR with its data type : AD_SMTPADR for to list the email ids of the customers.

    Regards,

    Arjun

    <b>Reward points if it helps</b>

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 12:51 PM

    Hi Sultan,

    To get all customer mail ids

    1. First write a select on KNA1 and get all the ADRNR

    2.goto table ADR6 , compare the ADRNR from KNA1 to ADDRNUMBER of ADR6 and get the field SMTP_ADDR

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 01:11 PM

    Data element for email id :AD_SMTPADR

    For customer: table :ADR6,Field name :SMTP_ADDR

    Regards,

    Shweta

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.