1. Home
  2. Resources
  3. SAP Tables
  4. KONA - Agreements

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
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
A Rebate agreement - Sales
B Promotion
C Sales deal
D Standard agreement
E Sales quote
F Agreement - Purchasing
Z Condition without any special agreement
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
NULL Display all documents
A Display totals by sold-to party/material/validity period
B Display totals by sold-to party/material
D Display totals by sold-to party
E Display totals by payer/material/validity period
F Display totals by payer/material
G Display totals by payer
H Display totals by rebate condition record
I Reserved for Ext. Bonus: Display All Documents for Var. Key
J Reserved for Ext. Bonus: Display Total for Var. Key
BOSTA Status of the agreement BOSTA CHAR 1 0
A Settlement is being checked for release
B Agreement released for settlement
C Settlement has been created
D Final settlement of agreement already carried out
NULL Open
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
X Yes
NULL No
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
NULL Display all documents
A Display totals at vendor/material/period level
B Display totals at vendor/material level
D Display totals at vendor level
E Display totals at condition granter/material/period level
F Display totals at condition granter/material level
G Display totals at condition granter level
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
NULL Invoice verification
A Goods receipt
B Purchase order
FOART Subsequent settlement: update type (scale/condition basis) FOART_NA CHAR 1 0
X Yes
NULL No
IDENT3 Settlement periods for agreements WFCID3 TFACD CHAR 2 0
ABPAR Indicator for type of settlement partner (vendor/customer) WABPAR CHAR 1 0
NULL Creditor
A Debtor
KFRST Release status KFRST CHAR 1 0
NULL Released
A Blocked
B Released for pricing simulation
C Released for planning and pricing simulation
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
X Yes
NULL No
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
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
/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
X Yes
NULL No
BON_ENH_INDIRECT Indicator for Indirect Settlement Types BON_ENH_INDIRECT CHAR 1 0
X Yes
NULL No
BON_ENH_PERIOD_S Indicates Periodic Settlement BON_ENH_PERIOD_S CHAR 1 0
X Yes
NULL No
BON_ENH_CTYP Contract Type RANTYP CHAR 1 0
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
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 ANGRP TMAN3 Trigger Group of Message Determination - Trigger Condition ANGRP
KONA ANBEDNFE KONA ANBEDNFE TMAN3 Trigger Group of Message Determination - Trigger Condition ANBEDNFE
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 ANGRP KONA MANDT TMAN2 Trigger Group of Message Determination MANDT
KONA ANGRP '60' TMAN2 Trigger Group of Message Determination ANOBJTYP
KONA ANGRP KONA ANGRP TMAN2 Trigger Group of Message Determination ANGRP
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 EKORG T024E Purchasing Organizations EKORG
KONA EKORG KONA MANDT T024E Purchasing Organizations MANDT
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 MANDT T6B2 Rebate : Group of permitted Condition Types/Tables MANDT
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 MANDT KONA MANDT T000 Clients MANDT
KONA NAUMF_ANAW KONA KAPPL TMAB Summarization Level KAPPL
KONA NAUMF_ANAW '03' TMAB Summarization Level CONDENSE_TYPE
KONA NAUMF_ANAW KONA NAUMF_ANAW TMAB Summarization Level NAUMF
KONA NAUMF_ANAW KONA MANDT TMAB Summarization Level MANDT
KONA NAUMF_ENAW '01' TMAB Summarization Level CONDENSE_TYPE
KONA NAUMF_ENAW KONA NAUMF_ENAW TMAB Summarization Level NAUMF
KONA NAUMF_ENAW KONA MANDT TMAB Summarization Level MANDT
KONA NAUMF_ENAW KONA KAPPL TMAB Summarization Level KAPPL
KONA NAUMF_SNAW KONA NAUMF_SNAW TMAB Summarization Level NAUMF
KONA NAUMF_SNAW KONA MANDT TMAB Summarization Level MANDT
KONA NAUMF_SNAW KONA KAPPL TMAB Summarization Level KAPPL
KONA NAUMF_SNAW '02' TMAB Summarization Level CONDENSE_TYPE
KONA SPART KONA VKORG TVTA Organizational Unit: Sales Area(s) VKORG
KONA SPART KONA VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
KONA SPART KONA SPART TVTA Organizational Unit: Sales Area(s) SPART
KONA SPART KONA MANDT TVTA Organizational Unit: Sales Area(s) MANDT
KONA UKNUMA KONA UKNUMA KONA Agreements KNUMA
KONA UKNUMA KONA MANDT KONA Agreements MANDT
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 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 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 MANDT TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
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 WAERS KONA MANDT TCURC Currency Codes MANDT
KONA WAERS KONA WAERS TCURC Currency Codes WAERS
KONA ZLSCH KONA MANDT T042Z Payment Methods for Automatic Payment MANDT
KONA ZLSCH T001 LAND1 T042Z Payment Methods for Automatic Payment LAND1
KONA ZLSCH KONA ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH