KNVV SAP (Customer Master Sales Data) Table details

Dictionary Type: Table
Description: Customer Master Sales Data




ABAP Code to SELECT data from KNVV
Related tables to KNVV
Access table KNVV




Table field list including key, data, relationships and ABAP select examples

KNVV is a standard SAP Table which is used to store Customer Master Sales Data data and is available within R/3 SAP systems depending on the version and release level.

The KNVV table consists of various fields, each holding specific information or linking keys about Customer Master Sales Data data available in SAP. These include KUNNR (Customer Numbers), VKORG (Sales Organization), VTWEG (Distribution Channel), SPART (Division).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP KNVV table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
KUNNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
BEGRUAuthorization Group BEGRUCHAR4BEGRU
LOEVMDeletion flag for customer (sales level) LOEVM_VCHAR1XFELD
VERSGCustomer Statistics Group STGKUCHAR1TVSDSTGKU
AUFSDCustomer order block (sales area) AUFSD_VCHAR2TVASTKAUFS
KALKSPricing procedure assigned to this customer KALKSCHAR1TVKDKALKS
KDGRPCustomer group KDGRPCHAR2T151KDGRPVKD
BZIRKSales district BZIRKCHAR6T171BZIRKBZI
KONDAPrice group (customer) KONDACHAR2T188KONDAVKA
PLTYPPrice list type PLTYPCHAR2T189PLTYPVPL
AWAHROrder probability of the item AWAHRNUMC3AWAHR
INCO1Incoterms (Part 1) INCO1CHAR3TINCINCO1
INCO2Incoterms (Part 2) INCO2CHAR28INCO2
LIFSDCustomer delivery block (sales area) LIFSD_VCHAR2TVLSLIFSP
AUTLFComplete delivery defined for each sales order? AUTLFCHAR1XFELD
ANTLFMaximum Number of Partial Deliveries Allowed Per Item ANTLFDEC1ANTLF
KZTLFPartial delivery at item level KZTLFCHAR1KZTLF
KZAZUOrder Combination Indicator KZAZU_DCHAR1XFELD
CHSPLBatch split allowed CHSPLCHAR1XFELD
LPRIODelivery Priority LPRIONUMC2TPRIOLPRIO
EIKTOShipper's (Our) Account Number at the Customer or Vendor EIKTOCHAR12CHAR12
VSBEDShipping Conditions VSBEDCHAR2TVSBVSBED
FAKSDBilling block for customer (sales and distribution) FAKSD_VCHAR2TVFSFAKSP
MRNKZManual invoice maintenance MRNKZCHAR1XFELD
PERFKInvoice dates (calendar identification) PERFKCHAR2TFACDWFCID
PERRLInvoice list schedule (calendar identification) PERRLCHAR2TFACDWFCID
KVAKZCost estimate indicator (inactive) KVAKZCHAR1XFELD
KVAWTValue limit for cost estimate (inactive) KVAWTCURR13(2) WERT7
WAERSCurrency WAERS_V02DCUKY5TCURCWAERS
KLABCCustomer classification (ABC analysis) KLABCCHAR2KLABC
KTGRDAccount assignment group for this customer KTGRDCHAR2TVKTKTGRD
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
VWERKDelivering Plant (Own or External) DWERK_EXTCHAR4TVKWZWERKSSH_DWERK_EXTS
VKGRPSales Group VKGRPCHAR3TVBVKVKGRPVKG
VKBURSales Office VKBURCHAR4TVBURVKBURVKB
VSORTItem proposal VSORTCHAR10VBUKALPHAVBELN
KVGR1Customer group 1 KVGR1CHAR3TVV1KVGR1
KVGR2Customer group 2 KVGR2CHAR3TVV2KVGR2
KVGR3Customer group 3 KVGR3CHAR3TVV3KVGR3
KVGR4Customer group 4 KVGR4CHAR3TVV4KVGR4
KVGR5Customer group 5 KVGR5CHAR3TVV5KVGR5
BOKREIndicator: Customer Is Rebate-Relevant BOKRECHAR1XFELD
BOIDTStart of validity per.for the rebate index for the customer BOIDTDATS8DATUM
KURSTExchange Rate Type KURSTCHAR4TCURVKURSTKUT
PRFRERelevant for price determination ID PRFRECHAR1XFELD
PRAT1ID for product attribute 1 KUAT1CHAR1PRATK
PRAT2ID for product attribute 2 KUAT2CHAR1PRATK
PRAT3ID for product attribute 3 KUAT3CHAR1PRATK
PRAT4ID for product attribute 4 KUAT4CHAR1PRATK
PRAT5ID for product attribute 5 KUAT5CHAR1PRATK
PRAT6ID for product attribute 6 KUAT6CHAR1PRATK
PRAT7ID for product attribute 7 KUAT7CHAR1PRATK
PRAT8ID for product attribute 8 KUAT8CHAR1PRATK
PRAT9ID for product attribute 9 KUAT9CHAR1PRATK
PRATAID for product attribute 10 KUATACHAR1PRATK
KABSSCustomer payment guarantee procedure KABSSCH_CMCHAR4T691PKABSSCH_CM
KKBERCredit control area KKBERCHAR4T014KKBERKKB
CASSDSales block for customer (sales area) CASSD_VCHAR2CASSP
RDOFFSwitch off rounding? RDOFFCHAR1XFELD
AGRELIndicator: Relevant for agency business AGRELCHAR1XFELD
MEGRUUnit of Measure Group MEGRUCHAR4TWMEGMEGRU
UEBTOOverdelivery Tolerance Limit UEBTODEC3(1) PRZ21
UNTTOUnderdelivery Tolerance Limit UNTTODEC3(1) PRZ21
UEBTKUnlimited overdelivery allowed UEBTK_VCHAR1XFELD
PVKSMCustomer procedure for product proposal PVKSMCHAR2TPVDPVKSM
PODKZRelevant for POD processing PODKZCHAR1XFELD
PODTGTimeframe for Confirmation of POD PODTGDEC11TSTRGTSTRDURAG
BLINDIndex Structure Active for Subsequent Settlement (in AB) BLIND_SDCHAR1XFELD
CARRIER_NOTIFCarrier is to be notified /SPE/CARRIER_NOTIFCHAR1XFELD
.INCLU--AP 0
/BEV1/EMLGPFANDDeposit on Empties /BEV1/EMGPFANDCHAR1/BEV1/EMGPFAND
/BEV1/EMLGFORTSIndicator for Empties Update /BEV1/EMGFORTSCHAR1/BEV1/EMGFORTS
.INCLU--AP 0
J_1NBOESLExchange Key for NF Processing /NFM/BOESLCHAR3/NFM/TBOESL/NFM/BOESL
.INCLU--AP 0
PROFILEDRM profile /SAPHT/DRM_PROFILECHAR4/SAPHT/DRM_PRF/SAPHT/DRM_PROFILE
.INCLU--AP 0
FPARTBilling/Invoicing Plan Type FPARTCHAR2TFPLAFPART
.INCLU--AP 0
/XLSO/CUST_DISRate (condition amount or percentage) where no scale exists KBETR_KONDCURR11(2) WERTV6
/XLSO/COMP_NAMEName 1 NAME1_GPCHAR35NAME
/XLSO/INDUSTRYIndustry key BRSCHCHAR4Assigned to domainBRSCH
/XLSO/H_NUMBERHouse Number AD_HSNM1CHAR10TEXT10
/XLSO/STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
/XLSO/POST_CODEPostal Code PSTLZCHAR10PSTLZ
/XLSO/CITYCity ORT01_GPCHAR35TEXT35
/XLSO/REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
/XLSO/COUNTRYCountry Key LAND1_GPCHAR3Assigned to domainLAND1C_LAND1
/XLSO/INACTIVESingle-Character Indicator CHAR1CHAR1CHAR1

Key field Non-key field



How do I retrieve data from SAP table KNVV using ABAP code

The following ABAP code Example will allow you to do a basic selection on KNVV to SELECT all data from the table
DATA: WA_KNVV TYPE KNVV.

SELECT SINGLE *
FROM KNVV
INTO CORRESPONDING FIELDS OF WA_KNVV
WHERE...

How to access SAP table KNVV

Within an ECC or HANA version of SAP you can also view further information about KNVV and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!