SAP table KNVV (Customer Master Sales Data)

SAP table KNVV has 5 primary key fields being MANDT,KUNNR,VKORG,VTWEG,SPART.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
SPART Division CHAR 2 0 TSPA SPART
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
BEGRU Authorization Group CHAR 4 0 BEGRU
LOEVM Deletion flag for customer (sales level) CHAR 1 0 LOEVM_V
VERSG Customer Statistics Group CHAR 1 0 TVSD STGKU
AUFSD Customer order block (sales area) CHAR 2 0 TVAST AUFSD_V
KALKS Customer Classification for Pricing Procedure Determination CHAR 2 0 TVKD KALKS
KDGRP Customer Group CHAR 2 0 T151 KDGRP
BZIRK Sales District CHAR 6 0 T171 BZIRK
KONDA Customer Price Group CHAR 2 0 T188 KONDA
PLTYP Price List Type CHAR 2 0 T189 PLTYP
AWAHR Order Probability of the Item NUMC 3 0 AWAHR
000 Sales order probability
INCO1 Incoterms (Part 1) CHAR 3 0 TINC INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
LIFSD Customer delivery block (sales area) CHAR 2 0 TVLS LIFSD_V
AUTLF Complete Delivery Defined for Each Sales Order? CHAR 1 0 AUTLF
ANTLF Maximum Number of Partial Deliveries Allowed Per Item DEC 1 0 ANTLF
KZTLF Partial delivery at item level CHAR 1 0 KZTLF
Partial delivery allowed
A Create a delivery with quantity 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 CHAR 1 0 KZAZU_D
CHSPL Batch split allowed CHAR 1 0 CHSPL
LPRIO Delivery Priority NUMC 2 0 TPRIO LPRIO
EIKTO Shipper's (Our) Account Number at the Customer or Vendor CHAR 12 0 EIKTO
VSBED Shipping Conditions CHAR 2 0 TVSB VSBED
FAKSD Billing block for customer (sales and distribution) CHAR 2 0 TVFS FAKSD_V
MRNKZ Manual Invoice Maintenance CHAR 1 0 MRNKZ
PERFK Invoice Dates (Calendar Identification) CHAR 2 0 TFACD PERFK
PERRL Invoice List Schedule (calendar identification) CHAR 2 0 TFACD PERRL
KVAKZ Cost estimate indicator (inactive) CHAR 1 0 KVAKZ
KVAWT Value limit for cost estimate (inactive) CURR 13 2 KVAWT
WAERS Currency CUKY 5 0 TCURC WAERS_V02D
KLABC Customer classification (ABC analysis) CHAR 2 0 KLABC
KTGRD Account Assignment Group for this Customer CHAR 2 0 TVKT KTGRD
ZTERM Terms of payment key CHAR 4 0 DZTERM
VWERK Delivering Plant (Own or External) CHAR 4 0 TVKWZ DWERK_EXT
VKGRP Sales group CHAR 3 0 TVBVK VKGRP
VKBUR Sales office CHAR 4 0 TVBUR VKBUR
VSORT Item proposal CHAR 10 0 VSORT
KVGR1 Customer Group 1 CHAR 3 0 TVV1 KVGR1
KVGR2 Customer Group 2 CHAR 3 0 TVV2 KVGR2
KVGR3 Customer Group 3 CHAR 3 0 TVV3 KVGR3
KVGR4 Customer Group 4 CHAR 3 0 TVV4 KVGR4
KVGR5 Customer Group 5 CHAR 3 0 TVV5 KVGR5
BOKRE Indicator: Customer Is Rebate-Relevant CHAR 1 0 BOKRE
BOIDT Start of validity per.for the rebate index for the customer DATS 8 0 BOIDT
KURST Exchange Rate Type CHAR 4 0 TCURV KURST
PRFRE Relevant for price determination ID CHAR 1 0 PRFRE
PRAT1 ID for product attribute 1 CHAR 1 0 KUAT1
PRAT2 ID for product attribute 2 CHAR 1 0 KUAT2
PRAT3 ID for product attribute 3 CHAR 1 0 KUAT3
PRAT4 ID for product attribute 4 CHAR 1 0 KUAT4
PRAT5 ID for product attribute 5 CHAR 1 0 KUAT5
PRAT6 ID for product attribute 6 CHAR 1 0 KUAT6
PRAT7 ID for product attribute 7 CHAR 1 0 KUAT7
PRAT8 ID for product attribute 8 CHAR 1 0 KUAT8
PRAT9 ID for product attribute 9 CHAR 1 0 KUAT9
PRATA ID for product attribute 10 CHAR 1 0 KUATA
KABSS Customer payment guarantee procedure CHAR 4 0 T691P KABSSCH_CM
KKBER Credit control area CHAR 4 0 T014 KKBER
CASSD Sales Block for Customer (Sales Area) CHAR 2 0 CASSD_V
RDOFF Switch off rounding? CHAR 1 0 RDOFF
AGREL Indicator: Relevant for Settlement Management CHAR 1 0 AGREL
MEGRU Unit of Measure Group CHAR 4 0 TWMEG MEGRU
UEBTO Overdelivery Tolerance DEC 3 1 UEBTO
UNTTO Underdelivery Tolerance DEC 3 1 UNTTO
UEBTK Unlimited Overdelivery Allowed CHAR 1 0 UEBTK_V
PVKSM Customer procedure for product proposal CHAR 2 0 TPVD PVKSM
PODKZ Relevant for POD processing CHAR 1 0 PODKZ
PODTG Timeframe for Confirmation of POD DEC 11 0 PODTG
BLIND Index Structure Active for Subsequent Settlement CHAR 1 0 BLIND_SD
CARRIER_NOTIF Carrier is to be notified CHAR 1 0 /SPE/CARRIER_NOTIF
CVP_XBLCK_V Business Purpose Completed Flag CHAR 1 0 CVP_XBLCK
not blocked
X blocked
INCOV Incoterms Version CHAR 4 0 TINCV INCOV
INCO2_L Incoterms Location 1 CHAR 70 0 INCO2_L
INCO3_L Incoterms Location 2 CHAR 70 0 INCO3_L
INCO2_KEY Incoterm Location 1 - Place of Destination RAW 16 0 /SCMTMS/INC_LOC_1_KEY
INCO3_KEY Incoterm Location 2 - Place of Delivery RAW 16 0 /SCMTMS/INC_LOC_2_KEY
INCO4_KEY Incoterm - Deviating Place of Destination RAW 16 0 /SCMTMS/INC_DEV_PLACE_DEST_KEY
KNVV_EEW_CONTACT Data element Extension for Contact CHAR 1 0 KNVV_EEW_CONTACT
STATUS_OBJ_GUID Globally Unique Identifier RAW 16 0 GUID
BILLPLAN_PROC Billing Plan Procedure CHAR 4 0 * CRMT_BILLPLAN_PROC
KNVV_ADDR_EEW_CUST Customer sales addr. dep. extensibility CHAR 1 0 KNVV_ADDR_EEW_CUST
/BEV1/EMLGPFAND Deposit on Empties CHAR 1 0 /BEV1/EMGPFAND
Deposit
X No Deposit
/BEV1/EMLGFORTS Indicator for Empties Update CHAR 1 0 /BEV1/EMGFORTS
Empties Update
X No Empties Update
J_1NBOESL Exchange Key for NF Processing CHAR 3 0 /NFM/TBOESL /NFM/BOESL
FSH_KVGR6 Customer Group 6 CHAR 3 0 FSH_TVV6 FSH_KVGR6
FSH_KVGR7 Customer Group 7 CHAR 3 0 FSH_TVV7 FSH_KVGR7
FSH_KVGR8 Customer Group 8 CHAR 3 0 FSH_TVV8 FSH_KVGR8
FSH_KVGR9 Customer Group 9 CHAR 3 0 FSH_TVV9 FSH_KVGR9
FSH_KVGR10 Customer Group 10 CHAR 3 0 FSH_TVV10 FSH_KVGR10
FSH_GRREG Grouping Rule CHAR 4 0 FSH_GRRG_W FSH_GRREG
FSH_RESGY Release Strategy CHAR 4 0 FSH_RESG_W FSH_RESGY
FSH_SC_CID Customer/Supplier Identifier CHAR 2 0 FSH_SC_VCIDS FSH_SC_CID
FSH_VAS_DETC VAS Determination Mode CHAR 1 0 FSH_VAS_DETC
No Determination
1 Determination and No VAS Item Generation
2 Determination and VAS Item Generation on Save
3 Determination and Instant VAS Item Generation
FSH_VAS_CG Value-Added Services Customer Group CHAR 3 0 FSH_VAS_CG FSH_VAS_CG_D
FSH_GRSGY ARUN Grouping Strategy CHAR 4 0 FSH_GRSG_W FSH_GRSGY
FSH_SS Order Scheduling Strategy CHAR 3 0 FSH_OSS FSH_SCH_STY
FSH_FRATE Fill Rate % NUMC 3 0 FSH_FRATE
FSH_FRATE_AGG_LEVEL Fill Rate Aggregation Level CHAR 1 0 FSH_FRATE_AGG_LEVEL
1 Complete Order
2 Season Year, Season, Collection and Theme
3 Article
4 Article with Color Characteristics
FSH_MSOCDC Distribution Center of Customer CHAR 10 0 KNA1 FSH_MSOCDC
FSH_MSOPID Customer Identification in the Partner System CHAR 20 0 FSH_MSOPID
RFM_PSST_RULE PSST Grouping Rule CHAR 4 0 RFM_PSST_RULE
RFM_PSST_EXCLUDE Exclude from PSST Grouping Rule Determination CHAR 1 0 RFM_PSST_EXCLUDE

KNVV foreign key relationships

Table Field Check Table Check Field
0 KNVV AUFSD TVAST Sales Document Blocking Reasons: Texts MANDT
0 KNVV AUFSD TVAST Sales Document Blocking Reasons: Texts SPRAS
1 KNVV BZIRK T171 Customers: Sales Districts MANDT
1 KNVV BZIRK T171 Customers: Sales Districts BZIRK
0 KNVV FAKSD TVFS Billing: Reasons for Blocking FAKSP
1 KNVV FSH_GRSGY FSH_GRSG_W ARun allocation grouping strategy (possible values) MANDT
0 KNVV FSH_KVGR10 FSH_TVV10 Customer group 10 MANDT
0 KNVV FSH_KVGR10 FSH_TVV10 Customer group 10 VKORG
1 KNVV FSH_KVGR6 FSH_TVV6 Customer Group 6 MANDT
1 KNVV FSH_KVGR6 FSH_TVV6 Customer Group 6 VKORG
0 KNVV FSH_KVGR7 FSH_TVV7 Customer group 7 MANDT
0 KNVV FSH_KVGR7 FSH_TVV7 Customer group 7 VKORG
1 KNVV FSH_KVGR8 FSH_TVV8 Customer group 8 MANDT
1 KNVV FSH_KVGR8 FSH_TVV8 Customer group 8 VKORG
0 KNVV FSH_KVGR9 FSH_TVV9 Customer group 9 MANDT
0 KNVV FSH_KVGR9 FSH_TVV9 Customer group 9 VKORG
1 KNVV FSH_MSOCDC KNA1 General Data in Customer Master MANDT
1 KNVV FSH_MSOCDC KNA1 General Data in Customer Master KUNNR
0 KNVV FSH_RESGY FSH_RESG_W ARun Allocation Release Strategy (possible values) MANDT
1 KNVV FSH_SC_CID FSH_SC_VCIDS Customer- & material-IDs MANDT
1 KNVV FSH_SC_CID FSH_SC_VCIDS Customer- & material-IDs FSH_SC_IDT
1 KNVV FSH_SC_CID FSH_SC_VCIDS Customer- & material-IDs FSH_SC_ID
0 KNVV FSH_SS FSH_OSS Order Scheduling Strategies MANDT
0 KNVV FSH_SS FSH_OSS Order Scheduling Strategies FSH_SS
1 KNVV FSH_VAS_CG FSH_VAS_CG VAS Customer Group FSH_VAS_CG
0 KNVV INCO1 TINC Customers: Incoterms INCO1
1 KNVV INCOV TINCV Incoterms Versions MANDT
1 KNVV INCOV TINCV Incoterms Versions INCOV
0 KNVV KABSS T691P Customer payment guarantee procedure MANDT
0 KNVV KABSS T691P Customer payment guarantee procedure KABSS
1 KNVV KALKS TVKD Customer classification for pricing procedure determination MANDT
1 KNVV KALKS TVKD Customer classification for pricing procedure determination KALKS
0 KNVV KDGRP T151 Customers: Customer Groups MANDT
0 KNVV KDGRP T151 Customers: Customer Groups KDGRP
1 KNVV KKBER T014 Credit control areas KKBER
0 KNVV KONDA T188 Conditions: Groups for Customer Classifications MANDT
0 KNVV KONDA T188 Conditions: Groups for Customer Classifications KONDA
1 KNVV KTGRD TVKT Customers: Account Assignment Groups KTGRD
0 KNVV KUNNR KNA1 General Data in Customer Master MANDT
0 KNVV KUNNR KNA1 General Data in Customer Master KUNNR
1 KNVV KURST TCURV Exchange rate types for currency translation MANDT
1 KNVV KURST TCURV Exchange rate types for currency translation KURST
0 KNVV KVGR1 TVV1 Customer Group 1 MANDT
0 KNVV KVGR1 TVV1 Customer Group 1 KVGR1
1 KNVV KVGR2 TVV2 Customer Group 2 MANDT
1 KNVV KVGR2 TVV2 Customer Group 2 KVGR2
0 KNVV KVGR3 TVV3 Customer Group 3 KVGR3
1 KNVV KVGR4 TVV4 Customer Group 4 MANDT
1 KNVV KVGR4 TVV4 Customer Group 4 KVGR4
0 KNVV KVGR5 TVV5 Customer Group 5 MANDT
0 KNVV KVGR5 TVV5 Customer Group 5 KVGR5
1 KNVV LIFSD TVLS Deliveries: Blocking Reasons/Criteria MANDT
1 KNVV LIFSD TVLS Deliveries: Blocking Reasons/Criteria LIFSP
0 KNVV LPRIO TPRIO Customers: Delivery Priorities LPRIO
1 KNVV MANDT T000 Clients MANDT
0 KNVV MEGRU TWMEG Unit of measure group MANDT
0 KNVV MEGRU TWMEG Unit of measure group MEGRU
0 KNVV MEGRU TWMEG Unit of measure group MEINS
1 KNVV PLTYP T189 Conditions: Price List Types MANDT
1 KNVV PLTYP T189 Conditions: Price List Types PLTYP
0 KNVV PVKSM TPVD Product Proposal: Definition of Customer Procedure PVKSM
1 KNVV SPART TSPA Organizational Unit: Sales Divisions MANDT
1 KNVV SPART TSPA Organizational Unit: Sales Divisions SPART
0 KNVV VERSG TVSD Customers: Statistics groups MANDT
1 KNVV VKBUR TVBUR Organizational Unit: Sales Offices MANDT
0 KNVV VKGRP TVBVK Organizational Unit: Sales Groups per Sales Office MANDT
1 KNVV VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 KNVV VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 KNVV VSBED TVSB Shipping Conditions MANDT
0 KNVV VSBED TVSB Shipping Conditions VSBED
1 KNVV VTWEG TVTW Organizational Unit: Distribution Channels MANDT
1 KNVV VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
0 KNVV VWERK TVKWZ Org.Unit: Allowed Plants per Sales Organization VKORG
0 KNVV VWERK TVKWZ Org.Unit: Allowed Plants per Sales Organization VTWEG
0 KNVV VWERK TVKWZ Org.Unit: Allowed Plants per Sales Organization WERKS
1 KNVV WAERS TCURC Currency Codes MANDT
1 KNVV WAERS TCURC Currency Codes WAERS