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
X Yes
NULL No
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
000 Sales order probability
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
X Yes
NULL No
ANTLF Maximum Number of Partial Deliveries Allowed Per Item ANTLF DEC 1 0
KZTLF Partial delivery at item level KZTLF CHAR 1 0
NULL Partial delivery allowed
A Create a delivery with qty greater than zero
B Create only one delivery (also with quantity = 0)
C Only complete delivery allowed
D No limit to subsequent deliveries
KZAZU Order Combination Indicator KZAZU_D CHAR 1 0
X Yes
NULL No
CHSPL Batch split allowed CHSPL CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
PRAT1 ID for product attribute 1 KUAT1 CHAR 1 0
NULL Ship-to party accepts product attribute
X Ship-to party does not accept product attribute
PRAT2 ID for product attribute 2 KUAT2 CHAR 1 0
NULL Ship-to party accepts product attribute
X Ship-to party does not accept product attribute
PRAT3 ID for product attribute 3 KUAT3 CHAR 1 0
NULL Ship-to party accepts product attribute
X Ship-to party does not accept product attribute
PRAT4 ID for product attribute 4 KUAT4 CHAR 1 0
NULL Ship-to party accepts product attribute
X Ship-to party does not accept product attribute
PRAT5 ID for product attribute 5 KUAT5 CHAR 1 0
NULL Ship-to party accepts product attribute
X Ship-to party does not accept product attribute
PRAT6 ID for product attribute 6 KUAT6 CHAR 1 0
NULL Ship-to party accepts product attribute
X Ship-to party does not accept product attribute
PRAT7 ID for product attribute 7 KUAT7 CHAR 1 0
NULL Ship-to party accepts product attribute
X Ship-to party does not accept product attribute
PRAT8 ID for product attribute 8 KUAT8 CHAR 1 0
NULL Ship-to party accepts product attribute
X Ship-to party does not accept product attribute
PRAT9 ID for product attribute 9 KUAT9 CHAR 1 0
NULL Ship-to party accepts product attribute
X Ship-to party does not accept product attribute
PRATA ID for product attribute 10 KUATA CHAR 1 0
NULL Ship-to party accepts product attribute
X Ship-to party does not accept product attribute
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
X Yes
NULL No
AGREL Indicator: Relevant for agency business AGREL CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
PVKSM Customer procedure for product proposal PVKSM TPVD CHAR 2 0
PODKZ Relevant for POD processing PODKZ CHAR 1 0
X Yes
NULL No
PODTG Timeframe for Confirmation of POD PODTG DEC 11 0
BLIND Index Structure Active for Subsequent Settlement (in AB) BLIND_SD CHAR 1 0
X Yes
NULL No
CARRIER_NOTIF Carrier is to be notified /SPE/CARRIER_NOTIF CHAR 1 0
X Yes
NULL No
/BEV1/EMLGPFAND Deposit on Empties /BEV1/EMGPFAND CHAR 1 0
NULL Deposit
X No Deposit
/BEV1/EMLGFORTS Indicator for Empties Update /BEV1/EMGFORTS CHAR 1 0
NULL Empties Update
X No Empties Update
/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
X Yes
NULL No
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