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

[Former Member]

Hi

Database table :LFA1 Vendor Master (General Section)

With Regards

Nikunj Shah

[Former Member]

check out the table with ADR__ will get all the details in here.....

regards,

babu

[Former Member]

hi,

check in LFA1 table

regards,

srilatha

[Former Member]

Hi srinivas kodukula,

Check the following table,,,

LFA1 - Vendor Master (General Section)

Hope it is helps.

Regards,

T.Durai murugan.

[Former Member]

Hi,

pass adrnr to ADRC table u can get..

[former_member186143]

LFA1