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