SAP ABAP Table BIW_KNA1_S (Provider Structure: Customer Master Data from KNA1)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ MDX (Package) Master Data Extractors

Basic Data

Table Category	INTTAB	Structure
Structure	BIW_KNA1_S	Table Relationship Diagram
Short Description	Provider Structure: Customer Master Data from 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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	KUNNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
3	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
4	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
5	AUFSD	☐	AUFSD_X	KAUFS	CHAR	2	0	Central order block for customer	*
6	BAHNE	☐	BAHNE	BAHNH	CHAR	25	0	Express train station
7	BAHNS	☐	BAHNS	BAHNH	CHAR	25	0	Train station
8	BBBNR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
9	BBSNR	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
10	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
11	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	*
12	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
13	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
14	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
15	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
16	EXABL	☐	EXABL	XFELD	CHAR	1	0	Indicator: Unloading points exist
17	FAKSD	☐	FAKSD_X	FAKSP	CHAR	2	0	Central billing block for customer	*
18	FISKN	☐	FISKN_D	KUNNR	CHAR	10	0	Account number of the master record with the fiscal address	*
19	KNAZK	☐	KNAZK	WFCID	CHAR	2	0	Working Time Calendar	*
20	KNRZA	☐	KNRZA	KUNNR	CHAR	10	0	Account number of an alternative payer	*
21	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
22	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	*
23	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	*
24	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
25	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
26	LIFSD	☐	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	*
27	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
28	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
29	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
30	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
31	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
32	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
33	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	*
34	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
35	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
36	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
37	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
38	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
39	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
40	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	*
41	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	*
42	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
43	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
44	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block
45	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
46	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
47	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
48	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
49	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
50	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
51	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
52	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
53	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
54	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
55	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
56	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
57	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	*
58	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
59	XZEMP	☐	XZEMP	XFELD	CHAR	1	0	Indicator: Alternative payee in document allowed ?
60	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
61	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
62	DEAR1	☐	DEAR1	XFELD	CHAR	1	0	Indicator: Competitor
63	DEAR2	☐	DEAR2	XFELD	CHAR	1	0	Indicator: Sales partner
64	DEAR3	☐	DEAR3	DEAR3	CHAR	1	0	Indicator: Sales prospect
65	DEAR4	☐	DEAR4	XFELD	CHAR	1	0	Indicator for customer type 4
66	DEAR5	☐	DEAR5	XFELD	CHAR	1	0	ID for default sold-to party
67	DEAR6	☐	DEAR6	XFELD	CHAR	1	0	Indicator: Consumer
68	GFORM	☐	GFORM	GFORM	CHAR	2	0	Legal status	*
69	BRAN1	☐	BRAN1_D	BRACO	CHAR	10	0	Industry code 1	*
70	BRAN2	☐	BRAN2	BRACO	CHAR	10	0	Industry code 2	*
71	BRAN3	☐	BRAN3	BRACO	CHAR	10	0	Industry code 3	*
72	BRAN4	☐	BRAN4	BRACO	CHAR	10	0	Industry code 4	*
73	BRAN5	☐	BRAN5	BRACO	CHAR	10	0	Industry code 5	*
74	EKONT	☐	EKONT	VBELN	CHAR	10	0	Initial contact	*
75	UMSAT	☐	UMSAT	UMSAT	CURR	8	2	Annual sales
76	UMJAH	☐	UMJAH	JAHR	NUMC	4	0	Year For Which Sales are Given
77	UWAER	☐	UWAER	WAERS	CUKY	5	0	Currency of Sales Volume	*
78	JMZAH	☐	JMZAH	JMZAH	NUMC	6	0	Yearly number of employees
79	JMJAH	☐	JMJAH	JAHR	NUMC	4	0	Year for which the number of employees is given
80	KATR1	☐	KATR1	ATTR1	CHAR	2	0	Attribute 1	*
81	KATR2	☐	KATR2	ATTR2	CHAR	2	0	Attribute 2	*
82	KATR3	☐	KATR3	ATTR3	CHAR	2	0	Attribute 3	*
83	KATR4	☐	KATR4	ATTR4	CHAR	2	0	Attribute 4	*
84	KATR5	☐	KATR5	ATTR5	CHAR	2	0	Attribute 5	*
85	KATR6	☐	KATR6	ATTR6	CHAR	3	0	Attribute 6	*
86	KATR7	☐	KATR7	ATTR7	CHAR	3	0	Attribute 7	*
87	KATR8	☐	KATR8	ATTR8	CHAR	3	0	Attribute 8	*
88	KATR9	☐	KATR9	ATTR9	CHAR	3	0	Attribute 9	*
89	KATR10	☐	KATR10	ATTR10	CHAR	3	0	Attribute 10	*
90	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
91	UMSA1	☐	UMSA1	UMSA1	CURR	15	2	Annual sales
92	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
93	MCOD1	☐	MCDD1	CHAR25	CHAR	25	0	Search term for matchcode search
94	MCOD2	☐	MCDD2	CHAR25	CHAR	25	0	Search Term for Matchcode Search
95	MCOD3	☐	MCDD3	CHAR25	CHAR	25	0	Search term for matchcode search
96	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
97	ABRVW	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator	*
98	INSPBYDEBI	☐	QINSPBYDEB	QKZ	CHAR	1	0	Inspection Carried Out By Customer (No Inspection Lot)
99	INSPATDEBI	☐	QINSPATDEB	QKZ	CHAR	1	0	Inspection for a Delivery Note After Outbound Delivery
100	KTOCD	☐	KTOCD	KTOKD	CHAR	4	0	Reference Account Group for One-Time Account (Customer)	*
101	PFORT	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
102	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
103	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
104	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	*
105	DUEFL	☐	DUEFL_BKPF	DUEFL_BKPF	CHAR	1	0	Status of Data Transfer into Subsequent Release
106	HZUOR	☐	HZUOR	HZUOR	NUMC	2	0	Assignment to Hierarchy
107	SPERZ	☐	SPERZ	XFELD	CHAR	1	0	Payment Block
108	ETIKG	☐	ETIKG	ETIKG	CHAR	10	0	IS-R Labeling: customer/plant group	*
109	CIVVE	☐	CIVVE	XFELD	CHAR	1	0	ID for mainly non-military use
110	MILVE	☐	MILVE	XFELD	CHAR	1	0	ID for mainly military use
111	KDKG1	☐	KDKG1	KDKGR	CHAR	2	0	Customer condition group 1	TVKGG
112	KDKG2	☐	KDKG2	KDKGR	CHAR	2	0	Customer condition group 2	TVKGG
113	KDKG3	☐	KDKG3	KDKGR	CHAR	2	0	Customer condition group 3	TVKGG
114	KDKG4	☐	KDKG4	KDKGR	CHAR	2	0	Customer condition group 4	TVKGG
115	KDKG5	☐	KDKG5	KDKGR	CHAR	2	0	Customer condition group 5	TVKGG
116	XKNZA	☐	XKNZA	XFELD	CHAR	1	0	Indicator: Alternative payer using account number
117	FITYP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	J_1AFITP
118	STCDT	☐	J_1ATOID	J_1ATOID	CHAR	2	0	Tax Number Type	J_1ATODC
119	STCD3	☐	STCD3	CHAR18	CHAR	18	0	Tax Number 3
120	STCD4	☐	STCD4	CHAR18	CHAR	18	0	Tax Number 4
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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BIW_KNA1_S	FITYP	J_1AFITP	J_1AFITP		1	CN
2	BIW_KNA1_S	KDKG1	TVKGG	KDKGR	REF	1	CN
3	BIW_KNA1_S	KDKG2	TVKGG	KDKGR	REF	1	CN
4	BIW_KNA1_S	KDKG3	TVKGG	KDKGR	REF	1	CN
5	BIW_KNA1_S	KDKG4	TVKGG	KDKGR	REF	1	CN
6	BIW_KNA1_S	KDKG5	TVKGG	KDKGR	REF	1	CN
7	BIW_KNA1_S	STCDT	J_1ATODC	J_1ATODC		1	CN
8	BIW_KNA1_S	TXLW1	J_1BATL1	TAXLAW		1	CN
9	BIW_KNA1_S	TXLW2	J_1BATL2	TAXLAW		1	CN
10	BIW_KNA1_S	XSUBT	J_1BTXSTG	STGRP	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in