KNB1 is a standard Financial Accounting Transparent Table in SAP FI application, which stores Customer Master (Company Code) data. On this page, you can view the Table Structure, Columns(Fields), links to SAP Documentation, Wiki & Help Pages, Q&A, similar/related TCodes, Tables, FMs, ABAP Reports, BW Datasources, and Authorization Objects for KNB1. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

KNB1 — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Data Element Primary Key Data Type Length Check Table
    1 MANDT Client MANDT X CLNT 3 T000
    2 KUNNR Customer KUNNR X CHAR 10 KNA1
    3 BUKRS Company Code BUKRS X CHAR 4 T001
    4 PERNR Personnel No. PERNR_D NUMC 8
    5 .INCLUDE 0
    6 KNB1_EEW_CC KNB1_EEW_CC CHAR 1
    7 .INCLUDE 0
    8 ERDAT Created on ERDAT_RF DATS 8
    9 ERNAM Created by ERNAM_RF CHAR 12
    10 SPERR Central posting block SPERB_B CHAR 1
    11 LOEVM Deletion Indicator LOEVM_B CHAR 1
    12 ZUAWA Key for sorting according to assignment numbers DZUAWA CHAR 3 TZUN
    13 BUSAB Accounting clerk BUSAB CHAR 2 T001S
    14 AKONT Recon. account AKONT CHAR 10 SKB1
    15 BEGRU Authorization Group BRGRU CHAR 4 *
    16 KNRZE Head office KNRZE CHAR 10 KNA1
    17 KNRZB Account number of an alternative payer KNRZB CHAR 10 KNA1
    18 ZAMIM Updated information in related user data field DZAMIM CHAR 1
    19 ZAMIV Updated information in related user data field DZAMIV CHAR 1
    20 ZAMIR Updated information in related user data field DZAMIR CHAR 1
    21 ZAMIB Updated information in related user data field DZAMIB CHAR 1
    22 ZAMIO Updated information in related user data field DZAMIO CHAR 1
    23 ZWELS List of Respected Payment Methods DZWELS CHAR 10
    24 XVERR Indicator: Clearing between customer and vendor ? XVERR_KNB1 CHAR 1
    25 ZAHLS Block Key for Payment DZAHLS CHAR 1 T008
    26 ZTERM Payt terms DZTERM CHAR 4
    27 WAKON Updated information in related user data field WAKON CHAR 4
    28 VZSKZ Interest Calculation Indicator VZSKZ CHAR 2 T056
    29 ZINDT Key Date of Last Interest Calculation DZINDT DATS 8
    30 ZINRT Version Number Component DZINRT NUMC 2
    31 EIKTO Shipper's (Our) Account Number at the Customer or Vendor EIKTO_D CHAR 12
    32 ZSABE User at customer DZSABE_D CHAR 15
    33 KVERM Updated information in related user data field KVERM CHAR 30
    34 FDGRV Planning group FDGRV CHAR 10 T035
    35 VRBKZ Updated information in related user data field VRBKZ CHAR 2
    36 VLIBB Updated information in related user data field VLIBB_CS CURR 13
    37 VRSZL Updated information in related user data field VRSZL DEC 3
    38 VRSPR Updated information in related user data field VRSPR DEC 3
    39 VRSNR Updated information in related user data field VRSNR CHAR 10
    40 VERDT Updated information in related user data field VERDT DATS 8
    41 PERKZ Period Indicator PERKZ_KNB1 CHAR 1
    42 XDEZV Updated information in related user data field XDEZV CHAR 1
    43 XAUSZ Indicator for Periodic Account Statements XAUSZ CHAR 1 T048K
    44 WEBTR Updated information in related user data field WEBTR_CS CURR 13
    45 REMIT Next payee REMIT CHAR 10 KNA1
    46 DATLZ Date of the last interest calculation run DATLZ DATS 8
    47 XZVER Indicator: Record Payment History ? XZVER CHAR 1
    48 TOGRU Tolerance Group for G/L Accounts TOGRU CHAR 4 T043G
    49 KULTG Updated information in related user data field KULTG DEC 3
    50 HBKID Short key for a house bank HBKID CHAR 5 T012
    51 XPORE Indicator: Single Payment XPORE CHAR 1
    52 BLNKZ (Obsolete) Subsidy Ind. for Determining the Reduction Rate BLNKZ CHAR 2 *
    53 ALTKN Previous Master Record Number ALTKN CHAR 10
    54 ZGRUP Updated information in related user data field DZGRUP CHAR 2 TZGR
    55 URLID Benefit ID for Uniform Resource Locator (URL) URLID CHAR 4 T052A
    56 MGRUP Key for Dunning Notice Grouping MGRUP CHAR 2 T047R
    57 LOCKB Updated information in related user data field LOCKB CHAR 7 T049L
    58 UZAWE Pmt meth.supl. UZAWE CHAR 2 T042F
    59 EKVBD Account Number of Buying Group EKVBD CHAR 10 KNA1
    60 SREGL Updated information in related user data field SREGL CHAR 3 T053A
    61 XEDIP Updated information in related user data field XEDIP CHAR 1
    62 FRGRP Updated information in related user data field FRGRP CHAR 4 VBWF08
    63 VRSDG Updated information in related user data field VRSDG CHAR 3 T053V
    64 TLFXS Accounting clerk's fax number at the customer/vendor TLFXS CHAR 31
    65 INTAD Internet Address of Partner Company Clerk INTAD CHAR 130
    66 XKNZB Updated information in related user data field XKNZB CHAR 1
    67 GUZTE Updated information in related user data field GUZTE CHAR 4
    68 GRICD Activity Code for Gross Income Tax J_1AGICD_D CHAR 2 J_1AGICD
    69 GRIDT Updated information in related user data field J_1ADTYP_D CHAR 2 J_1ADTYP
    70 WBRSL Updated information in related user data field WBRSL CHAR 2 T044G
    71 CONFS Status of Change Authorization (Central) CONFS_B CHAR 1
    72 UPDAT Update UPDAT_RF DATS 8
    73 UPTIM Time of Last Change (in UTC) UPTIM_RF TIMS 6
    74 NODEL Central deletion block for master record NODEL_B CHAR 1
    75 TLFNS Accounting clerk's telephone number at business partner TLFNS CHAR 30
    76 CESSION_KZ AR Pledging Ind CESSION_KZ CHAR 2 TCESSION
    77 AVSND Updated information in related user data field AVSND CHAR 1
    78 AD_HASH E-Mail Address for Avis: Hash Value ADHASH CHAR 10
    79 QLAND Country Key QLAND CHAR 3 T005Q
    80 CVP_XBLCK_B Updated information in related user data field CVP_XBLCK CHAR 1
    81 CIIUCODE Updated information in related user data field CIIUCODE NUMC 4
    82 .INCLU--AP 0
    83 GMVKZD Customer is in execution GMVKZD CHAR 1
    84 .INCLU--AP 0
    85 .INCLUDE 0
    86 INTERCOCD Intercompany code OIU_INTERCOCD CHAR 4 T001

