Skip to Content
avatar image
Former Member

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

Guys!

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

Please help me asap.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 16, 2007 at 05:40 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2007 at 06:01 PM

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

    LFA1,LFb1 and LFm1 Tables for Vendor master

    Thanks

    Seshu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2007 at 06:19 PM

    guys! i need fields tooo.

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Aug 16, 2007 at 06:39 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded