table that links vendor and customer

[Former Member]

hi

is there any table that links vendor and customer, for example theres a vendor zz400, he can be a customer as well

do you know in which table we can find that?

[Former Member · Accepted solution]

ya there is a table that links customer and vendor.it is KLPA.the fields in this table are NKULI / NBUKR / NKOAR / PNTYP/ VKULI / VBUKR / VKOAR

[Former Member]

Hi Sia,

LFA1(Vendor Master), KNA1(Customer Master) can be linked using KUNNR (Customer Number) and LIFNR(Account Number of Vendor or Creditor)

LFA1-KUNNR = KNA1-KUNNR

LFA1-LIFNR = KNA1-LIFNR.

Regards,

Chandra Sekhar

[Former Member]

Sia

Check fields KNA1-KUNNR, KNA1-LIFNR, LFA1-LIFNR, LFA1-KUNNR..

Thanks

Amol Lohade

[Former Member]

Hi

Go through the link given below :

With Regards

Sandeep

[JozsefSzikszai]

hi,

it is stored in the master data:

LFA1-KUNNR = KNA1-KUNNR

and vica versa:

KNA1-LIFNR = LFA1-LIFNR

this is maintained through normal customer/vendor master data transactions (XD02, XK02)

hope this helps

ec