what are the tables and fields which are affected on blocking vendor/custom

[Former Member]

Guys!

what are the tables and fields which are affected on blocking vendor/customer either financially or centrally...

Please help me asap.

[Former Member · Accepted solution]

Hi,

Check tables: KNA1 & KNB1 for customer.

LFA1 & LFB1 for vendor .

Transaction: XK03 for vendor master display.

If you go through this you will find a field which will be a indicator will block the vendor/customer.

Right now I am not on the system to exactly to field level.

Thanks,

Deepak.

[former_member187255]

Check these tables for Blocking/Deleting Vendor

Vendor Master (General Section)

LFA1-SPERQ

LFA1-SPERR

LFA1-SPERM

LFA1-LOEVM

LFA1-NODEL

Vendor Master (Company Code)

LFB1-SPERR

LFB1-LOEVM

LFB1-NODEL

Vendor master record purchasing organization data

LFM1-SPERM

LFM1-LOEVM

Hope this helps..

Chandra.

[Former Member]

guys! i need fields tooo.

[Former Member]

Below fields will update and according to this fields ,the other tables will effect.

Vendor :

lfa1-SPERR

lfa1-SPERM

customer :

kna1-AUFSD

KNA1-FAKSD

KNA1-LIFSD

Thanks

Seshu

[Former Member]

It is effecting only KNA1 ,KNb1 and KNVV -> customer master

LFA1,LFb1 and LFm1 Tables for Vendor master

Thanks

Seshu