SAP Table KNB1
Customer Master (Company Code)
KNB1 (Customer Master (Company Code)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link KNB1 to other SAP tables.
KNB1 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||||||||||
|
KUNNR
Customer Number
|
KUNNR | KNA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
PERNR
Personnel Number
|
PERNR_D |
NUMC
|
8 | 0 | ||||||||||||||||||||||||||||
|
ERDAT
Date on which the Record Was Created
|
ERDAT_RF |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM_RF |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||
|
SPERR
Posting block for company code
|
SPERB_B |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
LOEVM
Deletion Flag for Master Record (Company Code Level)
|
LOEVM_B |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
ZUAWA
Key for sorting according to assignment numbers
|
DZUAWA | TZUN |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||
|
BUSAB
Accounting clerk
|
BUSAB | T001S |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
AKONT
Reconciliation Account in General Ledger
|
AKONT | SKB1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
BEGRU
Authorization Group
|
BRGRU |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||
|
KNRZE
Head office account number (in branch accounts)
|
KNRZE | KNA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
KNRZB
Account number of an alternative payer
|
KNRZB | KNA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
ZAMIM
Indicator: Payment notice to customer (with cleared items)?
|
DZAMIM |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
ZAMIV
Indicator: payment notice to sales department?
|
DZAMIV |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
ZAMIR
Indicator: payment notice to legal department?
|
DZAMIR |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
ZAMIB
Indicator: Payment notice to the accounting department ?
|
DZAMIB |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
ZAMIO
Indicator: payment notice to customer (w/o cleared items)?
|
DZAMIO |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
ZWELS
List of the Payment Methods to be Considered
|
DZWELS |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||
|
XVERR
Indicator: Clearing between customer and vendor ?
|
XVERR_KNB1 |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
ZAHLS
Block Key for Payment
|
DZAHLS | T008 |
CHAR
|
1 | 0 | |||||||||||||||||||||||||||
|
ZTERM
Terms of Payment Key
|
DZTERM |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||
|
WAKON
Terms of payment key for bill of exchange charges
|
WAKON |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||
|
VZSKZ
Interest calculation indicator
|
VZSKZ | T056 |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
ZINDT
Key date of the last interest calculation
|
DZINDT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||
|
ZINRT
Interest calculation frequency in months
|
DZINRT |
NUMC
|
2 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
EIKTO
Our account number at customer
|
EIKTO_D |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||
|
ZSABE
User at customer
|
DZSABE_D |
CHAR
|
15 | 0 | ||||||||||||||||||||||||||||
|
KVERM
Memo
|
KVERM |
CHAR
|
30 | 0 | ||||||||||||||||||||||||||||
|
FDGRV
Planning group
|
FDGRV | T035 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
VRBKZ
Export credit insurance institution number
|
VRBKZ |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||
|
VLIBB
Amount Insured
|
VLIBB |
CURR
|
13 | 2 | ||||||||||||||||||||||||||||
|
VRSZL
Insurance lead months
|
VRSZL |
DEC
|
3 | 0 | ||||||||||||||||||||||||||||
|
VRSPR
Deductible percentage rate
|
VRSPR |
DEC
|
3 | 0 | ||||||||||||||||||||||||||||
|
VRSNR
Insurance number
|
VRSNR |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||
|
VERDT
Insurance validity date
|
VERDT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||
|
PERKZ
Collective invoice variant
|
PERKZ_KNB1 |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
XDEZV
Indicator: Local processing?
|
XDEZV |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
XAUSZ
Indicator for periodic account statements
|
XAUSZ | T048K |
CHAR
|
1 | 0 | |||||||||||||||||||||||||||
|
WEBTR
Bill of exchange limit (in local currency)
|
WEBTR |
CURR
|
13 | 2 | ||||||||||||||||||||||||||||
|
REMIT
Next payee
|
REMIT | KNA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
DATLZ
Date of the last interest calculation run
|
DATLZ |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||
|
XZVER
Indicator: Record Payment History ?
|
XZVER |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
TOGRU
Tolerance group for the business partner/G/L account
|
TOGRU | T043G |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
KULTG
Probable time until check is paid
|
KULTG |
DEC
|
3 | 0 | ||||||||||||||||||||||||||||
|
HBKID
Short Key for a House Bank
|
HBKID | T012 |
CHAR
|
5 | 0 | |||||||||||||||||||||||||||
|
XPORE
Indicator: Pay all items separately ?
|
XPORE |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
BLNKZ
Subsidy indicator for determining the reduction rates
|
BLNKZ |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||
|
ALTKN
Previous Master Record Number
|
ALTKN |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||
|
ZGRUP
Key for Payment Grouping
|
DZGRUP | TZGR |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
URLID
Short Key for Known/Negotiated Leave
|
URLID | T052A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
MGRUP
Key for dunning notice grouping
|
MGRUP | T047R |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
LOCKB
Key of the Lockbox to Which the Customer Is To Pay
|
LOCKB | T049L |
CHAR
|
7 | 0 | |||||||||||||||||||||||||||
|
UZAWE
Payment Method Supplement
|
UZAWE | T042F |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
EKVBD
Account Number of Buying Group
|
EKVBD | KNA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
SREGL
Selection Rule for Payment Advices
|
SREGL | T053A |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||
|
XEDIP
Indicator: Send Payment Advices by EDI
|
XEDIP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
FRGRP
Release Approval Group
|
FRGRP | VBWF08 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
VRSDG
Reason Code Conversion Version
|
VRSDG | T053V |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||
|
TLFXS
Accounting clerk's fax number at the customer/vendor
|
TLFXS |
CHAR
|
31 | 0 | ||||||||||||||||||||||||||||
|
INTAD
Internet address of partner company clerk
|
INTAD |
CHAR
|
130 | 0 | ||||||||||||||||||||||||||||
|
XKNZB
Indicator: Alternative payer using account number
|
XKNZB |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
GUZTE
Payment Terms Key for Credit Memos
|
GUZTE |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||
|
GRICD
Activity Code for Gross Income Tax
|
J_1AGICD_D | J_1AGICD |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
GRIDT
Distribution Type for Employment Tax
|
J_1ADTYP_D | J_1ADTYP |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
WBRSL
Value Adjustment Key
|
WBRSL | T044G |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
CONFS
Status of Change Authorization (Company Code Level)
|
CONFS_B |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
UPDAT
Date on Which the Changes Were Confirmed
|
UPDAT_RF |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||
|
UPTIM
Time of Last Change Confirmation
|
UPTIM_RF |
TIMS
|
6 | 0 | ||||||||||||||||||||||||||||
|
NODEL
Deletion bock for master record (company code level)
|
NODEL_B |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
TLFNS
Accounting clerk's telephone number at business partner
|
TLFNS |
CHAR
|
30 | 0 | ||||||||||||||||||||||||||||
|
CESSION_KZ
Accounts Receivable Pledging Indicator
|
CESSION_KZ | TCESSION |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
AVSND
Indicator: Send Payment Advice by XML
|
AVSND |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
AD_HASH
E-Mail Address for Avis: Hash Value
|
ADHASH |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||
|
QLAND
Withholding Tax Country Key
|
QLAND | T005Q |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||
|
GMVKZD
Customer is in execution
|
GMVKZD |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
INTERCOCD
Intercompany code
|
OIU_INTERCOCD | T001 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
KNB1 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| KNB1 | AKONT | KNB1 | MANDT |
SKB1
G/L account master (company code)
|
MANDT |
| KNB1 | AKONT | KNB1 | BUKRS |
SKB1
G/L account master (company code)
|
BUKRS |
| KNB1 | AKONT | KNB1 | AKONT |
SKB1
G/L account master (company code)
|
SAKNR |
| KNB1 | BUKRS | KNB1 | MANDT |
T001
Company Codes
|
MANDT |
| KNB1 | BUKRS | KNB1 | BUKRS |
T001
Company Codes
|
BUKRS |
| KNB1 | BUSAB | KNB1 | MANDT |
T001S
Accounting Clerks
|
MANDT |
| KNB1 | BUSAB | KNB1 | BUKRS |
T001S
Accounting Clerks
|
BUKRS |
| KNB1 | BUSAB | KNB1 | BUSAB |
T001S
Accounting Clerks
|
BUSAB |
| KNB1 | CESSION_KZ | KNB1 | BUKRS |
TCESSION
Accounts Receivable Pledging
|
COMPANY |
| KNB1 | CESSION_KZ | KNB1 | CESSION_KZ |
TCESSION
Accounts Receivable Pledging
|
CESSION_KZ |
| KNB1 | CESSION_KZ | KNB1 | MANDT |
TCESSION
Accounts Receivable Pledging
|
CLIENT |
| KNB1 | EKVBD | KNB1 | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| KNB1 | EKVBD | KNB1 | EKVBD |
KNA1
General Data in Customer Master
|
KUNNR |
| KNB1 | FDGRV | KNB1 | MANDT |
T035
Planning groups
|
MANDT |
| KNB1 | FDGRV | KNB1 | FDGRV |
T035
Planning groups
|
GRUPP |
| KNB1 | FRGRP | KNB1 | MANDT |
VBWF08
Release Groups
|
MANDT |
| KNB1 | FRGRP | KNB1 | FRGRP |
VBWF08
Release Groups
|
FRGRP |
| KNB1 | GRICD | KNB1 | MANDT |
J_1AGICD
Activity codes for gross income tax declaration
|
MANDT |
| KNB1 | GRICD | T001 | LAND1 |
J_1AGICD
Activity codes for gross income tax declaration
|
LAND1 |
| KNB1 | GRICD | KNB1 | GRICD |
J_1AGICD
Activity codes for gross income tax declaration
|
J_1AGICD |
| KNB1 | GRIDT | KNB1 | MANDT |
J_1ADTYP
Distribution Types for Gross Income Tax
|
MANDT |
| KNB1 | GRIDT | KNB1 | BUKRS |
J_1ADTYP
Distribution Types for Gross Income Tax
|
BUKRS |
| KNB1 | GRIDT | KNB1 | GRIDT |
J_1ADTYP
Distribution Types for Gross Income Tax
|
J_1ADTYP |
| KNB1 | HBKID | KNB1 | MANDT |
T012
House Banks
|
MANDT |
| KNB1 | HBKID | KNB1 | BUKRS |
T012
House Banks
|
BUKRS |
| KNB1 | HBKID | KNB1 | HBKID |
T012
House Banks
|
HBKID |
| KNB1 | INTERCOCD | SYST | MANDT |
T001
Company Codes
|
MANDT |
| KNB1 | INTERCOCD | KNB1 | INTERCOCD |
T001
Company Codes
|
BUKRS |
| KNB1 | KNRZB | KNB1 | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| KNB1 | KNRZB | KNB1 | KNRZB |
KNA1
General Data in Customer Master
|
KUNNR |
| KNB1 | KNRZE | KNB1 | KNRZE |
KNA1
General Data in Customer Master
|
KUNNR |
| KNB1 | KNRZE | KNB1 | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| KNB1 | KUNNR | KNB1 | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| KNB1 | KUNNR | KNB1 | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| KNB1 | LOCKB | KNB1 | LOCKB |
T049L
Lockboxes at our House Banks
|
LOCKB |
| KNB1 | LOCKB | KNB1 | MANDT |
T049L
Lockboxes at our House Banks
|
MANDT |
| KNB1 | LOCKB | KNB1 | BUKRS |
T049L
Lockboxes at our House Banks
|
BUKRS |
| KNB1 | MANDT | KNB1 | MANDT |
T000
Clients
|
MANDT |
| KNB1 | MGRUP | KNB1 | MANDT |
T047R
Grouping rules for dunning notices
|
MANDT |
| KNB1 | MGRUP | KNB1 | MGRUP |
T047R
Grouping rules for dunning notices
|
MGRUP |
| KNB1 | QLAND | SYST | MANDT |
T005Q
Country Keys for Withholding Tax Calculation
|
MANDT |
| KNB1 | QLAND | T001 | LAND1 |
T005Q
Country Keys for Withholding Tax Calculation
|
LAND1 |
| KNB1 | QLAND | KNB1 | QLAND |
T005Q
Country Keys for Withholding Tax Calculation
|
QLAND |
| KNB1 | REMIT | KNB1 | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| KNB1 | REMIT | KNB1 | REMIT |
KNA1
General Data in Customer Master
|
KUNNR |
| KNB1 | SREGL | KNB1 | MANDT |
T053A
Selection Rules for Payment Advices
|
MANDT |
| KNB1 | SREGL | KNB1 | SREGL |
T053A
Selection Rules for Payment Advices
|
SREGL |
| KNB1 | TOGRU | KNB1 | MANDT |
T043G
Tolerances for Groups of Customers/Vendors
|
MANDT |
| KNB1 | TOGRU | KNB1 | BUKRS |
T043G
Tolerances for Groups of Customers/Vendors
|
BUKRS |
| KNB1 | TOGRU | KNB1 | TOGRU |
T043G
Tolerances for Groups of Customers/Vendors
|
TOGRU |
| KNB1 | URLID | KNB1 | MANDT |
T052A
Known/Negotiated Leave
|
MANDT |
| KNB1 | URLID | KNB1 | URLID |
T052A
Known/Negotiated Leave
|
URLID |
| KNB1 | UZAWE | KNB1 | UZAWE |
T042F
Payment method supplements
|
UZAWE |
| KNB1 | UZAWE | KNB1 | MANDT |
T042F
Payment method supplements
|
MANDT |
| KNB1 | VRSDG | KNB1 | MANDT |
T053V
Reason Code Conversion Version
|
MANDT |
| KNB1 | VRSDG | KNB1 | VRSDG |
T053V
Reason Code Conversion Version
|
VRSDG |
| KNB1 | VZSKZ | KNB1 | MANDT |
T056
Interest settlement
|
MANDT |
| KNB1 | VZSKZ | KNB1 | VZSKZ |
T056
Interest settlement
|
VZSKZ |
| KNB1 | WBRSL | KNB1 | WBRSL |
T044G
Valuation Adjustment Key
|
WBRSL |
| KNB1 | WBRSL | * |
T044G
Valuation Adjustment Key
|
BWBER | |
| KNB1 | WBRSL | * |
T044G
Valuation Adjustment Key
|
LAND1 | |
| KNB1 | WBRSL | * |
T044G
Valuation Adjustment Key
|
OVDUE | |
| KNB1 | WBRSL | * |
T044G
Valuation Adjustment Key
|
FUTURE | |
| KNB1 | WBRSL | KNB1 | MANDT |
T044G
Valuation Adjustment Key
|
MANDT |
| KNB1 | XAUSZ | KNB1 | MANDT |
T048K
Indicator for Periodic Account Statements
|
MANDT |
| KNB1 | XAUSZ | KNB1 | XAUSZ |
T048K
Indicator for Periodic Account Statements
|
XAUSZ |
| KNB1 | ZAHLS | KNB1 | MANDT |
T008
Blocking Reasons for Automatic Payment Transcations
|
MANDT |
| KNB1 | ZAHLS | KNB1 | ZAHLS |
T008
Blocking Reasons for Automatic Payment Transcations
|
ZAHLS |
| KNB1 | ZGRUP | KNB1 | ZGRUP |
TZGR
Grouping rules for automatic payments
|
ZGRUP |
| KNB1 | ZUAWA | KNB1 | ZUAWA |
TZUN
Rules for 'Allocation' Field Layout
|
ZUAWA |