cancel
Showing results for 
Search instead for 
Did you mean: 

email field in customer master

Former Member
0 Kudos

Dear All,

Can anyone tell me how to view emil id for all customers in my company code any report ????????????

Helpful suggestion will surely be rewarded with points.

Regards,

Abhijit

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I don't think you have any such standard report. You need to write a query in SQ01 basing on the customer table KNA1

or you can use Se16 and give the cutomer number to get the table output.

Reward if useful

sarma

Former Member
0 Kudos

Hi,

KNA1 does not have that field for email atleast it is not showing it in se16

Regards,

Abhijit

Answers (2)

Answers (2)

Former Member
0 Kudos

hi

Customer Email field is there in a structure called SZA1_D0100. and field name is SMTP_ADDR

goto SE16 or SE11 and give this structure name and you will get the details.You can take from this structure or you can write a simple query .

otherwise you can develop a report with the help of an ABAPER

Asign point if useful

regards

Srilakshmi

Edited by: srilakshmi thammana on May 23, 2008 1:57 PM

Former Member
0 Kudos

Look to table ADR6 using the address number for your customer to view maintained email addresses.

Former Member
0 Kudos

Hi,

How to find out report on email id field

Regards,

Abhijit

Former Member
0 Kudos

Hi,

Try report S_ALR_87012086 - Vendor List . There you have a lot of options.

Reward points if useful,

Miroslav