A query to obtain the communication data (t.code XD03)

[Former Member]

Hi All,

I have to create a query to extract the comunication data (mainly email) for each customer.

Which table or database should I use ?

Thanks

gandalf

[Former Member]

Hi,

List of tables in which email ids are stored SRIRAGRP, ECAMIOPREMAIL, ADR6, TO24, ADR6S, ADR6S, EFISEL, USR21.

Cheers!!

VEnk@

[Former Member]

ADR6 is the table that stores the email address. You will have to query this from the table where ADR&-ADRNR = KNA1-ADNNR.

regards,

Advait