Customer-Email Id

[former_member185462]

Hi,

I was trying to find the e-mail id of customer,I am trying in IDES,when i enter E-mail id it is asking to update tax through Vertex.Now on seeing the below link,i could see the list of E-mail id's in table ADR6

http://scn.sap.com/thread/3470817

But i could not find to which customer the mail id corresponds.Kindly help me out.

Pradeep

[Former Member]

Hi Pradeep

For your customer please check the "Address" field (Technical name-ADRNR) from table KNA1. This is the reference number which you can use to extract data out of any ADR* table (ADRC, ADR2, ADR3, ADR6, etc.) to get detailed address information for that customer.

Hope this helps!

Thanks

Jyoti

[former_member184966]

Hi,

ADR6 table contains both the Customer and Vendor Email Addresses.

To find the E mail address of a customer, Go to SQVI T code and follow the below steps:

1. Enter a name and choose CREATE
2. Enter the Title name
3. Select the Table Join option in 1.Data Source and check the Basis Mode Radio Button
4. Insert the ADR6 and KNA1 tables

Here, you can see the primary key which are common to both tables i.e., ERDAT Field.

And do the necessary steps and generate the report.

Then you can able to view the Email address of the customer.

Thanks

Anand Kumar KS

[former_member185462]

Hi,

I came to this step,but i dont know what to do after this.

[former_member184966]

Hi,

Please check the below link to do further:

http://www.entrypointblog.com/wp-content/uploads/2011/11/SQVI_Guide1.pdf

It will help you to solve the issue.

Thanks

Anand Kumar KS