SAP ABAP Table KNVV (Customer Master Sales Data)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-BF (Application Component) Basic Functions
     VS (Package) Application development R/3 sales master data
Basic Data
Table Category TRANSP    Transparent table 
Transparent table KNVV   Table Relationship Diagram
Short Description Customer Master Sales Data    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number KNA1
3 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
4 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
5 SPART SPART SPART CHAR 2   0   Division TSPA
6 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
7 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
8 BEGRU BEGRU BEGRU CHAR 4   0   Authorization Group  
9 LOEVM LOEVM_V XFELD CHAR 1   0   Deletion flag for customer (sales level)  
10 VERSG STGKU STGKU CHAR 1   0   Customer Statistics Group TVSD
11 AUFSD AUFSD_V KAUFS CHAR 2   0   Customer order block (sales area) TVAST
12 KALKS KALKS KALKS CHAR 1   0   Pricing procedure assigned to this customer TVKD
13 KDGRP KDGRP KDGRP CHAR 2   0   Customer group T151
14 BZIRK BZIRK BZIRK CHAR 6   0   Sales district T171
15 KONDA KONDA KONDA CHAR 2   0   Price Group (Customer) T188
16 PLTYP PLTYP PLTYP CHAR 2   0   Price list type T189
17 AWAHR AWAHR AWAHR NUMC 3   0   Order probability of the item  
18 INCO1 INCO1 INCO1 CHAR 3   0   Incoterms (part 1) TINC
19 INCO2 INCO2 INCO2 CHAR 28   0   Incoterms (part 2)  
20 LIFSD LIFSD_V LIFSP CHAR 2   0   Customer delivery block (sales area) TVLS
21 AUTLF AUTLF XFELD CHAR 1   0   Complete delivery defined for each sales order?  
22 ANTLF ANTLF ANTLF DEC 1   0   Maximum number of partial deliveries allowed per item  
23 KZTLF KZTLF KZTLF CHAR 1   0   Partial delivery at item level  
24 KZAZU KZAZU_D XFELD CHAR 1   0   Order combination indicator  
25 CHSPL CHSPL XFELD CHAR 1   0   Batch split allowed  
26 LPRIO LPRIO LPRIO NUMC 2   0   Delivery priority TPRIO
27 EIKTO EIKTO CHAR12 CHAR 12   0   Shipper's (Our) Account Number at the Customer or Vendor  
28 VSBED VSBED VSBED CHAR 2   0   Shipping conditions TVSB
29 FAKSD FAKSD_V FAKSP CHAR 2   0   Billing block for customer (sales and distribution) TVFS
30 MRNKZ MRNKZ XFELD CHAR 1   0   Manual invoice maintenance  
31 PERFK PERFK WFCID CHAR 2   0   Invoice dates (calendar identification) TFACD
32 PERRL PERRL WFCID CHAR 2   0   Invoice list schedule (calendar identification) TFACD
33 KVAKZ KVAKZ XFELD CHAR 1   0   Cost estimate indicator (inactive)  
34 KVAWT KVAWT WERT7 CURR 13   2   Value limit for cost estimate (inactive)  
35 WAERS WAERS_V02D WAERS CUKY 5   0   Currency TCURC
36 KLABC KLABC KLABC CHAR 2   0   Customer classification (ABC analysis)  
37 KTGRD KTGRD KTGRD CHAR 2   0   Account assignment group for this customer TVKT
38 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
39 VWERK DWERK_EXT WERKS CHAR 4   0   Delivering Plant (Own or External) TVKWZ
40 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVBVK
41 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVBUR
42 VSORT VSORT VBELN CHAR 10   0   Item proposal VBUK
43 KVGR1 KVGR1 KVGR1 CHAR 3   0   Customer group 1 TVV1
44 KVGR2 KVGR2 KVGR2 CHAR 3   0   Customer group 2 TVV2
45 KVGR3 KVGR3 KVGR3 CHAR 3   0   Customer group 3 TVV3
46 KVGR4 KVGR4 KVGR4 CHAR 3   0   Customer group 4 TVV4
47 KVGR5 KVGR5 KVGR5 CHAR 3   0   Customer group 5 TVV5
48 BOKRE BOKRE XFELD CHAR 1   0   ID: Customer is to receive rebates  
49 BOIDT BOIDT DATUM DATS 8   0   Start of validity per.for the rebate index for the customer  
50 KURST KURST KURST CHAR 4   0   Exchange Rate Type TCURV
51 PRFRE PRFRE XFELD CHAR 1   0   Relevant for Pricing ID  
52 PRAT1 KUAT1 PRATK CHAR 1   0   ID for product attribute 1  
53 PRAT2 KUAT2 PRATK CHAR 1   0   ID for product attribute 2  
54 PRAT3 KUAT3 PRATK CHAR 1   0   ID for product attribute 3  
55 PRAT4 KUAT4 PRATK CHAR 1   0   ID for product attribute 4  
56 PRAT5 KUAT5 PRATK CHAR 1   0   ID for product attribute 5  
57 PRAT6 KUAT6 PRATK CHAR 1   0   ID for product attribute 6  
58 PRAT7 KUAT7 PRATK CHAR 1   0   ID for product attribute 7  
59 PRAT8 KUAT8 PRATK CHAR 1   0   ID for product attribute 8  
60 PRAT9 KUAT9 PRATK CHAR 1   0   ID for product attribute 9  
61 PRATA KUATA PRATK CHAR 1   0   ID for product attribute 10  
62 KABSS KABSSCH_CM KABSSCH_CM CHAR 4   0   Customer payment guarantee procedure T691P
63 KKBER KKBER KKBER CHAR 4   0   Credit control area T014
64 CASSD CASSD_V CASSP CHAR 2   0   Sales block for customer (sales area)  
65 RDOFF RDOFF XFELD CHAR 1   0   Switch off rounding?  
66 AGREL AGREL XFELD CHAR 1   0   Indicator: Relevant for agency business  
67 MEGRU MEGRU MEGRU CHAR 4   0   Unit of Measure Group TWMEG
68 UEBTO UEBTO PRZ21 DEC 3   1   Overdelivery Tolerance Limit  
69 UNTTO UNTTO PRZ21 DEC 3   1   Underdelivery Tolerance Limit  
70 UEBTK UEBTK_V XFELD CHAR 1   0   Unlimited overdelivery allowed  
71 PVKSM PVKSM PVKSM CHAR 2   0   Customer procedure for product proposal TPVD
72 PODKZ PODKZ XFELD CHAR 1   0   Relevant for POD processing  
73 PODTG PODTG TSTRDURAG DEC 11   0   Timeframe for Confirmation of POD  
74 BLIND BLIND_SD XFELD CHAR 1   0   Index Structure Active for Subsequent Settlement (in AB)  
75 CARRIER_NOTIF /SPE/CARRIER_NOTIF XFELD CHAR 1   0   Carrier is to be notified  
76 .INCLU--AP       0   0   Append for Empties  
77 .INCLUDE       0   0   Include for Empties  
78 /BEV1/EMLGPFAND /BEV1/EMGPFAND /BEV1/EMGPFAND CHAR 1   0   Deposit on Empties  
79 /BEV1/EMLGFORTS /BEV1/EMGFORTS /BEV1/EMGFORTS CHAR 1   0   Indicator for Empties Update  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 KNVV AUFSD TVAST AUFSP REF C CN
2 KNVV BZIRK T171 BZIRK REF C CN
3 KNVV FAKSD TVFS FAKSP REF C CN
4 KNVV INCO1 TINC INCO1 REF C CN
5 KNVV KABSS T691P KABSS REF C CN
6 KNVV KALKS TVKD KALKS REF C CN
7 KNVV KDGRP T151 KDGRP REF C CN
8 KNVV KKBER T014 KKBER C CN
9 KNVV KONDA T188 KONDA REF C CN
10 KNVV KTGRD TVKT KTGRD REF C CN
11 KNVV KUNNR KNA1 KUNNR KEY 1 CN
12 KNVV KURST TCURV KURST REF C CN
13 KNVV KVGR1 TVV1 KVGR1 REF C CN
14 KNVV KVGR2 TVV2 KVGR2 REF C CN
15 KNVV KVGR3 TVV3 KVGR3 REF C CN
16 KNVV KVGR4 TVV4 KVGR4 REF C CN
17 KNVV KVGR5 TVV5 KVGR5 REF C CN
18 KNVV LIFSD TVLS LIFSP REF C CN
19 KNVV LPRIO TPRIO LPRIO REF C CN
20 KNVV MANDT T000 MANDT KEY 1 CN
21 KNVV MEGRU TWMEG MEGRU 1 N
22 KNVV PERFK TFACD IDENT REF C CN
23 KNVV PERRL TFACD IDENT REF C CN
24 KNVV PLTYP T189 PLTYP REF C CN
25 KNVV PVKSM TPVD PVKSM KEY 1 1
26 KNVV SPART TSPA SPART KEY 1 CN
27 KNVV VERSG TVSD STGKU REF C CN
28 KNVV VKBUR TVBUR VKBUR REF C CN
29 KNVV VKGRP TVBVK VKGRP REF C CN
30 KNVV VKORG TVKO VKORG KEY 1 CN
31 KNVV VSBED TVSB VSBED REF C CN
32 KNVV VSORT VBUK VBELN REF C CN
33 KNVV VTWEG TVTW VTWEG KEY 1 CN
34 KNVV VWERK TVKWZ WERKS REF C CN
35 KNVV WAERS TCURC WAERS REF C CN
History
Last changed by/on SAP  20110901 
SAP Release Created in