SAP Table KONA - Agreements

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
KNUMA X KNUMA CHAR 3 10 0 KONA Agreement (various conditions grouped together)
VKORG VKORG CHAR 13 4 0 TVKO Sales Organization
VTWEG VTWEG CHAR 17 2 0 TVTW Distribution Channel
SPART SPART CHAR 19 2 0 TSPA Division
VKBUR VKBUR CHAR 21 4 0 TVBUR Sales Office
VKGRP VKGRP CHAR 25 3 0 TVKGR Sales Group
BOART BOART CHAR 28 4 0 T6B1 Agreement type
ABTYP BOABTYP CHAR 32 1 0 Category of the rebate agreement
KAPPL KAPPL CHAR 33 2 0 T681A Application
ERNAM ERNAM CHAR 35 12 0 Name of Person who Created the Object
ERDAT ERDAT DATS 47 8 0 Date on Which Record Was Created
ERZET ERZET TIMS 55 6 0 Entry time
AENAM AENAM CHAR 61 12 0 Name of Person Who Changed Object
AEDAT AEDAT DATS 73 8 0 Changed On
AEZET AEZET TIMS 81 6 0 Time last change was made
BONEM BONEM CHAR 87 10 0 KNA1 Rebate recipient
WAERS WAERS CUKY 97 5 0 TCURC Currency Key
MAXBO MAXBO CURR 102 13 2 Maximum rebate (not used)
ABREX ABREX CHAR 109 20 0 External description for agreement
EKORG EKORG CHAR 129 4 0 T024E Purchasing Organization
BOLIF BOGEW CHAR 133 10 0 LFA1 Condition granter
ABSPZ ABSPZ CHAR 143 1 0 Scope of verification level of rebate agreement
BOSTA BOSTA CHAR 144 1 0 Status of the agreement
DATAB ABDATAB DATS 145 8 0 Agreement valid-from date
DATBI ABDATBI DATS 153 8 0 Agreement valid-to date
KOBOG KOBOG CHAR 161 4 0 T6B2 Condition type/table group for agreements
BOTEXT BOTEXT CHAR 165 40 0 Description of agreement (e.g. sales deal, promotion)
ZLSCH DZLSCH CHAR 205 1 0 T042E Payment Method
VALTG VALTG NUMC 206 2 0 Additional value days
VALDT VALDT DATS 208 8 0 Fixed value date
ZTERM DZTERM CHAR 216 4 0 Terms of Payment Key
UKNUMA KNUMA_UEB CHAR 220 10 0 KONA Higher-level agreement
IDENT1 WFCID1 CHAR 230 2 0 TFACD Settlement calendar for rebate arrangements
IDENT2 WFCID2 CHAR 232 2 0 TFACD Arrangement calendar for rebate arrangements
UMNAM UMNAM CHAR 234 12 0 Person responsible for BVol. comparison f. final settlement
UMSDA UMSDA DATS 246 8 0 Date of last business volume comparison for final settlement
UMSAE UMSAEF CHAR 254 1 0 Business volume comparison required for final settlement
EKGRP EKGRP CHAR 255 3 0 T024 Purchasing Group
AKTNR WAKTION CHAR 258 10 0 Promotion
ABEIN ABEIN CHAR 268 1 0 Scope of statem. f. rebate arr. (Purchasing) -no longer used
BUKRS BUKRS_AB CHAR 269 4 0 T001 Company code for subsequent settlement
VKNUMA KNUMA_VOR CHAR 273 10 0 KONA Preceding arrangement for automatic renewal
FORZP FORZP CHAR 283 1 0 Subsequent settlement: time of LIS update
FOART FOART_NA CHAR 284 1 0 Subsequent settlement: update type (scale/condition basis)
IDENT3 WFCID3 CHAR 285 2 0 TFACD Settlement periods for agreements
ABPAR WABPAR CHAR 287 1 0 Indicator for type of settlement partner (vendor/customer)
KFRST KFRST CHAR 288 1 0 Release status
ANGRP ANGRP CHAR 289 2 0 Trigger Group Message Determination
ANBEDNFE ANBEDNFE CHAR 291 4 0 Trigger condition, message determination
NAUMF_ENAW NAUMF_ENAW CHAR 295 2 0 Default aggregation level "Detailed statement"
NAUMF_SNAW NAUMF_SNAW CHAR 297 2 0 Default aggregation level "Statement of statistical data"
NAUMF_ANAW NAUMF_ANAW CHAR 299 2 0 Default Summarization Level: "Statement of Settlement Docs"
UMSAEP UMSAEP CHAR 301 1 0 Business volume comparison required for parital settlement
UMNAMP UMNAMP CHAR 302 12 0 Pers. responsible for last BVol. comparison, partial settlm.
UMSDAP UMSDAP DATS 314 8 0 Date of last business vol. comparison for partial settlement
/BEV1/RBRTT RANTYP CHAR 322 1 0 Contract Type
/BEV1/RBRTN RANL CHAR 323 13 0 Contract Number
/BEV1/RBEWA SBEWART CHAR 336 4 0 TZB0A Flow Type
BON_ENH_VAKEY BON_ENH_VAKEY CHAR 340 1 0 Indicates Enhanced Rebate Settlement
BON_ENH_INDIRECT BON_ENH_INDIRECT CHAR 341 1 0 Indicator for Indirect Settlement Types
BON_ENH_PERIOD_S BON_ENH_PERIOD_S CHAR 342 1 0 Indicates Periodic Settlement
BON_ENH_CTYP RANTYP CHAR 343 1 0 Contract Type
BON_ENH_CNO RANL CHAR 344 13 0 Contract Number
BON_ENH_TTYP SBEWART CHAR 357 4 0 TZB0A Flow Type

751441Consulting: Settings for texts from purchase order
963314RVTEXTE - Documentation for the correction report
315686Rebates - Upgrading to 4.X releases
600356Enhancement for use of 'Enhanced rebate processing'
167284FAQs: Subsequent settlement (consulting, tips, Customizing)
425033 Problem extending arrangements if arrangement contains EURO
400432Expiring currencies, rebate arrangmnt maint. (purch., sales)