List Customer with mail

[Former Member]

Hi gurus,

Do you know a transaction standar with customer data that includes e-mail ?

In VCUST doesn't appear this info.

Thank you!!!

[Former Member · Accepted solution]

hello, friend.

you can do queries using table ADRC, look for field FLAGCOMM6 (which is the indicator if email is being maintained). if the entry is 'X' then the customer has email maintained in the CMR.

regards.

[Former Member]

Hi Daniel ,

sorry i didnt get u properly... do u want to know the table in which the e-mail id is stored or u want to add gthe e-mail address to a customer....

if u want to know the table.. get field ADRNR from KNA1 and with that address number u can get the e-mail id from the table ADR6

regards

shankar

[Former Member]

Check KNA1 table

in that table you will find field with ADR6 here all the email ids u have maintained can be seen