SAP ABAP Table CMDS_EI_EXTRACT (Complex Internal Structure for Customers)
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   LO-MD-BP-CM (Application Component) Customer Master
     CMD_INTERFACE (Package) Customer Interface
Basic Data
Table Category INTTAB    Structure 
Structure CMDS_EI_EXTRACT   Table Relationship Diagram
Short Description Complex Internal Structure for Customers    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 .INCLUDE       0   0   Tables for Central Data Compl. Structure Customer  
2 KNA1 KNA1   STRU 0   0    
3 MANDT MANDT MANDT CLNT 3   0   Client *
4 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number  
5 LAND1 LAND1_GP LAND1 CHAR 3   0   Country Key  
6 NAME1 NAME1_GP NAME CHAR 35   0   Name 1  
7 NAME2 NAME2_GP NAME CHAR 35   0   Name 2  
8 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
9 PSTLZ PSTLZ PSTLZ CHAR 10   0   Postal Code  
10 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) *
11 SORTL SORTL CHAR10 CHAR 10   0   Sort field  
12 STRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
13 TELF1 TELF1 TEXT16 CHAR 16   0   First telephone number  
14 TELFX TELFX TEXT31 CHAR 31   0   Fax Number  
15 XCPDK XCPDK XFELD CHAR 1   0   Indicator: Is the account a one-time account?  
16 ADRNR ADRNR ADRNR CHAR 10   0   Address *
17 MCOD1 MCDD1 CHAR25 CHAR 25   0   Search term for matchcode search  
18 MCOD2 MCDD2 CHAR25 CHAR 25   0   Search Term for Matchcode Search  
19 MCOD3 MCDD3 CHAR25 CHAR 25   0   Search term for matchcode search  
20 .INCLUDE       0   0   General Data in Customer Master  
21 ANRED ANRED TEXT15 CHAR 15   0   Title  
22 AUFSD AUFSD_X KAUFS CHAR 2   0   Central order block for customer *
23 BAHNE BAHNE BAHNH CHAR 25   0   Express train station  
24 BAHNS BAHNS BAHNH CHAR 25   0   Train station  
25 BBBNR BBBNR NUM07 NUMC 7   0   International location number (part 1)  
26 BBSNR BBSNR NUM05 NUMC 5   0   International location number (Part 2)  
27 BEGRU BRGRU BRGRU CHAR 4   0   Authorization Group *
28 BRSCH BRSCH BRSCH CHAR 4   0   Industry key *
29 BUBKZ BUBKZ NUM01 NUMC 1   0   Check digit for the international location number  
30 DATLT DATLT TEXT14 CHAR 14   0   Data communication line no.  
31 ERDAT ERDAT_RF DATUM DATS 8   0   Date on which the Record Was Created  
32 ERNAM ERNAM_RF USNAM CHAR 12   0   Name of Person who Created the Object  
33 EXABL EXABL XFELD CHAR 1   0   Indicator: Unloading points exist  
34 FAKSD FAKSD_X FAKSP CHAR 2   0   Central billing block for customer *
35 FISKN FISKN_D KUNNR CHAR 10   0   Account number of the master record with the fiscal address *
36 KNAZK KNAZK WFCID CHAR 2   0   Working Time Calendar *
37 KNRZA KNRZA KUNNR CHAR 10   0   Account number of an alternative payer *
38 KONZS KONZS KONZS CHAR 10   0   Group key  
39 KTOKD KTOKD KTOKD CHAR 4   0   Customer Account Group *
40 KUKLA KUKLA KUKLA CHAR 2   0   Customer classification *
41 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor  
42 LIFSD LIFSD_X LIFSP CHAR 2   0   Central delivery block for the customer *
43 LOCCO LOCCO LOCCO CHAR 10   0   City Coordinates  
44 LOEVM LOEVM_X XFELD CHAR 1   0   Central Deletion Flag for Master Record  
45 NAME3 NAME3_GP NAME CHAR 35   0   Name 3  
46 NAME4 NAME4_GP NAME CHAR 35   0   Name 4  
47 NIELS NIELS NIELS CHAR 2   0   Nielsen ID *
48 ORT02 ORT02_GP TEXT35 CHAR 35   0   District  
49 PFACH PFACH PFACH CHAR 10   0   PO Box  
50 PSTL2 PSTL2 PSTLZ CHAR 10   0   P.O. Box Postal Code  
51 COUNC COUNC COUNC CHAR 3   0   County Code *
52 CITYC CITYC CITYC CHAR 4   0   City Code *
53 RPMKR RPMKR RPMKR CHAR 5   0   Regional market  
54 SPERR SPERB_X XFELD CHAR 1   0   Central posting block  
55 SPRAS SPRAS SPRAS LANG 1   0   Language Key  
56 STCD1 STCD1 STCD1 CHAR 16   0   Tax Number 1  
57 STCD2 STCD2 STCD2 CHAR 11   0   Tax Number 2  
58 STKZA STKZA STKZA CHAR 1   0   Indicator: Business Partner Subject to Equalization Tax?  
59 STKZU STKZU XFELD CHAR 1   0   Liable for VAT  
60 TELBX TELBX TEXT15 CHAR 15   0   Telebox number  
61 TELF2 TELF2 TEXT16 CHAR 16   0   Second telephone number  
62 TELTX TELTX TEXT30 CHAR 30   0   Teletex number  
63 TELX1 TELX1 TEXT30 CHAR 30   0   Telex number  
64 LZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered *
65 XZEMP XREGU XFELD CHAR 1   0   Indicator: Is an alternative payer allowed in document?  
66 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner *
67 STCEG STCEG STCEG CHAR 20   0   VAT Registration Number  
68 DEAR1 DEAR1 XFELD CHAR 1   0   Indicator: Competitor  
69 DEAR2 DEAR2 XFELD CHAR 1   0   Indicator: Sales partner  
70 DEAR3 DEAR3 DEAR3 CHAR 1   0   Indicator: Sales prospect  
71 DEAR4 DEAR4 XFELD CHAR 1   0   Indicator for customer type 4  
72 DEAR5 DEAR5 XFELD CHAR 1   0   ID for default sold-to party  
73 GFORM GFORM GFORM CHAR 2   0   Legal status *
74 BRAN1 BRAN1_D BRACO CHAR 10   0   Industry code 1 *
75 BRAN2 BRAN2 BRACO CHAR 10   0   Industry code 2 *
76 BRAN3 BRAN3 BRACO CHAR 10   0   Industry code 3 *
77 BRAN4 BRAN4 BRACO CHAR 10   0   Industry code 4 *
78 BRAN5 BRAN5 BRACO CHAR 10   0   Industry code 5 *
79 EKONT EKONT VBELN CHAR 10   0   Initial contact *
80 UMSAT UMSAT UMSAT CURR 8   2   Annual sales  
81 UMJAH UMJAH JAHR NUMC 4   0   Year For Which Sales are Given  
82 UWAER UWAER WAERS CUKY 5   0   Currency of Sales Volume *
83 JMZAH JMZAH JMZAH NUMC 6   0   Yearly number of employees  
84 JMJAH JMJAH JAHR NUMC 4   0   Year for which the number of employees is given  
85 KATR1 KATR1 ATTR1 CHAR 2   0   Attribute 1 *
86 KATR2 KATR2 ATTR2 CHAR 2   0   Attribute 2 *
87 KATR3 KATR3 ATTR3 CHAR 2   0   Attribute 3 *
88 KATR4 KATR4 ATTR4 CHAR 2   0   Attribute 4 *
89 KATR5 KATR5 ATTR5 CHAR 2   0   Attribute 5 *
90 KATR6 KATR6 ATTR6 CHAR 3   0   Attribute 6 *
91 KATR7 KATR7 ATTR7 CHAR 3   0   Attribute 7 *
92 KATR8 KATR8 ATTR8 CHAR 3   0   Attribute 8 *
93 KATR9 KATR9 ATTR9 CHAR 3   0   Attribute 9 *
94 KATR10 KATR10 ATTR10 CHAR 3   0   Attribute 10 *
95 STKZN STKZN STKZN CHAR 1   0   Natural Person  
96 UMSA1 UMSA1 UMSA1 CURR 15   2   Annual sales  
97 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
98 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant *
99 ABRVW ABRVW ABRVW CHAR 3   0   Usage Indicator *
100 INSPBYDEBI QINSPBYDEB QKZ CHAR 1   0   Inspection Carried Out By Customer (No Inspection Lot)  
101 INSPATDEBI QINSPATDEB QKZ CHAR 1   0   Inspection for a Delivery Note After Outbound Delivery  
102 KTOCD KTOCD KTOKD CHAR 4   0   Reference Account Group for One-Time Account (Customer) *
103 PFORT PFORT_GP TEXT35 CHAR 35   0   PO Box city  
104 WERKS WERKS_D WERKS CHAR 4   0   Plant  
105 DTAMS DTAMS DTAMS CHAR 1   0   Report key for data medium exchange  
106 DTAWS DTAWS DTAWS CHAR 2   0   Instruction key for data medium exchange *
107 DUEFL DUEFL_BKPF DUEFL_BKPF CHAR 1   0   Status of Data Transfer into Subsequent Release  
108 HZUOR HZUOR HZUOR NUMC 2   0   Assignment to Hierarchy  
109 SPERZ SPERZ XFELD CHAR 1   0   Payment Block  
110 ETIKG ETIKG ETIKG CHAR 10   0   IS-R Labeling: customer/plant group *
111 CIVVE CIVVE XFELD CHAR 1   0   ID for mainly non-military use  
112 MILVE MILVE XFELD CHAR 1   0   ID for mainly military use  
113 KDKG1 KDKG1 KDKGR CHAR 2   0   Customer condition group 1 *
114 KDKG2 KDKG2 KDKGR CHAR 2   0   Customer condition group 2 *
115 KDKG3 KDKG3 KDKGR CHAR 2   0   Customer condition group 3 *
116 KDKG4 KDKG4 KDKGR CHAR 2   0   Customer condition group 4 *
117 KDKG5 KDKG5 KDKGR CHAR 2   0   Customer condition group 5 *
118 XKNZA XKNZA XFELD CHAR 1   0   Indicator: Alternative payer using account number  
119 FITYP J_1AFITP_D J_1AFITP CHAR 2   0   Tax type *
120 STCDT J_1ATOID J_1ATOID CHAR 2   0   Tax Number Type *
121 STCD3 STCD3 CHAR18 CHAR 18   0   Tax Number 3  
122 STCD4 STCD4 CHAR18 CHAR 18   0   Tax Number 4  
123 STCD5 STCD5 CHAR60 CHAR 60   0   Tax Number 5  
124 XICMS J_1BTCICMS XFELD CHAR 1   0   Customer is ICMS-exempt  
125 XXIPI J_1BTCIPI XFELD CHAR 1   0   Customer is IPI-exempt  
126 XSUBT J_1BTCST J_1BTCST1 CHAR 3   0   Customer group for Substituiçao Tributária calculation *
127 CFOPC J_1BINDUS1 J_1BINDUS1 CHAR 2   0   Customer's CFOP category  
128 TXLW1 J_1BTAXLW1 J_1BTAXLW1 CHAR 3   0   Tax law: ICMS *
129 TXLW2 J_1BTAXLW2 J_1BTAXLW2 CHAR 3   0   Tax law: IPI *
130 CCC01 CCC01 XFELD CHAR 1   0   Indicator for biochemical warfare for legal control  
131 CCC02 CCC02 XFELD CHAR 1   0   Indicator for nuclear nonproliferation for legal control  
132 CCC03 CCC03 XFELD CHAR 1   0   Indicator for national security for legal control  
133 CCC04 CCC04 XFELD CHAR 1   0   Indicator for missile technology for legal control  
134 CASSD CASSD_X CASSP CHAR 2   0   Central sales block for customer  
135 KNURL URL TEXT132 CHAR 132   0   Uniform resource locator  
136 J_1KFREPRE REPRES REPRES CHAR 10   0   Name of Representative  
137 J_1KFTBUS GESTYP GESTYP CHAR 30   0   Type of Business *
138 J_1KFTIND INDTYP INDTYP CHAR 30   0   Type of Industry *
139 CONFS CONFS_X CHAR1 CHAR 1   0   Status of Change Authorization (Central)  
140 UPDAT UPDAT_RF DATUM DATS 8   0   Date on Which the Changes Were Confirmed  
141 UPTIM UPTIM_RF AS4TIME TIMS 6   0   Time of Last Change Confirmation  
142 NODEL NODEL_X XFELD CHAR 1   0   Central deletion block for master record  
143 DEAR6 DEAR6 XFELD CHAR 1   0   Indicator: Consumer  
144 .INCLUDE       0   0   Customer Master Data - Brazil  
145 SUFRAMA J_1BSUFRAMA J_1BSUFRAMA CHAR 9   0   Suframa Code  
146 RG J_1BRG J_1BRG CHAR 11   0   RG Number  
147 EXP J_1BEXP J_1BEXP CHAR 3   0   Issued by  
148 UF J_1BUF J_1BUF CHAR 2   0   State  
149 RGDATE J_1BRGDATE DATUM DATS 8   0   RG Issue Date  
150 RIC J_1BRIC J_1BRIC NUMC 11   0   RIC Number  
151 RNE J_1BRNE J_1BRNE CHAR 10   0   Foreign National Registration  
152 RNEDATE J_1BRNEDATE DATUM DATS 8   0   RNE Issue Date  
153 CNAE J_1BCNAE J_1BCNAE CHAR 7   0   CNAE *
154 LEGALNAT J_1BLEGALNAT J_1BLEGALNAT NUMC 4   0   Legal Nature *
155 CRTN J_1BCRTN J_1BCRTN CHAR 1   0   CRT Number  
156 ICMSTAXPAY J_1BICMSTAXPAY J_1BICMSTAXPAY CHAR 2   0   ICMS Taxpayer *
157 INDTYP J_1BINDTYP J_1BINDTYP CHAR 2   0   Industry Main Type *
158 TDT J_1BTDT J_1BTDT CHAR 2   0   Tax Declaration Type *
159 COMSIZE J_1BCOMSIZE J_1BCOMSIZE CHAR 2   0   Company Size *
160 DECREGPC J_1BDECREGPC J_1BDECREGPC CHAR 2   0   Declaration Regimen for PIS/COFINS *
161 .INCLU--AP       0   0   Append to KNA1 for Vehicle Space Optimization  
162 .INCLUDE       0   0   Additional Data for Vehicle Space Optimization for KNA1  
163 /VSO/R_PALHGT /VSO/R_PAL_BIN_HGT MENG13 QUAN 13   3   Maximum Stacking Height of the Packaging Material (VSO)  
164 /VSO/R_PAL_UL /VSO/R_PAL_UNIT_L MEINS UNIT 3   0   Unit of Length for Packaging Material (VSO) *
165 /VSO/R_PK_MAT /VSO/M_PACK_BY_MAT /VSO/M_XFIELD CHAR 1   0   Customer-Related Packing for Each Packaging Material (VSO)  
166 /VSO/R_MATPAL /VSO/M_MATNR_PAL MATNR CHAR 18   0   Packaging Material of the Customer in VSO *
167 /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)  
168 /VSO/R_ONE_MAT /VSO/M_ONE_MAT /VSO/M_XFIELD CHAR 1   0   Packing Material-Specific for Each Packaging Material  
169 /VSO/R_ONE_SORT /VSO/M_ONE_SORT /VSO/M_XFIELD CHAR 1   0   Pack Only One Package Type for Each PKM (VSO)  
170 /VSO/R_ULD_SIDE /VSO/M_UNLOAD_SIDE_PREF /VSO/M_SIDE_PREF NUMC 1   0   Side Preference of Loading/Unloading (VSO)  
171 /VSO/R_LOAD_PREF /VSO/M_LOAD_PREF /VSO/M_LOAD_PREF NUMC 1   0   Front/Back Preference of Loading/Unloading (VSO)  
172 /VSO/R_DPOINT /VSO/R_DELIVERYPOINT /VSO/R_DELIVERYPOINT CHAR 10   0   Collective Unloading Point for VSO  
173 .INCLU--AP       0   0   US Federal Government Customer Master Data Additional Fields  
174 ALC FMFG_ALC FMFG_ALC CHAR 8   0   Agency Location Code *
175 PMT_OFFICE FMFG_PMT_OFF FMFG_PMT_OFF CHAR 5   0   Payment Office *
176 .INCLUDE       0   0    
177 .INCLU--AP       0   0   Local Authority Additional Fields  
178 PSOFG PSOFG PSOFG CHAR 10   0   Processor group *
179 PSOIS PSOIS CHAR20 CHAR 20   0   Subledger acct preprocessing procedure  
180 .INCLUDE       0   0   Local Authority Additional Fields (Address)  
181 PSON1 NAME1_GP NAME CHAR 35   0   Name 1  
182 PSON2 NAME2_GP NAME CHAR 35   0   Name 2  
183 PSON3 NAME3_GP NAME CHAR 35   0   Name 3  
184 PSOVN PSOVN NAME CHAR 35   0   First Name  
185 PSOTL PSOTL FMPSOTL CHAR 20   0   Title  
186 PSOHS PSOHS CHAR06 CHAR 6   0   House number: is no longer used from Release 4.6B  
187 PSOST PSOST PSOST CHAR 28   0   Street: No longer used from Release 4.6B  
188 .INCLUDE       0   0   Description (Customer/Vendor Supplement)  
189 PSOO1 PSOO1 TEXT50 CHAR 50   0   Description  
190 PSOO2 PSOO1 TEXT50 CHAR 50   0   Description  
191 PSOO3 PSOO1 TEXT50 CHAR 50   0   Description  
192 PSOO4 PSOO1 TEXT50 CHAR 50   0   Description  
193 PSOO5 PSOO1 TEXT50 CHAR 50   0   Description  
194 KNAS CMDS_KNAS_T   TTYP 0   0    
195 KNAT CMDS_KNAT_T   TTYP 0   0    
196 KNVI CMDS_KNVI_T   TTYP 0   0    
197 KNEX CMDS_KNEX_T   TTYP 0   0    
198 KNVA CMDS_KNVA_T   TTYP 0   0    
199 KNVK CMDS_KNVK_T   TTYP 0   0    
200 VCNUM CMDS_VCNUM_T   TTYP 0   0    
201 VCKUN CMDS_VCKUN_T   TTYP 0   0    
202 KNBK CMDS_KNBK_T   TTYP 0   0    
203 KNA1_TEXT CMDS_KNA1_TEXT_T   TTYP 0   0    
204 KNVK_TEXT CMDS_KNVK_TEXT_T   TTYP 0   0    
205 IBAN CVIS_IBAN_T   TTYP 0   0    
206 .INCLUDE       0   0   Tables for Company Data Compl. Structure Customer  
207 KNB1 CMDS_KNB1_T   TTYP 0   0    
208 KNB5 CMDS_KNB5_T   TTYP 0   0    
209 KNBW CMDS_KNBW_T   TTYP 0   0    
210 KNB1_TEXT CMDS_KNB1_TEXT_T   TTYP 0   0    
211 .INCLUDE       0   0   Tables for Sales Data Compl. Structure Customer  
212 KNVV CMDS_KNVV_T   TTYP 0   0    
213 KNVP CMDS_KNVP_T   TTYP 0   0    
214 KNVV_TEXT CMDS_KNVV_TEXT_T   TTYP 0   0    
215 T_UPD_TXT CMDS_FKUNTXT_TAB   TTYP 0   0    
216 .INCLUDE       0   0   Complex Structure Address Data  
217 .INCLUDE       0   0   Complex Structure Address Type 1 Data  
218 T1_ADRC ADRC_TAB   TTYP 0   0    
219 .INCLUDE       0   0   Complex Structure Address Type 1-Data Communication Data  
220 T1_ADR2 ADR2_TAB   TTYP 0   0    
221 T1_ADR3 ADR3_TAB   TTYP 0   0    
222 T1_ADR4 ADR4_TAB   TTYP 0   0    
223 T1_ADR5 ADR5_TAB   TTYP 0   0    
224 T1_ADR6 ADR6_TAB   TTYP 0   0    
225 T1_ADR7 ADR7_TAB   TTYP 0   0    
226 T1_ADR8 ADR8_TAB   TTYP 0   0    
227 T1_ADR9 ADR9_TAB   TTYP 0   0    
228 T1_ADR10 ADR10_TAB   TTYP 0   0    
229 T1_ADR11 ADR11_TAB   TTYP 0   0    
230 T1_ADR12 ADR12_TAB   TTYP 0   0    
231 T1_ADR13 ADR13_TAB   TTYP 0   0    
232 T1_ADRCT ADRCT_TAB   TTYP 0   0    
233 T1_ADRT ADRT_TAB   TTYP 0   0    
234 .INCLUDE       0   0   Complex Structure Address Data Type 2  
235 T2_ADRC ADRC_TAB   TTYP 0   0    
236 T2_ADRP ADRP_TAB   TTYP 0   0    
237 .INCLUDE       0   0   Complex Structure Address Type 2-Data Communication Data  
238 T2_ADR2 ADR2_TAB   TTYP 0   0    
239 T2_ADR3 ADR3_TAB   TTYP 0   0    
240 T2_ADR4 ADR4_TAB   TTYP 0   0    
241 T2_ADR5 ADR5_TAB   TTYP 0   0    
242 T2_ADR6 ADR6_TAB   TTYP 0   0    
243 T2_ADR7 ADR7_TAB   TTYP 0   0    
244 T2_ADR8 ADR8_TAB   TTYP 0   0    
245 T2_ADR9 ADR9_TAB   TTYP 0   0    
246 T2_ADR10 ADR10_TAB   TTYP 0   0    
247 T2_ADR11 ADR11_TAB   TTYP 0   0    
248 T2_ADR12 ADR12_TAB   TTYP 0   0    
249 T2_ADR13 ADR13_TAB   TTYP 0   0    
250 T2_ADRCT ADRCT_TAB   TTYP 0   0    
251 T2_ADRT ADRT_TAB   TTYP 0   0    
252 .INCLUDE       0   0   Complex Structure Address Data Type 3  
253 T3_ADCP ADCP_TAB   TTYP 0   0    
254 T3_ADRP ADRP_TAB   TTYP 0   0    
255 T3_ADRC ADRC_TAB   TTYP 0   0    
256 .INCLUDE       0   0   Complex Structure Address Type 2-Data Communication Data  
257 T3_ADR2 ADR2_TAB   TTYP 0   0    
258 T3_ADR3 ADR3_TAB   TTYP 0   0    
259 T3_ADR4 ADR4_TAB   TTYP 0   0    
260 T3_ADR5 ADR5_TAB   TTYP 0   0    
261 T3_ADR6 ADR6_TAB   TTYP 0   0    
262 T3_ADR7 ADR7_TAB   TTYP 0   0    
263 T3_ADR8 ADR8_TAB   TTYP 0   0    
264 T3_ADR9 ADR9_TAB   TTYP 0   0    
265 T3_ADR10 ADR10_TAB   TTYP 0   0    
266 T3_ADR11 ADR11_TAB   TTYP 0   0    
267 T3_ADR12 ADR12_TAB   TTYP 0   0    
268 T3_ADR13 ADR13_TAB   TTYP 0   0    
269 T3_ADRT ADRT_TAB   TTYP 0   0    
History
Last changed by/on SAP  20140121 
SAP Release Created in 600