KNB1 SAP table for – Customer Master (Company Code)

Here we would like to draw your attention to KNB1 table in SAP. As we know it is being mainly used with the SAP LO-MD (Logistics Basic Data in LO) component which is coming under LO module (Logistics). KNB1 is a SAP standard transparent table used for storing Customer Master (Company Code) related data in SAP. It comes under the package VSCORE.

SAP KNB1 table

Table KNB1 technical data

TableKNB1
Data storingCustomer Master (Company Code)
ModuleLO
ComponentLO-MD
SAP PackageVSCORE
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP KNB1 Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in KNB1 table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • BUSAB
    Its data type is C (Character String) with field length 2
  • BEGRU
    Its data type is C (Character String) with field length 4
  • KNRZB
    Its data type is C (Character String) with field length 10
  • ZAMIV
    Its data type is C (Character String) with field length 1
  • ZAMIR
    Its data type is C (Character String) with field length 1
  • ZAMIB
    Its data type is C (Character String) with field length 1
  • XVERR
    Its data type is C (Character String) with field length 1
  • ZTERM
    Its data type is C (Character String) with field length 4
  • VZSKZ
    Its data type is C (Character String) with field length 2
  • ZINRT
    Its data type is N (Character String with Digits Only) with field length 2
  • ZSABE
    Its data type is C (Character String) with field length 15
  • FDGRV
    Its data type is C (Character String) with field length 10
  • VLIBB
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • VRSZL
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • VERDT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PERKZ
    Its data type is C (Character String) with field length 1
  • PERNR : Personnel Number
    Its data type is N (Character String with Digits Only) with field length 8
  • XAUSZ
    Its data type is C (Character String) with field length 1
  • REMIT
    Its data type is C (Character String) with field length 10
  • XZVER
    Its data type is C (Character String) with field length 1
  • KULTG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • XPORE
    Its data type is C (Character String) with field length 1
  • ALTKN
    Its data type is C (Character String) with field length 10
  • URLID
    Its data type is C (Character String) with field length 4
  • LOCKB
    Its data type is C (Character String) with field length 7
  • EKVBD
    Its data type is C (Character String) with field length 10
  • XEDIP
    Its data type is C (Character String) with field length 1
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VRSDG
    Its data type is C (Character String) with field length 3
  • INTAD
    Its data type is C (Character String) with field length 130
  • GRICD
    Its data type is C (Character String) with field length 2
  • WBRSL
    Its data type is C (Character String) with field length 2
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • UPDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • UPTIM
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • TLFNS
    Its data type is C (Character String) with field length 30
  • AVSND
    Its data type is C (Character String) with field length 1
  • QLAND
    Its data type is C (Character String) with field length 3
  • GMVKZD
    Its data type is C (Character String) with field length 1
  • LOEVM : Deletion Indicator
    Its data type is C (Character String) with field length 1