SAP ABAP Table BIW_KNVK_S (Extraction Structure 0CONSUMER_ATTR)

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_KNVK_S	Table Relationship Diagram
Short Description	Extraction Structure 0CONSUMER_ATTR

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	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	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
14	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
15	EXABL	☐	EXABL	XFELD	CHAR	1	0	Indicator: Unloading points exist
16	FAKSD	☐	FAKSD_X	FAKSP	CHAR	2	0	Central billing block for customer	*
17	FISKN	☐	FISKN_D	KUNNR	CHAR	10	0	Account number of the master record with the fiscal address	*
18	KNAZK	☐	KNAZK	WFCID	CHAR	2	0	Working Time Calendar	*
19	KNRZA	☐	KNRZA	KUNNR	CHAR	10	0	Account number of an alternative payer	*
20	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
21	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	*
22	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	*
23	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
24	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
25	LIFSD	☐	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	*
26	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
27	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
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	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block
39	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
40	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
41	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
42	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
43	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
44	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
45	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
46	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
47	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
48	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
49	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
50	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
51	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	*
52	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
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	DEAR1	☐	DEAR1	XFELD	CHAR	1	0	Indicator: Competitor
57	DEAR2	☐	DEAR2	XFELD	CHAR	1	0	Indicator: Sales partner
58	DEAR3	☐	DEAR3	DEAR3	CHAR	1	0	Indicator: Sales prospect
59	DEAR4	☐	DEAR4	XFELD	CHAR	1	0	Indicator for customer type 4
60	DEAR5	☐	DEAR5	XFELD	CHAR	1	0	ID for default sold-to party
61	DEAR6	☐	DEAR6	XFELD	CHAR	1	0	Indicator: Consumer
62	GFORM	☐	GFORM	GFORM	CHAR	2	0	Legal status	*
63	BRAN1	☐	BRAN1_D	BRACO	CHAR	10	0	Industry code 1	*
64	BRAN2	☐	BRAN2	BRACO	CHAR	10	0	Industry code 2	*
65	BRAN3	☐	BRAN3	BRACO	CHAR	10	0	Industry code 3	*
66	BRAN4	☐	BRAN4	BRACO	CHAR	10	0	Industry code 4	*
67	BRAN5	☐	BRAN5	BRACO	CHAR	10	0	Industry code 5	*
68	EKONT	☐	EKONT	VBELN	CHAR	10	0	Initial contact	*
69	UMSAT	☐	UMSAT	UMSAT	CURR	8	2	Annual sales
70	UMJAH	☐	UMJAH	JAHR	NUMC	4	0	Year For Which Sales are Given
71	UWAER	☐	UWAER	WAERS	CUKY	5	0	Currency of Sales Volume	*
72	JMZAH	☐	JMZAH	JMZAH	NUMC	6	0	Yearly number of employees
73	JMJAH	☐	JMJAH	JAHR	NUMC	4	0	Year for which the number of employees is given
74	KATR1	☐	KATR1	ATTR1	CHAR	2	0	Attribute 1	*
75	KATR2	☐	KATR2	ATTR2	CHAR	2	0	Attribute 2	*
76	KATR3	☐	KATR3	ATTR3	CHAR	2	0	Attribute 3	*
77	KATR4	☐	KATR4	ATTR4	CHAR	2	0	Attribute 4	*
78	KATR5	☐	KATR5	ATTR5	CHAR	2	0	Attribute 5	*
79	KATR6	☐	KATR6	ATTR6	CHAR	3	0	Attribute 6	*
80	KATR7	☐	KATR7	ATTR7	CHAR	3	0	Attribute 7	*
81	KATR8	☐	KATR8	ATTR8	CHAR	3	0	Attribute 8	*
82	KATR9	☐	KATR9	ATTR9	CHAR	3	0	Attribute 9	*
83	KATR10	☐	KATR10	ATTR10	CHAR	3	0	Attribute 10	*
84	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
85	UMSA1	☐	UMSA1	UMSA1	CURR	15	2	Annual sales
86	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
87	MCOD1	☐	MCDD1	CHAR25	CHAR	25	0	Search term for matchcode search
88	MCOD2	☐	MCDD2	CHAR25	CHAR	25	0	Search Term for Matchcode Search
89	MCOD3	☐	MCDD3	CHAR25	CHAR	25	0	Search term for matchcode search
90	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
91	ABRVW	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator	*
92	INSPBYDEBI	☐	QINSPBYDEB	QKZ	CHAR	1	0	Inspection Carried Out By Customer (No Inspection Lot)
93	INSPATDEBI	☐	QINSPATDEB	QKZ	CHAR	1	0	Inspection for a Delivery Note After Outbound Delivery
94	KTOCD	☐	KTOCD	KTOKD	CHAR	4	0	Reference Account Group for One-Time Account (Customer)	*
95	PFORT	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
96	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
97	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
98	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	*
99	DUEFL	☐	DUEFL_BKPF	DUEFL_BKPF	CHAR	1	0	Status of Data Transfer into Subsequent Release
100	HZUOR	☐	HZUOR	HZUOR	NUMC	2	0	Assignment to Hierarchy
101	SPERZ	☐	SPERZ	XFELD	CHAR	1	0	Payment Block
102	ETIKG	☐	ETIKG	ETIKG	CHAR	10	0	IS-R Labeling: customer/plant group	*
103	CIVVE	☐	CIVVE	XFELD	CHAR	1	0	ID for mainly non-military use
104	MILVE	☐	MILVE	XFELD	CHAR	1	0	ID for mainly military use
105	KDKG1	☐	KDKG1	KDKGR	CHAR	2	0	Customer condition group 1	*
106	KDKG2	☐	KDKG2	KDKGR	CHAR	2	0	Customer condition group 2	*
107	KDKG3	☐	KDKG3	KDKGR	CHAR	2	0	Customer condition group 3	*
108	KDKG4	☐	KDKG4	KDKGR	CHAR	2	0	Customer condition group 4	*
109	KDKG5	☐	KDKG5	KDKGR	CHAR	2	0	Customer condition group 5	*
110	XKNZA	☐	XKNZA	XFELD	CHAR	1	0	Indicator: Alternative payer using account number
111	FITYP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	*
112	STCDT	☐	J_1ATOID	J_1ATOID	CHAR	2	0	Tax Number Type	*
113	STCD3	☐	STCD3	CHAR18	CHAR	18	0	Tax Number 3
114	STCD4	☐	STCD4	CHAR18	CHAR	18	0	Tax Number 4
115	XICMS	☐	J_1BTCICMS	XFELD	CHAR	1	0	Customer is ICMS-exempt
116	XXIPI	☐	J_1BTCIPI	XFELD	CHAR	1	0	Customer is IPI-exempt
117	XSUBT	☐	J_1BTCST	J_1BTCST1	CHAR	3	0	Customer group for Substituiçao Tributária calculation	*
118	CFOPC	☐	J_1BINDUS1	J_1BINDUS1	CHAR	2	0	Customer's CFOP category
119	TXLW1	☐	J_1BTAXLW1	J_1BTAXLW1	CHAR	3	0	Tax law: ICMS	*
120	TXLW2	☐	J_1BTAXLW2	J_1BTAXLW2	CHAR	3	0	Tax law: IPI	*
121	CCC01	☐	CCC01	XFELD	CHAR	1	0	Indicator for biochemical warfare for legal control
122	CCC02	☐	CCC02	XFELD	CHAR	1	0	Indicator for nuclear nonproliferation for legal control
123	CCC03	☐	CCC03	XFELD	CHAR	1	0	Indicator for national security for legal control
124	CCC04	☐	CCC04	XFELD	CHAR	1	0	Indicator for missile technology for legal control
125	CASSD	☐	CASSD_X	CASSP	CHAR	2	0	Central sales block for customer
126	KNURL	☐	URL	TEXT132	CHAR	132	0	Uniform resource locator
127	PARNR	☐	PARNR	PARNR	NUMC	10	0	Number of contact person
128	NAMEV	☐	NAMEV_VP	NAME	CHAR	35	0	First name
129	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
130	ADRND	☐	ADRND	ADRNR	CHAR	10	0	Business address	*
131	ADRNP	☐	ADRNP	ADRNR	CHAR	10	0	Private address	*
132	ABTPA	☐	ABTEI_PA	ABTEI	CHAR	12	0	Contact person's department at customer
133	ABTNR	☐	ABTNR_PA	ABTNR	CHAR	4	0	Contact person department	*
134	UEPAR	☐	UEPAR	PARNR	NUMC	10	0	Higher-level contact person
135	ANRED	☐	ANRED_AP	TEXT30	CHAR	30	0	Form of address for contact person (Mr, Mrs...etc)
136	PAFKT	☐	PAFKT	PAFKT	CHAR	2	0	Contact person function	*
137	PARVO	☐	PARVO	PARVO	CHAR	1	0	Partner's power of attorney	*
138	PAVIP	☐	PAVIP	PAVIP	CHAR	1	0	VIP Partner	*
139	PARGE	☐	PARGE	GESCH	CHAR	1	0	Partner's gender
140	PARLA	☐	PARLA	SPRAS	LANG	1	0	Partner language	*
141	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
142	VRTNR	☐	VTRNR	VTRNR	NUMC	10	0	Representative number
143	BRYTH	☐	BRYTH	BRYTH	CHAR	4	0	Call frequency	*
144	AKVER	☐	AKVER	AKVER	CHAR	2	0	Buying habits	*
145	NMAIL	☐	NMAIL	XFELD	CHAR	1	0	Advertising material indicator
146	PARAU	☐	PARAU	TEXT40	CHAR	40	0	Notes about contact person
147	PARH1	☐	PAAT1	PARHO	CHAR	2	0	Contact Partner: Attribute 1	*
148	PARH2	☐	PAAT2	PAAT2	CHAR	2	0	Contact person: Attribute 2	*
149	PARH3	☐	PAAT3	PAAT3	CHAR	2	0	Contact person: Attribute 3	*
150	PARH4	☐	PAAT4	PAAT4	CHAR	2	0	Contact person: Attribute 4	*
151	PARH5	☐	PAAT5	PAAT5	CHAR	2	0	Contact person: Attribute 5	*
152	MOAB1	☐	BEMOAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday morning from ...
153	MOBI1	☐	BEMOBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday morning until ...
154	MOAB2	☐	BEMOAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday afternoon from ...
155	MOBI2	☐	BEMOBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday afternoon until ...
156	DIAB1	☐	BEDIAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday morning from...
157	DIBI1	☐	BEDIBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday morning until ...
158	DIAB2	☐	BEDIAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday afternoon from..
159	DIBI2	☐	BEDIBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday afternoon until ...
160	MIAB1	☐	BEMIAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday morning from...
161	MIBI1	☐	BEMIBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday morning until ...
162	MIAB2	☐	BEMIAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday afternoon from ..
163	MIBI2	☐	BEMIBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday afternoon until..
164	DOAB1	☐	BEDOAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday morning from ....
165	DOBI1	☐	BEDOBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday morning until ....
166	DOAB2	☐	BEDOAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday afternoon from...
167	DOBI2	☐	BEDOBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday afternoon until ..
168	FRAB1	☐	BEFRAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday morning from ...
169	FRBI1	☐	BEFRBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday morning until ...
170	FRAB2	☐	BEFRAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday afternoon from ...
171	FRBI2	☐	BEFRBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday afternoon until ...
172	SAAB1	☐	BESAAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday morning from ...
173	SABI1	☐	BESABI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday morning until ...
174	SAAB2	☐	BESAAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday afternoon from ...
175	SABI2	☐	BESABI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday afternoon until ..
176	SOAB1	☐	BESOAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday morning from ...
177	SOBI1	☐	BESOBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday morning until ...
178	SOAB2	☐	BESOAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday afternoon from ...
179	SOBI2	☐	BESOBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday afternoon until ...
180	PAKN1	☐	PAAT6	PAAT6	CHAR	3	0	Contact person: Attribute 6	*
181	PAKN2	☐	PAAT7	PAAT7	CHAR	3	0	Contact person: Attribute 7	*
182	PAKN3	☐	PAAT8	PAAT8	CHAR	3	0	Contact person: Attribute 8	*
183	PAKN4	☐	PAAT9	PAAT9	CHAR	3	0	Contact person: Attribute 9	*
184	PAKN5	☐	PAAT0	PAAT0	CHAR	3	0	Contact person: Attribute 10	*
185	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
186	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	*
187	SPNAM	☐	SPNAM	TEXT10	CHAR	10	0	Nickname
188	TITEL_AP	☐	TITEL_AP	TEXT35	CHAR	35	0	Title of contact person (description of function)
189	KZHERK	☐	KZHERK	XFELD	CHAR	1	0	Internal indicator for origin of the CP: Customer or Vendor
190	ADRNP_2	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
191	PRSNR	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*

History

Last changed by/on	SAP	20130529
SAP Release Created in