Table to to know mail ids of the customer master

[Former Member]

Hello Friends,

Is there any standard table or report to display the Email ids maintained in the customer master data general view.

Say for ex: In the customer master 1000 we maintained 6 mail address so I should know the maild ids in the report format.

For this is ther any std table or report.

I know that from the table ADR6 we ca

Regards,

Ram.

[Former Member]

Hi,

There is no standard report for email id and customer combination.if you want to create user specific report you can do it Quickviewer by T-code SQVI.

Otherwise follow what ramakrishna has suggested.

Thank you.

[Former Member]

Hi Ram,

Yes,you are correct we get customer mail id from ADR6 table,first go to SE16N give table no KNA1 and give the customer no then get the value of ADRNR pass the same into ADR6 - ADDRNUMBER you will get the custoemr mail id details.

ADR6 - SMTP_ADDR is the mail id details field.

Regards

Ram

[Former Member]

Hello Ramkrishna,

Thanks for your prompt reply

I am creating a query for the same

Regards,

ram.