vendor - countries - prices

[Former Member]

Hallo Gurus

I need to put in file following datas:

Material nr / material name / vendor of material /

and I have found it in few tables but...

in my case we have more than one vendor of single material - how to separate them ?

example

material XXX / name YYY / vendor ZZZ / price 111

material XXX / name YYY / vendor XXX / price 222

thesame material, other vendors and diferent prices - what is name of tables with vendors and field COUNTRY in it? becouse our vendors are from diferent countries...

thx

[Former Member · Accepted solution]

HI CHECK THE TABLE

EKAN Vendor Address: Purchasing Document

LFA1 Vendor Master (General Section)

LFAS Vendor master (VAT registration numbers general section)

LFAT Vendor master record (tax groupings)

LFB1 Vendor Master (Company Code)

LFB5 Vendor master (dunning data)

LFBK Vendor Master (Bank Details)