Follow us on LinkedIn for your next SAP project

SAP Table KNVV

Customer Master Sales Data

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.

KNVV table fields

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

KNVV foreign key relationships

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