Email field in XD03

[Former Member]

Hi

In xd03 for email address it shows E_mail as the field and its dispalyed as a structure.Any idea about the table from which it is fetched?

Structure:Bapicontact_addressdata

field: e_mail

DE: ad_smtpadr

George

[Former Member]

Hi

Try to see ADR6 table:

you have to read it using field ADDRNUMBER, the address ID is stored in field KNA1-ADRNR:

SELECT SINGLE * FROM KNA1 WHERE KUNNR = <.....>

SELECT * FROM ADR6 WHERE ADDRNUMBER = KNA1-ADRNR

Max

[Former Member]

after F1...double click on the data element and then click on the where used list in the next screen...check the database table and enter it'll list u all the database tables..

Reward points if it helps

Regards

Gunjan

[Manohar2u]

Similar thread link.

Regds

Manohar

[Former Member]

Hi George,

This e-mail field will be there in

<b>

TABLE : ADR6

FIELD = SMTP ADDR</b>

This is what u r asking George

Thanks

Vikranth Khimavath

[Former Member]

Hi Vikranth

There r two email addresses One for the main person and one tab s comes up and shows COntact persons details .It doesnt show up for all entries..

For that too there is an email address,We need to get that ...

George

[Manohar2u]

refer to my link, you will have two different adrnr fields one for customer and one for contact person.

Regds

Manohar

[Manohar2u]

KNA1-ADRNR - > Customer adress number

KNVK-ADRNP_2 - >Customer contact address number

Use these numbers to get relevant email address from ADR6 table

Regds

Manohar

[Former Member]

Hi Gerorge ,

I didnt understand ur question can u please elobrate and let me know.As far as my knowledge i dont think there will be 2 email address.when u create a customer in xd01 there will be only one email option.

Thanks

Vikranth Khimavath