SAP table SI_KNA1 (General Data in Customer Master)

Field Description Data Type Length Decimals Checktable Data Element
ANRED Title CHAR 15 0 ANRED
AUFSD Central order block for customer CHAR 2 0 TVAST AUFSD_X
BAHNE Express train station CHAR 25 0 BAHNE
BAHNS Train station CHAR 25 0 BAHNS
BBBNR International location number (part 1) NUMC 7 0 BBBNR
BBSNR International location number (Part 2) NUMC 5 0 BBSNR
BEGRU Authorization Group CHAR 4 0 BRGRU
BRSCH Industry key CHAR 4 0 T016 BRSCH
BUBKZ Check digit for the international location number NUMC 1 0 BUBKZ
DATLT Data communication line no. CHAR 14 0 DATLT
ERDAT Date on which the Record Was Created DATS 8 0 ERDAT_RF
ERNAM Name of Person who Created the Object CHAR 12 0 ERNAM_RF
EXABL Indicator: Unloading points exist CHAR 1 0 EXABL
FAKSD Central billing block for customer CHAR 2 0 TVFS FAKSD_X
FISKN Account number of the master record with the fiscal address CHAR 10 0 KNA1 FISKN_D
KNAZK Working Time Calendar CHAR 2 0 TFACD KNAZK
KNRZA Account Number of an Alternative Payer CHAR 10 0 KNA1 KNRZA
KONZS Group key CHAR 10 0 KONZS
KTOKD Customer Account Group CHAR 4 0 T077D KTOKD
KUKLA Customer Classification CHAR 2 0 TKUKL KUKLA
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
LIFSD Central delivery block for the customer CHAR 2 0 TVLS LIFSD_X
LOCCO City Coordinates CHAR 10 0 LOCCO
LOEVM Central Deletion Flag for Master Record CHAR 1 0 LOEVM_X
NAME3 Name 3 CHAR 35 0 NAME3_GP
NAME4 Name 4 CHAR 35 0 NAME4_GP
NIELS Nielsen ID CHAR 2 0 TNLS NIELS
ORT02 District CHAR 35 0 ORT02_GP
PFACH PO Box CHAR 10 0 PFACH
PSTL2 P.O. Box Postal Code CHAR 10 0 PSTL2
COUNC County Code CHAR 3 0 T005E COUNC
CITYC City Code CHAR 4 0 T005G CITYC
RPMKR Regional market CHAR 5 0 RPMKR
SPERR Central posting block CHAR 1 0 SPERB_X
SPRAS Language Key LANG 1 0 T002 SPRAS
STCD1 Tax Number 1 CHAR 16 0 STCD1
STCD2 Tax Number 2 CHAR 11 0 STCD2
STKZA Indicator: Business Partner Subject to Equalization Tax? CHAR 1 0 STKZA
Not subject to equalization tax
X Subject to equalization tax
STKZU Liable for VAT CHAR 1 0 STKZU
TELBX Telebox number CHAR 15 0 TELBX
TELF2 Second telephone number CHAR 16 0 TELF2
TELTX Teletex number CHAR 30 0 TELTX
TELX1 Telex number CHAR 30 0 TELX1
LZONE Transportation zone to or from which the goods are delivered CHAR 10 0 TZONE LZONE
XZEMP Indicator: Is an alternative payer allowed in document? CHAR 1 0 XREGU
VBUND Company ID of Trading Partner CHAR 6 0 T880 RASSC
STCEG VAT Registration Number CHAR 20 0 STCEG
DEAR1 Indicator: Competitor CHAR 1 0 DEAR1
DEAR2 Indicator: Sales partner CHAR 1 0 DEAR2
DEAR3 Indicator: Sales prospect CHAR 1 0 DEAR3
No
X yes
DEAR4 Indicator for customer type 4 CHAR 1 0 DEAR4
DEAR5 ID for default sold-to party CHAR 1 0 DEAR5
GFORM Legal status CHAR 2 0 TVGF GFORM
BRAN1 Industry code 1 CHAR 10 0 TBRC BRAN1_D
BRAN2 Industry code 2 CHAR 10 0 TBRC BRAN2
BRAN3 Industry code 3 CHAR 10 0 TBRC BRAN3
BRAN4 Industry code 4 CHAR 10 0 TBRC BRAN4
BRAN5 Industry code 5 CHAR 10 0 TBRC BRAN5
EKONT Initial contact CHAR 10 0 EKONT
UMSAT Annual sales CURR 8 2 UMSAT
UMJAH Year For Which Sales are Given NUMC 4 0 UMJAH
UWAER Currency of sales figure CUKY 5 0 TCURC UWAER
JMZAH Yearly number of employees NUMC 6 0 JMZAH
JMJAH Year for which the number of employees is given NUMC 4 0 JMJAH
KATR1 Attribute 1 CHAR 2 0 TVK1 KATR1
KATR2 Attribute 2 CHAR 2 0 TVK2 KATR2
KATR3 Attribute 3 CHAR 2 0 TVK3 KATR3
KATR4 Attribute 4 CHAR 2 0 TVK4 KATR4
KATR5 Attribute 5 CHAR 2 0 TVK5 KATR5
KATR6 Attribute 6 CHAR 3 0 TVK6 KATR6
KATR7 Attribute 7 CHAR 3 0 TVK7 KATR7
KATR8 Attribute 8 CHAR 3 0 TVK8 KATR8
KATR9 Attribute 9 CHAR 3 0 TVK9 KATR9
KATR10 Attribute 10 CHAR 3 0 TVK0 KATR10
STKZN Natural Person CHAR 1 0 STKZN
Legal person
X Natural person
UMSA1 Annual sales CURR 15 2 UMSA1
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
ABRVW Usage Indicator CHAR 3 0 TVLV ABRVW
INSPBYDEBI Inspection Carried Out By Customer (No Inspection Lot) CHAR 1 0 QINSPBYDEB
INSPATDEBI Inspection for a Delivery Note After Outbound Delivery CHAR 1 0 QINSPATDEB
KTOCD Reference Account Group for One-Time Account (Customer) CHAR 4 0 T077D KTOCD
PFORT PO Box city CHAR 35 0 PFORT_GP
WERKS Plant CHAR 4 0 T001W WERKS_D
DTAMS Report key for data medium exchange CHAR 1 0 DTAMS
Use house bank default value
0 Single data record can be forwarded to the Bundesbank
1 Single data record not to be forwarded to the Bundesbank
DTAWS Instruction Key for Data Medium Exchange CHAR 2 0 DTAWS
DUEFL Status of Data Transfer into Subsequent Release CHAR 1 0 DUEFL_BKPF
Not transferred yet
A Transfer taken place, document changed later
X Transfer taken place, document unchanged
HZUOR Assignment to Hierarchy NUMC 2 0 HZUOR
SPERZ Payment Block CHAR 1 0 SPERZ
ETIKG IS-R Labeling: customer/plant group CHAR 10 0 TWEK ETIKG
CIVVE ID for mainly non-military use CHAR 1 0 CIVVE
MILVE ID for mainly military use CHAR 1 0 MILVE
KDKG1 Customer condition group 1 CHAR 2 0 TVKGG KDKG1
KDKG2 Customer condition group 2 CHAR 2 0 TVKGG KDKG2
KDKG3 Customer condition group 3 CHAR 2 0 TVKGG KDKG3
KDKG4 Customer condition group 4 CHAR 2 0 TVKGG KDKG4
KDKG5 Customer condition group 5 CHAR 2 0 TVKGG KDKG5
XKNZA Indicator: Alternative payer using account number CHAR 1 0 XKNZA
FITYP Tax type CHAR 2 0 J_1AFITP J_1AFITP_D
STCDT Tax Number Type CHAR 2 0 J_1ATODC J_1ATOID
STCD3 Tax Number 3 CHAR 18 0 STCD3
STCD4 Tax Number 4 CHAR 18 0 STCD4
STCD5 Tax Number 5 CHAR 60 0 STCD5
STCD6 Tax Number 6 CHAR 20 0 STCD6
XICMS Customer is ICMS-exempt CHAR 1 0 J_1BTCICMS
XXIPI Customer is IPI-exempt CHAR 1 0 J_1BTCIPI
XSUBT Customer group for Substituiçao Tributária calculation CHAR 3 0 J_1BTXSTG J_1BTCST
CFOPC Customer's CFOP category CHAR 2 0 J_1BINDUS1
00 industry (cooperative)
01 electric co.
02 communication co.
03 transport co.
04 service co.
05 consumer industry (cooperative)
06 non-contributing customer
07 agricultural customer
08 trading company
09 producer establishment
TXLW1 Tax law: ICMS CHAR 3 0 J_1BATL1 J_1BTAXLW1
TXLW2 Tax law: IPI CHAR 3 0 J_1BATL2 J_1BTAXLW2
CCC01 Indicator for biochemical warfare for legal control CHAR 1 0 CCC01
CCC02 Indicator for nuclear nonproliferation for legal control CHAR 1 0 CCC02
CCC03 Indicator for national security for legal control CHAR 1 0 CCC03
CCC04 Indicator for missile technology for legal control CHAR 1 0 CCC04
BONDED_AREA_CONFIRM TW: Bonded Area Confirm in Business Partner Extension CHAR 1 0 TWVAT_BONDED_AREA_CONF
1 Buyer as business entity in the Bonded Area
2 Buyer as business entity of overseas fishery
3 Buyer as business entity in the Free Trade Zone
DONATE_MARK TW: Donate Mark in Business Partner Extension CHAR 1 0 TWVAT_DONATE_MARK
0 Non-Donation Invoice
1 Donation Invoice
CONSOLIDATE_INVOICE Consolidated Invoicing for Taiwan CHAR 1 0 TWGUI_CONSOLIDATE_INVOICE
Not support
X Support collective billing
ALLOWANCE_TYPE TW: Allowance Type in Business Partner Extension CHAR 1 0 TWVAT_ALLOWANCE_TYPE
1 Allowance issued by buyer
2 Allowance issued by seller
EINVOICE_MODE Taiwan, China: Mode in Business Partner Extension CHAR 1 0 TWVAT_EINVOICE_MODE
1 Certificate Mode
2 B2B Exchange Mode
CASSD Central sales block for customer CHAR 2 0 CASSD_X
KNURL Uniform resource locator CHAR 132 0 URL
J_1KFREPRE Name of Representative CHAR 10 0 REPRES
J_1KFTBUS Type of Business CHAR 30 0 BUSTYPE GESTYP
J_1KFTIND Type of Industry CHAR 30 0 INDUSTYPE INDTYP
CONFS Status of Change Authorization (Central) CHAR 1 0 CONFS_X
UPDAT Date on Which the Changes Were Confirmed DATS 8 0 UPDAT_RF
UPTIM Time of Last Change Confirmation TIMS 6 0 UPTIM_RF
NODEL Central deletion block for master record CHAR 1 0 NODEL_X
DEAR6 Indicator: Consumer CHAR 1 0 DEAR6
DELIVERY_DATE_RULE Delivery Date Rule CHAR 1 0 SD_DELIVERY_DATE_TYPE_RULE
On Requested Date or Later
A On Confirmed Date
B By Confirmed Date
CVP_XBLCK Business Purpose Completed Flag CHAR 1 0 CVP_XBLCK
not blocked
X blocked
SUFRAMA Suframa Code CHAR 9 0 * J_1BSUFRAMA
RG RG Number CHAR 11 0 J_1BRG
EXP Issued by CHAR 3 0 J_1BEXP
UF State CHAR 2 0 J_1BUF
RGDATE RG Issuing Date DATS 8 0 J_1BRGDATE
RIC RIC Number NUMC 11 0 J_1BRIC
RNE Foreign National Registration CHAR 10 0 J_1BRNE
RNEDATE RNE Issuing Date DATS 8 0 J_1BRNEDATE
CNAE CNAE CHAR 7 0 J_1BTCNAE J_1BCNAE
LEGALNAT Legal Nature NUMC 4 0 J_1BTLEGALNAT J_1BLEGALNAT
CRTN CRT Number CHAR 1 0 * J_1BCRTN
1 Simples Nacional
2 Simples Nacional # excesso de sublimite da receita bruta
3 Regime Normal (não simples)
4 Simples Nacional - Microempreendedor Individual - MEI
ICMSTAXPAY ICMS Taxpayer CHAR 2 0 J_1BTICMSTAXPAY J_1BICMSTAXPAY
INDTYP Industry Main Type CHAR 2 0 J_1BTINDTYP J_1BINDTYP
TDT Tax Declaration Type CHAR 2 0 J_1BTTDT J_1BTDT
COMSIZE Company Size CHAR 2 0 J_1BTCOMSIZE J_1BCOMSIZE
DECREGPC Declaration Regimen for PIS/COFINS CHAR 2 0 J_1BTDECREGPC J_1BDECREGPC
PH_BIZ_STYLE PH Business Style Text CHAR 140 0 PH_BIZ_STYLE
PAYTRSN Payment Reason CHAR 4 0 FARP_PAYT_RSN

