KNA1 SAP table for – General Data in Customer Master

Here we would like to draw your attention to KNA1 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). KNA1 is a SAP standard transparent table used for storing General Data in Customer Master related data in SAP. It comes under the package VSCORE.

SAP KNA1 table

Table KNA1 technical data

TableKNA1
Data storingGeneral Data in Customer Master
ModuleLO
ComponentLO-MD
SAP PackageVSCORE
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP KNA1 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 KNA1 table.

  • STRAS
    Its data type is C (Character String) with field length 35
  • PFORT
    Its data type is C (Character String) with field length 35
  • DTAMS
    Its data type is C (Character String) with field length 1
  • DUEFL
    Its data type is C (Character String) with field length 1
  • HZUOR
    Its data type is N (Character String with Digits Only) with field length 2
  • SPERZ
    Its data type is C (Character String) with field length 1
  • MILVE
    Its data type is C (Character String) with field length 1
  • KDKG2
    Its data type is C (Character String) with field length 2
  • KDKG4
    Its data type is C (Character String) with field length 2
  • KDKG5
    Its data type is C (Character String) with field length 2
  • XKNZA
    Its data type is C (Character String) with field length 1
  • STCDT
    Its data type is C (Character String) with field length 2
  • TELFX
    Its data type is C (Character String) with field length 31
  • STCD4
    Its data type is C (Character String) with field length 18
  • STCD5
    Its data type is C (Character String) with field length 60
  • XICMS
    Its data type is C (Character String) with field length 1
  • XXIPI
    Its data type is C (Character String) with field length 1
  • CFOPC
    Its data type is C (Character String) with field length 2
  • TXLW2
    Its data type is C (Character String) with field length 3
  • CCC02
    Its data type is C (Character String) with field length 1
  • XCPDK
    Its data type is C (Character String) with field length 1
  • CCC03
    Its data type is C (Character String) with field length 1
  • CCC04
    Its data type is C (Character String) with field length 1
  • KNURL
    Its data type is C (Character String) with field length 132
  • J_1KFTBUS
    Its data type is C (Character String) with field length 30
  • CONFS
    Its data type is C (Character String) with field length 1
  • UPDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • NODEL
    Its data type is C (Character String) with field length 1
  • SUFRAMA
    Its data type is C (Character String) with field length 9
  • EXP
    Its data type is C (Character String) with field length 3
  • RGDATE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • RNE
    Its data type is C (Character String) with field length 10
  • RNEDATE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • CNAE
    Its data type is C (Character String) with field length 7
  • CRTN
    Its data type is C (Character String) with field length 1
  • INDTYP
    Its data type is C (Character String) with field length 2
  • TDT
    Its data type is C (Character String) with field length 2
  • COMSIZE
    Its data type is C (Character String) with field length 2
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is /VSO/R_KNA1_A
  • MCOD2
    Its data type is C (Character String) with field length 25
  • /VSO/R_PALHGT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • /VSO/R_PK_MAT
    Its data type is C (Character String) with field length 1
  • /VSO/R_I_NO_LYR
    Its data type is N (Character String with Digits Only) with field length 2
  • /VSO/R_ONE_SORT
    Its data type is C (Character String) with field length 1
  • /VSO/R_LOAD_PREF
    Its data type is N (Character String with Digits Only) with field length 1
  • PMT_OFFICE
    Its data type is C (Character String) with field length 5
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is SI_KNA1
  • PSON2
    Its data type is C (Character String) with field length 35
  • PSON3
    Its data type is C (Character String) with field length 35
  • PSOHS
    Its data type is C (Character String) with field length 6
  • PSOST
    Its data type is C (Character String) with field length 28
  • PSOO1
    Its data type is C (Character String) with field length 50
  • PSOO3
    Its data type is C (Character String) with field length 50
  • ANRED
    Its data type is C (Character String) with field length 15
  • PSOO5
    Its data type is C (Character String) with field length 50
  • KUNNR : Customer number
    Its a key field. Its data type is C (Character String) with field length 10
  • BAHNE
    Its data type is C (Character String) with field length 25
  • BBBNR
    Its data type is N (Character String with Digits Only) with field length 7
  • BEGRU
    Its data type is C (Character String) with field length 4
  • BUBKZ
    Its data type is N (Character String with Digits Only) with field length 1
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • EXABL
    Its data type is C (Character String) with field length 1
  • FISKN
    Its data type is C (Character String) with field length 10
  • KNRZA
    Its data type is C (Character String) with field length 10
  • KTOKD
    Its data type is C (Character String) with field length 4
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • NAME1 : Name 1
    Its data type is C (Character String) with field length 35
  • LOCCO
    Its data type is C (Character String) with field length 10
  • NAME3 : Name 3
    Its data type is C (Character String) with field length 35
  • NIELS
    Its data type is C (Character String) with field length 2
  • PFACH
    Its data type is C (Character String) with field length 10
  • COUNC : County Code
    Its data type is C (Character String) with field length 3
  • RPMKR
    Its data type is C (Character String) with field length 5
  • SPRAS : Language Key
    Its data type is C (Character String) with field length 1
  • STCD2
    Its data type is C (Character String) with field length 11
  • STKZU
    Its data type is C (Character String) with field length 1
  • TELF2
    Its data type is C (Character String) with field length 16
  • ORT01
    Its data type is C (Character String) with field length 35
  • TELX1
    Its data type is C (Character String) with field length 30
  • XZEMP
    Its data type is C (Character String) with field length 1
  • STCEG
    Its data type is C (Character String) with field length 20
  • DEAR2
    Its data type is C (Character String) with field length 1
  • DEAR4
    Its data type is C (Character String) with field length 1
  • GFORM
    Its data type is C (Character String) with field length 2
  • BRAN2
    Its data type is C (Character String) with field length 10
  • BRAN4
    Its data type is C (Character String) with field length 10
  • UMSAT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • UMJAH
    Its data type is N (Character String with Digits Only) with field length 4
  • REGIO : Region (State, Province, County)
    Its data type is C (Character String) with field length 3
  • JMZAH
    Its data type is N (Character String with Digits Only) with field length 6
  • KATR1
    Its data type is C (Character String) with field length 2
  • KATR3
    Its data type is C (Character String) with field length 2
  • KATR5
    Its data type is C (Character String) with field length 2
  • KATR7
    Its data type is C (Character String) with field length 3
  • KATR9
    Its data type is C (Character String) with field length 3
  • STKZN
    Its data type is C (Character String) with field length 1
  • TXJCD : Tax Jurisdiction
    Its data type is C (Character String) with field length 15
  • ABRVW
    Its data type is C (Character String) with field length 3
  • INSPBYDEBI
    Its data type is C (Character String) with field length 1
  • INSPATDEBI
    Its data type is C (Character String) with field length 1