topic Re: Regarding master tables in Application Development and Automation Discussions

Regarding master tables

Former Member — Thu, 15 May 2008 09:57:25 GMT

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

Re: Regarding master tables

Former Member — Thu, 15 May 2008 10:11:47 GMT

KNA1 - Has the all general customer releavnt data

KNB1 - Has the Customer data based on the company code

Re: Regarding master tables

Former Member — Thu, 15 May 2008 10:20:55 GMT

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