cancel
Showing results for 
Search instead for 
Did you mean: 

Table that stores the email id

Former Member
0 Kudos

Hi all,

can any bosy pls tell me the table where the mails id of

1. contact person

2. sales employee

3.delivery head

4.people executive are stored when these deatils are given at the time of creating a sales order .

please tell me.good points will be given ..

its very urgent.....

thanks

Message was edited by:

Prabhudutta ......

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Chk table ADR6 if you have the personnel no of all the roles that you have mentioned below.

Table ADR6 should resolve your issue

Hope it helps

Former Member
0 Kudos

Hi

Refer below sdn post

Former Member
0 Kudos

sorrry ,

u have not mentioned any link below..

could you please tell me again.

tahnks

Former Member
0 Kudos

To get all customer mail ids

You will have to 1st fetch the Address number (ADRNR ) for the Customer from KNA1 table and then for the Address Number you will get the Email Address in the field SMTP_ADDR from ADR6 table

Cheers

Former Member
0 Kudos

Thanks for the answer.

i have tried but i am not getting any mail id in the adr6 table for the respective

ADRNR.

so can u please help me out to sort this .

thanks

Former Member
0 Kudos

Well i am cent percent sure if you follow the steps properly you should get it

once again go to Se11 enter KNA1 and hit display then press (ClrlShiftF10) and then execute may be you can enter your Customer number if you remember in KUNNR field and double click once you get the result and select ADRNR field you will surely have a number next to it

Now again go to ADr6 in se11 and press (Ctrlshiftf10) enter ADRNR and execute you will get a line display double click on that and in the field u will see the <b>Email Provided you have maintained it for that particular Customer</b>

Cheers

Former Member
0 Kudos

Check table ADRC ( fields : extension1 extension2 ) with key ADRNR

Hope this helps,

Erwan

Former Member
0 Kudos

SORRY there is nothing stored in the extension 1 and 2 respective of the adrnd no.

tahnks