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