SAP Table KONA
Agreements
KONA (Agreements) 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 KONA to other SAP tables.
KONA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||||||||||||||||
|
KNUMA
Agreement (various conditions grouped together)
|
KNUMA |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||||||||
|
VKORG
Sales Organization
|
VKORG | TVKO |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
VTWEG
Distribution Channel
|
VTWEG | TVKOV |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||||||||
|
SPART
Division
|
SPART | TVTA |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||||||||
|
VKBUR
Sales Office
|
VKBUR | TVKBZ |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
VKGRP
Sales Group
|
VKGRP | TVBVK |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||||||||
|
BOART
Agreement type
|
BOART | T6B1 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
ABTYP
Category of the rebate agreement
|
BOABTYP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
KAPPL
Application
|
KAPPL | T681A |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||||||||
|
ERDAT
Date on Which Record Was Created
|
ERDAT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||||||
|
ERZET
Entry time
|
ERZET |
TIMS
|
6 | 0 | ||||||||||||||||||||||||||||||||||
|
AENAM
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||||||||
|
AEDAT
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||||||
|
AEZET
Time last change was made
|
AEZET |
TIMS
|
6 | 0 | ||||||||||||||||||||||||||||||||||
|
BONEM
Rebate recipient
|
BONEM | KNA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||||||||
|
WAERS
Currency Key
|
WAERS | TCURC |
CUKY
|
5 | 0 | |||||||||||||||||||||||||||||||||
|
MAXBO
Maximum rebate (not used)
|
MAXBO |
CURR
|
13 | 2 | ||||||||||||||||||||||||||||||||||
|
ABREX
External description for agreement
|
ABREX |
CHAR
|
20 | 0 | ||||||||||||||||||||||||||||||||||
|
EKORG
Purchasing Organization
|
EKORG | T024E |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
BOLIF
Condition granter
|
BOGEW | LFA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||||||||
|
ABSPZ
Scope of verification level of rebate agreement
|
ABSPZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
BOSTA
Status of the agreement
|
BOSTA |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
DATAB
Agreement valid-from date
|
ABDATAB |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||||||
|
DATBI
Agreement valid-to date
|
ABDATBI |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||||||
|
KOBOG
Condition type/table group for agreements
|
KOBOG | T6B2 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
BOTEXT
Description of agreement (e.g. sales deal, promotion)
|
BOTEXT |
CHAR
|
40 | 0 | ||||||||||||||||||||||||||||||||||
|
ZLSCH
Payment Method
|
DZLSCH | T042Z |
CHAR
|
1 | 0 | |||||||||||||||||||||||||||||||||
|
VALTG
Additional value days
|
VALTG |
NUMC
|
2 | 0 | ||||||||||||||||||||||||||||||||||
|
VALDT
Fixed value date
|
VALDT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||||||
|
ZTERM
Terms of Payment Key
|
DZTERM |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||||||||
|
UKNUMA
Higher-level agreement
|
KNUMA_UEB | KONA |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||||||||
|
IDENT1
Settlement calendar for rebate arrangements
|
WFCID1 | TFACD |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||||||||
|
IDENT2
Arrangement calendar for rebate arrangements
|
WFCID2 | TFACD |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||||||||
|
UMNAM
Person responsible for BVol. comparison f. final settlement
|
UMNAM |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||||||||
|
UMSDA
Date of last business volume comparison for final settlement
|
UMSDA |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||||||
|
UMSAE
Business volume comparison required for final settlement
|
UMSAEF |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
EKGRP
Purchasing Group
|
EKGRP | T024 |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||||||||
|
AKTNR
Promotion
|
WAKTION | WAKH |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||||||||
|
ABEIN
Scope of statem. f. rebate arr. (Purchasing) -no longer used
|
ABEIN |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
BUKRS
Company code for subsequent settlement
|
BUKRS_AB | T001 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
VKNUMA
Preceding arrangement for automatic renewal
|
KNUMA_VOR | KONA |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||||||||
|
FORZP
Subsequent settlement: time of LIS update
|
FORZP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
FOART
Subsequent settlement: update type (scale/condition basis)
|
FOART_NA |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
IDENT3
Settlement periods for agreements
|
WFCID3 | TFACD |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||||||||
|
ABPAR
Indicator for type of settlement partner (vendor/customer)
|
WABPAR |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
KFRST
Release status
|
KFRST |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
ANGRP
Trigger Group Message Determination
|
ANGRP | TMAN2 |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||||||||
|
ANBEDNFE
Trigger condition, message determination
|
ANBEDNFE | TMAN3 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
NAUMF_ENAW
Default aggregation level "Detailed statement"
|
NAUMF_ENAW | TMAB |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||||||||
|
NAUMF_SNAW
Default aggregation level "Statement of statistical data"
|
NAUMF_SNAW | TMAB |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||||||||
|
NAUMF_ANAW
Default Summarization Level: "Statement of Settlement Docs"
|
NAUMF_ANAW | TMAB |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||||||||
|
UMSAEP
Business volume comparison required for parital settlement
|
UMSAEP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
UMNAMP
Pers. responsible for last BVol. comparison, partial settlm.
|
UMNAMP |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||||||||
|
UMSDAP
Date of last business vol. comparison for partial settlement
|
UMSDAP |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||||||
|
/BEV1/RBRTT
Contract Type
|
RANTYP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
/BEV1/RBRTN
Contract Number
|
RANL |
CHAR
|
13 | 0 | ||||||||||||||||||||||||||||||||||
|
/BEV1/RBEWA
Flow Type
|
SBEWART |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||||||||
|
BON_ENH_VAKEY
Indicates Enhanced Rebate Settlement
|
BON_ENH_VAKEY |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
BON_ENH_INDIRECT
Indicator for Indirect Settlement Types
|
BON_ENH_INDIRECT |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
BON_ENH_PERIOD_S
Indicates Periodic Settlement
|
BON_ENH_PERIOD_S |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
BON_ENH_CTYP
Contract Type
|
RANTYP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
BON_ENH_CNO
Contract Number
|
RANL |
CHAR
|
13 | 0 | ||||||||||||||||||||||||||||||||||
|
BON_ENH_TTYP
Flow Type
|
SBEWART |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||||||||
KONA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| KONA | AKTNR | KONA | MANDT |
WAKH
Promotion Header Data, IS-R
|
MANDT |
| KONA | AKTNR | KONA | AKTNR |
WAKH
Promotion Header Data, IS-R
|
AKTNR |
| KONA | ANBEDNFE | KONA | MANDT |
TMAN3
Trigger Group of Message Determination - Trigger Condition
|
MANDT |
| KONA | ANBEDNFE | '60' |
TMAN3
Trigger Group of Message Determination - Trigger Condition
|
ANOBJTYP | |
| KONA | ANBEDNFE | KONA | ANGRP |
TMAN3
Trigger Group of Message Determination - Trigger Condition
|
ANGRP |
| KONA | ANBEDNFE | KONA | ANBEDNFE |
TMAN3
Trigger Group of Message Determination - Trigger Condition
|
ANBEDNFE |
| KONA | ANGRP | KONA | ANGRP |
TMAN2
Trigger Group of Message Determination
|
ANGRP |
| KONA | ANGRP | KONA | MANDT |
TMAN2
Trigger Group of Message Determination
|
MANDT |
| KONA | ANGRP | '60' |
TMAN2
Trigger Group of Message Determination
|
ANOBJTYP | |
| KONA | BOART | KONA | MANDT |
T6B1
Rebate : Rebate Agreement Types
|
MANDT |
| KONA | BOART | KONA | BOART |
T6B1
Rebate : Rebate Agreement Types
|
BOART |
| KONA | BOLIF | KONA | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| KONA | BOLIF | KONA | BOLIF |
LFA1
Vendor Master (General Section)
|
LIFNR |
| KONA | BONEM | KONA | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| KONA | BONEM | KONA | BONEM |
KNA1
General Data in Customer Master
|
KUNNR |
| KONA | BUKRS | KONA | MANDT |
T001
Company Codes
|
MANDT |
| KONA | BUKRS | KONA | BUKRS |
T001
Company Codes
|
BUKRS |
| KONA | EKGRP | KONA | MANDT |
T024
Purchasing Groups
|
MANDT |
| KONA | EKGRP | KONA | EKGRP |
T024
Purchasing Groups
|
EKGRP |
| KONA | EKORG | KONA | MANDT |
T024E
Purchasing Organizations
|
MANDT |
| KONA | EKORG | KONA | EKORG |
T024E
Purchasing Organizations
|
EKORG |
| KONA | IDENT1 | KONA | IDENT1 |
TFACD
Factory calendar definition
|
IDENT |
| KONA | IDENT2 | KONA | IDENT2 |
TFACD
Factory calendar definition
|
IDENT |
| KONA | IDENT3 | KONA | IDENT3 |
TFACD
Factory calendar definition
|
IDENT |
| KONA | KAPPL | KONA | KAPPL |
T681A
Conditions: Applications
|
KAPPL |
| KONA | KOBOG | KONA | KAPPL |
T6B2
Rebate : Group of permitted Condition Types/Tables
|
KAPPL |
| KONA | KOBOG | KONA | KOBOG |
T6B2
Rebate : Group of permitted Condition Types/Tables
|
KOBOG |
| KONA | KOBOG | KONA | MANDT |
T6B2
Rebate : Group of permitted Condition Types/Tables
|
MANDT |
| KONA | MANDT | KONA | MANDT |
T000
Clients
|
MANDT |
| KONA | NAUMF_ANAW | KONA | NAUMF_ANAW |
TMAB
Summarization Level
|
NAUMF |
| KONA | NAUMF_ANAW | KONA | MANDT |
TMAB
Summarization Level
|
MANDT |
| KONA | NAUMF_ANAW | KONA | KAPPL |
TMAB
Summarization Level
|
KAPPL |
| KONA | NAUMF_ANAW | '03' |
TMAB
Summarization Level
|
CONDENSE_TYPE | |
| KONA | NAUMF_ENAW | KONA | MANDT |
TMAB
Summarization Level
|
MANDT |
| KONA | NAUMF_ENAW | KONA | KAPPL |
TMAB
Summarization Level
|
KAPPL |
| KONA | NAUMF_ENAW | '01' |
TMAB
Summarization Level
|
CONDENSE_TYPE | |
| KONA | NAUMF_ENAW | KONA | NAUMF_ENAW |
TMAB
Summarization Level
|
NAUMF |
| KONA | NAUMF_SNAW | KONA | KAPPL |
TMAB
Summarization Level
|
KAPPL |
| KONA | NAUMF_SNAW | '02' |
TMAB
Summarization Level
|
CONDENSE_TYPE | |
| KONA | NAUMF_SNAW | KONA | NAUMF_SNAW |
TMAB
Summarization Level
|
NAUMF |
| KONA | NAUMF_SNAW | KONA | MANDT |
TMAB
Summarization Level
|
MANDT |
| KONA | SPART | KONA | SPART |
TVTA
Organizational Unit: Sales Area(s)
|
SPART |
| KONA | SPART | KONA | MANDT |
TVTA
Organizational Unit: Sales Area(s)
|
MANDT |
| KONA | SPART | KONA | VKORG |
TVTA
Organizational Unit: Sales Area(s)
|
VKORG |
| KONA | SPART | KONA | VTWEG |
TVTA
Organizational Unit: Sales Area(s)
|
VTWEG |
| KONA | UKNUMA | KONA | MANDT |
KONA
Agreements
|
MANDT |
| KONA | UKNUMA | KONA | UKNUMA |
KONA
Agreements
|
KNUMA |
| KONA | VKBUR | KONA | SPART |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
SPART |
| KONA | VKBUR | KONA | VKBUR |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
VKBUR |
| KONA | VKBUR | KONA | MANDT |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
MANDT |
| KONA | VKBUR | KONA | VKORG |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
VKORG |
| KONA | VKBUR | KONA | VTWEG |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
VTWEG |
| KONA | VKGRP | KONA | MANDT |
TVBVK
Organizational Unit: Sales Groups per Sales Office
|
MANDT |
| KONA | VKGRP | KONA | VKBUR |
TVBVK
Organizational Unit: Sales Groups per Sales Office
|
VKBUR |
| KONA | VKGRP | KONA | VKGRP |
TVBVK
Organizational Unit: Sales Groups per Sales Office
|
VKGRP |
| KONA | VKNUMA | KONA | MANDT |
KONA
Agreements
|
MANDT |
| KONA | VKNUMA | KONA | VKNUMA |
KONA
Agreements
|
KNUMA |
| KONA | VKORG | KONA | MANDT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| KONA | VKORG | KONA | VKORG |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| KONA | VTWEG | KONA | VKORG |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
VKORG |
| KONA | VTWEG | KONA | VTWEG |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
VTWEG |
| KONA | VTWEG | KONA | MANDT |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
MANDT |
| KONA | WAERS | KONA | MANDT |
TCURC
Currency Codes
|
MANDT |
| KONA | WAERS | KONA | WAERS |
TCURC
Currency Codes
|
WAERS |
| KONA | ZLSCH | T001 | LAND1 |
T042Z
Payment Methods for Automatic Payment
|
LAND1 |
| KONA | ZLSCH | KONA | ZLSCH |
T042Z
Payment Methods for Automatic Payment
|
ZLSCH |
| KONA | ZLSCH | KONA | MANDT |
T042Z
Payment Methods for Automatic Payment
|
MANDT |