SAP ABAP Table CMDS_KNVV_S (Customer Master Sales Data)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-MD-BP-CM (Application Component) Customer Master
     ⤷ CMD_INTERFACE (Package) Customer Interface

Basic Data

Table Category	INTTAB	Structure
Structure	CMDS_KNVV_S	Table Relationship Diagram
Short Description	Customer Master Sales Data

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	OLD_DATA	☐	KNVV		STRU	0	0
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
3	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number
4	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization
5	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel
6	SPART	☐	SPART	SPART	CHAR	2	0	Division
7	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
8	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
9	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
10	LOEVM	☐	LOEVM_V	XFELD	CHAR	1	0	Deletion flag for customer (sales level)
11	VERSG	☐	STGKU	STGKU	CHAR	1	0	Customer Statistics Group
12	AUFSD	☐	AUFSD_V	KAUFS	CHAR	2	0	Customer order block (sales area)
13	KALKS	☐	KALKS	KALKS	CHAR	1	0	Pricing procedure assigned to this customer
14	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group
15	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district
16	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)
17	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type
18	AWAHR	☐	AWAHR	AWAHR	NUMC	3	0	Order probability of the item
19	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)
20	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
21	LIFSD	☐	LIFSD_V	LIFSP	CHAR	2	0	Customer delivery block (sales area)
22	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
23	ANTLF	☐	ANTLF	ANTLF	DEC	1	0	Maximum number of partial deliveries allowed per item
24	KZTLF	☐	KZTLF	KZTLF	CHAR	1	0	Partial delivery at item level
25	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
26	CHSPL	☐	CHSPL	XFELD	CHAR	1	0	Batch split allowed
27	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority
28	EIKTO	☐	EIKTO	CHAR12	CHAR	12	0	Shipper's (Our) Account Number at the Customer or Vendor
29	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions
30	FAKSD	☐	FAKSD_V	FAKSP	CHAR	2	0	Billing block for customer (sales and distribution)
31	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
32	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)
33	PERRL	☐	PERRL	WFCID	CHAR	2	0	Invoice list schedule (calendar identification)
34	KVAKZ	☐	KVAKZ	XFELD	CHAR	1	0	Cost estimate indicator (inactive)
35	KVAWT	☐	KVAWT	WERT7	CURR	13	2	Value limit for cost estimate (inactive)
36	WAERS	☐	WAERS_V02D	WAERS	CUKY	5	0	Currency
37	KLABC	☐	KLABC	KLABC	CHAR	2	0	Customer classification (ABC analysis)
38	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer
39	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
40	VWERK	☐	DWERK_EXT	WERKS	CHAR	4	0	Delivering Plant (Own or External)
41	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group
42	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office
43	VSORT	☐	VSORT	VBELN	CHAR	10	0	Item proposal
44	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1
45	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2
46	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3
47	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4
48	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5
49	BOKRE	☐	BOKRE	XFELD	CHAR	1	0	ID: Customer is to receive rebates
50	BOIDT	☐	BOIDT	DATUM	DATS	8	0	Start of validity per.for the rebate index for the customer
51	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type
52	PRFRE	☐	PRFRE	XFELD	CHAR	1	0	Relevant for Pricing ID
53	PRAT1	☐	KUAT1	PRATK	CHAR	1	0	ID for product attribute 1
54	PRAT2	☐	KUAT2	PRATK	CHAR	1	0	ID for product attribute 2
55	PRAT3	☐	KUAT3	PRATK	CHAR	1	0	ID for product attribute 3
56	PRAT4	☐	KUAT4	PRATK	CHAR	1	0	ID for product attribute 4
57	PRAT5	☐	KUAT5	PRATK	CHAR	1	0	ID for product attribute 5
58	PRAT6	☐	KUAT6	PRATK	CHAR	1	0	ID for product attribute 6
59	PRAT7	☐	KUAT7	PRATK	CHAR	1	0	ID for product attribute 7
60	PRAT8	☐	KUAT8	PRATK	CHAR	1	0	ID for product attribute 8
61	PRAT9	☐	KUAT9	PRATK	CHAR	1	0	ID for product attribute 9
62	PRATA	☐	KUATA	PRATK	CHAR	1	0	ID for product attribute 10
63	KABSS	☐	KABSSCH_CM	KABSSCH_CM	CHAR	4	0	Customer payment guarantee procedure
64	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area
65	CASSD	☐	CASSD_V	CASSP	CHAR	2	0	Sales block for customer (sales area)
66	RDOFF	☐	RDOFF	XFELD	CHAR	1	0	Switch off rounding?
67	AGREL	☐	AGREL	XFELD	CHAR	1	0	Indicator: Relevant for agency business
68	MEGRU	☐	MEGRU	MEGRU	CHAR	4	0	Unit of Measure Group
69	UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
70	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
71	UEBTK	☐	UEBTK_V	XFELD	CHAR	1	0	Unlimited overdelivery allowed
72	PVKSM	☐	PVKSM	PVKSM	CHAR	2	0	Customer procedure for product proposal
73	PODKZ	☐	PODKZ	XFELD	CHAR	1	0	Relevant for POD processing
74	PODTG	☐	PODTG	TSTRDURAG	DEC	11	0	Timeframe for Confirmation of POD
75	BLIND	☐	BLIND_SD	XFELD	CHAR	1	0	Index Structure Active for Subsequent Settlement (in AB)
76	CARRIER_NOTIF	☐	/SPE/CARRIER_NOTIF	XFELD	CHAR	1	0	Carrier is to be notified
77	.INCLU--AP	☐				0	0	Append for Empties
78	.INCLUDE	☐				0	0	Include for Empties
79	/BEV1/EMLGPFAND	☐	/BEV1/EMGPFAND	/BEV1/EMGPFAND	CHAR	1	0	Deposit on Empties
80	/BEV1/EMLGFORTS	☐	/BEV1/EMGFORTS	/BEV1/EMGFORTS	CHAR	1	0	Indicator for Empties Update
81	NEW_DATA	☐	KNVV		STRU	0	0
82	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
83	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number
84	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization
85	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel
86	SPART	☐	SPART	SPART	CHAR	2	0	Division
87	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
88	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
89	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
90	LOEVM	☐	LOEVM_V	XFELD	CHAR	1	0	Deletion flag for customer (sales level)
91	VERSG	☐	STGKU	STGKU	CHAR	1	0	Customer Statistics Group
92	AUFSD	☐	AUFSD_V	KAUFS	CHAR	2	0	Customer order block (sales area)
93	KALKS	☐	KALKS	KALKS	CHAR	1	0	Pricing procedure assigned to this customer
94	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group
95	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district
96	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)
97	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type
98	AWAHR	☐	AWAHR	AWAHR	NUMC	3	0	Order probability of the item
99	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)
100	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
101	LIFSD	☐	LIFSD_V	LIFSP	CHAR	2	0	Customer delivery block (sales area)
102	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
103	ANTLF	☐	ANTLF	ANTLF	DEC	1	0	Maximum number of partial deliveries allowed per item
104	KZTLF	☐	KZTLF	KZTLF	CHAR	1	0	Partial delivery at item level
105	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
106	CHSPL	☐	CHSPL	XFELD	CHAR	1	0	Batch split allowed
107	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority
108	EIKTO	☐	EIKTO	CHAR12	CHAR	12	0	Shipper's (Our) Account Number at the Customer or Vendor
109	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions
110	FAKSD	☐	FAKSD_V	FAKSP	CHAR	2	0	Billing block for customer (sales and distribution)
111	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
112	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)
113	PERRL	☐	PERRL	WFCID	CHAR	2	0	Invoice list schedule (calendar identification)
114	KVAKZ	☐	KVAKZ	XFELD	CHAR	1	0	Cost estimate indicator (inactive)
115	KVAWT	☐	KVAWT	WERT7	CURR	13	2	Value limit for cost estimate (inactive)
116	WAERS	☐	WAERS_V02D	WAERS	CUKY	5	0	Currency
117	KLABC	☐	KLABC	KLABC	CHAR	2	0	Customer classification (ABC analysis)
118	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer
119	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
120	VWERK	☐	DWERK_EXT	WERKS	CHAR	4	0	Delivering Plant (Own or External)
121	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group
122	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office
123	VSORT	☐	VSORT	VBELN	CHAR	10	0	Item proposal
124	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1
125	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2
126	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3
127	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4
128	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5
129	BOKRE	☐	BOKRE	XFELD	CHAR	1	0	ID: Customer is to receive rebates
130	BOIDT	☐	BOIDT	DATUM	DATS	8	0	Start of validity per.for the rebate index for the customer
131	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type
132	PRFRE	☐	PRFRE	XFELD	CHAR	1	0	Relevant for Pricing ID
133	PRAT1	☐	KUAT1	PRATK	CHAR	1	0	ID for product attribute 1
134	PRAT2	☐	KUAT2	PRATK	CHAR	1	0	ID for product attribute 2
135	PRAT3	☐	KUAT3	PRATK	CHAR	1	0	ID for product attribute 3
136	PRAT4	☐	KUAT4	PRATK	CHAR	1	0	ID for product attribute 4
137	PRAT5	☐	KUAT5	PRATK	CHAR	1	0	ID for product attribute 5
138	PRAT6	☐	KUAT6	PRATK	CHAR	1	0	ID for product attribute 6
139	PRAT7	☐	KUAT7	PRATK	CHAR	1	0	ID for product attribute 7
140	PRAT8	☐	KUAT8	PRATK	CHAR	1	0	ID for product attribute 8
141	PRAT9	☐	KUAT9	PRATK	CHAR	1	0	ID for product attribute 9
142	PRATA	☐	KUATA	PRATK	CHAR	1	0	ID for product attribute 10
143	KABSS	☐	KABSSCH_CM	KABSSCH_CM	CHAR	4	0	Customer payment guarantee procedure
144	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area
145	CASSD	☐	CASSD_V	CASSP	CHAR	2	0	Sales block for customer (sales area)
146	RDOFF	☐	RDOFF	XFELD	CHAR	1	0	Switch off rounding?
147	AGREL	☐	AGREL	XFELD	CHAR	1	0	Indicator: Relevant for agency business
148	MEGRU	☐	MEGRU	MEGRU	CHAR	4	0	Unit of Measure Group
149	UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
150	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
151	UEBTK	☐	UEBTK_V	XFELD	CHAR	1	0	Unlimited overdelivery allowed
152	PVKSM	☐	PVKSM	PVKSM	CHAR	2	0	Customer procedure for product proposal
153	PODKZ	☐	PODKZ	XFELD	CHAR	1	0	Relevant for POD processing
154	PODTG	☐	PODTG	TSTRDURAG	DEC	11	0	Timeframe for Confirmation of POD
155	BLIND	☐	BLIND_SD	XFELD	CHAR	1	0	Index Structure Active for Subsequent Settlement (in AB)
156	CARRIER_NOTIF	☐	/SPE/CARRIER_NOTIF	XFELD	CHAR	1	0	Carrier is to be notified
157	.INCLU--AP	☐				0	0	Append for Empties
158	.INCLUDE	☐				0	0	Include for Empties
159	/BEV1/EMLGPFAND	☐	/BEV1/EMGPFAND	/BEV1/EMGPFAND	CHAR	1	0	Deposit on Empties
160	/BEV1/EMLGFORTS	☐	/BEV1/EMGFORTS	/BEV1/EMGFORTS	CHAR	1	0	Indicator for Empties Update
161	UPD	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

History

Last changed by/on	SAP	20110901
SAP Release Created in	600