SAP ABAP View KNA1VV (Customer Master View KNA1 KNVV)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-IS-DC (Application Component) Data Collection
     ⤷ VIEW (Package) Application development views

Basic Data

View Type	D	Database View
Database View	KNA1VV
Short Description	Customer Master View KNA1 KNVV
Root table	KNA1	General Data in Customer Master

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	KNA1	KNA1
2	KNVV

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	KNA1	MANDT	JL	EQ				0	0
2	KNVV	MANDT	JR	EQ			AND	0	0
3	KNA1	KUNNR	JL	EQ				0	0
4	KNVV	KUNNR	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20131127
SAP Release Created in