SAP table KONA (Agreements)

SAP table KONA has 2 primary key fields being MANDT,KNUMA.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KNUMA Agreement (various conditions grouped together) CHAR 10 0 KNUMA
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVKOV VTWEG
SPART Division CHAR 2 0 TVTA SPART
VKBUR Sales office CHAR 4 0 TVKBZ VKBUR
VKGRP Sales group CHAR 3 0 TVBVK VKGRP
BOART Agreement type CHAR 4 0 T6B1 BOART
ABTYP Category of the rebate agreement CHAR 1 0 BOABTYP
KAPPL Application CHAR 2 0 T681A KAPPL
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERZET Entry time TIMS 6 0 ERZET
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Last Changed On DATS 8 0 AEDAT
AEZET Time last change was made TIMS 6 0 AEZET
BONEM Rebate recipient CHAR 10 0 KNA1 BONEM
WAERS Currency Key CUKY 5 0 TCURC WAERS
MAXBO Maximum rebate (not used) CURR 13 2 MAXBO
ABREX External description for agreement CHAR 20 0 ABREX
EKORG Purchasing organization CHAR 4 0 T024E EKORG
BOLIF Condition granter CHAR 10 0 LFA1 BOGEW
ABSPZ Scope of verification level of rebate agreement CHAR 1 0 ABSPZ
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 CHAR 1 0 BOSTA
Open
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
DATAB Agreement valid-from date DATS 8 0 ABDATAB
DATBI Agreement valid-to date DATS 8 0 ABDATBI
KOBOG Condition Type/Table Group CHAR 4 0 T6B2 KOBOG
BOTEXT Description of agreement (e.g. sales deal, promotion) CHAR 40 0 BOTEXT
ZLSCH Payment Method CHAR 1 0 T042Z DZLSCH
VALTG Additional Value Days NUMC 2 0 VALTG
VALDT Fixed Value Date DATS 8 0 VALDT
ZTERM Terms of payment key CHAR 4 0 DZTERM
UKNUMA Higher-level agreement CHAR 10 0 KONA KNUMA_UEB
IDENT1 Settlement calendar for rebate arrangements CHAR 2 0 TFACD WFCID1
IDENT2 Arrangement calendar for rebate arrangements CHAR 2 0 TFACD WFCID2
UMNAM Person responsible for BVol. comparison f. final settlement CHAR 12 0 UMNAM
UMSDA Date of last business volume comparison for final settlement DATS 8 0 UMSDA
UMSAE Business volume comparison required for final settlement CHAR 1 0 UMSAEF
EKGRP Purchasing Group CHAR 3 0 T024 EKGRP
AKTNR Promotion CHAR 10 0 WAKH WAKTION
ABEIN Scope of statem. f. rebate arr. (Purchasing) -no longer used CHAR 1 0 ABEIN
Display all documents
A Display totals at supplier/material/period level
B Display totals at supplier/material level
D Display totals at supplier 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 CHAR 4 0 T001 BUKRS_AB
VKNUMA Preceding arrangement for automatic renewal CHAR 10 0 KONA KNUMA_VOR
FORZP Subsequent settlement: time of LIS update CHAR 1 0 FORZP
Invoice verification
A Goods receipt
B Purchase order
FOART Subsequent settlement: update type (scale/condition basis) CHAR 1 0 FOART_NA
IDENT3 Settlement periods for agreements CHAR 2 0 TFACD WFCID3
ABPAR Indicator for Type of Settlement Partner (Supplier/Customer) CHAR 1 0 WABPAR
Creditor
A Debtor
KFRST Release Status CHAR 1 0 KFRST
Released
A Blocked
B Released for pricing simulation
C Released for planning and pricing simulation
D In Review
E Rejected
ANGRP Trigger Group Message Determination CHAR 2 0 TMAN2 ANGRP
ANBEDNFE Trigger condition, message determination CHAR 4 0 TMAN3 ANBEDNFE
NAUMF_ENAW Default aggregation level "Detailed statement" CHAR 2 0 TMAB NAUMF_ENAW
NAUMF_SNAW Default aggregation level "Statement of statistical data" CHAR 2 0 TMAB NAUMF_SNAW
NAUMF_ANAW Default Summarization Level: "Statement of Settlement Docs" CHAR 2 0 TMAB NAUMF_ANAW
UMSAEP Business volume comparison required for parital settlement CHAR 1 0 UMSAEP
UMNAMP Pers. responsible for last BVol. comparison, partial settlm. CHAR 12 0 UMNAMP
UMSDAP Date of last business vol. comparison for partial settlement DATS 8 0 UMSDAP
BON_ENH_VAKEY Indicates Enhanced Rebate Settlement CHAR 1 0 BON_ENH_VAKEY
BON_ENH_INDIRECT Indicator for Indirect Settlement Types CHAR 1 0 BON_ENH_INDIRECT
BON_ENH_PERIOD_S Indicates Periodic Settlement CHAR 1 0 BON_ENH_PERIOD_S
BON_ENH_CTYP Contract Type CHAR 1 0 RANTYP
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
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
BON_ENH_CNO Contract Number CHAR 13 0 RANL
BON_ENH_TTYP Flow Type CHAR 4 0 * SBEWART

