reg vendor master

[Former Member]

hai to all,

could you please tell me in vendor master generation ie., xk01 at address view / communication block / .please let me know the data base table where these <b>email</b> id and <b>comments</b> line is stored.

asap

regards

vijay.j

[Former Member]

hai to all,

could you please tell me in vendor master generation ie., xk01 at address view / communication block / .please let me know the data base table where these <b>email</b> id and <b>comments</b> line is stored.

asap

regards

vijay.j

[Former Member]

Usually the email address is stored in the ADR6 table for a given ADRNR. The Address number (ADRNR) is stored in LFA1 table.

Regards,

Ravi

Note : Please mark all the helpful answers

[Former Member]

hai ravi

thank you

just now i found the tables

email in ADR6

Comments in ADRCT

regards

vijay

[Former Member]

Vijay,

As you have the solution now, please mark the helpful answers and close the thread, by choosing "Solved the problem".

Regards,

Ravi

[Former Member]

Hi,

From LFA1 table, get the ADRNR field value by passing LIFNR(Vendor number ) to LFA1-LIFNR, pass LFA1-ADRNR value to ADR6 table Address number and get the email address, the field is SMTP_ADDR,

Hope this helps,

Rgds,