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 | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||||||
| 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 |
Possible values
|
||||||||||||
| 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 |
Possible values
|
||||||||||||
| ANTLF | Maximum Number of Partial Deliveries Allowed Per Item | ANTLF | DEC | 1 | 0 | |||||||||||||
| KZTLF | Partial delivery at item level | KZTLF | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| KZAZU | Order Combination Indicator | KZAZU_D | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| CHSPL | Batch split allowed | CHSPL | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| 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 |
Possible values
|
||||||||||||
| 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 |
Possible values
|
||||||||||||
| 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 |
Possible values
|
||||||||||||
| 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 |
Possible values
|
||||||||||||
| PRAT1 | ID for product attribute 1 | KUAT1 | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| PRAT2 | ID for product attribute 2 | KUAT2 | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| PRAT3 | ID for product attribute 3 | KUAT3 | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| PRAT4 | ID for product attribute 4 | KUAT4 | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| PRAT5 | ID for product attribute 5 | KUAT5 | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| PRAT6 | ID for product attribute 6 | KUAT6 | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| PRAT7 | ID for product attribute 7 | KUAT7 | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| PRAT8 | ID for product attribute 8 | KUAT8 | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| PRAT9 | ID for product attribute 9 | KUAT9 | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| PRATA | ID for product attribute 10 | KUATA | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| 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 |
Possible values
|
||||||||||||
| AGREL | Indicator: Relevant for agency business | AGREL | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| 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 |
Possible values
|
||||||||||||
| PVKSM | Customer procedure for product proposal | PVKSM | TPVD | CHAR | 2 | 0 | ||||||||||||
| PODKZ | Relevant for POD processing | PODKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| PODTG | Timeframe for Confirmation of POD | PODTG | DEC | 11 | 0 | |||||||||||||
| BLIND | Index Structure Active for Subsequent Settlement (in AB) | BLIND_SD | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| CARRIER_NOTIF | Carrier is to be notified | /SPE/CARRIER_NOTIF | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| /BEV1/EMLGPFAND | Deposit on Empties | /BEV1/EMGPFAND | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| /BEV1/EMLGFORTS | Indicator for Empties Update | /BEV1/EMGFORTS | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| /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 |
Possible values
|
||||||||||||
| 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 | AUFSD | TVAST | Sales Document Blocking Reasons: Texts | AUFSP |
| KNVV | AUFSD | KNVV | MANDT | TVAST | Sales Document Blocking Reasons: Texts | MANDT |
| KNVV | AUFSD | SYST | LANGU | TVAST | Sales Document Blocking Reasons: Texts | SPRAS |
| 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 | MANDT | TVKD | Customer Pricing Procedures | MANDT |
| KNVV | KALKS | KNVV | KALKS | TVKD | Customer Pricing Procedures | KALKS |
| 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 | MANDT | T188 | Conditions: Groups for Customer Classifications | MANDT |
| KNVV | KONDA | KNVV | KONDA | T188 | Conditions: Groups for Customer Classifications | KONDA |
| 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 | KURST | TCURV | Exchange rate types for currency translation | KURST |
| KNVV | KURST | KNVV | MANDT | TCURV | Exchange rate types for currency translation | MANDT |
| 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 | MANDT | TVV4 | Customer Group 4 | MANDT |
| KNVV | KVGR4 | KNVV | KVGR4 | TVV4 | Customer Group 4 | KVGR4 |
| KNVV | KVGR5 | KNVV | KVGR5 | TVV5 | Customer Group 5 | KVGR5 |
| KNVV | KVGR5 | KNVV | MANDT | TVV5 | Customer Group 5 | MANDT |
| KNVV | LIFSD | KNVV | MANDT | TVLS | Deliveries: Blocking Reasons/Criteria | MANDT |
| KNVV | LIFSD | KNVV | LIFSD | TVLS | Deliveries: Blocking Reasons/Criteria | LIFSP |
| 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 | KNVV | OIABTNR | TSAB | Contact persons: standard departments | ABTNR |
| KNVV | OIABTNR | T000 | MANDT | TSAB | Contact persons: standard departments | MANDT |
| KNVV | OIC_MOT | T000 | MANDT | TVTR | Routes: Modes of Transport | MANDT |
| KNVV | OIC_MOT | KNVV | OIC_MOT | TVTR | Routes: Modes of Transport | VKTRA |
| 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 | KNVV | OIPAFKT | TPFK | Contact Persons: Functions | PAFKT |
| KNVV | OIPAFKT | T000 | KNVV | TPFK | Contact Persons: Functions | MANDT |
| KNVV | OIPFLIC | SYST | MANDT | TPAR | Business Partner: Functions | MANDT |
| KNVV | OIPFLIC | KNVV | OIPFLIC | TPAR | Business Partner: Functions | PARVW |
| KNVV | PERFK | KNVV | PERFK | TFACD | Factory calendar definition | IDENT |
| KNVV | PERRL | KNVV | PERRL | TFACD | Factory calendar definition | IDENT |
| KNVV | PLTYP | KNVV | PLTYP | T189 | Conditions: Price List Categories | PLTYP |
| KNVV | PLTYP | KNVV | MANDT | T189 | Conditions: Price List Categories | MANDT |
| KNVV | PVKSM | KNVV | MANDT | TPVD | Product Proposal: Definition of Customer Procedure | MANDT |
| KNVV | PVKSM | KNVV | PVKSM | TPVD | Product Proposal: Definition of Customer Procedure | PVKSM |
| 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 | VKGRP | TVBVK | Organizational Unit: Sales Groups per Sales Office | VKGRP |
| 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 | VKORG | KNVV | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| KNVV | VKORG | KNVV | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| KNVV | VSBED | KNVV | VSBED | TVSB | Shipping Conditions | VSBED |
| KNVV | VSBED | KNVV | MANDT | TVSB | Shipping Conditions | MANDT |
| 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 | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| KNVV | VTWEG | KNVV | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| 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 | 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 | WAERS | KNVV | MANDT | TCURC | Currency Codes | MANDT |
| KNVV | WAERS | KNVV | WAERS | TCURC | Currency Codes | WAERS |