KONA foreign key relationships

Table Field Check Table Check Field
0 KONA AKTNR WAKH Promotion Header Data, IS-R MANDT
0 KONA AKTNR WAKH Promotion Header Data, IS-R AKTNR
1 KONA ANBEDNFE TMAN3 Trigger Group of Message Determination - Trigger Condition MANDT
1 KONA ANBEDNFE TMAN3 Trigger Group of Message Determination - Trigger Condition ANOBJTYP
1 KONA ANBEDNFE TMAN3 Trigger Group of Message Determination - Trigger Condition ANGRP
1 KONA ANBEDNFE TMAN3 Trigger Group of Message Determination - Trigger Condition ANBEDNFE
0 KONA ANGRP TMAN2 Trigger Group of Message Determination MANDT
0 KONA ANGRP TMAN2 Trigger Group of Message Determination ANOBJTYP
0 KONA ANGRP TMAN2 Trigger Group of Message Determination ANGRP
1 KONA BOART T6B1 Rebate : Rebate Agreement Types MANDT
1 KONA BOART T6B1 Rebate : Rebate Agreement Types BOART
0 KONA BOLIF LFA1 Supplier Master (General Section) MANDT
0 KONA BOLIF LFA1 Supplier Master (General Section) LIFNR
1 KONA BONEM KNA1 General Data in Customer Master MANDT
1 KONA BONEM KNA1 General Data in Customer Master KUNNR
0 KONA BUKRS T001 Company Codes BUKRS
1 KONA EKGRP T024 Purchasing Groups EKGRP
0 KONA EKORG T024E Purchasing Organizations EKORG
1 KONA KAPPL T681A Conditions: Applications KAPPL
0 KONA KOBOG T6B2 Rebate : Group of permitted Condition Types/Tables KAPPL
1 KONA MANDT T000 Clients MANDT
0 KONA NAUMF_ANAW TMAB Summarization Level MANDT
0 KONA NAUMF_ANAW TMAB Summarization Level KAPPL
1 KONA NAUMF_ENAW TMAB Summarization Level MANDT
1 KONA NAUMF_ENAW TMAB Summarization Level KAPPL
0 KONA NAUMF_SNAW TMAB Summarization Level MANDT
0 KONA NAUMF_SNAW TMAB Summarization Level KAPPL
1 KONA SPART TVTA Organizational Unit: Sales Area(s) MANDT
1 KONA SPART TVTA Organizational Unit: Sales Area(s) VKORG
1 KONA SPART TVTA Organizational Unit: Sales Area(s) VTWEG
1 KONA SPART TVTA Organizational Unit: Sales Area(s) SPART
0 KONA UKNUMA KONA Agreements MANDT
0 KONA UKNUMA KONA Agreements KNUMA
1 KONA VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit MANDT
1 KONA VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKORG
1 KONA VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VTWEG
1 KONA VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit SPART
0 KONA VKGRP TVBVK Organizational Unit: Sales Groups per Sales Office MANDT
1 KONA VKNUMA KONA Agreements MANDT
1 KONA VKNUMA KONA Agreements KNUMA
0 KONA VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 KONA VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 KONA VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
1 KONA VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
1 KONA VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
0 KONA WAERS TCURC Currency Codes MANDT
0 KONA WAERS TCURC Currency Codes WAERS
1 KONA ZLSCH T042Z Payment Methods for Automatic Payment MANDT
1 KONA ZLSCH T042Z Payment Methods for Automatic Payment LAND1
1 KONA ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH