KNVV - Customer Master Sales Data

Customer Master Sales Data information is stored in SAP table KNVV.
It is part of development package VS in software component LO-MD-BP-CM. This development package consists of objects that can be grouped under "Application development R/3 sales master data".

Fields for table KNVV

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