SAP Table E3KNB1M

Master customer master company code (KNB1)

E3KNB1M (Master customer master company code (KNB1)) 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 E3KNB1M to other SAP tables.

Source: E3KNB1M (Master customer master company code (KNB1))

E3KNB1M table fields

Field Data element Checktable Datatype Length Decimals
MSGFN Function MSGFN CHAR 3 0
003 Delete: Message contains objects to be deleted
004 Change: Message contains changes
005 Replace: This message replaces previous messages
009 Original: First message for process
023 Wait/Adjust: Data should not be imported
018 Resend
BUKRS Company Code BUKRS CHAR 4 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 CHAR 3 0
BUSAB Accounting clerk BUSAB CHAR 2 0
AKONT Reconciliation Account in General Ledger AKONT CHAR 10 0
BEGRU Authorization Group BRGRU CHAR 4 0
KNRZE Head office account number (in branch accounts) KNRZE CHAR 10 0
KNRZB Account number of an alternative payer KNRZB 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 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 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 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 CHAR 1 0
WEBTR Bill of exchange limit (in local currency) WEBTR CURR 13 2
REMIT Next payee REMIT 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 CHAR 4 0
KULTG Probable time until check is paid KULTG DEC 3 0
HBKID Short Key for a House Bank HBKID 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 CHAR 2 0
URLID Short Key for Known/Negotiated Leave URLID CHAR 4 0
MGRUP Key for dunning notice grouping MGRUP CHAR 2 0
LOCKB Key of the Lockbox to Which the Customer Is To Pay LOCKB CHAR 7 0
UZAWE Payment Method Supplement UZAWE CHAR 2 0
EKVBD Account Number of Buying Group EKVBD CHAR 10 0
SREGL Selection Rule for Payment Advices SREGL CHAR 3 0
XEDIP Indicator: Send Payment Advices by EDI XEDIP CHAR 1 0
X Yes
NULL No
FRGRP Release Approval Group FRGRP CHAR 4 0
VRSDG Reason Code Conversion Version VRSDG CHAR 3 0
TLFXS Accounting clerk's fax number at the customer/vendor TLFXS CHAR 31 0
PERNR Personnel Number PERNR_D NUMC 8 0
INTAD Internet address of partner company clerk INTAD CHAR 130 0