KONA SAP (Agreements) Table details

Dictionary Type: Table
Description: Agreements




ABAP Code to SELECT data from KONA
Related tables to KONA
Access table KONA




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
MANDTClient MANDTCLNT3T000MANDT
KNUMAAgreement (various conditions grouped together) KNUMACHAR10ALPHAKNUMAVMBO
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVKOVVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TVTASPARTSPAC_SPART
VKBURSales Office VKBURCHAR4TVKBZVKBURVKB
VKGRPSales Group VKGRPCHAR3TVBVKVKGRPVKG
BOARTAgreement type BOARTCHAR4T6B1BOARTVBA
ABTYPCategory of the rebate agreement BOABTYPCHAR1ABTYP
KAPPLApplication KAPPLCHAR2T681AKAPPLKAP
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERZETEntry time ERZETTIMS6UZEIT
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
AEZETTime last change was made AEZETTIMS6UZEIT
BONEMRebate recipient BONEMCHAR10KNA1ALPHAKUNNRVBE
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
MAXBOMaximum rebate (not used) MAXBOCURR13(2) WERTV7
ABREXExternal description for agreement ABREXCHAR20CHAR20
EKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
BOLIFCondition granter BOGEWCHAR10LFA1ALPHALIFNRLIF
ABSPZScope of verification level of rebate agreement ABSPZCHAR1ABSPZ
BOSTAStatus of the agreement BOSTACHAR1BOSTA
DATABAgreement valid-from date ABDATABDATS8DATUM
DATBIAgreement valid-to date ABDATBIDATS8DATUM
KOBOGCondition type/table group for agreements KOBOGCHAR4T6B2KOBOG
BOTEXTDescription of agreement (e.g. sales deal, promotion) BOTEXTCHAR40TEXT40
ZLSCHPayment Method DZLSCHCHAR1T042ZZLSCH
VALTGAdditional value days VALTGNUMC2TAGE2
VALDTFixed value date VALDTDATS8DATUM
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
UKNUMAHigher-level agreement KNUMA_UEBCHAR10KONAALPHAKNUMA
IDENT1Settlement calendar for rebate arrangements WFCID1CHAR2TFACDWFCID
IDENT2Arrangement calendar for rebate arrangements WFCID2CHAR2TFACDWFCID
UMNAMPerson responsible for BVol. comparison f. final settlement UMNAMCHAR12USNAM
UMSDADate of last business volume comparison for final settlement UMSDADATS8DATUM
UMSAEBusiness volume comparison required for final settlement UMSAEFCHAR1XFELD
EKGRPPurchasing Group EKGRPCHAR3T024EKGRPEKG
AKTNRCOUPON WAKTIONCHAR10WAKHALPHAWAKTIONWAK
ABEINScope of statem. f. rebate arr. (Purchasing) -no longer used ABEINCHAR1ABEIN
BUKRSCompany code for subsequent settlement BUKRS_ABCHAR4T001BUKRS
VKNUMAPreceding arrangement for automatic renewal KNUMA_VORCHAR10KONAALPHAKNUMA
FORZPSubsequent settlement: time of LIS update FORZPCHAR1FORZP
FOARTSubsequent settlement: update type (scale/condition basis) FOART_NACHAR1XFELD
IDENT3Settlement periods for agreements WFCID3CHAR2TFACDWFCID
ABPARIndicator for type of settlement partner (vendor/customer) WABPARCHAR1WABPAR
KFRSTRelease status KFRSTCHAR1KFRST
ANGRPTrigger Group Message Determination ANGRPCHAR2TMAN2CHAR2
ANBEDNFETrigger condition, message determination ANBEDNFECHAR4TMAN3CHAR4
NAUMF_ENAWDefault aggregation level 'Detailed statement' NAUMF_ENAWCHAR2TMABCHAR02
NAUMF_SNAWDefault aggregation level 'Statement of statistical data' NAUMF_SNAWCHAR2TMABCHAR02
NAUMF_ANAWDefault Summarization Level: 'Statement of Settlement Docs' NAUMF_ANAWCHAR2TMABCHAR02
UMSAEPBusiness volume comparison required for parital settlement UMSAEPCHAR1XFELD
UMNAMPPers. responsible for last BVol. comparison, partial settlm. UMNAMPCHAR12USNAM
UMSDAPDate of last business vol. comparison for partial settlement UMSDAPDATS8DATUM
.INCLU--AP 0
/BEV1/RBRTTContract Type RANTYPCHAR1RANTYP
/BEV1/RBRTNContract Number RANLCHAR13ALPHARANLRAN
/BEV1/RBEWAFlow Type SBEWARTCHAR4Assigned to domainSBEWART
.INCLU--AP 0
BON_ENH_VAKEYIndicates Enhanced Rebate Settlement BON_ENH_VAKEYCHAR1XFELD
BON_ENH_INDIRECTIndicator for Indirect Settlement Types BON_ENH_INDIRECTCHAR1XFELD
BON_ENH_PERIOD_SIndicates Periodic Settlement BON_ENH_PERIOD_SCHAR1XFELD
.INCLU--AP 0
BON_ENH_CTYPContract Type RANTYPCHAR1RANTYP
BON_ENH_CNOContract Number RANLCHAR13ALPHARANLRAN
BON_ENH_TTYPFlow Type SBEWARTCHAR4Assigned to domainSBEWART

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!