Table of Vendor's E-mail ?

[Former Member]

Hi,

What is the table of Vendor's E-mail ?

in XK03 i find :

Table : ADDR1_DATA (Structure)

Field : EXTENSION2

Please help

Regards.

[iklovski · Accepted solution]

Hi,

The table is ADR6. You link between this table and vendors table by ADDRNUMBER field.

Regards,

Eli

P.S. SZA1_D0100 mentioned in other answer is not a table.

[former_member182098]

Hello,

You have to join two tables LFA1 and ADR6 (ADRNR and ADDRNUMBER respectively) in SQ00 or FQUK

You have to create a query.

Create the data source type is: Table Join

Remove all other Joining links.

You will get the email address for all the vendors.

If you have any issue, let me know.

Thanks,

Ravi

[Former Member]

Hi

Table name-SZA1_D0100

Field Name-SMTP_ADDR

Regards

Arun M

[Former Member]

Thanks Arun, but when i enter the Table SZA1_D0100 in SE16N i have this error message : "Table SZA1_D0100 is not the correct category"

Please any other suggestions.

[iklovski]

Refer to my answer.

[Former Member]

ok i'll check