SAP Help, Wiki, Q&A and other resources for KNB1

Click the above link for the full list of resources and help pages, only the first few are posted below


Related Tables

TABLE Description Functional Area
KNA1 General Data in Customer Master Logistics - Customer Master
KNVV Customer Master Sales Data Logistics - Customer Master
LFB1 Vendor Master (Company Code) FI - Financial Accounting
LFA1 Vendor Master (General Section) FI - Financial Accounting
BKPF Accounting Document Header FI - Financial Accounting

Transaction Codes for SAP Table KNB1

TCODE Description Functional Area
XD01 Create Customer (Centrally) FI - Basic Functions
SE16 Data Browser Basis - Workbench Utilities
VBKD Bonus Buy: Condition Types SD - Free Goods
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
XD03 Display Customer (Centrally) FI - Basic Functions
FD01 Create Customer (Accounting) LO - Customer Master

FMs for SAP Table KNB1

FM Description Functional Area
GUI_UPLOAD Upload for Data Provider Basis - Graphical User Interface
LVC_FIELDCATALOG_MERGE Create field catalog from dictionary structure or internal table BC - liveCache
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
BDC_OPEN_GROUP Open batch input session for adding transactions 700 - UI Services
BDC_INSERT Insert batch input transactions in batch input session 700 - UI Services
BDC_CLOSE_GROUP Close batch input session 700 - UI Services

ABAP Reports for SAP Table KNB1

ABAP REPORT Description Functional Area
SAPMF02D Customer Master Data Logistics - Customer Master
EMSG Standard-Include des Nachrichtenobjektes IS - Monitors for Automotive
BDCRECX1 Include f Basis - UI Services, Screen, Batch Input
RFBIDE00 Batch Input Interface for Customers FI - Financial Accounting
SAPMV45A Sales Order Processing SD - Sales
BCALV_EDIT_02 Define ready-for-input status at cell level Basis - SAP List Viewer

BW Datasources for SAP Table KNB1

BW DATASOURCE Description Functional Area
0CUSTOMER_ATTR Customer Number Logistics - Logistics - General
0FI_AR_4 Customers: Line Items with Delta Extraction FI - Accounts Receivable
0CUST_COMPC_ATTR Customer Number Compounded with Company Code Logistics - Logistics - General
2LIS_11_VAITM Sales Document Item Data SD - Sales and Distribution
0FI_AR_9 Customer Credit Managmt. Cntrl Area Data via Delta Extractn FI - Accounts Receivable
0FI_GL_4 General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting

Authorization Objects for SAP Table KNB1

AUTHORIZATION OBJECT Description Functional Area
F_BKPF_BUK Accounting Document: Authorization for Company Codes
C_VKORG Transfer of Sales Organization Data
M_MATE_STA Material Master: Maintenance Statuses
E_GRID Authorization Object for Grid
F_KNA1_AEN Customer: Change Authorization for Certain Fields

Most searched SAP Financial Accounting Tables