SAP ABAP Table KNA1VV (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	KNA1VV	Table Relationship Diagram
Short Description	Generated Table for View

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	T000
2	KUNNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number
3	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
4	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
5	SPART	☑	SPART	SPART	CHAR	2	0	Division	TSPA
6	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address
7	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
8	AUFSD	☐	AUFSD_X	KAUFS	CHAR	2	0	Central order block for customer	TVAST
9	BAHNE	☐	BAHNE	BAHNH	CHAR	25	0	Express train station
10	BAHNS	☐	BAHNS	BAHNH	CHAR	25	0	Train station
11	BBBNR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
12	BBSNR	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
13	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group
14	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
15	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
16	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
17	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
18	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
19	EXABL	☐	EXABL	XFELD	CHAR	1	0	Indicator: Unloading points exist
20	FAKSD	☐	FAKSD_X	FAKSP	CHAR	2	0	Central billing block for customer	TVFS
21	FISKN	☐	FISKN_D	KUNNR	CHAR	10	0	Account number of the master record with the fiscal address	KNA1
22	KNAZK	☐	KNAZK	WFCID	CHAR	2	0	Working Time Calendar	TFACD
23	KNRZA	☐	KNRZA	KUNNR	CHAR	10	0	Account number of an alternative payer	KNA1
24	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
25	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	T077D
26	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	TKUKL
27	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
28	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
29	LIFSD	☐	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	TVLS
30	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
31	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
32	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
33	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
34	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
35	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
36	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	TNLS
37	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
38	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
39	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
40	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
41	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
42	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
43	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
44	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
45	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
46	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
47	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block
48	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
49	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
50	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
51	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
52	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
53	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
54	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
55	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
56	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
57	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
58	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
59	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
60	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
61	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
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	ERNAM_KNVV	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
65	ERDAT_KNVV	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
66	BEGRU_KNVV	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
67	LOEVM_KNVV	☐	LOEVM_V	XFELD	CHAR	1	0	Deletion flag for customer (sales level)
68	VERSG	☐	STGKU	STGKU	CHAR	1	0	Customer Statistics Group	TVSD
69	AUFSD_KNVV	☐	AUFSD_V	KAUFS	CHAR	2	0	Customer order block (sales area)	TVAST
70	KALKS	☐	KALKS	KALKS	CHAR	1	0	Pricing procedure assigned to this customer	TVKD
71	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
72	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
73	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
74	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
75	AWAHR	☐	AWAHR	AWAHR	NUMC	3	0	Order probability of the item
76	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
77	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
78	LIFSD_KNVV	☐	LIFSD_V	LIFSP	CHAR	2	0	Customer delivery block (sales area)	TVLS
79	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
80	ANTLF	☐	ANTLF	ANTLF	DEC	1	0	Maximum number of partial deliveries allowed per item
81	KZTLF	☐	KZTLF	KZTLF	CHAR	1	0	Partial delivery at item level
82	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
83	CHSPL	☐	CHSPL	XFELD	CHAR	1	0	Batch split allowed
84	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
85	EIKTO	☐	EIKTO	CHAR12	CHAR	12	0	Shipper's (Our) Account Number at the Customer or Vendor
86	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
87	FAKSD_KNVV	☐	FAKSD_V	FAKSP	CHAR	2	0	Billing block for customer (sales and distribution)	TVFS
88	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
89	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
90	PERRL	☐	PERRL	WFCID	CHAR	2	0	Invoice list schedule (calendar identification)	TFACD
91	KVAKZ	☐	KVAKZ	XFELD	CHAR	1	0	Cost estimate indicator (inactive)
92	KVAWT	☐	KVAWT	WERT7	CURR	13	2	Value limit for cost estimate (inactive)
93	WAERS	☐	WAERS_V02D	WAERS	CUKY	5	0	Currency	TCURC
94	KLABC	☐	KLABC	KLABC	CHAR	2	0	Customer classification (ABC analysis)
95	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
96	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
97	VWERK	☐	DWERK_EXT	WERKS	CHAR	4	0	Delivering Plant (Own or External)	TVKWZ
98	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
99	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
100	VSORT	☐	VSORT	VBELN	CHAR	10	0	Item proposal	VBUK
101	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
102	DEAR1	☐	DEAR1	XFELD	CHAR	1	0	Indicator: Competitor
103	DEAR2	☐	DEAR2	XFELD	CHAR	1	0	Indicator: Sales partner
104	DEAR3	☐	DEAR3	DEAR3	CHAR	1	0	Indicator: Sales prospect
105	DEAR4	☐	DEAR4	XFELD	CHAR	1	0	Indicator for customer type 4
106	DEAR5	☐	DEAR5	XFELD	CHAR	1	0	ID for default sold-to party
107	GFORM	☐	GFORM	GFORM	CHAR	2	0	Legal status	TVGF
108	BRAN1	☐	BRAN1_D	BRACO	CHAR	10	0	Industry code 1	TBRC
109	BRAN2	☐	BRAN2	BRACO	CHAR	10	0	Industry code 2	TBRC
110	BRAN3	☐	BRAN3	BRACO	CHAR	10	0	Industry code 3	TBRC
111	BRAN4	☐	BRAN4	BRACO	CHAR	10	0	Industry code 4	TBRC
112	BRAN5	☐	BRAN5	BRACO	CHAR	10	0	Industry code 5	TBRC
113	EKONT	☐	EKONT	VBELN	CHAR	10	0	Initial contact	VBUK
114	UMJAH	☐	UMJAH	JAHR	NUMC	4	0	Year For Which Sales are Given
115	UWAER	☐	UWAER	WAERS	CUKY	5	0	Currency of Sales Volume	TCURC
116	JMZAH	☐	JMZAH	JMZAH	NUMC	6	0	Yearly number of employees
117	JMJAH	☐	JMJAH	JAHR	NUMC	4	0	Year for which the number of employees is given
118	KATR1	☐	KATR1	ATTR1	CHAR	2	0	Attribute 1	TVK1
119	KATR2	☐	KATR2	ATTR2	CHAR	2	0	Attribute 2	TVK2
120	KATR3	☐	KATR3	ATTR3	CHAR	2	0	Attribute 3	TVK3
121	KATR4	☐	KATR4	ATTR4	CHAR	2	0	Attribute 4	TVK4
122	KATR5	☐	KATR5	ATTR5	CHAR	2	0	Attribute 5	TVK5
123	KATR6	☐	KATR6	ATTR6	CHAR	3	0	Attribute 6	TVK6
124	KATR7	☐	KATR7	ATTR7	CHAR	3	0	Attribute 7	TVK7
125	KATR8	☐	KATR8	ATTR8	CHAR	3	0	Attribute 8	TVK8
126	KATR9	☐	KATR9	ATTR9	CHAR	3	0	Attribute 9	TVK9
127	KATR10	☐	KATR10	ATTR10	CHAR	3	0	Attribute 10	TVK0
128	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
129	UMSA1	☐	UMSA1	UMSA1	CURR	15	2	Annual sales

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	KNA1VV	AUFSD	TVAST	AUFSP	REF	C	CN
2	KNA1VV	AUFSD_KNVV	TVAST	AUFSP	REF	C	CN
3	KNA1VV	BRAN1	TBRC	BRACO	KEY	1	CN
4	KNA1VV	BRAN2	TBRC	BRACO	KEY	1	CN
5	KNA1VV	BRAN3	TBRC	BRACO	KEY	1	CN
6	KNA1VV	BRAN4	TBRC	BRACO	KEY	1	CN
7	KNA1VV	BRAN5	TBRC	BRACO	KEY	1	CN
8	KNA1VV	BRSCH	T016	BRSCH	REF	C	CN
9	KNA1VV	BZIRK	T171	BZIRK	REF	C	CN
10	KNA1VV	CITYC	T005G	CITYC	REF	C	CN
11	KNA1VV	COUNC	T005E	COUNC	REF	C	CN
12	KNA1VV	EKONT	VBUK	VBELN	REF	1	C
13	KNA1VV	FAKSD	TVFS	FAKSP	REF	C	CN
14	KNA1VV	FAKSD_KNVV	TVFS	FAKSP	REF	C	CN
15	KNA1VV	FISKN	KNA1	KUNNR	REF	C	CN
16	KNA1VV	GFORM	TVGF	GFORM	KEY	1	CN
17	KNA1VV	INCO1	TINC	INCO1	REF	C	CN
18	KNA1VV	KALKS	TVKD	KALKS	REF	C	CN
19	KNA1VV	KATR1	TVK1	KATR1	KEY	1	CN
20	KNA1VV	KATR10	TVK0	KATR10	KEY	1	CN
21	KNA1VV	KATR2	TVK2	KATR2	KEY	1	CN
22	KNA1VV	KATR3	TVK3	KATR3	KEY	1	CN
23	KNA1VV	KATR4	TVK4	KATR4	KEY	1	CN
24	KNA1VV	KATR5	TVK5	KATR5	KEY	1	CN
25	KNA1VV	KATR6	TVK6	KATR6	KEY	1	CN
26	KNA1VV	KATR7	TVK7	KATR7	KEY	1	CN
27	KNA1VV	KATR8	TVK8	KATR8	KEY	1	CN
28	KNA1VV	KATR9	TVK9	KATR9	KEY	1	CN
29	KNA1VV	KDGRP	T151	KDGRP	REF	C	CN
30	KNA1VV	KNAZK	TFACD	IDENT	REF	C	CN
31	KNA1VV	KNRZA	KNA1	KUNNR	REF	C	CN
32	KNA1VV	KONDA	T188	KONDA	REF	C	CN
33	KNA1VV	KTGRD	TVKT	KTGRD	REF	C	CN
34	KNA1VV	KTOKD	T077D	KTOKD	REF	1	CN
35	KNA1VV	KUKLA	TKUKL	KUKLA	REF	C	CN
36	KNA1VV	LAND1	T005	LAND1	REF	C	CN
37	KNA1VV	LIFNR	LFA1	LIFNR	REF	C	CN
38	KNA1VV	LIFSD	TVLS	LIFSP	REF	C	CN
39	KNA1VV	LIFSD_KNVV	TVLS	LIFSP	REF	C	CN
40	KNA1VV	LPRIO	TPRIO	LPRIO	REF	C	CN
41	KNA1VV	LZONE	TZONE	ZONE1	REF	C	CN
42	KNA1VV	MANDT	T000	MANDT	KEY	1	CN
43	KNA1VV	NIELS	TNLS	NIELS	REF	C	CN
44	KNA1VV	PERFK	TFACD	IDENT	REF	C	CN
45	KNA1VV	PERRL	TFACD	IDENT	REF	C	CN
46	KNA1VV	PLTYP	T189	PLTYP	REF	C	CN
47	KNA1VV	REGIO	T005S	BLAND	REF	C	CN
48	KNA1VV	SPART	TSPA	SPART	KEY	1	CN
49	KNA1VV	SPRAS	T002	SPRAS	REF	1	CN
50	KNA1VV	UWAER	TCURC	WAERS	REF	1	C
51	KNA1VV	VBUND	T880	RCOMP	REF	C	CN
52	KNA1VV	VERSG	TVSD	STGKU	REF	C	CN
53	KNA1VV	VKBUR	TVBUR	VKBUR	REF	C	CN
54	KNA1VV	VKGRP	TVBVK	VKGRP	REF	C	CN
55	KNA1VV	VKORG	TVKO	VKORG	KEY	1	CN
56	KNA1VV	VSBED	TVSB	VSBED	REF	C	CN
57	KNA1VV	VSORT	VBUK	VBELN	REF	C	CN
58	KNA1VV	VTWEG	TVTW	VTWEG	KEY	1	CN
59	KNA1VV	VWERK	TVKWZ	WERKS	REF	C	CN
60	KNA1VV	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in