KNVV (Customer Master Sales Data) 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 KNVV to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||
|
KUNNR
Customer Number
|
KUNNR | KNA1 |
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 | |||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||||||||
|
ERDAT
Date on Which Record Was Created
|
ERDAT |
DATS
|
8 | 0 | ||||||||||||||
|
BEGRU
Authorization Group
|
BEGRU |
CHAR
|
4 | 0 | ||||||||||||||
|
LOEVM
Deletion flag for customer (sales level)
|
LOEVM_V |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
VERSG
Customer Statistics Group
|
STGKU | TVSD |
CHAR
|
1 | 0 | |||||||||||||
|
AUFSD
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
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
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 | |||||||||||||
|
KVGR1
Customer group 1
|
KVGR1 | TVV1 |
CHAR
|
3 | 0 | |||||||||||||
|
KVGR2
Customer group 2
|
KVGR2 | TVV2 |
CHAR
|
3 | 0 | |||||||||||||
|
KVGR3
Customer group 3
|
KVGR3 | TVV3 |
CHAR
|
3 | 0 | |||||||||||||
|
KVGR4
Customer group 4
|
KVGR4 | TVV4 |
CHAR
|
3 | 0 | |||||||||||||
|
KVGR5
Customer group 5
|
KVGR5 | TVV5 |
CHAR
|
3 | 0 | |||||||||||||
|
BOKRE
Indicator: Customer Is Rebate-Relevant
|
BOKRE |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
BOIDT
Start of validity per.for the rebate index for the customer
|
BOIDT |
DATS
|
8 | 0 | ||||||||||||||
|
KURST
Exchange Rate Type
|
KURST | TCURV |
CHAR
|
4 | 0 | |||||||||||||
|
PRFRE
Relevant for price determination ID
|
PRFRE |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PRAT1
ID for product attribute 1
|
KUAT1 |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PRAT2
ID for product attribute 2
|
KUAT2 |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PRAT3
ID for product attribute 3
|
KUAT3 |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PRAT4
ID for product attribute 4
|
KUAT4 |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PRAT5
ID for product attribute 5
|
KUAT5 |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PRAT6
ID for product attribute 6
|
KUAT6 |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PRAT7
ID for product attribute 7
|
KUAT7 |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PRAT8
ID for product attribute 8
|
KUAT8 |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PRAT9
ID for product attribute 9
|
KUAT9 |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PRATA
ID for product attribute 10
|
KUATA |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
KABSS
Customer payment guarantee procedure
|
KABSSCH_CM | T691P |
CHAR
|
4 | 0 | |||||||||||||
|
KKBER
Credit control area
|
KKBER | T014 |
CHAR
|
4 | 0 | |||||||||||||
|
CASSD
Sales block for customer (sales area)
|
CASSD_V |
CHAR
|
2 | 0 | ||||||||||||||
|
RDOFF
Switch off rounding?
|
RDOFF |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
AGREL
Indicator: Relevant for agency business
|
AGREL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
MEGRU
Unit of Measure Group
|
MEGRU | TWMEG |
CHAR
|
4 | 0 | |||||||||||||
|
UEBTO
Overdelivery Tolerance Limit
|
UEBTO |
DEC
|
3 | 1 | ||||||||||||||
|
UNTTO
Underdelivery Tolerance Limit
|
UNTTO |
DEC
|
3 | 1 | ||||||||||||||
|
UEBTK
Unlimited overdelivery allowed
|
UEBTK_V |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PVKSM
Customer procedure for product proposal
|
PVKSM | TPVD |
CHAR
|
2 | 0 | |||||||||||||
|
PODKZ
Relevant for POD processing
|
PODKZ |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PODTG
Timeframe for Confirmation of POD
|
PODTG |
DEC
|
11 | 0 | ||||||||||||||
|
BLIND
Index Structure Active for Subsequent Settlement (in AB)
|
BLIND_SD |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
CARRIER_NOTIF
Carrier is to be notified
|
/SPE/CARRIER_NOTIF |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
/BEV1/EMLGPFAND
Deposit on Empties
|
/BEV1/EMGPFAND |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
/BEV1/EMLGFORTS
Indicator for Empties Update
|
/BEV1/EMGFORTS |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
/XLSO/CUST_DIS
Rate (condition amount or percentage) where no scale exists
|
KBETR_KOND |
CURR
|
11 | 2 | ||||||||||||||
|
/XLSO/COMP_NAME
Name 1
|
NAME1_GP |
CHAR
|
35 | 0 | ||||||||||||||
|
/XLSO/INDUSTRY
Industry key
|
BRSCH |
CHAR
|
4 | 0 | ||||||||||||||
|
/XLSO/H_NUMBER
House Number
|
AD_HSNM1 |
CHAR
|
10 | 0 | ||||||||||||||
|
/XLSO/STREET
Street
|
AD_STREET |
CHAR
|
60 | 0 | ||||||||||||||
|
/XLSO/POST_CODE
Postal Code
|
PSTLZ |
CHAR
|
10 | 0 | ||||||||||||||
|
/XLSO/CITY
City
|
ORT01_GP |
CHAR
|
35 | 0 | ||||||||||||||
|
/XLSO/REGION
Region (State, Province, County)
|
REGIO |
CHAR
|
3 | 0 | ||||||||||||||
|
/XLSO/COUNTRY
Country Key
|
LAND1_GP |
CHAR
|
3 | 0 | ||||||||||||||
|
/XLSO/INACTIVE
Single-Character Indicator
|
CHAR1 |
CHAR
|
1 | 0 | ||||||||||||||
|
OIC_MOT
IS-OIL MAP external details mode of transport
|
OIC_MOT | TVTR |
CHAR
|
2 | 0 | |||||||||||||
|
OILASTOR
Last order number
|
OID_LASTOR |
CHAR
|
10 | 0 | ||||||||||||||
|
OIC_HOBIND
Head office / branch indicator
|
OIC_HOBIND |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
OIABTNR
Contact person department
|
ABTNR_PA | TSAB |
CHAR
|
4 | 0 | |||||||||||||
|
OIPAFKT
Contact person function
|
PAFKT | TPFK |
CHAR
|
2 | 0 | |||||||||||||
|
OIGROUPNAM
TD:customer compatibility group
|
OIG_CCG | TOIGBC |
CHAR
|
8 | 0 | |||||||||||||
|
OIHANTYP
Excise Duty Handling Type
|
OIH_HANTYP | OIH5 |
CHAR
|
2 | 0 | |||||||||||||
|
OIINEX
Code for internal or external excise duty rate determination
|
OIH_INEX | OIH16 |
CHAR
|
2 | 0 | |||||||||||||
|
OIPFLIC
IS-OIL partner function for tax exemption license
|
OIH_PFLIC | TPAR |
CHAR
|
2 | 0 | |||||||||||||
|
OIHCGROUP
Customer tax group
|
OIH_J1B_CTXGR | OIH2C_J1B |
CHAR
|
4 | 0 | |||||||||||||
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| KNVV | AUFSD | KNVV | MANDT |
TVAST
Sales Document Blocking Reasons: Texts
|
MANDT |
| KNVV | AUFSD | SYST | LANGU |
TVAST
Sales Document Blocking Reasons: Texts
|
SPRAS |
| KNVV | AUFSD | KNVV | AUFSD |
TVAST
Sales Document Blocking Reasons: Texts
|
AUFSP |
| KNVV | BZIRK | KNVV | MANDT |
T171
Customers: Sales Districts
|
MANDT |
| KNVV | BZIRK | KNVV | BZIRK |
T171
Customers: Sales Districts
|
BZIRK |
| KNVV | FAKSD | KNVV | MANDT |
TVFS
Billing: Reasons for Blocking
|
MANDT |
| KNVV | FAKSD | KNVV | FAKSD |
TVFS
Billing: Reasons for Blocking
|
FAKSP |
| KNVV | INCO1 | KNVV | MANDT |
TINC
Customers: Incoterms
|
MANDT |
| KNVV | INCO1 | KNVV | INCO1 |
TINC
Customers: Incoterms
|
INCO1 |
| KNVV | KABSS | KNVV | MANDT |
T691P
Customer payment guarantee procedure
|
MANDT |
| KNVV | KABSS | KNVV | KABSS |
T691P
Customer payment guarantee procedure
|
KABSS |
| KNVV | KALKS | KNVV | KALKS |
TVKD
Customer Pricing Procedures
|
KALKS |
| KNVV | KALKS | KNVV | MANDT |
TVKD
Customer Pricing Procedures
|
MANDT |
| KNVV | KDGRP | KNVV | MANDT |
T151
Customers: Customer Groups
|
MANDT |
| KNVV | KDGRP | KNVV | KDGRP |
T151
Customers: Customer Groups
|
KDGRP |
| KNVV | KKBER | KNVV | MANDT |
T014
Credit control areas
|
MANDT |
| KNVV | KKBER | KNVV | KKBER |
T014
Credit control areas
|
KKBER |
| KNVV | KONDA | KNVV | KONDA |
T188
Conditions: Groups for Customer Classifications
|
KONDA |
| KNVV | KONDA | KNVV | MANDT |
T188
Conditions: Groups for Customer Classifications
|
MANDT |
| KNVV | KTGRD | KNVV | MANDT |
TVKT
Customers: Account Assignment Groups
|
MANDT |
| KNVV | KTGRD | KNVV | KTGRD |
TVKT
Customers: Account Assignment Groups
|
KTGRD |
| KNVV | KUNNR | KNVV | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| KNVV | KUNNR | KNVV | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| KNVV | KURST | KNVV | MANDT |
TCURV
Exchange rate types for currency translation
|
MANDT |
| KNVV | KURST | KNVV | KURST |
TCURV
Exchange rate types for currency translation
|
KURST |
| KNVV | KVGR1 | KNVV | MANDT |
TVV1
Customer Group 1
|
MANDT |
| KNVV | KVGR1 | KNVV | KVGR1 |
TVV1
Customer Group 1
|
KVGR1 |
| KNVV | KVGR2 | KNVV | MANDT |
TVV2
Customer Group 2
|
MANDT |
| KNVV | KVGR2 | KNVV | KVGR2 |
TVV2
Customer Group 2
|
KVGR2 |
| KNVV | KVGR3 | KNVV | MANDT |
TVV3
Customer Group 3
|
MANDT |
| KNVV | KVGR3 | KNVV | KVGR3 |
TVV3
Customer Group 3
|
KVGR3 |
| KNVV | KVGR4 | KNVV | KVGR4 |
TVV4
Customer Group 4
|
KVGR4 |
| KNVV | KVGR4 | KNVV | MANDT |
TVV4
Customer Group 4
|
MANDT |
| KNVV | KVGR5 | KNVV | MANDT |
TVV5
Customer Group 5
|
MANDT |
| KNVV | KVGR5 | KNVV | KVGR5 |
TVV5
Customer Group 5
|
KVGR5 |
| KNVV | LIFSD | KNVV | LIFSD |
TVLS
Deliveries: Blocking Reasons/Criteria
|
LIFSP |
| KNVV | LIFSD | KNVV | MANDT |
TVLS
Deliveries: Blocking Reasons/Criteria
|
MANDT |
| KNVV | LPRIO | KNVV | MANDT |
TPRIO
Customers: Delivery Priorities
|
MANDT |
| KNVV | LPRIO | KNVV | LPRIO |
TPRIO
Customers: Delivery Priorities
|
LPRIO |
| KNVV | MANDT | KNVV | MANDT |
T000
Clients
|
MANDT |
| KNVV | MEGRU | KNVV | MANDT |
TWMEG
Unit of measure group
|
MANDT |
| KNVV | MEGRU | KNVV | MEGRU |
TWMEG
Unit of measure group
|
MEGRU |
| KNVV | MEGRU | * |
TWMEG
Unit of measure group
|
MEINS | |
| KNVV | OIABTNR | T000 | MANDT |
TSAB
Contact persons: standard departments
|
MANDT |
| KNVV | OIABTNR | KNVV | OIABTNR |
TSAB
Contact persons: standard departments
|
ABTNR |
| KNVV | OIC_MOT | KNVV | OIC_MOT |
TVTR
Routes: Modes of Transport
|
VKTRA |
| KNVV | OIC_MOT | T000 | MANDT |
TVTR
Routes: Modes of Transport
|
MANDT |
| KNVV | OIGROUPNAM | KNVV | MANDT |
TOIGBC
TD Customer Group
|
CLIENT |
| KNVV | OIGROUPNAM | KNVV | OIGROUPNAM |
TOIGBC
TD Customer Group
|
GROUPNAME |
| KNVV | OIHANTYP | KNVV | MANDT |
OIH5
Definition of Excise Duty Handling Type (IS-OIL-TDP)
|
MANDT |
| KNVV | OIHANTYP | KNVV | OIHANTYP |
OIH5
Definition of Excise Duty Handling Type (IS-OIL-TDP)
|
HANTYP |
| KNVV | OIHCGROUP | SYST | MANDT |
OIH2C_J1B
Check table for customer tax group
|
MANDT |
| KNVV | OIHCGROUP | KNVV | OIHCGROUP |
OIH2C_J1B
Check table for customer tax group
|
OIHCTXGR |
| KNVV | OIINEX | T001 | MANDT |
OIH16
Internal/external price conditions
|
MANDT |
| KNVV | OIINEX | KNVV | OIINEX |
OIH16
Internal/external price conditions
|
INEX |
| KNVV | OIPAFKT | T000 | KNVV |
TPFK
Contact Persons: Functions
|
MANDT |
| KNVV | OIPAFKT | KNVV | OIPAFKT |
TPFK
Contact Persons: Functions
|
PAFKT |
| KNVV | OIPFLIC | KNVV | OIPFLIC |
TPAR
Business Partner: Functions
|
PARVW |
| KNVV | OIPFLIC | SYST | MANDT |
TPAR
Business Partner: Functions
|
MANDT |
| KNVV | PERFK | KNVV | PERFK |
TFACD
Factory calendar definition
|
IDENT |
| KNVV | PERRL | KNVV | PERRL |
TFACD
Factory calendar definition
|
IDENT |
| KNVV | PLTYP | KNVV | MANDT |
T189
Conditions: Price List Categories
|
MANDT |
| KNVV | PLTYP | KNVV | PLTYP |
T189
Conditions: Price List Categories
|
PLTYP |
| KNVV | PVKSM | KNVV | PVKSM |
TPVD
Product Proposal: Definition of Customer Procedure
|
PVKSM |
| KNVV | PVKSM | KNVV | MANDT |
TPVD
Product Proposal: Definition of Customer Procedure
|
MANDT |
| KNVV | SPART | KNVV | MANDT |
TSPA
Organizational Unit: Sales Divisions
|
MANDT |
| KNVV | SPART | KNVV | SPART |
TSPA
Organizational Unit: Sales Divisions
|
SPART |
| KNVV | VERSG | KNVV | MANDT |
TVSD
Customers: Statistics groups
|
MANDT |
| KNVV | VERSG | KNVV | VERSG |
TVSD
Customers: Statistics groups
|
STGKU |
| KNVV | VKBUR | KNVV | MANDT |
TVBUR
Organizational Unit: Sales Offices
|
MANDT |
| KNVV | VKBUR | KNVV | VKBUR |
TVBUR
Organizational Unit: Sales Offices
|
VKBUR |
| KNVV | VKGRP | KNVV | MANDT |
TVBVK
Organizational Unit: Sales Groups per Sales Office
|
MANDT |
| KNVV | VKGRP | KNVV | VKBUR |
TVBVK
Organizational Unit: Sales Groups per Sales Office
|
VKBUR |
| KNVV | VKGRP | KNVV | VKGRP |
TVBVK
Organizational Unit: Sales Groups per Sales Office
|
VKGRP |
| KNVV | VKORG | KNVV | MANDT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| KNVV | VKORG | KNVV | VKORG |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| KNVV | VSBED | KNVV | MANDT |
TVSB
Shipping Conditions
|
MANDT |
| KNVV | VSBED | KNVV | VSBED |
TVSB
Shipping Conditions
|
VSBED |
| KNVV | VSORT | KNVV | MANDT |
VBUK
Sales Document: Header Status and Administrative Data
|
MANDT |
| KNVV | VSORT | KNVV | VSORT |
VBUK
Sales Document: Header Status and Administrative Data
|
VBELN |
| KNVV | VTWEG | KNVV | MANDT |
TVTW
Organizational Unit: Distribution Channels
|
MANDT |
| KNVV | VTWEG | KNVV | VTWEG |
TVTW
Organizational Unit: Distribution Channels
|
VTWEG |
| KNVV | VWERK | KNVV | MANDT |
TVKWZ
Org.Unit: Allowed Plants per Sales Organization
|
MANDT |
| KNVV | VWERK | KNVV | VKORG |
TVKWZ
Org.Unit: Allowed Plants per Sales Organization
|
VKORG |
| KNVV | VWERK | KNVV | VTWEG |
TVKWZ
Org.Unit: Allowed Plants per Sales Organization
|
VTWEG |
| KNVV | VWERK | KNVV | VWERK |
TVKWZ
Org.Unit: Allowed Plants per Sales Organization
|
WERKS |
| KNVV | WAERS | KNVV | WAERS |
TCURC
Currency Codes
|
WAERS |
| KNVV | WAERS | KNVV | MANDT |
TCURC
Currency Codes
|
MANDT |