SAP ABAP Table CMDS_EI_EXTRACT_CENTRAL_DATA (Tables for Central Data Compl. Structure Customer)

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_CENTRAL_DATA	Table Relationship Diagram
Short Description	Tables for Central Data Compl. Structure Customer

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

History

Last changed by/on	SAP	20131127
SAP Release Created in	600