Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Regarding master tables

Former Member

‎2008 May 15 10:57 AM

0 Likes
867

Hello,

What is the difference between the Kna1 and Knb1 table.

Now i want to see the blocked kustomers information from

BSID. So what conditions i can apply to fetch the data from this.And what are the fields i have to select from kna1 or knb1.

Thank you

2 REPLIES 2
Read only

Former Member

‎2008 May 15 11:11 AM

0 Likes
600

KNA1 - Has the all general customer releavnt data

KNB1 - Has the Customer data based on the company code

Read only

Former Member

‎2008 May 15 11:20 AM

0 Likes
600

Hi,

1.check the report RFDKVZ00 (transaction: S_ALR_87012179).

2.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.

Difference :

KNA1--General Data in Customer Master

KNB1-->Customer Master (Company Code)

Regards,

Shiva