SAP ABAP Table E3KNA1M (Master customer master basic data (KNA1))

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CO-OM-CCA (Application Component) Cost Center Accounting
     ⤷ KSVCORE (Package) Cost Centers ALE

Basic Data

Table Category	INTTAB	Structure
Structure	E3KNA1M	Table Relationship Diagram
Short Description	Master customer master basic data (KNA1)

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	MSGFN	☑	MSGFN	MSGFN	CHAR	3	0	Function
2	KUNNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
3	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
4	AUFSD	☐	AUFSD_X	KAUFS	CHAR	2	0	Central order block for customer	*
5	BAHNE	☐	BAHNE	BAHNH	CHAR	25	0	Express train station
6	BAHNS	☐	BAHNS	BAHNH	CHAR	25	0	Train station
7	BBBNR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
8	BBSNR	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
9	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
10	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	*
11	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
12	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
13	FAKSD	☐	FAKSD_X	FAKSP	CHAR	2	0	Central billing block for customer	*
14	FISKN	☐	FISKN_D	KUNNR	CHAR	10	0	Account number of the master record with the fiscal address	*
15	KNRZA	☐	KNRZA	KUNNR	CHAR	10	0	Account number of an alternative payer	*
16	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
17	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	*
18	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	*
19	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
20	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
21	LIFSD	☐	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	*
22	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
23	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
24	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
25	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
26	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
27	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
28	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	*
29	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
30	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
31	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
32	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
33	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
34	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
35	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	*
36	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	*
37	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
38	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
39	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block
40	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
41	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
42	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
43	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
44	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
45	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
46	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
47	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
48	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
49	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
50	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
51	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
52	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	*
53	XZEMP	☐	XZEMP	XFELD	CHAR	1	0	Indicator: Alternative payee in document allowed ?
54	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
55	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
56	GFORM	☐	GFORM	GFORM	CHAR	2	0	Legal status	*
57	BRAN1	☐	BRAN1_D	BRACO	CHAR	10	0	Industry code 1	*
58	BRAN2	☐	BRAN2	BRACO	CHAR	10	0	Industry code 2	*
59	BRAN3	☐	BRAN3	BRACO	CHAR	10	0	Industry code 3	*
60	BRAN4	☐	BRAN4	BRACO	CHAR	10	0	Industry code 4	*
61	BRAN5	☐	BRAN5	BRACO	CHAR	10	0	Industry code 5	*
62	UMJAH	☐	UMJAH	JAHR	NUMC	4	0	Year For Which Sales are Given
63	UWAER	☐	UWAER	WAERS	CUKY	5	0	Currency of Sales Volume	*
64	JMZAH	☐	JMZAH	JMZAH	NUMC	6	0	Yearly number of employees
65	JMJAH	☐	JMJAH	JAHR	NUMC	4	0	Year for which the number of employees is given
66	KATR1	☐	KATR1	ATTR1	CHAR	2	0	Attribute 1	*
67	KATR2	☐	KATR2	ATTR2	CHAR	2	0	Attribute 2	*
68	KATR3	☐	KATR3	ATTR3	CHAR	2	0	Attribute 3	*
69	KATR4	☐	KATR4	ATTR4	CHAR	2	0	Attribute 4	*
70	KATR5	☐	KATR5	ATTR5	CHAR	2	0	Attribute 5	*
71	KATR6	☐	KATR6	ATTR6	CHAR	3	0	Attribute 6	*
72	KATR7	☐	KATR7	ATTR7	CHAR	3	0	Attribute 7	*
73	KATR8	☐	KATR8	ATTR8	CHAR	3	0	Attribute 8	*
74	KATR9	☐	KATR9	ATTR9	CHAR	3	0	Attribute 9	*
75	KATR10	☐	KATR10	ATTR10	CHAR	3	0	Attribute 10	*
76	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
77	UMSA1	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
78	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
79	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
80	KTOCD	☐	KTOCD	KTOKD	CHAR	4	0	Reference Account Group for One-Time Account (Customer)	*
81	PFORT	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
82	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
83	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	*

History

Last changed by/on	SAP	20130529
SAP Release Created in