KONA - Agreements

Agreements information is stored in SAP table KONA.
It is part of development package VKON in software component SD-MD-CM. This development package consists of objects that can be grouped under "Application development Conditions".

Fields for table KONA

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
KNUMA	Agreement (various conditions grouped together)	X	KNUMA	CHAR	20
VKORG	Sales Organization		VKORG	CHAR	8	TVKO
VTWEG	Distribution Channel		VTWEG	CHAR	4	TVKOV
SPART	Division		SPART	CHAR	4	TVTA
VKBUR	Sales office		VKBUR	CHAR	8	TVKBZ
VKGRP	Sales group		VKGRP	CHAR	6	TVBVK
BOART	Agreement type		BOART	CHAR	8	T6B1
ABTYP	Category of the rebate agreement		BOABTYP	CHAR	2
KAPPL	Application		KAPPL	CHAR	4	T681A
ERNAM	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
ERDAT	Date on which the record was created		ERDAT	DATS	16
ERZET	Entry time		ERZET	TIMS	12
AENAM	Name of Person Who Changed Object		AENAM	CHAR	24
AEDAT	Last Changed On		AEDAT	DATS	16
AEZET	Time last change was made		AEZET	TIMS	12
BONEM	Rebate recipient		BONEM	CHAR	20	KNA1
WAERS	Currency Key		WAERS	CUKY	10	TCURC
MAXBO	Maximum rebate (not used)		MAXBO	CURR	7
ABREX	External description for agreement		ABREX	CHAR	40
EKORG	Purchasing organization		EKORG	CHAR	8	T024E
BOLIF	Condition granter		BOGEW	CHAR	20	LFA1
ABSPZ	Scope of verification level of rebate agreement		ABSPZ	CHAR	2
BOSTA	Status of the agreement		BOSTA	CHAR	2
DATAB	Agreement valid-from date		ABDATAB	DATS	16
DATBI	Agreement valid-to date		ABDATBI	DATS	16
KOBOG	Condition Type/Table Group		KOBOG	CHAR	8	T6B2
BOTEXT	Description of agreement (e.g. sales deal, promotion)		BOTEXT	CHAR	80
VALTG	Additional Value Days		VALTG	NUMC	4
VALDT	Fixed Value Date		VALDT	DATS	16
UKNUMA	Higher-level agreement		KNUMA_UEB	CHAR	20	KONA
IDENT1	Settlement calendar for rebate arrangements		WFCID1	CHAR	4	TFACD
IDENT2	Arrangement calendar for rebate arrangements		WFCID2	CHAR	4	TFACD
UMNAM	Person responsible for BVol. comparison f. final settlement		UMNAM	CHAR	24
UMSDA	Date of last business volume comparison for final settlement		UMSDA	DATS	16
UMSAE	Business volume comparison required for final settlement		UMSAEF	CHAR	2
EKGRP	Purchasing Group		EKGRP	CHAR	6	T024
AKTNR	Promotion		WAKTION	CHAR	20	WAKH
ABEIN	Scope of statem. f. rebate arr. (Purchasing) -no longer used		ABEIN	CHAR	2
BUKRS	Company code for subsequent settlement		BUKRS_AB	CHAR	8	T001
VKNUMA	Preceding arrangement for automatic renewal		KNUMA_VOR	CHAR	20	KONA
FORZP	Subsequent settlement: time of LIS update		FORZP	CHAR	2
FOART	Subsequent settlement: update type (scale/condition basis)		FOART_NA	CHAR	2
IDENT3	Settlement periods for agreements		WFCID3	CHAR	4	TFACD
ABPAR	Indicator for Type of Settlement Partner (Supplier/Customer)		WABPAR	CHAR	2
KFRST	Release Status		KFRST	CHAR	2
ANGRP	Trigger Group Message Determination		ANGRP	CHAR	4	TMAN2
ANBEDNFE	Trigger condition, message determination		ANBEDNFE	CHAR	8	TMAN3
NAUMF_ENAW	Default aggregation level "Detailed statement"		NAUMF_ENAW	CHAR	4	TMAB
NAUMF_SNAW	Default aggregation level "Statement of statistical data"		NAUMF_SNAW	CHAR	4	TMAB
NAUMF_ANAW	Default Summarization Level: "Statement of Settlement Docs"		NAUMF_ANAW	CHAR	4	TMAB
UMSAEP	Business volume comparison required for parital settlement		UMSAEP	CHAR	2
UMNAMP	Pers. responsible for last BVol. comparison, partial settlm.		UMNAMP	CHAR	24
UMSDAP	Date of last business vol. comparison for partial settlement		UMSDAP	DATS	16
.INCLU--AP				BON_ENH_KONA_A1	0
.INCLUDE				BON_ENH_S3	0
BON_ENH_VAKEY	Indicates Enhanced Rebate Settlement		BON_ENH_VAKEY	CHAR	2
BON_ENH_INDIRECT	Indicator for Indirect Settlement Types		BON_ENH_INDIRECT	CHAR	2
BON_ENH_PERIOD_S	Indicates Periodic Settlement		BON_ENH_PERIOD_S	CHAR	2
.INCLU--AP				BON_ENH_KONA_A2	0
.INCLUDE				BON_ENH_S5	0
BON_ENH_CTYP	Contract Type		RANTYP	CHAR	2
BON_ENH_CNO	Contract Number		RANL	CHAR	26
BON_ENH_TTYP	Flow Type		SBEWART	CHAR	8	*