Report on Blocked Customer

[Former Member]

Dear Guru's

How do I get the report on blocked Customers.

Customer Blocked / Unblocked

1 Y

2 N

3 Y

4 Y

Please guide me.

If I can get it through Query report which table Should I refer.

regards,

Amlan Sarkar

[Former Member · Accepted solution]

You may query results from customer master table KNA1 (central). But, there is no specific fiedl that may give you result as expected directly.

Here are few fields that may interest you:

AUFSD: Central order block for customer

FAKSD: Central billing block for customer

LIFSD: Central delivery block for the customer

SPERR: Central posting block

SPERZ: Payment Block

If you are not looking at central customer matser, you may consider table KNB1 for customers at compnay code level, or KNVV for customers at sales area level.

Hope it helps