SI_KNA1 foreign key relationships

Table Field Check Table Check Field
0 SI_KNA1 ABRVW TVLV Check table for release orders: Usage ID ABRVW
1 SI_KNA1 AUFSD TVAST Sales Document Blocking Reasons: Texts MANDT
1 SI_KNA1 AUFSD TVAST Sales Document Blocking Reasons: Texts SPRAS
0 SI_KNA1 BRAN1 TBRC Industry Code (Customer Master) MANDT
0 SI_KNA1 BRAN1 TBRC Industry Code (Customer Master) BRACO
1 SI_KNA1 BRAN2 TBRC Industry Code (Customer Master) MANDT
1 SI_KNA1 BRAN2 TBRC Industry Code (Customer Master) BRACO
0 SI_KNA1 BRAN3 TBRC Industry Code (Customer Master) MANDT
0 SI_KNA1 BRAN3 TBRC Industry Code (Customer Master) BRACO
1 SI_KNA1 BRAN4 TBRC Industry Code (Customer Master) MANDT
1 SI_KNA1 BRAN4 TBRC Industry Code (Customer Master) BRACO
0 SI_KNA1 BRAN5 TBRC Industry Code (Customer Master) MANDT
0 SI_KNA1 BRAN5 TBRC Industry Code (Customer Master) BRACO
1 SI_KNA1 BRSCH T016 Industries BRSCH
0 SI_KNA1 CITYC T005G City MANDT
0 SI_KNA1 CITYC T005G City LAND1
0 SI_KNA1 CITYC T005G City REGIO
0 SI_KNA1 CITYC T005G City CITYC
1 SI_KNA1 COMSIZE J_1BTCOMSIZE Company Size J_1BCOMSIZE
0 SI_KNA1 COUNC T005E County MANDT
0 SI_KNA1 COUNC T005E County LAND1
0 SI_KNA1 COUNC T005E County REGIO
0 SI_KNA1 COUNC T005E County COUNC
1 SI_KNA1 DECREGPC J_1BTDECREGPC Declaration Regimen for PIS/COFINS J_1BDECREGPC
0 SI_KNA1 ETIKG TWEK IS-R Labeling: Check Table Customer/Plant Groups MANDT
0 SI_KNA1 ETIKG TWEK IS-R Labeling: Check Table Customer/Plant Groups KUNGR
1 SI_KNA1 FAKSD TVFS Billing: Reasons for Blocking FAKSP
0 SI_KNA1 FISKN KNA1 General Data in Customer Master MANDT
0 SI_KNA1 FISKN KNA1 General Data in Customer Master KUNNR
1 SI_KNA1 FITYP J_1AFITP Tax Types MANDT
0 SI_KNA1 GFORM TVGF Legal Status (Customer Master) MANDT
0 SI_KNA1 GFORM TVGF Legal Status (Customer Master) GFORM
1 SI_KNA1 ICMSTAXPAY J_1BTICMSTAXPAY ICMS Taxpayer J_1BICMSTAXPAY
0 SI_KNA1 INDTYP J_1BTINDTYP Industry Main Type J_1BINDTYP
1 SI_KNA1 J_1KFTBUS BUSTYPE Type of Business GESTYP
0 SI_KNA1 J_1KFTIND INDUSTYPE Type of Industry MANDT
0 SI_KNA1 J_1KFTIND INDUSTYPE Type of Industry INDTYPE
1 SI_KNA1 KATR1 TVK1 Attribute 1 (customer master) MANDT
1 SI_KNA1 KATR1 TVK1 Attribute 1 (customer master) KATR1
0 SI_KNA1 KATR10 TVK0 Attribute 10 (customer master) MANDT
1 SI_KNA1 KATR2 TVK2 Attribute 2 (customer master) MANDT
1 SI_KNA1 KATR2 TVK2 Attribute 2 (customer master) KATR2
0 SI_KNA1 KATR3 TVK3 Attribute 3 (customer master) MANDT
0 SI_KNA1 KATR3 TVK3 Attribute 3 (customer master) KATR3
1 SI_KNA1 KATR4 TVK4 Attribute 4 (customer master) MANDT
1 SI_KNA1 KATR4 TVK4 Attribute 4 (customer master) KATR4
0 SI_KNA1 KATR5 TVK5 Attribute 5 (customer master) MANDT
0 SI_KNA1 KATR5 TVK5 Attribute 5 (customer master) KATR5
1 SI_KNA1 KATR6 TVK6 Attribute 6 (customer master) MANDT
0 SI_KNA1 KATR7 TVK7 Attribute 7 (customer master) MANDT
1 SI_KNA1 KATR8 TVK8 Attribute 8 (customer master) MANDT
0 SI_KNA1 KATR9 TVK9 Attribute 9 (customer master) MANDT
1 SI_KNA1 KDKG1 TVKGG Customer Condition Groups (Customer Master) MANDT
1 SI_KNA1 KDKG1 TVKGG Customer Condition Groups (Customer Master) KDKGR
0 SI_KNA1 KDKG2 TVKGG Customer Condition Groups (Customer Master) MANDT
0 SI_KNA1 KDKG2 TVKGG Customer Condition Groups (Customer Master) KDKGR
1 SI_KNA1 KDKG3 TVKGG Customer Condition Groups (Customer Master) MANDT
1 SI_KNA1 KDKG3 TVKGG Customer Condition Groups (Customer Master) KDKGR
0 SI_KNA1 KDKG4 TVKGG Customer Condition Groups (Customer Master) MANDT
0 SI_KNA1 KDKG4 TVKGG Customer Condition Groups (Customer Master) KDKGR
1 SI_KNA1 KDKG5 TVKGG Customer Condition Groups (Customer Master) MANDT
1 SI_KNA1 KDKG5 TVKGG Customer Condition Groups (Customer Master) KDKGR
0 SI_KNA1 KNRZA KNA1 General Data in Customer Master MANDT
0 SI_KNA1 KNRZA KNA1 General Data in Customer Master KUNNR
1 SI_KNA1 KTOCD T077D Customer account groups MANDT
0 SI_KNA1 KTOKD T077D Customer account groups MANDT
1 SI_KNA1 KUKLA TKUKL Customers: Customer Classifications KUKLA
0 SI_KNA1 LIFNR LFA1 Supplier Master (General Section) MANDT
0 SI_KNA1 LIFNR LFA1 Supplier Master (General Section) LIFNR
1 SI_KNA1 LIFSD TVLS Deliveries: Blocking Reasons/Criteria MANDT
1 SI_KNA1 LIFSD TVLS Deliveries: Blocking Reasons/Criteria LIFSP
0 SI_KNA1 LZONE TZONE Customers: Regional zones MANDT
0 SI_KNA1 LZONE TZONE Customers: Regional zones LAND1
0 SI_KNA1 LZONE TZONE Customers: Regional zones ZONE1
1 SI_KNA1 NIELS TNLS Nielsen ID MANDT
1 SI_KNA1 NIELS TNLS Nielsen ID NIELS
0 SI_KNA1 PERIV T009 Fiscal Year Variants MANDT
0 SI_KNA1 PERIV T009 Fiscal Year Variants PERIV
1 SI_KNA1 SPRAS T002 Language Keys (Component BC-I18) SPRAS
0 SI_KNA1 STCDT J_1ATODC Type of identification J_1ATODC
1 SI_KNA1 TDT J_1BTTDT TDT J_1BTDT
0 SI_KNA1 TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
0 SI_KNA1 TXJCD TTXJ Check Table for Tax Jurisdiction KALSM
1 SI_KNA1 UWAER TCURC Currency Codes MANDT
1 SI_KNA1 UWAER TCURC Currency Codes WAERS
0 SI_KNA1 VBUND T880 Global Company Data (for KONS Ledger) MANDT
0 SI_KNA1 VBUND T880 Global Company Data (for KONS Ledger) RCOMP
1 SI_KNA1 WERKS T001W Plants/Branches WERKS
0 SI_KNA1 XSUBT J_1BTXSTG Tax calc.: Sub.Trib. customer group MANDT