SAP Table KNB1
Customer Master (Company Code)
What Is the SAP KNB1 Table?
SAP KNB1 table stores the company code specific data of customer master records in Financial Accounting. The Information in KNB1 is maintained separately for each company code in which the customer is used.
Customer Master Data in SAP is maintained at different organization levels and stored in different tables
- KNA1: Customer Master General Data
- KNB1: Customer Master Company Code Data
- KNVV: Customer Master Sales Area Data
KNB1 contains Financial Accounting information such as Reconciliation account, payment terms, payment methods, payment block and dunning related setting and company code specific customer master data.
For Example:
When a customer invoice is posted using transaction code FB70, after entering the company code and customer number, SAP system automatically derives the customer general information from KNA1 and company code specific information from KNB1.
After posting, the customer accounting document information is stored in BKPF and BSEG table. The unpaid item information is stored in BSID table, and once cleared corresponding clearing items information available in BSAD table.
Simple Business Process flow:
Customer + Company Code → KNA1 General Data → KNB1 Company Code Data → BKPF/BSEG Accounting Document → BSID Open Item → BSAD Cleared Item.
In SAP S/4HANA, Business Partner (BP) is used to maintain customer master data with Business Partner Roles.
Quick overview
| SAP table | KNB1 |
|---|---|
| Short description | Customer Master (Company Code) |
| Table type | Transparent table |
| Primary key | MANDT (Client), KUNNR (Customer Number), BUKRS (Company Code) |
| Client-dependent | Yes |
Important fields explained
| Field | SAP field description | What this field means |
|---|---|---|
KUNNR |
Customer Number | Customer Number that identifies the customer master record |
BUKRS |
Company Code | Company Code for which the customer specific financial accounting data is maintained |
ZUAWA |
Key for sorting according to assignment numbers | Sort key used to determine how the assignment field is populated in the customer accounting line items |
AKONT |
Reconciliation Account in General Ledger | Reconciliation account assigned to the customer account |
ZTERM |
Terms of Payment Key | Terms of payment key used to determine payment due dates and cash discounts for the customers |
ZWELS |
List of Respected Payment Methods | Payment methods allowed for the customer in the specified company code |
At a glance
- Module
- Financial Accounting
- Application component
- LOGISTICS - GENERAL LO
- Subcomponent
- LOGISTICS BASIC DATA LO-MD
- Specific component
- BUSINESS PARTNERS LO-MD-BP
- Component level 4
- CUSTOMER MASTER LO-MD-BP-CM
Technical details
- Delivery class
- A (Application table: master and transaction data)
- Data class
- APPL0 (Master Data, Transparent Tables)
- Package
- Application development R/3 sales master data (VSCORE)
Primary key fields
| Field | Description | Data element | Type | Length |
|---|---|---|---|---|
MANDT
|
Client | MANDT | CLNT | 3 |
KUNNR
|
Customer Number | KUNNR | CHAR | 10 |
BUKRS
|
Company Code | BUKRS | CHAR | 4 |
Table fields
92 fields
92 fields
| Field | Description | Data element | Domain | Type | Length | Decimals | Check table |
|---|---|---|---|---|---|---|---|
MANDT
Key
|
Client | MANDT | MANDT | CLNT | 3 | — | T000 |
KUNNR
Key
|
Customer Number | KUNNR | KUNNR | CHAR | 10 | — | KNA1 |
BUKRS
Key
|
Company Code | BUKRS | BUKRS | CHAR | 4 | — | T001 |
PERNR
|
Personnel Number | PERNR_D | PERNR | NUMC | 8 | — | |
KNB1_EEW_CC
|
Extensibility enabled for Company Code | KNB1_EEW_CC | KNB1_EEW_CC | CHAR | 1 | — | |
ERDAT
|
Record Created On | ERDAT_RF | DATUM | DATS | 8 | — | |
ERNAM
|
Name of Person who Created the Object | ERNAM_RF | USNAM | CHAR | 12 | — | |
SPERR
|
Posting block for company code | SPERB_B | XFELD | CHAR | 1 | — | |
LOEVM
|
Deletion Flag for Master Record (Company Code Level) | LOEVM_B | XFELD | CHAR | 1 | — | |
ZUAWA
|
Key for sorting according to assignment numbers | DZUAWA | ZUAWA | CHAR | 3 | — | TZUN |
BUSAB
|
Accounting Clerk Abbreviation | BUSAB | BUSAB | CHAR | 2 | — | T001S |
AKONT
|
Reconciliation Account in General Ledger | AKONT | SAKNR | CHAR | 10 | — | SKB1 |
BEGRU
|
Authorization Group | BRGRU | BRGRU | CHAR | 4 | — | |
KNRZE
|
Head Office Account Number (in branch accounts) | KNRZE | KUNNR | CHAR | 10 | — | KNA1 |
KNRZB
|
Account number of an alternative payer | KNRZB | KUNNR | CHAR | 10 | — | KNA1 |
ZAMIM
|
Indicator: Payment Notice to Customer (with Cleared Items)? | DZAMIM | XFELD | CHAR | 1 | — | |
ZAMIV
|
Indicator: Payment Notice to Sales Department? | DZAMIV | XFELD | CHAR | 1 | — | |
ZAMIR
|
Indicator: Payment Notice to Legal Department? | DZAMIR | XFELD | CHAR | 1 | — | |
ZAMIB
|
Indicator: Payment Notice to the Accounting Department? | DZAMIB | XFELD | CHAR | 1 | — | |
ZAMIO
|
Indicator: Payment Notice to Customer (W/o Cleared Items)? | DZAMIO | XFELD | CHAR | 1 | — | |
ZWELS
|
List of Respected Payment Methods | DZWELS | ZWELS | CHAR | 10 | — | |
XVERR
|
Indicator: Clearing between customer and vendor ? | XVERR_KNB1 | XFELD | CHAR | 1 | — | |
ZAHLS
|
Block Key for Payment | DZAHLS | ZAHLS | CHAR | 1 | — | T008 |
ZTERM
|
Terms of Payment Key | DZTERM | ZTERM | CHAR | 4 | — | |
WAKON
|
Terms of Payment Key for Bill of Exchange Charges | WAKON | ZTERM | CHAR | 4 | — | |
VZSKZ
|
Interest Indicator | VZSKZ | VZSKZ | CHAR | 2 | — | T056 |
ZINDT
|
Key Date of Last Interest Calculation | DZINDT | DATUM | DATS | 8 | — | |
ZINRT
|
Interest Calculation Frequency in Months | DZINRT | ZINRT | NUMC | 2 | — | |
EIKTO
|
Our account number at customer | EIKTO_D | CHAR12 | CHAR | 12 | — | |
ZSABE
|
User at customer | DZSABE_D | TEXT15 | CHAR | 15 | — | |
KVERM
|
Memo | KVERM | TEXT30 | CHAR | 30 | — | |
FDGRV
|
Planning Group | FDGRV | FDGRP | CHAR | 10 | — | T035 |
VRBKZ
|
Export Credit Insurance Institution Number | VRBKZ | VRBKZ | CHAR | 2 | — | |
VLIBB
|
Amount Insured | VLIBB_CS | WERT7 | CURR | 13 | 2 | |
VRSZL
|
Insurance Lead Months | VRSZL | PACK2 | DEC | 3 | 0 | |
VRSPR
|
Deductible Percentage Rate | VRSPR | PACK2 | DEC | 3 | 0 | |
VRSNR
|
Insurance Number | VRSNR | CHAR10 | CHAR | 10 | — | |
VERDT
|
Insurance Validity Date | VERDT | DATUM | DATS | 8 | — | |
PERKZ
|
Collective Invoice Variant | PERKZ_KNB1 | PERKZ_KNB1 | CHAR | 1 | — | |
XDEZV
|
Indicator: Local Processing? | XDEZV | XFELD | CHAR | 1 | — | |
XAUSZ
|
Indicator for Periodic Account Statements | XAUSZ | AUSZG | CHAR | 1 | — | T048K |
WEBTR
|
Bill of Exchange Limit (in Local Currency) | WEBTR_CS | WERT7 | CURR | 13 | 2 | |
REMIT
|
Next payee | REMIT | KUNNR | CHAR | 10 | — | KNA1 |
DATLZ
|
Date of Last Interest Calculation Run | DATLZ | DATUM | DATS | 8 | — | |
XZVER
|
Indicator: Record Payment History ? | XZVER | XFELD | CHAR | 1 | — | |
TOGRU
|
Tolerance Group for Business Partner/G/L Account | TOGRU | TOGRU | CHAR | 4 | — | T043G |
KULTG
|
Probable Time Until Check Is Paid | KULTG | PACK2 | DEC | 3 | 0 | |
HBKID
|
Short Key for a House Bank | HBKID | HBKID | CHAR | 5 | — | T012 |
XPORE
|
Indicator: Pay All Items Separately? | XPORE | XFELD | CHAR | 1 | — | |
BLNKZ
|
(Obsolete) Subsidy Ind. for Determining the Reduction Rate | BLNKZ | BLNKZ | CHAR | 2 | — | |
ALTKN
|
Previous Master Record Number | ALTKN | CHAR10 | CHAR | 10 | — | |
ZGRUP
|
Key for Payment Grouping | DZGRUP | ZGRUP | CHAR | 2 | — | TZGR |
URLID
|
Short Key for Known/Negotiated Leave | URLID | URLID | CHAR | 4 | — | T052A |
MGRUP
|
Key for Dunning Notice Grouping | MGRUP | MGRUP | CHAR | 2 | — | T047R |
LOCKB
|
Key of the Lockbox to Which the Customer Is to Pay | LOCKB | LCKID | CHAR | 7 | — | T049L |
UZAWE
|
Payment method supplement | UZAWE | UZAWE | CHAR | 2 | — | T042F |
EKVBD
|
Account Number of Buying Group | EKVBD | KUNNR | CHAR | 10 | — | KNA1 |
SREGL
|
Selection Rule for Payment Advices | SREGL | SREGL | CHAR | 3 | — | T053A |
XEDIP
|
Indicator: Send Payment Advices by EDI | XEDIP | XFELD | CHAR | 1 | — | |
FRGRP
|
Release Approval Group | FRGRP | FRGRP | CHAR | 4 | — | VBWF08 |
VRSDG
|
Reason Code Conversion Version | VRSDG | VRSDG | CHAR | 3 | — | T053V |
TLFXS
|
Accounting clerk's fax number at the customer/vendor | TLFXS | TEXT31 | CHAR | 31 | — | |
INTAD
|
Internet address of partner company clerk | INTAD | TXT130 | CHAR | 130 | — | |
XKNZB
|
Indicator: Alternative Payer Using Account Number | XKNZB | XFELD | CHAR | 1 | — | |
GUZTE
|
Payment Terms Key for Credit Memos | GUZTE | ZTERM | CHAR | 4 | — | |
GRICD
|
Activity Code for Gross Income Tax | J_1AGICD_D | J_1AGICD2 | CHAR | 2 | — | J_1AGICD |
GRIDT
|
Distribution Type for Employment Tax | J_1ADTYP_D | J_1ADTYP | CHAR | 2 | — | J_1ADTYP |
WBRSL
|
Value Adjustment Key | WBRSL | WBRSL | CHAR | 2 | — | T044G |
CONFS
|
Status of Change Authorization (Company Code Level) | CONFS_B | CHAR1 | CHAR | 1 | — | |
UPDAT
|
Date on Which the Changes Were Confirmed | UPDAT_RF | DATUM | DATS | 8 | — | |
UPTIM
|
Time of Last Change Confirmation | UPTIM_RF | AS4TIME | TIMS | 6 | — | |
NODEL
|
Deletion bock for master record (company code level) | NODEL_B | XFELD | CHAR | 1 | — | |
TLFNS
|
Accounting clerk's telephone number at business partner | TLFNS | CHAR30 | CHAR | 30 | — | |
CESSION_KZ
|
Accounts Receivable Pledging Indicator | CESSION_KZ | CESSION_KZ | CHAR | 2 | — | TCESSION |
AVSND
|
Indicator: Send Payment Advice by XML | AVSND | AVSND | CHAR | 1 | — | |
AD_HASH
|
E-Mail Address for Avis: Hash Value | ADHASH | ADHASH | CHAR | 10 | — | |
QLAND
|
Withholding Tax Country/Region Key | QLAND | QLAND | CHAR | 3 | — | T005Q |
CVP_XBLCK_B
|
Business Purpose Completed Flag | CVP_XBLCK | CVP_XBLCK | CHAR | 1 | — | |
CIIUCODE
|
Main economic activity | CIIUCODE | CIIUCODE | NUMC | 4 | — | |
PAYMENTCLEARINGGRPID
|
Payment Clearing Group ID | FAR_PAYMENT_CLEARING_GROUP | FAR_PAYMENT_CLEARING_GROUP | CHAR | 8 | — | FAR_PYMT_CLG_GRP |
PAYTRSN
|
Payment Reason | FARP_PAYT_RSN | FARP_PAYT_RSN | CHAR | 4 | — | |
GMVKZD
|
Customer is in execution | GMVKZD | XFELD | CHAR | 1 | — | |
US_REC_COUNTRY
|
Country/Region Key | LAND1 | LAND1 | CHAR | 3 | — | |
US_GIIN
|
US Recipient GIIN | FIWTUS_RECIPIENT_GIIN | — | CHAR | 19 | — | |
US_FTID
|
US Recipient Foreign Tax ID | FIWTUS_RECIPIENT_FTID | — | CHAR | 22 | — | |
US_LOB_CODE
|
LOB Treaty Code | FIWTUS_LOB_CODE | — | CHAR | 2 | — | |
US_W8_RECVDATE
|
US W8 Form Received Date | FIWTUS_W8_RECV_DATE | DATUM | DATS | 8 | — | |
US_W9_RECVDATE
|
US W8 Form Received Date | FIWTUS_W9_RECV_DATE | DATUM | DATS | 8 | — | |
US_TIN_NOTICE
|
Second TIN Notice from IRS | FIWTUS_SECOND_TIN_NOTICE | BOOLEAN | CHAR | 1 | — | |
US_PARTNERSHIP_IND
|
Partnership Interest Indicator | FIWTUS_PARTNERSHIP_IND | BOOLEAN | CHAR | 1 | — | |
US_FATCA_IND
|
US FATCA Indicator | FIWTUS_FATCA_IND | BOOLEAN | CHAR | 1 | — | |
US_CHAP4_STATUS_CODE
|
US Chapter 4 Status Code | FIWTUS_CHAP4_STATUS_CODE | — | CHAR | 2 | — |
No fields match the selected filters.
SAP KNB1 Table Availability
| SAP product | Verified release/system | Table availability | Verified on |
|---|---|---|---|
| SAP S/4HANA | 2023 - On-Premise - Initial Shipment Stack | Available |
Related SAP Tables
| Table | Description | Common Key Fields with KNB1 |
|---|---|---|
| SKB1 | G/L account master (company code) | MANDT, BUKRS |
| T001 | Company Codes | MANDT, BUKRS |
| KNA1 | General Data in Customer Master | MANDT, KUNNR |
| T052 | Terms of Payment | MANDT |
| KNB5 | Customer master (dunning data) | MANDT, KUNNR, BUKRS |
Fields marked as primary keys in both tables. Additional fields or filters may be needed when joining records.
Editorial and verification
- Content editor
- ERPSAP Content Team
- Technical reviewer
- ERPSAP Technical Review Team
- Verified against
- SAP S/4HANA 2023 On-Premise system
- Last updated
- October 7, 2026
The information on this SAP KNB1 table page is based on the verified SAP S/4HANA 2023 on-premise system identified above. Table definitions, fields, and availability may differ across SAP releases and customer-specific systems.