1. Home
  2. Resources
  3. SAP Tables
  4. KNB1 - Customer Master (Company Code)

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
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
X Yes
NULL No
LOEVM Deletion Flag for Master Record (Company Code Level) LOEVM_B CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
ZAMIV Indicator: payment notice to sales department? DZAMIV CHAR 1 0
X Yes
NULL No
ZAMIR Indicator: payment notice to legal department? DZAMIR CHAR 1 0
X Yes
NULL No
ZAMIB Indicator: Payment notice to the accounting department ? DZAMIB CHAR 1 0
X Yes
NULL No
ZAMIO Indicator: payment notice to customer (w/o cleared items)? DZAMIO CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
01 1 month
02 2 months
03 3 months
04 4 months
05 5 months
06 6 months
07 7 months
08 8 months
09 9 months
10 10 months
11 11 months
12 12 months
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
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
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
X Without E-mail
Y With E-mail
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
X Yes
NULL No
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 MANDT TCESSION Accounts Receivable Pledging CLIENT
KNB1 CESSION_KZ KNB1 BUKRS TCESSION Accounts Receivable Pledging COMPANY
KNB1 CESSION_KZ KNB1 CESSION_KZ TCESSION Accounts Receivable Pledging CESSION_KZ
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 MANDT KNA1 General Data in Customer Master MANDT
KNB1 KNRZE KNB1 KNRZE KNA1 General Data in Customer Master KUNNR
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 MANDT T049L Lockboxes at our House Banks MANDT
KNB1 LOCKB KNB1 BUKRS T049L Lockboxes at our House Banks BUKRS
KNB1 LOCKB KNB1 LOCKB T049L Lockboxes at our House Banks LOCKB
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 BUKRS T043G Tolerances for Groups of Customers/Vendors BUKRS
KNB1 TOGRU KNB1 TOGRU T043G Tolerances for Groups of Customers/Vendors TOGRU
KNB1 TOGRU KNB1 MANDT T043G Tolerances for Groups of Customers/Vendors MANDT
KNB1 URLID KNB1 URLID T052A Known/Negotiated Leave URLID
KNB1 URLID KNB1 MANDT T052A Known/Negotiated Leave MANDT
KNB1 UZAWE KNB1 MANDT T042F Payment method supplements MANDT
KNB1 UZAWE KNB1 UZAWE T042F Payment method supplements UZAWE
KNB1 VRSDG KNB1 MANDT T053V Reason Code Conversion Version MANDT
KNB1 VRSDG KNB1 VRSDG T053V Reason Code Conversion Version VRSDG
KNB1 VZSKZ KNB1 VZSKZ T056 Interest settlement VZSKZ
KNB1 VZSKZ KNB1 MANDT T056 Interest settlement MANDT
KNB1 WBRSL * T044G Valuation Adjustment Key OVDUE
KNB1 WBRSL * T044G Valuation Adjustment Key FUTURE
KNB1 WBRSL KNB1 MANDT T044G Valuation Adjustment Key MANDT
KNB1 WBRSL KNB1 WBRSL T044G Valuation Adjustment Key WBRSL
KNB1 WBRSL * T044G Valuation Adjustment Key BWBER
KNB1 WBRSL * T044G Valuation Adjustment Key LAND1
KNB1 XAUSZ KNB1 XAUSZ T048K Indicator for Periodic Account Statements XAUSZ
KNB1 XAUSZ KNB1 MANDT T048K Indicator for Periodic Account Statements MANDT
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