SAP CRM e1459022344657
SAP KNVV is the standard table for SAP Customer Master Sales Data.
It contains all relevant data for a SAP customer for Sales Operation.
Table of Contents
In order to display the SAP customer Sales Data, launch the tcode XD03.
You can select:
SAP KNVV stores Sales Data for customer.
The Keys for this table are based on SAP Customer Number (KUNNR) and Sales Area (built with Sales Org + Distribution Channel + Division).
So the Keys for SAP KNVV are:
Check also how to Update Customer with CMD_EI_API
The Structure of SAP KNVV table is
| Field | Description | Checktable |
|---|---|---|
| MANDT | Client | T000 |
| KUNNR | Customer Number | KNA1 |
| VKORG | Sales Organization | TVKO |
| VTWEG | Distribution Channel | TVTW |
| SPART | Division | TSPA |
| ERNAM | Name of Person who Created the Object | |
| ERDAT | Date on Which Record Was Created | |
| BEGRU | Authorization Group | |
| LOEVM | Deletion flag for customer (sales level) | |
| VERSG | Customer Statistics Group | TVSD |
| AUFSD | Customer order block (sales area) | TVAST |
| KALKS | Pricing procedure assigned to this customer | TVKD |
| KDGRP | Customer group | T151 |
| BZIRK | Sales district | T171 |
| KONDA | Price group (customer) | T188 |
| PLTYP | Price list type | T189 |
| AWAHR | Order probability of the item | |
| INCO1 | Incoterms (Part 1) | TINC |
| INCO2 | Incoterms (Part 2) | |
| LIFSD | Customer delivery block (sales area) | TVLS |
| AUTLF | Complete delivery defined for each sales order? | |
| ANTLF | Maximum Number of Partial Deliveries Allowed Per Item | |
| KZTLF | Partial delivery at item level | |
| KZAZU | Order Combination Indicator | |
| CHSPL | Batch split allowed | |
| LPRIO | Delivery Priority | TPRIO |
| EIKTO | Shipper's (Our) Account Number at the Customer or Vendor | |
| VSBED | Shipping Conditions | TVSB |
| FAKSD | Billing block for customer (sales and distribution) | TVFS |
| MRNKZ | Manual invoice maintenance | |
| PERFK | Invoice dates (calendar identification) | TFACD |
| PERRL | Invoice list schedule (calendar identification) | TFACD |
| KVAKZ | Cost estimate indicator (inactive) | |
| KVAWT | Value limit for cost estimate (inactive) | |
| WAERS | Currency | TCURC |
| KLABC | Customer classification (ABC analysis) | |
| KTGRD | Account assignment group for this customer | TVKT |
| ZTERM | Terms of Payment Key | |
| VWERK | Delivering Plant (Own or External) | TVKWZ |
| VKGRP | Sales Group | TVBVK |
| VKBUR | Sales Office | TVBUR |
| VSORT | Item proposal | VBUK |
| KVGR1 | Customer group 1 | TVV1 |
| KVGR2 | Customer group 2 | TVV2 |
| KVGR3 | Customer group 3 | TVV3 |
| KVGR4 | Customer group 4 | TVV4 |
| KVGR5 | Customer group 5 | TVV5 |
| BOKRE | Indicator: Customer Is Rebate-Relevant | |
| BOIDT | Start of validity per.for the rebate index for the customer | |
| KURST | Exchange Rate Type | TCURV |
| PRFRE | Relevant for price determination ID | |
| PRAT1 | ID for product attribute 1 | |
| PRAT2 | ID for product attribute 2 | |
| PRAT3 | ID for product attribute 3 | |
| PRAT4 | ID for product attribute 4 | |
| PRAT5 | ID for product attribute 5 | |
| PRAT6 | ID for product attribute 6 | |
| PRAT7 | ID for product attribute 7 | |
| PRAT8 | ID for product attribute 8 | |
| PRAT9 | ID for product attribute 9 | |
| PRATA | ID for product attribute 10 | |
| KABSS | Customer payment guarantee procedure | T691P |
| KKBER | Credit control area | T014 |
| CASSD | Sales block for customer (sales area) | |
| RDOFF | Switch off rounding? | |
| AGREL | Indicator: Relevant for agency business | |
| MEGRU | Unit of Measure Group | TWMEG |
| UEBTO | Overdelivery Tolerance Limit | |
| UNTTO | Underdelivery Tolerance Limit | |
| UEBTK | Unlimited overdelivery allowed | |
| PVKSM | Customer procedure for product proposal | TPVD |
| PODKZ | Relevant for POD processing | |
| PODTG | Timeframe for Confirmation of POD | |
| BLIND | Index Structure Active for Subsequent Settlement (in AB) | |
| CARRIER_NOTIF | Carrier is to be notified | |
| CVP_XBLCK_V | Business Purpose Completed Flag | |
| /BEV1/EMLGPFAND | Deposit on Empties | |
| /BEV1/EMLGFORTS | Indicator for Empties Update |
SAP ISU Tables for Technical master data, for Billing Master Data, Billing and invoicing Tables?…
SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd…
Dunning is the business practice of informing a customer of past due payment. Dunning letters…
SAP AP Tcodes & SAP AR Tcodes: House Banks Tcodes, Advance Payments or Down Payments,…
What are the main SAP Payment Terms Tables ? What are the related Tables in…
Work center consists of master data related to routing of products. It contains data related…