SAP ABAP Table KNA1 (General Data in Customer Master)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-BF (Application Component) Basic Functions
     VSCORE (Package) B2R: BAPI Structures
Basic Data
Table Category TRANSP    Transparent table 
Transparent table KNA1   Table Relationship Diagram
Short Description General Data in Customer Master    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number  
3 LAND1 LAND1_GP LAND1 CHAR 3   0   Country Key T005
4 NAME1 NAME1_GP NAME CHAR 35   0   Name 1  
5 NAME2 NAME2_GP NAME CHAR 35   0   Name 2  
6 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
7 PSTLZ PSTLZ PSTLZ CHAR 10   0   Postal Code  
8 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
9 SORTL SORTL CHAR10 CHAR 10   0   Sort field  
10 STRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
11 TELF1 TELF1 TEXT16 CHAR 16   0   First telephone number  
12 TELFX TELFX TEXT31 CHAR 31   0   Fax Number  
13 XCPDK XCPDK XFELD CHAR 1   0   Indicator: Is the account a one-time account?  
14 ADRNR ADRNR ADRNR CHAR 10   0   Address *
15 MCOD1 MCDD1 CHAR25 CHAR 25   0   Search term for matchcode search  
16 MCOD2 MCDD2 CHAR25 CHAR 25   0   Search Term for Matchcode Search  
17 MCOD3 MCDD3 CHAR25 CHAR 25   0   Search term for matchcode search  
18 .INCLUDE       0   0   General Data in Customer Master  
19 ANRED ANRED TEXT15 CHAR 15   0   Title  
20 AUFSD AUFSD_X KAUFS CHAR 2   0   Central order block for customer TVAST
21 BAHNE BAHNE BAHNH CHAR 25   0   Express train station  
22 BAHNS BAHNS BAHNH CHAR 25   0   Train station  
23 BBBNR BBBNR NUM07 NUMC 7   0   International location number (part 1)  
24 BBSNR BBSNR NUM05 NUMC 5   0   International location number (Part 2)  
25 BEGRU BRGRU BRGRU CHAR 4   0   Authorization Group *
26 BRSCH BRSCH BRSCH CHAR 4   0   Industry key T016
27 BUBKZ BUBKZ NUM01 NUMC 1   0   Check digit for the international location number  
28 DATLT DATLT TEXT14 CHAR 14   0   Data communication line no.  
29 ERDAT ERDAT_RF DATUM DATS 8   0   Date on which the Record Was Created  
30 ERNAM ERNAM_RF USNAM CHAR 12   0   Name of Person who Created the Object  
31 EXABL EXABL XFELD CHAR 1   0   Indicator: Unloading points exist  
32 FAKSD FAKSD_X FAKSP CHAR 2   0   Central billing block for customer TVFS
33 FISKN FISKN_D KUNNR CHAR 10   0   Account number of the master record with the fiscal address KNA1
34 KNAZK KNAZK WFCID CHAR 2   0   Working Time Calendar TFACD
35 KNRZA KNRZA KUNNR CHAR 10   0   Account number of an alternative payer KNA1
36 KONZS KONZS KONZS CHAR 10   0   Group key  
37 KTOKD KTOKD KTOKD CHAR 4   0   Customer Account Group T077D
38 KUKLA KUKLA KUKLA CHAR 2   0   Customer classification TKUKL
39 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor LFA1
40 LIFSD LIFSD_X LIFSP CHAR 2   0   Central delivery block for the customer TVLS
41 LOCCO LOCCO LOCCO CHAR 10   0   City Coordinates  
42 LOEVM LOEVM_X XFELD CHAR 1   0   Central Deletion Flag for Master Record  
43 NAME3 NAME3_GP NAME CHAR 35   0   Name 3  
44 NAME4 NAME4_GP NAME CHAR 35   0   Name 4  
45 NIELS NIELS NIELS CHAR 2   0   Nielsen ID TNLS
46 ORT02 ORT02_GP TEXT35 CHAR 35   0   District  
47 PFACH PFACH PFACH CHAR 10   0   PO Box  
48 PSTL2 PSTL2 PSTLZ CHAR 10   0   P.O. Box Postal Code  
49 COUNC COUNC COUNC CHAR 3   0   County Code T005E
50 CITYC CITYC CITYC CHAR 4   0   City Code T005G
51 RPMKR RPMKR RPMKR CHAR 5   0   Regional market  
52 SPERR SPERB_X XFELD CHAR 1   0   Central posting block  
53 SPRAS SPRAS SPRAS LANG 1   0   Language Key T002
54 STCD1 STCD1 STCD1 CHAR 16   0   Tax Number 1  
55 STCD2 STCD2 STCD2 CHAR 11   0   Tax Number 2  
56 STKZA STKZA STKZA CHAR 1   0   Indicator: Business Partner Subject to Equalization Tax?  
57 STKZU STKZU XFELD CHAR 1   0   Liable for VAT  
58 TELBX TELBX TEXT15 CHAR 15   0   Telebox number  
59 TELF2 TELF2 TEXT16 CHAR 16   0   Second telephone number  
60 TELTX TELTX TEXT30 CHAR 30   0   Teletex number  
61 TELX1 TELX1 TEXT30 CHAR 30   0   Telex number  
62 LZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered TZONE
63 XZEMP XREGU XFELD CHAR 1   0   Indicator: Is an alternative payer allowed in document?  
64 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner T880
65 STCEG STCEG STCEG CHAR 20   0   VAT Registration Number  
66 DEAR1 DEAR1 XFELD CHAR 1   0   Indicator: Competitor  
67 DEAR2 DEAR2 XFELD CHAR 1   0   Indicator: Sales partner  
68 DEAR3 DEAR3 DEAR3 CHAR 1   0   Indicator: Sales prospect  
69 DEAR4 DEAR4 XFELD CHAR 1   0   Indicator for customer type 4  
70 DEAR5 DEAR5 XFELD CHAR 1   0   ID for default sold-to party  
71 GFORM GFORM GFORM CHAR 2   0   Legal status TVGF
72 BRAN1 BRAN1_D BRACO CHAR 10   0   Industry code 1 TBRC
73 BRAN2 BRAN2 BRACO CHAR 10   0   Industry code 2 TBRC
74 BRAN3 BRAN3 BRACO CHAR 10   0   Industry code 3 TBRC
75 BRAN4 BRAN4 BRACO CHAR 10   0   Industry code 4 TBRC
76 BRAN5 BRAN5 BRACO CHAR 10   0   Industry code 5 TBRC
77 EKONT EKONT VBELN CHAR 10   0   Initial contact VBUK
78 UMSAT UMSAT UMSAT CURR 8   2   Annual sales  
79 UMJAH UMJAH JAHR NUMC 4   0   Year For Which Sales are Given  
80 UWAER UWAER WAERS CUKY 5   0   Currency of Sales Volume TCURC
81 JMZAH JMZAH JMZAH NUMC 6   0   Yearly number of employees  
82 JMJAH JMJAH JAHR NUMC 4   0   Year for which the number of employees is given  
83 KATR1 KATR1 ATTR1 CHAR 2   0   Attribute 1 TVK1
84 KATR2 KATR2 ATTR2 CHAR 2   0   Attribute 2 TVK2
85 KATR3 KATR3 ATTR3 CHAR 2   0   Attribute 3 TVK3
86 KATR4 KATR4 ATTR4 CHAR 2   0   Attribute 4 TVK4
87 KATR5 KATR5 ATTR5 CHAR 2   0   Attribute 5 TVK5
88 KATR6 KATR6 ATTR6 CHAR 3   0   Attribute 6 TVK6
89 KATR7 KATR7 ATTR7 CHAR 3   0   Attribute 7 TVK7
90 KATR8 KATR8 ATTR8 CHAR 3   0   Attribute 8 TVK8
91 KATR9 KATR9 ATTR9 CHAR 3   0   Attribute 9 TVK9
92 KATR10 KATR10 ATTR10 CHAR 3   0   Attribute 10 TVK0
93 STKZN STKZN STKZN CHAR 1   0   Natural Person  
94 UMSA1 UMSA1 UMSA1 CURR 15   2   Annual sales  
95 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction TTXJ
96 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant T009
97 ABRVW ABRVW ABRVW CHAR 3   0   Usage Indicator TVLV
98 INSPBYDEBI QINSPBYDEB QKZ CHAR 1   0   Inspection Carried Out By Customer (No Inspection Lot)  
99 INSPATDEBI QINSPATDEB QKZ CHAR 1   0   Inspection for a Delivery Note After Outbound Delivery  
100 KTOCD KTOCD KTOKD CHAR 4   0   Reference Account Group for One-Time Account (Customer) T077D
101 PFORT PFORT_GP TEXT35 CHAR 35   0   PO Box city  
102 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
103 DTAMS DTAMS DTAMS CHAR 1   0   Report key for data medium exchange  
104 DTAWS DTAWS DTAWS CHAR 2   0   Instruction key for data medium exchange *
105 DUEFL DUEFL_BKPF DUEFL_BKPF CHAR 1   0   Status of Data Transfer into Subsequent Release  
106 HZUOR HZUOR HZUOR NUMC 2   0   Assignment to Hierarchy  
107 SPERZ SPERZ XFELD CHAR 1   0   Payment Block  
108 ETIKG ETIKG ETIKG CHAR 10   0   IS-R Labeling: customer/plant group TWEK
109 CIVVE CIVVE XFELD CHAR 1   0   ID for mainly non-military use  
110 MILVE MILVE XFELD CHAR 1   0   ID for mainly military use  
111 KDKG1 KDKG1 KDKGR CHAR 2   0   Customer condition group 1 TVKGG
112 KDKG2 KDKG2 KDKGR CHAR 2   0   Customer condition group 2 TVKGG
113 KDKG3 KDKG3 KDKGR CHAR 2   0   Customer condition group 3 TVKGG
114 KDKG4 KDKG4 KDKGR CHAR 2   0   Customer condition group 4 TVKGG
115 KDKG5 KDKG5 KDKGR CHAR 2   0   Customer condition group 5 TVKGG
116 XKNZA XKNZA XFELD CHAR 1   0   Indicator: Alternative payer using account number  
117 FITYP J_1AFITP_D J_1AFITP CHAR 2   0   Tax type J_1AFITP
118 STCDT J_1ATOID J_1ATOID CHAR 2   0   Tax Number Type J_1ATODC
119 STCD3 STCD3 CHAR18 CHAR 18   0   Tax Number 3  
120 STCD4 STCD4 CHAR18 CHAR 18   0   Tax Number 4  
121 STCD5 STCD5 CHAR60 CHAR 60   0   Tax Number 5  
122 XICMS J_1BTCICMS XFELD CHAR 1   0   Customer is ICMS-exempt  
123 XXIPI J_1BTCIPI XFELD CHAR 1   0   Customer is IPI-exempt  
124 XSUBT J_1BTCST J_1BTCST1 CHAR 3   0   Customer group for Substituiçao Tributária calculation J_1BTXSTG
125 CFOPC J_1BINDUS1 J_1BINDUS1 CHAR 2   0   Customer's CFOP category  
126 TXLW1 J_1BTAXLW1 J_1BTAXLW1 CHAR 3   0   Tax law: ICMS J_1BATL1
127 TXLW2 J_1BTAXLW2 J_1BTAXLW2 CHAR 3   0   Tax law: IPI J_1BATL2
128 CCC01 CCC01 XFELD CHAR 1   0   Indicator for biochemical warfare for legal control  
129 CCC02 CCC02 XFELD CHAR 1   0   Indicator for nuclear nonproliferation for legal control  
130 CCC03 CCC03 XFELD CHAR 1   0   Indicator for national security for legal control  
131 CCC04 CCC04 XFELD CHAR 1   0   Indicator for missile technology for legal control  
132 CASSD CASSD_X CASSP CHAR 2   0   Central sales block for customer  
133 KNURL URL TEXT132 CHAR 132   0   Uniform resource locator  
134 J_1KFREPRE REPRES REPRES CHAR 10   0   Name of Representative  
135 J_1KFTBUS GESTYP GESTYP CHAR 30   0   Type of Business BUSTYPE
136 J_1KFTIND INDTYP INDTYP CHAR 30   0   Type of Industry INDUSTYPE
137 CONFS CONFS_X CHAR1 CHAR 1   0   Status of Change Authorization (Central)  
138 UPDAT UPDAT_RF DATUM DATS 8   0   Date on Which the Changes Were Confirmed  
139 UPTIM UPTIM_RF AS4TIME TIMS 6   0   Time of Last Change Confirmation  
140 NODEL NODEL_X XFELD CHAR 1   0   Central deletion block for master record  
141 DEAR6 DEAR6 XFELD CHAR 1   0   Indicator: Consumer  
142 .INCLUDE       0   0   Customer Master Data - Brazil  
143 SUFRAMA J_1BSUFRAMA J_1BSUFRAMA CHAR 9   0   Suframa Code  
144 RG J_1BRG J_1BRG CHAR 11   0   RG Number  
145 EXP J_1BEXP J_1BEXP CHAR 3   0   Issued by  
146 UF J_1BUF J_1BUF CHAR 2   0   State  
147 RGDATE J_1BRGDATE DATUM DATS 8   0   RG Issue Date  
148 RIC J_1BRIC J_1BRIC NUMC 11   0   RIC Number  
149 RNE J_1BRNE J_1BRNE CHAR 10   0   Foreign National Registration  
150 RNEDATE J_1BRNEDATE DATUM DATS 8   0   RNE Issue Date  
151 CNAE J_1BCNAE J_1BCNAE CHAR 7   0   CNAE J_1BTCNAE
152 LEGALNAT J_1BLEGALNAT J_1BLEGALNAT NUMC 4   0   Legal Nature J_1BTLEGALNAT
153 CRTN J_1BCRTN J_1BCRTN CHAR 1   0   CRT Number  
154 ICMSTAXPAY J_1BICMSTAXPAY J_1BICMSTAXPAY CHAR 2   0   ICMS Taxpayer J_1BTICMSTAXPAY
155 INDTYP J_1BINDTYP J_1BINDTYP CHAR 2   0   Industry Main Type J_1BTINDTYP
156 TDT J_1BTDT J_1BTDT CHAR 2   0   Tax Declaration Type J_1BTTDT
157 COMSIZE J_1BCOMSIZE J_1BCOMSIZE CHAR 2   0   Company Size J_1BTCOMSIZE
158 DECREGPC J_1BDECREGPC J_1BDECREGPC CHAR 2   0   Declaration Regimen for PIS/COFINS J_1BTDECREGPC
159 .INCLU--AP       0   0   Append to KNA1 for Vehicle Space Optimization  
160 .INCLUDE       0   0   Additional Data for Vehicle Space Optimization for KNA1  
161 /VSO/R_PALHGT /VSO/R_PAL_BIN_HGT MENG13 QUAN 13   3   Maximum Stacking Height of the Packaging Material (VSO)  
162 /VSO/R_PAL_UL /VSO/R_PAL_UNIT_L MEINS UNIT 3   0   Unit of Length for Packaging Material (VSO) T006
163 /VSO/R_PK_MAT /VSO/M_PACK_BY_MAT /VSO/M_XFIELD CHAR 1   0   Customer-Related Packing for Each Packaging Material (VSO)  
164 /VSO/R_MATPAL /VSO/M_MATNR_PAL MATNR CHAR 18   0   Packaging Material of the Customer in VSO MARA
165 /VSO/R_I_NO_LYR /VSO/M_IPAL_NO_LYR /VSO/M_IPAL_NO_LYR NUMC 2   0   Number Layers Under an Inter-Pallet (VSO)  
166 /VSO/R_ONE_MAT /VSO/M_ONE_MAT /VSO/M_XFIELD CHAR 1   0   Packing Material-Specific for Each Packaging Material  
167 /VSO/R_ONE_SORT /VSO/M_ONE_SORT /VSO/M_XFIELD CHAR 1   0   Pack Only One Package Type for Each PKM (VSO)  
168 /VSO/R_ULD_SIDE /VSO/M_UNLOAD_SIDE_PREF /VSO/M_SIDE_PREF NUMC 1   0   Side Preference of Loading/Unloading (VSO)  
169 /VSO/R_LOAD_PREF /VSO/M_LOAD_PREF /VSO/M_LOAD_PREF NUMC 1   0   Front/Back Preference of Loading/Unloading (VSO)  
170 /VSO/R_DPOINT /VSO/R_DELIVERYPOINT /VSO/R_DELIVERYPOINT CHAR 10   0   Collective Unloading Point for VSO /VSO/R_DPOINT
171 .INCLU--AP       0   0   US Federal Government Customer Master Data Additional Fields  
172 ALC FMFG_ALC FMFG_ALC CHAR 8   0   Agency Location Code FMFGT_ALC
173 PMT_OFFICE FMFG_PMT_OFF FMFG_PMT_OFF CHAR 5   0   Payment Office FMFGT_PO
174 .INCLUDE       0   0    
175 .INCLU--AP       0   0   Local Authority Additional Fields  
176 PSOFG PSOFG PSOFG CHAR 10   0   Processor group PSO19
177 PSOIS PSOIS CHAR20 CHAR 20   0   Subledger acct preprocessing procedure  
178 .INCLUDE       0   0   Local Authority Additional Fields (Address)  
179 PSON1 NAME1_GP NAME CHAR 35   0   Name 1  
180 PSON2 NAME2_GP NAME CHAR 35   0   Name 2  
181 PSON3 NAME3_GP NAME CHAR 35   0   Name 3  
182 PSOVN PSOVN NAME CHAR 35   0   First Name  
183 PSOTL PSOTL FMPSOTL CHAR 20   0   Title  
184 PSOHS PSOHS CHAR06 CHAR 6   0   House number: is no longer used from Release 4.6B  
185 PSOST PSOST PSOST CHAR 28   0   Street: No longer used from Release 4.6B  
186 .INCLUDE       0   0   Description (Customer/Vendor Supplement)  
187 PSOO1 PSOO1 TEXT50 CHAR 50   0   Description  
188 PSOO2 PSOO1 TEXT50 CHAR 50   0   Description  
189 PSOO3 PSOO1 TEXT50 CHAR 50   0   Description  
190 PSOO4 PSOO1 TEXT50 CHAR 50   0   Description  
191 PSOO5 PSOO1 TEXT50 CHAR 50   0   Description  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 KNA1 /VSO/R_DPOINT /VSO/R_DPOINT /VSO/R_DPOINT    
2 KNA1 /VSO/R_MATPAL MARA MATNR    
3 KNA1 /VSO/R_PAL_UL T006 MSEHI    
4 KNA1 ABRVW TVLV ABRVW REF C CN
5 KNA1 ALC FMFGT_ALC ALC    
6 KNA1 AUFSD TVAST AUFSP REF C CN
7 KNA1 BRAN1 TBRC BRACO KEY 1 CN
8 KNA1 BRAN2 TBRC BRACO KEY 1 CN
9 KNA1 BRAN3 TBRC BRACO KEY 1 CN
10 KNA1 BRAN4 TBRC BRACO KEY 1 CN
11 KNA1 BRAN5 TBRC BRACO KEY 1 CN
12 KNA1 BRSCH T016 BRSCH REF C CN
13 KNA1 CITYC T005G CITYC REF C CN
14 KNA1 CNAE J_1BTCNAE J_1BCNAE KEY    
15 KNA1 COMSIZE J_1BTCOMSIZE J_1BCOMSIZE KEY    
16 KNA1 COUNC T005E COUNC REF C CN
17 KNA1 DECREGPC J_1BTDECREGPC J_1BDECREGPC KEY    
18 KNA1 EKONT VBUK VBELN REF 1 C
19 KNA1 ETIKG TWEK KUNGR REF 1 CN
20 KNA1 FAKSD TVFS FAKSP REF C CN
21 KNA1 FISKN KNA1 KUNNR REF C CN
22 KNA1 FITYP J_1AFITP J_1AFITP 1 CN
23 KNA1 GFORM TVGF GFORM KEY 1 CN
24 KNA1 ICMSTAXPAY J_1BTICMSTAXPAY J_1BICMSTAXPAY KEY    
25 KNA1 INDTYP J_1BTINDTYP J_1BINDTYP KEY    
26 KNA1 J_1KFTBUS BUSTYPE GESTYP REF C CN
27 KNA1 J_1KFTIND INDUSTYPE INDTYPE REF C CN
28 KNA1 KATR1 TVK1 KATR1 KEY 1 CN
29 KNA1 KATR10 TVK0 KATR10 KEY 1 CN
30 KNA1 KATR2 TVK2 KATR2 KEY 1 CN
31 KNA1 KATR3 TVK3 KATR3 KEY 1 CN
32 KNA1 KATR4 TVK4 KATR4 KEY 1 CN
33 KNA1 KATR5 TVK5 KATR5 KEY 1 CN
34 KNA1 KATR6 TVK6 KATR6 KEY 1 CN
35 KNA1 KATR7 TVK7 KATR7 KEY 1 CN
36 KNA1 KATR8 TVK8 KATR8 KEY 1 CN
37 KNA1 KATR9 TVK9 KATR9 KEY 1 CN
38 KNA1 KDKG1 TVKGG KDKGR REF 1 CN
39 KNA1 KDKG2 TVKGG KDKGR REF 1 CN
40 KNA1 KDKG3 TVKGG KDKGR REF 1 CN
41 KNA1 KDKG4 TVKGG KDKGR REF 1 CN
42 KNA1 KDKG5 TVKGG KDKGR REF 1 CN
43 KNA1 KNAZK TFACD IDENT REF C CN
44 KNA1 KNRZA KNA1 KUNNR REF C CN
45 KNA1 KTOCD T077D KTOKD REF C CN
46 KNA1 KTOKD T077D KTOKD REF 1 CN
47 KNA1 KUKLA TKUKL KUKLA REF C CN
48 KNA1 LAND1 T005 LAND1 REF C CN
49 KNA1 LEGALNAT J_1BTLEGALNAT J_1BLEGALNAT KEY    
50 KNA1 LIFNR LFA1 LIFNR REF C CN
51 KNA1 LIFSD TVLS LIFSP REF C CN
52 KNA1 LZONE TZONE ZONE1 REF C CN
53 KNA1 MANDT T000 MANDT KEY 1 CN
54 KNA1 NIELS TNLS NIELS REF C CN
55 KNA1 PERIV T009 PERIV REF C CN
56 KNA1 PMT_OFFICE FMFGT_PO PMT_OFFICE    
57 KNA1 PSOFG PSO19 PSOFG 1 CN
58 KNA1 REGIO T005S BLAND REF C CN
59 KNA1 SPRAS T002 SPRAS REF 1 CN
60 KNA1 STCDT J_1ATODC J_1ATODC 1 CN
61 KNA1 TDT J_1BTTDT J_1BTDT KEY    
62 KNA1 TXJCD TTXJ TXJCD REF C CN
63 KNA1 TXLW1 J_1BATL1 TAXLAW 1 CN
64 KNA1 TXLW2 J_1BATL2 TAXLAW 1 CN
65 KNA1 UWAER TCURC WAERS REF 1 C
66 KNA1 VBUND T880 RCOMP REF C CN
67 KNA1 WERKS T001W WERKS REF C CN
68 KNA1 XSUBT J_1BTXSTG STGRP 1 CN
History
Last changed by/on SAP  20131127 
SAP Release Created in