KONA SAP (Agreements) Table details
Dictionary Type: Table
Description: Agreements
Description: Agreements
Table field list including key, data, relationships and ABAP select examples
KONA is a standard SAP Table which is used to store Agreements data and is available within R/3 SAP systems depending on the version and release level.
The KONA table consists of various fields, each holding specific information or linking keys about Agreements data available in SAP. These include KNUMA (Agreement (various conditions grouped together)), VKORG (Sales Organization), VTWEG (Distribution Channel), SPART (Division).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP KONA table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
KNUMA | Agreement (various conditions grouped together) | KNUMA | CHAR | 10 | ALPHA | KNUMA | VMBO | ||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVKOV | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | TVTA | SPART | SPA | C_SPART | |
VKBUR | Sales Office | VKBUR | CHAR | 4 | TVKBZ | VKBUR | VKB | ||
VKGRP | Sales Group | VKGRP | CHAR | 3 | TVBVK | VKGRP | VKG | ||
BOART | Agreement type | BOART | CHAR | 4 | T6B1 | BOART | VBA | ||
ABTYP | Category of the rebate agreement | BOABTYP | CHAR | 1 | ABTYP | ||||
KAPPL | Application | KAPPL | CHAR | 2 | T681A | KAPPL | KAP | ||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERZET | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AEZET | Time last change was made | AEZET | TIMS | 6 | UZEIT | ||||
BONEM | Rebate recipient | BONEM | CHAR | 10 | KNA1 | ALPHA | KUNNR | VBE | |
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
MAXBO | Maximum rebate (not used) | MAXBO | CURR | 13(2) | WERTV7 | ||||
ABREX | External description for agreement | ABREX | CHAR | 20 | CHAR20 | ||||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
BOLIF | Condition granter | BOGEW | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | |
ABSPZ | Scope of verification level of rebate agreement | ABSPZ | CHAR | 1 | ABSPZ | ||||
BOSTA | Status of the agreement | BOSTA | CHAR | 1 | BOSTA | ||||
DATAB | Agreement valid-from date | ABDATAB | DATS | 8 | DATUM | ||||
DATBI | Agreement valid-to date | ABDATBI | DATS | 8 | DATUM | ||||
KOBOG | Condition type/table group for agreements | KOBOG | CHAR | 4 | T6B2 | KOBOG | |||
BOTEXT | Description of agreement (e.g. sales deal, promotion) | BOTEXT | CHAR | 40 | TEXT40 | ||||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | T042Z | ZLSCH | |||
VALTG | Additional value days | VALTG | NUMC | 2 | TAGE2 | ||||
VALDT | Fixed value date | VALDT | DATS | 8 | DATUM | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
UKNUMA | Higher-level agreement | KNUMA_UEB | CHAR | 10 | KONA | ALPHA | KNUMA | ||
IDENT1 | Settlement calendar for rebate arrangements | WFCID1 | CHAR | 2 | TFACD | WFCID | |||
IDENT2 | Arrangement calendar for rebate arrangements | WFCID2 | CHAR | 2 | TFACD | WFCID | |||
UMNAM | Person responsible for BVol. comparison f. final settlement | UMNAM | CHAR | 12 | USNAM | ||||
UMSDA | Date of last business volume comparison for final settlement | UMSDA | DATS | 8 | DATUM | ||||
UMSAE | Business volume comparison required for final settlement | UMSAEF | CHAR | 1 | XFELD | ||||
EKGRP | Purchasing Group | EKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
AKTNR | COUPON | WAKTION | CHAR | 10 | WAKH | ALPHA | WAKTION | WAK | |
ABEIN | Scope of statem. f. rebate arr. (Purchasing) -no longer used | ABEIN | CHAR | 1 | ABEIN | ||||
BUKRS | Company code for subsequent settlement | BUKRS_AB | CHAR | 4 | T001 | BUKRS | |||
VKNUMA | Preceding arrangement for automatic renewal | KNUMA_VOR | CHAR | 10 | KONA | ALPHA | KNUMA | ||
FORZP | Subsequent settlement: time of LIS update | FORZP | CHAR | 1 | FORZP | ||||
FOART | Subsequent settlement: update type (scale/condition basis) | FOART_NA | CHAR | 1 | XFELD | ||||
IDENT3 | Settlement periods for agreements | WFCID3 | CHAR | 2 | TFACD | WFCID | |||
ABPAR | Indicator for type of settlement partner (vendor/customer) | WABPAR | CHAR | 1 | WABPAR | ||||
KFRST | Release status | KFRST | CHAR | 1 | KFRST | ||||
ANGRP | Trigger Group Message Determination | ANGRP | CHAR | 2 | TMAN2 | CHAR2 | |||
ANBEDNFE | Trigger condition, message determination | ANBEDNFE | CHAR | 4 | TMAN3 | CHAR4 | |||
NAUMF_ENAW | Default aggregation level 'Detailed statement' | NAUMF_ENAW | CHAR | 2 | TMAB | CHAR02 | |||
NAUMF_SNAW | Default aggregation level 'Statement of statistical data' | NAUMF_SNAW | CHAR | 2 | TMAB | CHAR02 | |||
NAUMF_ANAW | Default Summarization Level: 'Statement of Settlement Docs' | NAUMF_ANAW | CHAR | 2 | TMAB | CHAR02 | |||
UMSAEP | Business volume comparison required for parital settlement | UMSAEP | CHAR | 1 | XFELD | ||||
UMNAMP | Pers. responsible for last BVol. comparison, partial settlm. | UMNAMP | CHAR | 12 | USNAM | ||||
UMSDAP | Date of last business vol. comparison for partial settlement | UMSDAP | DATS | 8 | DATUM | ||||
.INCLU--AP | 0 | ||||||||
/BEV1/RBRTT | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
/BEV1/RBRTN | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
/BEV1/RBEWA | Flow Type | SBEWART | CHAR | 4 | Assigned to domain | SBEWART | |||
.INCLU--AP | 0 | ||||||||
BON_ENH_VAKEY | Indicates Enhanced Rebate Settlement | BON_ENH_VAKEY | CHAR | 1 | XFELD | ||||
BON_ENH_INDIRECT | Indicator for Indirect Settlement Types | BON_ENH_INDIRECT | CHAR | 1 | XFELD | ||||
BON_ENH_PERIOD_S | Indicates Periodic Settlement | BON_ENH_PERIOD_S | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
BON_ENH_CTYP | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
BON_ENH_CNO | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
BON_ENH_TTYP | Flow Type | SBEWART | CHAR | 4 | Assigned to domain | SBEWART |
Key field | Non-key field |
How do I retrieve data from SAP table KONA using ABAP code
The following ABAP code Example will allow you to do a basic selection on KONA to SELECT all data from the tableDATA: WA_KONA TYPE KONA.
SELECT SINGLE *
FROM KONA
INTO CORRESPONDING FIELDS OF WA_KONA
WHERE...
How to access SAP table KONA
Within an ECC or HANA version of SAP you can also view further information about KONA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects