Database table for vendor data

[Former Member]

Hi,

what is database table which stores the vendor email id, fax number, telephone extn number.

[former_member125931 · Accepted solution]

Yes it is LFA1,please close your thread.

[Former Member · Accepted solution]

Hi,

Can you just tell me the fiels name in LFA1 table which stores the mail id, fax number and telephone extn number.

[Former Member · Accepted solution]

Telephone ->TELBX

Fax ->TELFX

Hope it helps

[Former Member · Accepted solution]

ADR6 you will get the email

[former_member125931 · Accepted solution]

Join the tables LFA1 and ADR6 by using the field (ADRNR in lfa1 and ADDRNUMBER in adr6) for mailid: ADR6-SMTP_ADDR

and remaining from LFA1

fax number :TELFX

telephone extn number : TELBX

TELF1

TELF2

Edited by: SnickyUcan on Jul 16, 2008 12:32 PM

[former_member125931 · Accepted solution]

Hi Srinivas,

Is your problem solved???

let me know if you struck some where.

[Former Member · Accepted solution]

Hi,

thanks for your information.

its giving