SAP Table KNVV
Customer Master Sales Data
What Is the SAP KNVV Table?
SAP KNVV Table stores Customer Master Sales area data used in the SAP Sales and Distribution (SD) module. It contains sales-related information maintained for a customer under a specific Sales Area.
In SAP SD, a Sales Area is defined by the combination of Sales Organization + Distribution Channel + Division. Each customer can have different sales-related settings for different sales areas.
The KNVV table contains important information used in sales activities such as Customer Number, Sales Organization, Distribution Channel, Division, Customer Group, Customer Pricing Procedure, Shipping Conditions, Delivery Priority and Payment Terms.
When a sales document is created, SAP uses relevant customer master data from KNVV to determine sales related information based on sales area and configuration.
For Example:
If Customer ABC100, purchases product through Sales organization 1010, distribution channel 10 and division 01, SAP uses sales-relation information maintained in KNVV table for that sales area.
If Same customer is extended to another sales area, a separate recorded is updated in the KNVV table for the new sales area combination.
In SAP ECC, customer sales area data is maintained using transaction code VD01, VD02,& VD03.
In SAP S/4HANA, Business Partner (BP) is used to maintain customer master record based on business partner roles. The FLCU01 – Customer role is used to maintain sales area data. The KNVV table continue to be available in SAP S/4HANA for customer sales area information.
Quick overview
| SAP table | KNVV |
|---|---|
| Short description | Customer Master Sales Data |
| Table type | Transparent table |
| Primary key | MANDT (Client), KUNNR (Customer Number), VKORG (Sales Organization), VTWEG (Distribution Channel), SPART (Division) |
| Client-dependent | Yes |
Important fields explained
| Field | SAP field description | What this field means |
|---|---|---|
KUNNR |
Customer Number | Customer number for which the sales area data is maintained. |
VKORG |
Sales Organization | Sales organization that forms part of the customer's sales area. |
VTWEG |
Distribution Channel | Distribution channel that forms part of the customer's sales area. |
INCO1 |
Incoterms (Part 1) | Incoterms key that specifies the agreed delivery terms between the seller and customer. |
VSBED |
Shipping Conditions | Shipping conditions maintained for the customer in this sales area. |
At a glance
- Module
- Sales and Distribution
- Application component
- LOGISTICS - GENERAL LO
- Subcomponent
- LOGISTICS BASIC DATA LO-MD
- Specific component
- BUSINESS PARTNERS LO-MD-BP
- Component level 4
- CUSTOMER MASTER LO-MD-BP-CM
Technical details
- Delivery class
- A (Application table: master and transaction data)
- Data class
- APPL0 (Master Data, Transparent Tables)
- Package
- Application development R/3 sales master data (VS)
Primary key fields
| Field | Description | Data element | Type | Length |
|---|---|---|---|---|
MANDT
|
Client | MANDT | CLNT | 3 |
KUNNR
|
Customer Number | KUNNR | CHAR | 10 |
VKORG
|
Sales Organization | VKORG | CHAR | 4 |
VTWEG
|
Distribution Channel | VTWEG | CHAR | 2 |
SPART
|
Division | SPART | CHAR | 2 |
Table fields
107 fields
107 fields
| Field | Description | Data element | Domain | Type | Length | Decimals | Check table |
|---|---|---|---|---|---|---|---|
MANDT
Key
|
Client | MANDT | MANDT | CLNT | 3 | — | T000 |
KUNNR
Key
|
Customer Number | KUNNR | KUNNR | CHAR | 10 | — | KNA1 |
VKORG
Key
|
Sales Organization | VKORG | VKORG | CHAR | 4 | — | TVKO |
VTWEG
Key
|
Distribution Channel | VTWEG | VTWEG | CHAR | 2 | — | TVTW |
SPART
Key
|
Division | SPART | SPART | CHAR | 2 | — | TSPA |
ERNAM
|
Name of Person Responsible for Creating the Object | ERNAM | USNAM | CHAR | 12 | — | |
ERDAT
|
Record Created On | ERDAT | DATUM | DATS | 8 | — | |
BEGRU
|
Authorization Group | BEGRU | BEGRU | CHAR | 4 | — | |
LOEVM
|
Deletion flag for customer (sales level) | LOEVM_V | XFELD | CHAR | 1 | — | |
VERSG
|
Customer Statistics Group | STGKU | STGKU | CHAR | 1 | — | TVSD |
AUFSD
|
Customer order block (sales area) | AUFSD_V | KAUFS | CHAR | 2 | — | TVAST |
KALKS
|
Customer Classification for Pricing Procedure Determination | KALKS | KALKS | CHAR | 2 | — | TVKD |
KDGRP
|
Customer Group | KDGRP | KDGRP | CHAR | 2 | — | T151 |
BZIRK
|
Sales District | BZIRK | BZIRK | CHAR | 6 | — | T171 |
KONDA
|
Customer Price Group | KONDA | KONDA | CHAR | 2 | — | T188 |
PLTYP
|
Price List Type | PLTYP | PLTYP | CHAR | 2 | — | T189 |
AWAHR
|
Order Probability of the Item | AWAHR | AWAHR | NUMC | 3 | — | |
INCO1
|
Incoterms (Part 1) | INCO1 | INCO1 | CHAR | 3 | — | TINC |
INCO2
|
Incoterms (Part 2) | INCO2 | INCO2 | CHAR | 28 | — | |
LIFSD
|
Customer delivery block (sales area) | LIFSD_V | LIFSP | CHAR | 2 | — | TVLS |
AUTLF
|
Complete Delivery Defined for Each Sales Order | AUTLF | XFELD | CHAR | 1 | — | |
ANTLF
|
Maximum Number of Partial Deliveries Allowed Per Item | ANTLF | ANTLF | DEC | 1 | 0 | |
KZTLF
|
Partial delivery at item level | KZTLF | KZTLF | CHAR | 1 | — | |
KZAZU
|
Order Combination Indicator | KZAZU_D | XFELD | CHAR | 1 | — | |
CHSPL
|
Batch split allowed | CHSPL | XFELD | CHAR | 1 | — | |
LPRIO
|
Delivery Priority | LPRIO | LPRIO | NUMC | 2 | — | TPRIO |
EIKTO
|
Shipper's (Our) Account Number at the Customer or Vendor | EIKTO | CHAR12 | CHAR | 12 | — | |
VSBED
|
Shipping Conditions | VSBED | VSBED | CHAR | 2 | — | TVSB |
FAKSD
|
Billing block for customer (sales and distribution) | FAKSD_V | FAKSP | CHAR | 2 | — | TVFS |
MRNKZ
|
Manual Invoice Maintenance | MRNKZ | XFELD | CHAR | 1 | — | |
PERFK
|
Invoice Dates (Calendar Identification) | PERFK | WFCID | CHAR | 2 | — | TFACD |
PERRL
|
Invoice List Schedule (calendar identification) | PERRL | WFCID | CHAR | 2 | — | TFACD |
KVAKZ
|
Cost estimate indicator (inactive) | KVAKZ | XFELD | CHAR | 1 | — | |
KVAWT
|
Value limit for cost estimate (inactive) | KVAWT | WERT7 | CURR | 13 | 2 | |
WAERS
|
Currency | WAERS_V02D | WAERS | CUKY | 5 | — | TCURC |
KLABC
|
Customer classification (ABC analysis) | KLABC | KLABC | CHAR | 2 | — | |
KTGRD
|
Account Assignment Group for Customer | KTGRD | KTGRD | CHAR | 2 | — | TVKT |
ZTERM
|
Terms of Payment Key | DZTERM | ZTERM | CHAR | 4 | — | |
VWERK
|
Delivering Plant (Own or External) | DWERK_EXT | WERKS | CHAR | 4 | — | TVKWZ |
VKGRP
|
Sales Group | VKGRP | VKGRP | CHAR | 3 | — | TVBVK |
VKBUR
|
Sales Office | VKBUR | VKBUR | CHAR | 4 | — | TVBUR |
VSORT
|
Item proposal | VSORT | VBELN | CHAR | 10 | — | |
KVGR1
|
Customer Group 1 | KVGR1 | KVGR1 | CHAR | 3 | — | TVV1 |
KVGR2
|
Customer Group 2 | KVGR2 | KVGR2 | CHAR | 3 | — | TVV2 |
KVGR3
|
Customer Group 3 | KVGR3 | KVGR3 | CHAR | 3 | — | TVV3 |
KVGR4
|
Customer Group 4 | KVGR4 | KVGR4 | CHAR | 3 | — | TVV4 |
KVGR5
|
Customer Group 5 | KVGR5 | KVGR5 | CHAR | 3 | — | TVV5 |
BOKRE
|
Indicator: Customer Is Rebate-Relevant | BOKRE | XFELD | CHAR | 1 | — | |
BOIDT
|
Start of validity per.for the rebate index for the customer | BOIDT | DATUM | DATS | 8 | — | |
KURST
|
Exchange Rate Type | KURST | KURST | CHAR | 4 | — | TCURV |
PRFRE
|
Relevant for price determination ID | PRFRE | XFELD | CHAR | 1 | — | |
PRAT1
|
ID for product attribute 1 | KUAT1 | PRATK | CHAR | 1 | — | |
PRAT2
|
ID for product attribute 2 | KUAT2 | PRATK | CHAR | 1 | — | |
PRAT3
|
ID for product attribute 3 | KUAT3 | PRATK | CHAR | 1 | — | |
PRAT4
|
ID for product attribute 4 | KUAT4 | PRATK | CHAR | 1 | — | |
PRAT5
|
ID for product attribute 5 | KUAT5 | PRATK | CHAR | 1 | — | |
PRAT6
|
ID for product attribute 6 | KUAT6 | PRATK | CHAR | 1 | — | |
PRAT7
|
ID for product attribute 7 | KUAT7 | PRATK | CHAR | 1 | — | |
PRAT8
|
ID for product attribute 8 | KUAT8 | PRATK | CHAR | 1 | — | |
PRAT9
|
ID for product attribute 9 | KUAT9 | PRATK | CHAR | 1 | — | |
PRATA
|
ID for product attribute 10 | KUATA | PRATK | CHAR | 1 | — | |
KABSS
|
Customer payment guarantee procedure | KABSSCH_CM | KABSSCH_CM | CHAR | 4 | — | T691P |
KKBER
|
Credit Control Area | KKBER | KKBER | CHAR | 4 | — | T014 |
CASSD
|
Sales Block for Customer (Sales Area) | CASSD_V | CASSP | CHAR | 2 | — | |
RDOFF
|
Switch off rounding? | RDOFF | XFELD | CHAR | 1 | — | |
AGREL
|
Indicator: Relevant for Settlement Management | AGREL | XFELD | CHAR | 1 | — | |
MEGRU
|
Unit of Measure Group | MEGRU | MEGRU | CHAR | 4 | — | TWMEG |
UEBTO
|
Overdelivery Tolerance | UEBTO | PRZ21 | DEC | 3 | 1 | |
UNTTO
|
Underdelivery Tolerance | UNTTO | PRZ21 | DEC | 3 | 1 | |
UEBTK
|
Unlimited Overdelivery Allowed | UEBTK_V | XFELD | CHAR | 1 | — | |
PVKSM
|
Customer procedure for product proposal | PVKSM | PVKSM | CHAR | 2 | — | TPVD |
PODKZ
|
Relevant for POD processing | PODKZ | XFELD | CHAR | 1 | — | |
PODTG
|
Timeframe for Confirmation of POD | PODTG | TSTRDURAG | DEC | 11 | 0 | |
BLIND
|
Index Structure Active for Subsequent Settlement | BLIND_SD | XFELD | CHAR | 1 | — | |
CARRIER_NOTIF
|
Carrier is to be notified | /SPE/CARRIER_NOTIF | XFELD | CHAR | 1 | — | |
CVP_XBLCK_V
|
Business Purpose Completed Flag | CVP_XBLCK | CVP_XBLCK | CHAR | 1 | — | |
INCOV
|
Incoterms Version | INCOV | INCOV | CHAR | 4 | — | TINCV |
INCO2_L
|
Incoterms Location 1 | INCO2_L | INCO_L | CHAR | 70 | — | |
INCO3_L
|
Incoterms Location 2 | INCO3_L | INCO_L | CHAR | 70 | — | |
INCO2_KEY
|
Incoterm Location 1 - Place of Destination | /SCMTMS/INC_LOC_1_KEY | /SCMTMS/LOCUUID | RAW | 16 | — | |
INCO3_KEY
|
Incoterm Location 2 - Place of Delivery | /SCMTMS/INC_LOC_2_KEY | /SCMTMS/LOCUUID | RAW | 16 | — | |
INCO4_KEY
|
Incoterm - Deviating Place of Destination | /SCMTMS/INC_DEV_PLACE_DEST_KEY | /SCMTMS/LOCUUID | RAW | 16 | — | |
KNVV_EEW_CONTACT
|
Data element Extension for Contact | KNVV_EEW_CONTACT | KNVV_EEW_CONTACT | CHAR | 1 | — | |
STATUS_OBJ_GUID
|
Globally Unique Identifier | GUID | — | RAW | 16 | — | |
BILLPLAN_PROC
|
Billing Plan Procedure | CRMT_BILLPLAN_PROC | CRM_BILLPLAN_PROC | CHAR | 4 | — | |
KNVV_ADDR_EEW_CUST
|
Customer sales addr. dep. extensibility | KNVV_ADDR_EEW_CUST | KNVV_ADDR_EEW_CUST | CHAR | 1 | — | |
/BEV1/EMLGPFAND
|
Deposit on Empties | /BEV1/EMGPFAND | /BEV1/EMGPFAND | CHAR | 1 | — | |
/BEV1/EMLGFORTS
|
Indicator for Empties Update | /BEV1/EMGFORTS | /BEV1/EMGFORTS | CHAR | 1 | — | |
J_1NBOESL
|
Exchange Key for NF Processing | /NFM/BOESL | /NFM/BOESL | CHAR | 3 | — | /NFM/TBOESL |
FSH_KVGR6
|
Customer Group 6 | FSH_KVGR6 | FSH_KVGR_6 | CHAR | 3 | — | FSH_TVV6 |
FSH_KVGR7
|
Customer Group 7 | FSH_KVGR7 | FSH_KVGR7 | CHAR | 3 | — | FSH_TVV7 |
FSH_KVGR8
|
Customer Group 8 | FSH_KVGR8 | FSH_KVGR8 | CHAR | 3 | — | FSH_TVV8 |
FSH_KVGR9
|
Customer Group 9 | FSH_KVGR9 | FSH_KVGR9 | CHAR | 3 | — | FSH_TVV9 |
FSH_KVGR10
|
Customer Group 10 | FSH_KVGR10 | FSH_KVGR10 | CHAR | 3 | — | FSH_TVV10 |
FSH_GRREG
|
Grouping Rule | FSH_GRREG | FSH_GRREG | CHAR | 4 | — | FSH_GRRG_W |
FSH_RESGY
|
Release Strategy | FSH_RESGY | FSH_RESGY | CHAR | 4 | — | FSH_RESG_W |
FSH_SC_CID
|
Customer/Supplier Identifier | FSH_SC_CID | FSH_SC_CID | CHAR | 2 | — | FSH_SC_VCIDS |
FSH_VAS_DETC
|
VAS Determination Mode | FSH_VAS_DETC | FSH_VAS_DETC | CHAR | 1 | — | |
FSH_VAS_CG
|
Value-Added Services Customer Group | FSH_VAS_CG_D | FSH_VAS_CG | CHAR | 3 | — | FSH_VAS_CG |
FSH_GRSGY
|
ARUN Grouping Strategy | FSH_GRSGY | FSH_GRSGY | CHAR | 4 | — | FSH_GRSG_W |
FSH_SS
|
Order Scheduling Strategy | FSH_SCH_STY | FSH_SCH_STY | CHAR | 3 | — | FSH_OSS |
FSH_FRATE
|
Fill Rate % | FSH_FRATE | PROZENT | NUMC | 3 | — | |
FSH_FRATE_AGG_LEVEL
|
Fill Rate Aggregation Level | FSH_FRATE_AGG_LEVEL | FSH_FRATE_AGG_LEVEL | CHAR | 1 | — | |
FSH_MSOCDC
|
Distribution Center of Customer | FSH_MSOCDC | KUNNR | CHAR | 10 | — | KNA1 |
FSH_MSOPID
|
Customer Identification in the Partner System | FSH_MSOPID | CHAR20 | CHAR | 20 | — | |
RFM_PSST_RULE
|
PSST Grouping Rule | RFM_PSST_RULE | RFM_PSST_RULE | CHAR | 4 | — | |
RFM_PSST_EXCLUDE
|
Exclude from PSST Grouping Rule Determination | RFM_PSST_EXCLUDE | XFELD | CHAR | 1 | — |
No fields match the selected filters.
Editorial and verification
- Content editor
- ERPSAP Content Team
- Technical reviewer
- ERPSAP Technical Review Team
- Verified against
- SAP S/4HANA 2023 On-Premise system
- Last updated
- October 11, 2026
The information on this SAP KNVV table page is based on the verified SAP S/4HANA 2023 on-premise system identified above. Table definitions, fields, and availability may differ across SAP releases and customer-specific systems.