Follow us on LinkedIn for your next SAP project

SAP Table KNA1VV

Generated Table for View

KNA1VV (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link KNA1VV to other SAP tables.

KNA1VV table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
MANDT T000
CLNT
3 0
KUNNR
Customer Number
KUNNR
CHAR
10 0
VKORG
Sales Organization
VKORG TVKO
CHAR
4 0
VTWEG
Distribution Channel
VTWEG TVTW
CHAR
2 0
SPART
Division
SPART TSPA
CHAR
2 0
ADRNR
Address
ADRNR
CHAR
10 0
ANRED
Title
ANRED
CHAR
15 0
AUFSD
Central order block for customer
AUFSD_X TVAST
CHAR
2 0
BAHNE
Express train station
BAHNE
CHAR
25 0
BAHNS
Train station
BAHNS
CHAR
25 0
BBBNR
International location number (part 1)
BBBNR
NUMC
7 0
BBSNR
International location number (Part 2)
BBSNR
NUMC
5 0
BEGRU
Authorization Group
BRGRU
CHAR
4 0
BRSCH
Industry key
BRSCH T016
CHAR
4 0
BUBKZ
Check digit for the international location number
BUBKZ
NUMC
1 0
DATLT
Data communication line no.
DATLT
CHAR
14 0
ERDAT
Date on which the Record Was Created
ERDAT_RF
DATS
8 0
ERNAM
Name of Person who Created the Object
ERNAM_RF
CHAR
12 0
EXABL
Indicator: Unloading points exist
EXABL
CHAR
1 0
FAKSD
Central billing block for customer
FAKSD_X TVFS
CHAR
2 0
FISKN
Account number of the master record with the fiscal address
FISKN_D KNA1
CHAR
10 0
KNAZK
Working Time Calendar
KNAZK TFACD
CHAR
2 0
KNRZA
Account number of an alternative payer
KNRZA KNA1
CHAR
10 0
KONZS
Group key
KONZS
CHAR
10 0
KTOKD
Customer Account Group
KTOKD T077D
CHAR
4 0
KUKLA
Customer classification
KUKLA TKUKL
CHAR
2 0
LAND1
Country Key
LAND1_GP T005
CHAR
3 0
LIFNR
Account Number of Vendor or Creditor
LIFNR LFA1
CHAR
10 0
LIFSD
Central delivery block for the customer
LIFSD_X TVLS
CHAR
2 0
LOCCO
City Coordinates
LOCCO
CHAR
10 0
LOEVM
Central Deletion Flag for Master Record
LOEVM_X
CHAR
1 0
NAME1
Name 1
NAME1_GP
CHAR
35 0
NAME2
Name 2
NAME2_GP
CHAR
35 0
NAME3
Name 3
NAME3_GP
CHAR
35 0
NAME4
Name 4
NAME4_GP
CHAR
35 0
NIELS
Nielsen ID
NIELS TNLS
CHAR
2 0
ORT01
City
ORT01_GP
CHAR
35 0
ORT02
District
ORT02_GP
CHAR
35 0
PFACH
PO Box
PFACH
CHAR
10 0
PSTL2
P.O. Box Postal Code
PSTL2
CHAR
10 0
PSTLZ
Postal Code
PSTLZ
CHAR
10 0
REGIO
Region (State, Province, County)
REGIO T005S
CHAR
3 0
COUNC
County Code
COUNC T005E
CHAR
3 0
CITYC
City Code
CITYC T005G
CHAR
4 0
RPMKR
Regional Market
RPMKR
CHAR
5 0
SORTL
Sort field
SORTL
CHAR
10 0
SPERR
Central posting block
SPERB_X
CHAR
1 0
SPRAS
Language Key
SPRAS T002
LANG
1 0
STCD1
Tax Number 1
STCD1
CHAR
16 0
STCD2
Tax Number 2
STCD2
CHAR
11 0
STKZA
Indicator: Business Partner Subject to Equalization Tax?
STKZA
CHAR
1 0
STKZU
Liable for VAT
STKZU
CHAR
1 0
STRAS
House number and street
STRAS_GP
CHAR
35 0
TELBX
Telebox number
TELBX
CHAR
15 0
TELF1
First telephone number
TELF1
CHAR
16 0
TELF2
Second telephone number
TELF2
CHAR
16 0
TELFX
Fax Number
TELFX
CHAR
31 0
TELTX
Teletex number
TELTX
CHAR
30 0
TELX1
Telex number
TELX1
CHAR
30 0
LZONE
Transportation zone to or from which the goods are delivered
LZONE TZONE
CHAR
10 0
XCPDK
Indicator: Is the account a one-time account?
XCPDK
CHAR
1 0
XZEMP
Indicator: Is an alternative payer allowed in document?
XREGU
CHAR
1 0
VBUND
Company ID of trading partner
RASSC T880
CHAR
6 0
ERNAM_KNVV
Name of Person who Created the Object
ERNAM
CHAR
12 0
ERDAT_KNVV
Date on Which Record Was Created
ERDAT
DATS
8 0
BEGRU_KNVV
Authorization Group
BEGRU
CHAR
4 0
LOEVM_KNVV
Deletion flag for customer (sales level)
LOEVM_V
CHAR
1 0
VERSG
Customer Statistics Group
STGKU TVSD
CHAR
1 0
AUFSD_KNVV
Customer order block (sales area)
AUFSD_V TVAST
CHAR
2 0
KALKS
Pricing procedure assigned to this customer
KALKS TVKD
CHAR
1 0
KDGRP
Customer group
KDGRP T151
CHAR
2 0
BZIRK
Sales district
BZIRK T171
CHAR
6 0
KONDA
Price group (customer)
KONDA T188
CHAR
2 0
PLTYP
Price list type
PLTYP T189
CHAR
2 0
AWAHR
Order probability of the item
AWAHR
NUMC
3 0
INCO1
Incoterms (Part 1)
INCO1 TINC
CHAR
3 0
INCO2
Incoterms (Part 2)
INCO2
CHAR
28 0
LIFSD_KNVV
Customer delivery block (sales area)
LIFSD_V TVLS
CHAR
2 0
AUTLF
Complete delivery defined for each sales order?
AUTLF
CHAR
1 0
ANTLF
Maximum Number of Partial Deliveries Allowed Per Item
ANTLF
DEC
1 0
KZTLF
Partial delivery at item level
KZTLF
CHAR
1 0
KZAZU
Order Combination Indicator
KZAZU_D
CHAR
1 0
CHSPL
Batch split allowed
CHSPL
CHAR
1 0
LPRIO
Delivery Priority
LPRIO TPRIO
NUMC
2 0
EIKTO
Shipper's (Our) Account Number at the Customer or Vendor
EIKTO
CHAR
12 0
VSBED
Shipping Conditions
VSBED TVSB
CHAR
2 0
FAKSD_KNVV
Billing block for customer (sales and distribution)
FAKSD_V TVFS
CHAR
2 0
MRNKZ
Manual invoice maintenance
MRNKZ
CHAR
1 0
PERFK
Invoice dates (calendar identification)
PERFK TFACD
CHAR
2 0
PERRL
Invoice list schedule (calendar identification)
PERRL TFACD
CHAR
2 0
KVAKZ
Cost estimate indicator (inactive)
KVAKZ
CHAR
1 0
KVAWT
Value limit for cost estimate (inactive)
KVAWT
CURR
13 2
WAERS
Currency
WAERS_V02D TCURC
CUKY
5 0
KLABC
Customer classification (ABC analysis)
KLABC
CHAR
2 0
KTGRD
Account assignment group for this customer
KTGRD TVKT
CHAR
2 0
ZTERM
Terms of Payment Key
DZTERM
CHAR
4 0
VWERK
Delivering Plant (Own or External)
DWERK_EXT TVKWZ
CHAR
4 0
VKGRP
Sales Group
VKGRP TVBVK
CHAR
3 0
VKBUR
Sales Office
VKBUR TVBUR
CHAR
4 0
VSORT
Item proposal
VSORT VBUK
CHAR
10 0
STCEG
VAT Registration Number
STCEG
CHAR
20 0
DEAR1
Indicator: Competitor
DEAR1
CHAR
1 0
DEAR2
Indicator: Sales partner
DEAR2
CHAR
1 0
DEAR3
Indicator: Sales prospect
DEAR3
CHAR
1 0
DEAR4
Indicator for customer type 4
DEAR4
CHAR
1 0
DEAR5
ID for default sold-to party
DEAR5
CHAR
1 0
GFORM
Legal status
GFORM TVGF
CHAR
2 0
BRAN1
Industry Code 1
BRAN1_D TBRC
CHAR
10 0
BRAN2
Industry code 2
BRAN2 TBRC
CHAR
10 0
BRAN3
Industry code 3
BRAN3 TBRC
CHAR
10 0
BRAN4
Industry code 4
BRAN4 TBRC
CHAR
10 0
BRAN5
Industry code 5
BRAN5 TBRC
CHAR
10 0
EKONT
Initial contact
EKONT VBUK
CHAR
10 0
UMJAH
Year For Which Sales are Given
UMJAH
NUMC
4 0
UWAER
Currency of sales figure
UWAER TCURC
CUKY
5 0
JMZAH
Yearly number of employees
JMZAH
NUMC
6 0
JMJAH
Year for which the number of employees is given
JMJAH
NUMC
4 0
KATR1
Attribute 1
KATR1 TVK1
CHAR
2 0
KATR2
Attribute 2
KATR2 TVK2
CHAR
2 0
KATR3
Attribute 3
KATR3 TVK3
CHAR
2 0
KATR4
Attribute 4
KATR4 TVK4
CHAR
2 0
KATR5
Attribute 5
KATR5 TVK5
CHAR
2 0
KATR6
Attribute 6
KATR6 TVK6
CHAR
3 0
KATR7
Attribute 7
KATR7 TVK7
CHAR
3 0
KATR8
Attribute 8
KATR8 TVK8
CHAR
3 0
KATR9
Attribute 9
KATR9 TVK9
CHAR
3 0
KATR10
Attribute 10
KATR10 TVK0
CHAR
3 0
STKZN
Natural Person
STKZN
CHAR
1 0
UMSA1
Annual sales
UMSA1
CURR
15 2

KNA1VV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
KNA1VV AUFSD KNA1VV AUFSD TVAST
Sales Document Blocking Reasons: Texts
AUFSP
KNA1VV AUFSD KNA1VV MANDT TVAST
Sales Document Blocking Reasons: Texts
MANDT
KNA1VV AUFSD SYST LANGU TVAST
Sales Document Blocking Reasons: Texts
SPRAS
KNA1VV AUFSD_KNVV KNA1VV MANDT TVAST
Sales Document Blocking Reasons: Texts
MANDT
KNA1VV AUFSD_KNVV SYST LANGU TVAST
Sales Document Blocking Reasons: Texts
SPRAS
KNA1VV AUFSD_KNVV KNA1VV AUFSD_KNVV TVAST
Sales Document Blocking Reasons: Texts
AUFSP
KNA1VV BRAN1 KNA1VV MANDT TBRC
Industry Code (Customer Master)
MANDT
KNA1VV BRAN1 KNA1VV BRAN1 TBRC
Industry Code (Customer Master)
BRACO
KNA1VV BRAN2 KNA1VV BRAN2 TBRC
Industry Code (Customer Master)
BRACO
KNA1VV BRAN2 KNA1VV MANDT TBRC
Industry Code (Customer Master)
MANDT
KNA1VV BRAN3 KNA1VV MANDT TBRC
Industry Code (Customer Master)
MANDT
KNA1VV BRAN3 KNA1VV BRAN3 TBRC
Industry Code (Customer Master)
BRACO
KNA1VV BRAN4 KNA1VV MANDT TBRC
Industry Code (Customer Master)
MANDT
KNA1VV BRAN4 KNA1VV BRAN4 TBRC
Industry Code (Customer Master)
BRACO
KNA1VV BRAN5 KNA1VV MANDT TBRC
Industry Code (Customer Master)
MANDT
KNA1VV BRAN5 KNA1VV BRAN5 TBRC
Industry Code (Customer Master)
BRACO
KNA1VV BRSCH KNA1VV BRSCH T016
Industries
BRSCH
KNA1VV BRSCH KNA1VV MANDT T016
Industries
MANDT
KNA1VV BZIRK KNA1VV MANDT T171
Customers: Sales Districts
MANDT
KNA1VV BZIRK KNA1VV BZIRK T171
Customers: Sales Districts
BZIRK
KNA1VV CITYC KNA1VV REGIO T005G
City
REGIO
KNA1VV CITYC KNA1VV CITYC T005G
City
CITYC
KNA1VV CITYC KNA1VV MANDT T005G
City
MANDT
KNA1VV CITYC KNA1VV LAND1 T005G
City
LAND1
KNA1VV COUNC KNA1VV LAND1 T005E
County
LAND1
KNA1VV COUNC KNA1VV REGIO T005E
County
REGIO
KNA1VV COUNC KNA1VV COUNC T005E
County
COUNC
KNA1VV COUNC KNA1VV MANDT T005E
County
MANDT
KNA1VV EKONT KNA1VV EKONT VBUK
Sales Document: Header Status and Administrative Data
VBELN
KNA1VV EKONT KNA1VV MANDT VBUK
Sales Document: Header Status and Administrative Data
MANDT
KNA1VV FAKSD KNA1VV MANDT TVFS
Billing: Reasons for Blocking
MANDT
KNA1VV FAKSD KNA1VV FAKSD TVFS
Billing: Reasons for Blocking
FAKSP
KNA1VV FAKSD_KNVV KNA1VV MANDT TVFS
Billing: Reasons for Blocking
MANDT
KNA1VV FAKSD_KNVV KNA1VV FAKSD_KNVV TVFS
Billing: Reasons for Blocking
FAKSP
KNA1VV FISKN KNA1VV MANDT KNA1
General Data in Customer Master
MANDT
KNA1VV FISKN KNA1VV FISKN KNA1
General Data in Customer Master
KUNNR
KNA1VV GFORM KNA1VV MANDT TVGF
Legal Status (Customer Master)
MANDT
KNA1VV GFORM KNA1VV GFORM TVGF
Legal Status (Customer Master)
GFORM
KNA1VV INCO1 KNA1VV MANDT TINC
Customers: Incoterms
MANDT
KNA1VV INCO1 KNA1VV INCO1 TINC
Customers: Incoterms
INCO1
KNA1VV KALKS KNA1VV MANDT TVKD
Customer Pricing Procedures
MANDT
KNA1VV KALKS KNA1VV KALKS TVKD
Customer Pricing Procedures
KALKS
KNA1VV KATR1 KNA1VV MANDT TVK1
Attribute 1 (customer master)
MANDT
KNA1VV KATR1 KNA1VV KATR1 TVK1
Attribute 1 (customer master)
KATR1
KNA1VV KATR10 KNA1VV KATR10 TVK0
Attribute 10 (customer master)
KATR10
KNA1VV KATR10 KNA1VV MANDT TVK0
Attribute 10 (customer master)
MANDT
KNA1VV KATR2 KNA1VV MANDT TVK2
Attribute 2 (customer master)
MANDT
KNA1VV KATR2 KNA1VV KATR2 TVK2
Attribute 2 (customer master)
KATR2
KNA1VV KATR3 KNA1VV KATR3 TVK3
Attribute 3 (customer master)
KATR3
KNA1VV KATR3 KNA1VV MANDT TVK3
Attribute 3 (customer master)
MANDT
KNA1VV KATR4 KNA1VV MANDT TVK4
Attribute 4 (customer master)
MANDT
KNA1VV KATR4 KNA1VV KATR4 TVK4
Attribute 4 (customer master)
KATR4
KNA1VV KATR5 KNA1VV MANDT TVK5
Attribute 5 (customer master)
MANDT
KNA1VV KATR5 KNA1VV KATR5 TVK5
Attribute 5 (customer master)
KATR5
KNA1VV KATR6 KNA1VV MANDT TVK6
Attribute 6 (customer master)
MANDT
KNA1VV KATR6 KNA1VV KATR6 TVK6
Attribute 6 (customer master)
KATR6
KNA1VV KATR7 KNA1VV MANDT TVK7
Attribute 7 (customer master)
MANDT
KNA1VV KATR7 KNA1VV KATR7 TVK7
Attribute 7 (customer master)
KATR7
KNA1VV KATR8 KNA1VV KATR8 TVK8
Attribute 8 (customer master)
KATR8
KNA1VV KATR8 KNA1VV MANDT TVK8
Attribute 8 (customer master)
MANDT
KNA1VV KATR9 KNA1VV MANDT TVK9
Attribute 9 (customer master)
MANDT
KNA1VV KATR9 KNA1VV KATR9 TVK9
Attribute 9 (customer master)
KATR9
KNA1VV KDGRP KNA1VV MANDT T151
Customers: Customer Groups
MANDT
KNA1VV KDGRP KNA1VV KDGRP T151
Customers: Customer Groups
KDGRP
KNA1VV KNAZK KNA1VV KNAZK TFACD
Factory calendar definition
IDENT
KNA1VV KNRZA KNA1VV MANDT KNA1
General Data in Customer Master
MANDT
KNA1VV KNRZA KNA1VV KNRZA KNA1
General Data in Customer Master
KUNNR
KNA1VV KONDA KNA1VV MANDT T188
Conditions: Groups for Customer Classifications
MANDT
KNA1VV KONDA KNA1VV KONDA T188
Conditions: Groups for Customer Classifications
KONDA
KNA1VV KTGRD KNA1VV MANDT TVKT
Customers: Account Assignment Groups
MANDT
KNA1VV KTGRD KNA1VV KTGRD TVKT
Customers: Account Assignment Groups
KTGRD
KNA1VV KTOKD KNA1VV MANDT T077D
Customer account groups
MANDT
KNA1VV KTOKD KNA1VV KTOKD T077D
Customer account groups
KTOKD
KNA1VV KUKLA KNA1VV MANDT TKUKL
Customers: Customer Classifications
MANDT
KNA1VV KUKLA KNA1VV KUKLA TKUKL
Customers: Customer Classifications
KUKLA
KNA1VV LAND1 KNA1VV MANDT T005
Countries
MANDT
KNA1VV LAND1 KNA1VV LAND1 T005
Countries
LAND1
KNA1VV LIFNR KNA1VV MANDT LFA1
Vendor Master (General Section)
MANDT
KNA1VV LIFNR KNA1VV LIFNR LFA1
Vendor Master (General Section)
LIFNR
KNA1VV LIFSD KNA1VV MANDT TVLS
Deliveries: Blocking Reasons/Criteria
MANDT
KNA1VV LIFSD KNA1VV LIFSD TVLS
Deliveries: Blocking Reasons/Criteria
LIFSP
KNA1VV LIFSD_KNVV KNA1VV LIFSD_KNVV TVLS
Deliveries: Blocking Reasons/Criteria
LIFSP
KNA1VV LIFSD_KNVV KNA1VV MANDT TVLS
Deliveries: Blocking Reasons/Criteria
MANDT
KNA1VV LPRIO KNA1VV LPRIO TPRIO
Customers: Delivery Priorities
LPRIO
KNA1VV LPRIO KNA1VV MANDT TPRIO
Customers: Delivery Priorities
MANDT
KNA1VV LZONE KNA1VV MANDT TZONE
Customers: Regional zones
MANDT
KNA1VV LZONE KNA1VV LAND1 TZONE
Customers: Regional zones
LAND1
KNA1VV LZONE KNA1VV LZONE TZONE
Customers: Regional zones
ZONE1
KNA1VV MANDT KNA1VV MANDT T000
Clients
MANDT
KNA1VV NIELS KNA1VV MANDT TNLS
Nielsen ID
MANDT
KNA1VV NIELS KNA1VV NIELS TNLS
Nielsen ID
NIELS
KNA1VV PERFK KNA1VV PERFK TFACD
Factory calendar definition
IDENT
KNA1VV PERRL KNA1VV PERRL TFACD
Factory calendar definition
IDENT
KNA1VV PLTYP KNA1VV PLTYP T189
Conditions: Price List Categories
PLTYP
KNA1VV PLTYP KNA1VV MANDT T189
Conditions: Price List Categories
MANDT
KNA1VV REGIO KNA1VV MANDT T005S
Taxes: Region (Province) Key
MANDT
KNA1VV REGIO KNA1VV LAND1 T005S
Taxes: Region (Province) Key
LAND1
KNA1VV REGIO KNA1VV REGIO T005S
Taxes: Region (Province) Key
BLAND
KNA1VV SPART KNA1VV MANDT TSPA
Organizational Unit: Sales Divisions
MANDT
KNA1VV SPART KNA1VV SPART TSPA
Organizational Unit: Sales Divisions
SPART
KNA1VV SPRAS KNA1VV SPRAS T002
Language Keys (Component BC-I18)
SPRAS
KNA1VV UWAER KNA1VV MANDT TCURC
Currency Codes
MANDT
KNA1VV UWAER KNA1VV UWAER TCURC
Currency Codes
WAERS
KNA1VV VBUND KNA1VV MANDT T880
Global Company Data (for KONS Ledger)
MANDT
KNA1VV VBUND KNA1VV VBUND T880
Global Company Data (for KONS Ledger)
RCOMP
KNA1VV VERSG KNA1VV MANDT TVSD
Customers: Statistics groups
MANDT
KNA1VV VERSG KNA1VV VERSG TVSD
Customers: Statistics groups
STGKU
KNA1VV VKBUR KNA1VV MANDT TVBUR
Organizational Unit: Sales Offices
MANDT
KNA1VV VKBUR KNA1VV VKBUR TVBUR
Organizational Unit: Sales Offices
VKBUR
KNA1VV VKGRP KNA1VV MANDT TVBVK
Organizational Unit: Sales Groups per Sales Office
MANDT
KNA1VV VKGRP KNA1VV VKBUR TVBVK
Organizational Unit: Sales Groups per Sales Office
VKBUR
KNA1VV VKGRP KNA1VV VKGRP TVBVK
Organizational Unit: Sales Groups per Sales Office
VKGRP
KNA1VV VKORG KNA1VV VKORG TVKO
Organizational Unit: Sales Organizations
VKORG
KNA1VV VKORG KNA1VV MANDT TVKO
Organizational Unit: Sales Organizations
MANDT
KNA1VV VSBED KNA1VV MANDT TVSB
Shipping Conditions
MANDT
KNA1VV VSBED KNA1VV VSBED TVSB
Shipping Conditions
VSBED
KNA1VV VSORT KNA1VV MANDT VBUK
Sales Document: Header Status and Administrative Data
MANDT
KNA1VV VSORT KNA1VV VSORT VBUK
Sales Document: Header Status and Administrative Data
VBELN
KNA1VV VTWEG KNA1VV VTWEG TVTW
Organizational Unit: Distribution Channels
VTWEG
KNA1VV VTWEG KNA1VV MANDT TVTW
Organizational Unit: Distribution Channels
MANDT
KNA1VV VWERK KNA1VV VTWEG TVKWZ
Org.Unit: Allowed Plants per Sales Organization
VTWEG
KNA1VV VWERK KNA1VV VWERK TVKWZ
Org.Unit: Allowed Plants per Sales Organization
WERKS
KNA1VV VWERK KNA1VV MANDT TVKWZ
Org.Unit: Allowed Plants per Sales Organization
MANDT
KNA1VV VWERK KNA1VV VKORG TVKWZ
Org.Unit: Allowed Plants per Sales Organization
VKORG
KNA1VV WAERS KNA1VV WAERS TCURC
Currency Codes
WAERS
KNA1VV WAERS KNA1VV MANDT TCURC
Currency Codes
MANDT