1. Home
  2. Resources
  3. SAP Tables
  4. E1KNVVM - Master customer master sales data (KNVV)

SAP Table E1KNVVM

Master customer master sales data (KNVV)

E1KNVVM (Master customer master sales data (KNVV)) 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 E1KNVVM to other SAP tables.

E1KNVVM table fields

Field Data element Checktable Datatype Length Decimals
MSGFN Function MSGFN CHAR 3 0
003 Delete: Message contains objects to be deleted
004 Change: Message contains changes
005 Replace: This message replaces previous messages
009 Original: First message for process
023 Wait/Adjust: Data should not be imported
018 Resend
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
SPART Division SPART CHAR 2 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 CHAR 1 0
AUFSD Customer order block (sales area) AUFSD_V CHAR 2 0
KALKS Pricing procedure assigned to this customer KALKS CHAR 1 0
KDGRP Customer group KDGRP CHAR 2 0
BZIRK Sales district BZIRK CHAR 6 0
KONDA Price group (customer) KONDA CHAR 2 0
PLTYP Price list type PLTYP CHAR 2 0
AWAHR 3-Byte field CHAR3 CHAR 3 0
INCO1 Incoterms (Part 1) INCO1 CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
LIFSD Customer delivery block (sales area) LIFSD_V CHAR 2 0
AUTLF Complete delivery defined for each sales order? AUTLF CHAR 1 0
X Yes
NULL No
ANTLF Version Number Component CHAR2 CHAR 2 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 Version Number Component CHAR2 CHAR 2 0
EIKTO Shipper's (Our) Account Number at the Customer or Vendor EIKTO CHAR 12 0
VSBED Shipping Conditions VSBED CHAR 2 0
FAKSD Billing block for customer (sales and distribution) FAKSD_V CHAR 2 0
MRNKZ Manual invoice maintenance MRNKZ CHAR 1 0
X Yes
NULL No
PERFK Invoice dates (calendar identification) PERFK CHAR 2 0
PERRL Invoice list schedule (calendar identification) PERRL CHAR 2 0
WAERS R/2 table CHAR5 CHAR 5 0
KTGRD Account assignment group for this customer KTGRD CHAR 2 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
VWERK Delivering Plant DWERK CHAR 4 0
VKGRP Sales Group VKGRP CHAR 3 0
VKBUR Sales Office VKBUR CHAR 4 0
VSORT Item proposal VSORT CHAR 10 0
KVGR1 Customer group 1 KVGR1 CHAR 3 0
KVGR2 Customer group 2 KVGR2 CHAR 3 0
KVGR3 Customer group 3 KVGR3 CHAR 3 0
KVGR4 Customer group 4 KVGR4 CHAR 3 0
KVGR5 Customer group 5 KVGR5 CHAR 3 0
BOKRE Indicator: Customer Is Rebate-Relevant BOKRE CHAR 1 0
X Yes
NULL No
KURST Exchange Rate Type KURST CHAR 4 0
PRFRE Relevant for price determination ID PRFRE CHAR 1 0
X Yes
NULL No
KLABC CHAR 2 0
KABSS CHAR 4 0
KKBER CHAR 4 0
CASSD CHAR 2 0
RDOFF CHAR 1 0
AGREL CHAR 1 0
MEGRU CHAR 4 0
UEBTO CHAR 4 0
UNTTO CHAR 4 0
UEBTK CHAR 1 0
PVKSM CHAR 2 0
PODKZ CHAR 1 0
PODTG CHAR 11 0
BLIND CHAR 1 0
CARRIER_NOTIF CHAR 1 0