06-18-2006 8:02 AM
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
06-18-2006 9:50 AM
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
06-18-2006 8:09 AM
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
06-18-2006 8:11 AM
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
06-18-2006 9:28 AM
06-18-2006 9:50 AM
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
06-18-2006 12:50 PM
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
06-18-2006 12:52 PM
refer to my link, you will have two different adrnr fields one for customer and one for contact person.
Regds
Manohar
06-18-2006 12:56 PM
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
06-18-2006 1:41 PM
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