SAP ABAP Table SI_KNA1_DI (Customer Master (General Part) Direct Input)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-FS-BP (Application Component) Business Partner Enhancements for Financial Services
     ⤷ FLBPD (Package) Business partner:

Basic Data

Table Category	INTTAB	Structure
Structure	SI_KNA1_DI	Table Relationship Diagram
Short Description	Customer Master (General Part) Direct Input

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	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
2	AUFSD	☐	AUFSD_X	KAUFS	CHAR	2	0	Central order block for customer	TVAST
3	BAHNE	☐	BAHNE	BAHNH	CHAR	25	0	Express train station
4	BAHNS	☐	BAHNS	BAHNH	CHAR	25	0	Train station
5	BBBNR	☐	BBBNR_DI	CHAR7	CHAR	7	0	International Location Number (Part 1) (Direct Input)
6	BBSNR	☐	BBSNR_DI	CHAR5	CHAR	5	0	International location number (Part 2)
7	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
8	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
9	BUBKZ	☐	BUBKZ_DI	CHAR1	CHAR	1	0	Check Digit for International Location Number (Direct Input)
10	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
11	ERDAT	☐	ERDAT_RF_DI	CHAR10	CHAR	10	0	Date on Which Record was Added (Direct Input)
12	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
13	EXABL	☐	EXABL	XFELD	CHAR	1	0	Indicator: Unloading points exist
14	FAKSD	☐	FAKSD_X	FAKSP	CHAR	2	0	Central billing block for customer	TVFS
15	FISKN	☐	FISKN_D	KUNNR	CHAR	10	0	Account number of the master record with the fiscal address	KNA1
16	KNAZK	☐	KNAZK	WFCID	CHAR	2	0	Working Time Calendar	TFACD
17	KNRZA	☐	KNRZA	KUNNR	CHAR	10	0	Account number of an alternative payer	KNA1
18	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
19	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	T077D
20	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	TKUKL
21	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
22	LIFSD	☐	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	TVLS
23	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
24	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
25	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
26	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
27	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	TNLS
28	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
29	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
30	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
31	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
32	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
33	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
34	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block
35	SPRAS	☐	SPRAS_DI	CHAR1	CHAR	1	0	Language Key (Direct Input)
36	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
37	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
38	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
39	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
40	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
41	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
42	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
43	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
44	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
45	XZEMP	☐	XREGU	XFELD	CHAR	1	0	Indicator: Is an alternative payer allowed in document?
46	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
47	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
48	DEAR1	☐	DEAR1	XFELD	CHAR	1	0	Indicator: Competitor
49	DEAR2	☐	DEAR2	XFELD	CHAR	1	0	Indicator: Sales partner
50	DEAR3	☐	DEAR3	DEAR3	CHAR	1	0	Indicator: Sales prospect
51	DEAR4	☐	DEAR4	XFELD	CHAR	1	0	Indicator for customer type 4
52	DEAR5	☐	DEAR5	XFELD	CHAR	1	0	ID for default sold-to party
53	GFORM	☐	GFORM	GFORM	CHAR	2	0	Legal status	TVGF
54	BRAN1	☐	BRAN1_D	BRACO	CHAR	10	0	Industry code 1	TBRC
55	BRAN2	☐	BRAN2	BRACO	CHAR	10	0	Industry code 2	TBRC
56	BRAN3	☐	BRAN3	BRACO	CHAR	10	0	Industry code 3	TBRC
57	BRAN4	☐	BRAN4	BRACO	CHAR	10	0	Industry code 4	TBRC
58	BRAN5	☐	BRAN5	BRACO	CHAR	10	0	Industry code 5	TBRC
59	EKONT	☐	EKONT	VBELN	CHAR	10	0	Initial contact	VBUK
60	UMSAT	☐	UMSAT_DI	CHAR10	CHAR	10	0	Annual Sales (Direct Input)
61	UMJAH	☐	UMJAH_DI	CHAR4	CHAR	4	0	Year for Which Sales Figures Apply (Direct Input)
62	UWAER	☐	UWAEHR_DI	CHAR5	CHAR	5	0	Currency of Sales Figure (Direct Input)
63	JMZAH	☐	JMZAH_DI	CHAR6	CHAR	6	0	Annual Employee Count (Direct Input)
64	JMJAH	☐	JMJAH_DI	CHAR4	CHAR	4	0	Year for which the number of employees is given
65	KATR1	☐	KATR1	ATTR1	CHAR	2	0	Attribute 1	TVK1
66	KATR2	☐	KATR2	ATTR2	CHAR	2	0	Attribute 2	TVK2
67	KATR3	☐	KATR3	ATTR3	CHAR	2	0	Attribute 3	TVK3
68	KATR4	☐	KATR4	ATTR4	CHAR	2	0	Attribute 4	TVK4
69	KATR5	☐	KATR5	ATTR5	CHAR	2	0	Attribute 5	TVK5
70	KATR6	☐	KATR6	ATTR6	CHAR	3	0	Attribute 6	TVK6
71	KATR7	☐	KATR7	ATTR7	CHAR	3	0	Attribute 7	TVK7
72	KATR8	☐	KATR8	ATTR8	CHAR	3	0	Attribute 8	TVK8
73	KATR9	☐	KATR9	ATTR9	CHAR	3	0	Attribute 9	TVK9
74	KATR10	☐	KATR10	ATTR10	CHAR	3	0	Attribute 10	TVK0
75	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
76	UMSA1	☐	UMSA1_DI	CHAR20	CHAR	20	0	Annual Sales (Direct Input)
77	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
78	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
79	ABRVW	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator	TVLV
80	INSPBYDEBI	☐	QINSPBYDEB	QKZ	CHAR	1	0	Inspection Carried Out By Customer (No Inspection Lot)
81	INSPATDEBI	☐	QINSPATDEB	QKZ	CHAR	1	0	Inspection for a Delivery Note After Outbound Delivery
82	KTOCD	☐	KTOCD	KTOKD	CHAR	4	0	Reference Account Group for One-Time Account (Customer)	T077D
83	PFORT	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
84	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
85	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
86	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	*
87	DUEFL	☐	DUEFL_BKPF	DUEFL_BKPF	CHAR	1	0	Status of Data Transfer into Subsequent Release
88	HZUOR	☐	HZUOR_DI	CHAR2	CHAR	2	0	Assignment to Hierarchy (Direct Input)
89	SPERZ	☐	SPERZ	XFELD	CHAR	1	0	Payment Block
90	ETIKG	☐	ETIKG	ETIKG	CHAR	10	0	IS-R Labeling: customer/plant group	TWEK
91	CIVVE	☐	CIVVE	XFELD	CHAR	1	0	ID for mainly non-military use
92	MILVE	☐	MILVE	XFELD	CHAR	1	0	ID for mainly military use
93	KDKG1	☐	KDKG1	KDKGR	CHAR	2	0	Customer condition group 1	TVKGG
94	KDKG2	☐	KDKG2	KDKGR	CHAR	2	0	Customer condition group 2	TVKGG
95	KDKG3	☐	KDKG3	KDKGR	CHAR	2	0	Customer condition group 3	TVKGG
96	KDKG4	☐	KDKG4	KDKGR	CHAR	2	0	Customer condition group 4	TVKGG
97	KDKG5	☐	KDKG5	KDKGR	CHAR	2	0	Customer condition group 5	TVKGG
98	XKNZA	☐	XKNZA	XFELD	CHAR	1	0	Indicator: Alternative payer using account number
99	FITYP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	J_1AFITP
100	STCDT	☐	J_1ATOID	J_1ATOID	CHAR	2	0	Tax Number Type	J_1ATODC
101	STCD3	☐	STCD3	CHAR18	CHAR	18	0	Tax Number 3
102	STCD4	☐	STCD4	CHAR18	CHAR	18	0	Tax Number 4
103	XICMS	☐	J_1BTCICMS	XFELD	CHAR	1	0	Customer is ICMS-exempt
104	XXIPI	☐	J_1BTCIPI	XFELD	CHAR	1	0	Customer is IPI-exempt
105	XSUBT	☐	J_1BTCST	J_1BTCST1	CHAR	3	0	Customer group for Substituiçao Tributária calculation	J_1BTXSTG
106	CFOPC	☐	J_1BINDUS1	J_1BINDUS1	CHAR	2	0	Customer's CFOP category
107	TXLW1	☐	J_1BTAXLW1	J_1BTAXLW1	CHAR	3	0	Tax law: ICMS	J_1BATL1
108	TXLW2	☐	J_1BTAXLW2	J_1BTAXLW2	CHAR	3	0	Tax law: IPI	J_1BATL2
109	CCC01	☐	CCC01	XFELD	CHAR	1	0	Indicator for biochemical warfare for legal control
110	CCC02	☐	CCC02	XFELD	CHAR	1	0	Indicator for nuclear nonproliferation for legal control
111	CCC03	☐	CCC03	XFELD	CHAR	1	0	Indicator for national security for legal control
112	CCC04	☐	CCC04	XFELD	CHAR	1	0	Indicator for missile technology for legal control
113	CASSD	☐	CASSD_X	CASSP	CHAR	2	0	Central sales block for customer
114	KNURL	☐	URL	TEXT132	CHAR	132	0	Uniform resource locator
115	J_1KFREPRE	☐	REPRES	REPRES	CHAR	10	0	Name of Representative
116	J_1KFTBUS	☐	GESTYP	GESTYP	CHAR	30	0	Type of Business	BUSTYPE
117	J_1KFTIND	☐	INDTYP	INDTYP	CHAR	30	0	Type of Industry	INDUSTYPE
118	CONFS	☐	CONFS_X	CHAR1	CHAR	1	0	Status of Change Authorization (Central)
119	UPDAT	☐	UPDAT_RF_DI	CHAR10	CHAR	10	0	Date on which Changes were Confirmed (Direct Input)
120	UPTIM	☐	UPTIM_RF_DI	CHAR8	CHAR	8	0	Time of Last Change Confirmation (Direct Input)
121	NODEL	☐	NODEL_X	XFELD	CHAR	1	0	Central deletion block for master record
122	DEAR6	☐	DEAR6	XFELD	CHAR	1	0	Indicator: Consumer

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	462