1. Home
  2. Resources
  3. SAP Tables
  4. KONDN - Conditions: Free goods - Data section

SAP Table KONDN

Conditions: Free goods - Data section

KONDN (Conditions: Free goods - Data section) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link KONDN to other SAP tables.

KONDN table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KNUMH Condition record number KNUMH CHAR 10 0
KNRMM Minimum quantity KNRMM QUAN 13 3
KNRNM Free goods quantity KNRNM QUAN 13 3
KNRME Quantity unit for minimum quantity and free goods quantity KNRME T006 UNIT 3 0
KNRZM Additional quantity for free goods KNRZM QUAN 13 3
KNREZ Quantity unit for free goods additional quantity KNREZ T006 UNIT 3 0
KNRMAT Additional material for free goods KNRMAT MARA CHAR 18 0
KNRRR Calculation type for determining free goods quantity KNRRR NUMC 3 0
KNRDD Free goods category KNRDD CHAR 1 0
1 Inclusive rebate (with item generation)
2 Exclusive
3 Inclusive rebate (w/o item generation; only for sales)
KNR_PI Promotion KNUMA_PI KONA CHAR 10 0
KNR_AG Sales deal KNUMA_AG KONA CHAR 10 0
KNR_SQ Sales quote KNUMA_SQ KONA CHAR 10 0
KNR_AK Promotion WAKTION WAKH CHAR 10 0
KVEWE Usage of the condition table KVEWE T681V CHAR 1 0
KOTABNR Condition table KOTABNR T681 NUMC 3 0
KAPPL Application KAPPL T681A CHAR 2 0
KSCHL Discount type KSCHN T685 CHAR 4 0
VAKEY Variable key 100 bytes VAKEY CHAR 100 0
LSTANR Free goods delivery control LSTANR CHAR 1 0
NULL Delivery takes place regardless of main item
A Delivery only if main item is partially delivered
B Delivery only if main item is fully delivered
C Delivery if main item is part. delivered, only with main itm
E Delivery proportional to quantity in main item
BBYNR Bonus buy BBYNR KONBBYH CHAR 12 0
BBYTYPE Bonus buy type BBYTYPE CHAR 1 0
P Price
R Fixed discount
% Percentage discount
N Free-goods discount
BBYPER Bonus buy condition value (percentage) BBYPER DEC 6 3
BBYVAL Bonus buy condition value (fixed) BBYVAL CURR 15 2
BBYCUR Currency of bonus buy condition BBYCUR TCURC CUKY 5 0
BBYREQNR Requirement number REQNR NUMC 3 0
BBYRQMIN Bonus buy requirement: miminum value BBYRQMIN CURR 15 2
BBYRQMAX Bonus buy requirement: maximum value BBYRQMAX CURR 15 2
BBYCUSCARD Bonus buy requirement: customer card BBYCUSCARD CHAR 25 0
BBYSCALETYPE Scale basis indicator KZBZG CHAR 1 0
B Value scale
C Quantity scale
D Gross weight scale
E Net weight scale
F Volume scale
G Scale based on a formula
L Point scale
M Time period scale - Month
N Time period scale - Years
O Time period scale - Days
P Time period scale - Week
R Distance
S Number of shipping units
T reserved (IS-OIL, time prices)
X reserved (IS-OIL, day prices)
BBYRQCUR Bonus Buy Currency BBYCUR2 CUKY 5 0
GRPNR Material grouping GRPGNR CHAR 12 0
BGINT Internal Class Number CLINT NUMC 10 0
KPEIN Condition pricing unit KPEIN DEC 5 0
KMEIN Condition unit KMEIN UNIT 3 0
MQUAN Material Quantity MATQUAN QUAN 10 3
VRKME Sales unit VRKME UNIT 3 0
STFKZ Scale Type line item bonus buy RDM_BBY_STFKZ CHAR 1 0
A From
B Up To
C Equal
SUMFLAG Indicates number as total SUMFLAG CHAR 1 0
X Yes
NULL No
REWREF Bonus Buy - Condition Reference RDM_BBY_REWREF CHAR 1 0
1 Get Total
2 Get Line Item
3 Get Override
5 Buy Line Item
STPLGR Status of Plant Group within Bonus Buy RDM_BBY_STPLGR CHAR 1 0
1 Existing in Classification System
2 Generated out of Classification System
3 Created Manually
FILGR Class number KLASSE_D CHAR 18 0
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
STGRP Status Material Grouping within Bonus Buy RDM_BBY_MATGRP_STATUS CHAR 1 0
1 Existing Material Grouping
2 Generated out of Material Grouping
3 Created Manually

KONDN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
KONDN BBYCUR KONDN MANDT TCURC Currency Codes MANDT
KONDN BBYCUR KONDN BBYCUR TCURC Currency Codes WAERS
KONDN BBYNR KONDN MANDT KONBBYH Bonus Buys: Header MANDT
KONDN BBYNR KONDN BBYNR KONBBYH Bonus Buys: Header BBYNR
KONDN KAPPL KONDN KAPPL T681A Conditions: Applications KAPPL
KONDN KNREZ KONDN MANDT T006 Units of Measurement MANDT
KONDN KNREZ KONDN KNREZ T006 Units of Measurement MSEHI
KONDN KNRMAT KONDN MANDT MARA General Material Data MANDT
KONDN KNRMAT KONDN KNRMAT MARA General Material Data MATNR
KONDN KNRME KONDN MANDT T006 Units of Measurement MANDT
KONDN KNRME KONDN KNRME T006 Units of Measurement MSEHI
KONDN KNR_AG KONDN MANDT KONA Agreements MANDT
KONDN KNR_AG KONDN KNR_AG KONA Agreements KNUMA
KONDN KNR_AK KONDN MANDT WAKH Promotion Header Data, IS-R MANDT
KONDN KNR_AK KONDN KNR_AK WAKH Promotion Header Data, IS-R AKTNR
KONDN KNR_PI KONDN MANDT KONA Agreements MANDT
KONDN KNR_PI KONDN KNR_PI KONA Agreements KNUMA
KONDN KNR_SQ KONDN MANDT KONA Agreements MANDT
KONDN KNR_SQ KONDN KNR_SQ KONA Agreements KNUMA
KONDN KOTABNR KONDN KOTABNR T681 Conditions: Structures KOTABNR
KONDN KOTABNR KONDN KVEWE T681 Conditions: Structures KVEWE
KONDN KSCHL KONDN KSCHL T685 Conditions: Types KSCHL
KONDN KSCHL KONDN MANDT T685 Conditions: Types MANDT
KONDN KSCHL 'N' T685 Conditions: Types KVEWE
KONDN KSCHL KONDN KAPPL T685 Conditions: Types KAPPL
KONDN KVEWE KONDN KVEWE T681V Conditions: Usages KVEWE
KONDN MANDT KONDN MANDT T000 Clients MANDT