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
⤷ 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
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |