SAP ABAP Table IFMKNA1 (Customer Master)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FM-IS (Application Component) Information system
     ⤷ FMKO (Package) FM: Reporting for German Local Authorities

Basic Data

Table Category	INTTAB	Structure
Structure	IFMKNA1	Table Relationship Diagram
Short Description	Customer Master

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IFMKNA1	ABRVW	TVLV	ABRVW	REF	C	CN
2	IFMKNA1	AUFSD	TVAST	AUFSP	REF	C	CN
3	IFMKNA1	BRAN1	TBRC	BRACO	KEY	1	CN
4	IFMKNA1	BRAN2	TBRC	BRACO	KEY	1	CN
5	IFMKNA1	BRAN3	TBRC	BRACO	KEY	1	CN
6	IFMKNA1	BRAN4	TBRC	BRACO	KEY	1	CN
7	IFMKNA1	BRAN5	TBRC	BRACO	KEY	1	CN
8	IFMKNA1	BRSCH	T016	BRSCH	REF	C	CN
9	IFMKNA1	CITYC	T005G	CITYC	REF	C	CN
10	IFMKNA1	CNAE	J_1BTCNAE	J_1BCNAE	KEY
11	IFMKNA1	COMSIZE	J_1BTCOMSIZE	J_1BCOMSIZE	KEY
12	IFMKNA1	COUNC	T005E	COUNC	REF	C	CN
13	IFMKNA1	DECREGPC	J_1BTDECREGPC	J_1BDECREGPC	KEY
14	IFMKNA1	EKONT	VBUK	VBELN	REF	1	C
15	IFMKNA1	ETIKG	TWEK	KUNGR	REF	1	CN
16	IFMKNA1	FAKSD	TVFS	FAKSP	REF	C	CN
17	IFMKNA1	FISKN	KNA1	KUNNR	REF	C	CN
18	IFMKNA1	FITYP	J_1AFITP	J_1AFITP		1	CN
19	IFMKNA1	GFORM	TVGF	GFORM	KEY	1	CN
20	IFMKNA1	ICMSTAXPAY	J_1BTICMSTAXPAY	J_1BICMSTAXPAY	KEY
21	IFMKNA1	INDTYP	J_1BTINDTYP	J_1BINDTYP	KEY
22	IFMKNA1	J_1KFTBUS	BUSTYPE	GESTYP	REF	C	CN
23	IFMKNA1	J_1KFTIND	INDUSTYPE	INDTYPE	REF	C	CN
24	IFMKNA1	KATR1	TVK1	KATR1	KEY	1	CN
25	IFMKNA1	KATR10	TVK0	KATR10	KEY	1	CN
26	IFMKNA1	KATR2	TVK2	KATR2	KEY	1	CN
27	IFMKNA1	KATR3	TVK3	KATR3	KEY	1	CN
28	IFMKNA1	KATR4	TVK4	KATR4	KEY	1	CN
29	IFMKNA1	KATR5	TVK5	KATR5	KEY	1	CN
30	IFMKNA1	KATR6	TVK6	KATR6	KEY	1	CN
31	IFMKNA1	KATR7	TVK7	KATR7	KEY	1	CN
32	IFMKNA1	KATR8	TVK8	KATR8	KEY	1	CN
33	IFMKNA1	KATR9	TVK9	KATR9	KEY	1	CN
34	IFMKNA1	KDKG1	TVKGG	KDKGR	REF	1	CN
35	IFMKNA1	KDKG2	TVKGG	KDKGR	REF	1	CN
36	IFMKNA1	KDKG3	TVKGG	KDKGR	REF	1	CN
37	IFMKNA1	KDKG4	TVKGG	KDKGR	REF	1	CN
38	IFMKNA1	KDKG5	TVKGG	KDKGR	REF	1	CN
39	IFMKNA1	KNAZK	TFACD	IDENT	REF	C	CN
40	IFMKNA1	KNRZA	KNA1	KUNNR	REF	C	CN
41	IFMKNA1	KTOCD	T077D	KTOKD	REF	C	CN
42	IFMKNA1	KTOKD	T077D	KTOKD	REF	1	CN
43	IFMKNA1	KUKLA	TKUKL	KUKLA	REF	C	CN
44	IFMKNA1	LEGALNAT	J_1BTLEGALNAT	J_1BLEGALNAT	KEY
45	IFMKNA1	LIFNR	LFA1	LIFNR	REF	C	CN
46	IFMKNA1	LIFSD	TVLS	LIFSP	REF	C	CN
47	IFMKNA1	LZONE	TZONE	ZONE1	REF	C	CN
48	IFMKNA1	NIELS	TNLS	NIELS	REF	C	CN
49	IFMKNA1	PERIV	T009	PERIV	REF	C	CN
50	IFMKNA1	SPRAS	T002	SPRAS	REF	1	CN
51	IFMKNA1	STCDT	J_1ATODC	J_1ATODC		1	CN
52	IFMKNA1	TDT	J_1BTTDT	J_1BTDT	KEY
53	IFMKNA1	TXJCD	TTXJ	TXJCD	REF	C	CN
54	IFMKNA1	TXLW1	J_1BATL1	TAXLAW		1	CN
55	IFMKNA1	TXLW2	J_1BATL2	TAXLAW		1	CN
56	IFMKNA1	UWAER	TCURC	WAERS	REF	1	C
57	IFMKNA1	VBUND	T880	RCOMP	REF	C	CN
58	IFMKNA1	WERKS	T001W	WERKS	REF	C	CN
59	IFMKNA1	XSUBT	J_1BTXSTG	STGRP		1	CN

History

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