SAP ABAP Table KONDNVB (Free goods determination - Posting structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ AP-PRC-PR (Application Component) Pricing
     ⤷ VKON (Package) Application development R/3 conditions

Basic Data

Table Category	INTTAB	Structure
Structure	KONDNVB	Table Relationship Diagram
Short Description	Free goods determination - Posting structure

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	.INCLUDE	☐				0	0	Conditions: Free goods - Data section
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	KNUMH	☐	KNUMH	KNUMB	CHAR	10	0	Condition record number
4	KNRMM	☐	KNRMM	MENG13	QUAN	13	3	Minimum quantity
5	KNRNM	☐	KNRNM	MENG13	QUAN	13	3	Free goods quantity
6	KNRME	☐	KNRME	MEINS	UNIT	3	0	Quantity unit for minimum quantity and free goods quantity	T006
7	KNRZM	☐	KNRZM	MENG13	QUAN	13	3	Additional quantity for free goods
8	KNREZ	☐	KNREZ	MEINS	UNIT	3	0	Quantity unit for free goods additional quantity	T006
9	KNRMAT	☐	KNRMAT	MATNR	CHAR	18	0	Additional material for free goods	MARA
10	KNRRR	☐	KNRRR	KOFRM	NUMC	3	0	Calculation type for determining free goods quantity
11	KNRDD	☐	KNRDD	KNRDD	CHAR	1	0	Free goods category
12	KNR_PI	☐	KNUMA_PI	KNUMA	CHAR	10	0	Promotion	KONA
13	KNR_AG	☐	KNUMA_AG	KNUMA	CHAR	10	0	Sales deal	KONA
14	KNR_SQ	☐	KNUMA_SQ	KNUMA	CHAR	10	0	Sales quote	KONA
15	KNR_AK	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
16	KVEWE	☐	KVEWE	KVEWE	CHAR	1	0	Usage of the Condition Table	T681V
17	KOTABNR	☐	KOTABNR	KOTABNR	NUMC	3	0	Condition table	T681
18	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
19	KSCHL	☐	KSCHN	KSCHL	CHAR	4	0	Discount type	T685
20	VAKEY	☐	VAKEY	VAKEY	CHAR	100	0	Variable key 100 bytes
21	LSTANR	☐	LSTANR	STATVNR	CHAR	1	0	Free goods delivery control
22	.INCLUDE	☐				0	0	Bonus Buys: Include KONDN
23	BBYNR	☐	BBYNR	BBYNR	CHAR	12	0	Bonus buy	KONBBYH
24	BBYTYPE	☐	BBYTYPE	BBYTYPE	CHAR	1	0	Bonus buy type
25	BBYPER	☐	BBYPER	DEC3_3	DEC	6	3	Bonus buy condition value (percentage)
26	BBYVAL	☐	BBYVAL	WERT8	CURR	15	2	Bonus buy condition value (fixed)
27	BBYCUR	☐	BBYCUR	WAERS	CUKY	5	0	Currency of bonus buy condition	TCURC
28	BBYREQNR	☐	REQNR	BEDNG	NUMC	3	0	Requirement number
29	BBYRQMIN	☐	BBYRQMIN	WERT8	CURR	15	2	Bonus buy requirement: miminum value
30	BBYRQMAX	☐	BBYRQMAX	WERT8	CURR	15	2	Bonus buy requirement: maximum value
31	BBYCUSCARD	☐	BBYCUSCARD	CHAR25	CHAR	25	0	Bonus buy requirement: customer card
32	BBYSCALETYPE	☐	KZBZG	KZBZG	CHAR	1	0	Indicator: Scale Base Type
33	BBYRQCUR	☐	BBYCUR2	WAERS	CUKY	5	0	Bonus Buy Currency	*
34	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	KONDNVB	BBYCUR	TCURC	WAERS	REF	1	CN
2	KONDNVB	BBYNR	KONBBYH	BBYNR	REF	1	CN
3	KONDNVB	KAPPL	T681A	KAPPL	KEY	1	1
4	KONDNVB	KNREZ	T006	MSEHI	KEY	1	CN
5	KONDNVB	KNRMAT	MARA	MATNR	KEY	1	CN
6	KONDNVB	KNRME	T006	MSEHI	KEY	1	CN
7	KONDNVB	KNR_AG	KONA	KNUMA	REF	C	CN
8	KONDNVB	KNR_AK	WAKH	AKTNR	REF	C	CN
9	KONDNVB	KNR_PI	KONA	KNUMA	REF	C	CN
10	KONDNVB	KNR_SQ	KONA	KNUMA	REF	C	CN
11	KONDNVB	KOTABNR	T681	KOTABNR	KEY	1	1
12	KONDNVB	KSCHL	T685	KSCHL
13	KONDNVB	KVEWE	T681V	KVEWE	KEY	1	1
14	KONDNVB	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20100310
SAP Release Created in