KONA

Agreements | #masterdata | Component: Conditions

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities
📅 Dates (9)
☰ Categorical (14)
Other (10)
🔗 Relations (27)

Column Name	Description
MANDT FK	Client
KNUMA	Agreement (various conditions grouped together)

Column Name	Description
💲 Currency Key (WAERS):
MAXBO	Maximum rebate (not used)

Column Name	Description

Column Name	Description
ERDAT	Date on which the record was created
ERZET	Entry time
AEDAT	Last Changed On
AEZET	Time last change was made
DATAB	Agreement valid-from date
DATBI	Agreement valid-to date
VALDT	Fixed Value Date
UMSDA	Date of last business volume comparison for final settlement
UMSDAP	Date of last business vol. comparison for partial settlement

Column Name	Description
ABTYP	Category of the rebate agreement	Show values
ABSPZ	Scope of verification level of rebate agreement	Show values
BOSTA	Status of the agreement	Show values
UMSAE	Business volume comparison required for final settlement	Show values
ABEIN	Scope of statem. f. rebate arr. (Purchasing) -no longer used	Show values
FORZP	Subsequent settlement: time of LIS update	Show values
FOART	Subsequent settlement: update type (scale/condition basis)	Show values
ABPAR	Indicator for Type of Settlement Partner (Supplier/Customer)	Show values
KFRST	Release Status	Show values
UMSAEP	Business volume comparison required for parital settlement	Show values
BON_ENH_VAKEY	Indicates Enhanced Rebate Settlement	Show values
BON_ENH_INDIRECT	Indicator for Indirect Settlement Types	Show values
BON_ENH_PERIOD_S	Indicates Periodic Settlement	Show values
BON_ENH_CTYP	Contract Type	Show values

Column Name	Description	Domain name
ERNAM	Name of Person Responsible for Creating the Object	USNAM
AENAM	Name of Person Who Changed Object	USNAM
ABREX	External description for agreement	CHAR20
BOTEXT	Description of agreement (e.g. sales deal, promotion)	TEXT40
VALTG	Additional Value Days	TAGE2
ZTERM	Terms of payment key	ZTERM
UMNAM	Person responsible for BVol. comparison f. final settlement	USNAM
UMNAMP	Pers. responsible for last BVol. comparison, partial settlm.	USNAM
BON_ENH_CNO	Contract Number	RANL
BON_ENH_TTYP	Flow Type	SBEWART

Master Data Relations \| to Other Relations ↓	Join Conditions
Promotion Promotion Client	`KONA.AKTNR == WAKH.AKTNR` `KONA.MANDT == WAKH.MANDT`
Trigger Group Message Determination ? Client Trigger Group Message Determination	`KONA.[column in domain "ANOBJTYP"] == TMAN2.ANOBJTYP` `KONA.MANDT == TMAN2.MANDT` `KONA.ANGRP == TMAN2.ANGRP`
Agreement type	`KONA.MANDT == T6B1.MANDT` `KONA.BOART == T6B1.BOART`
Condition granter	`KONA.MANDT == LFA1.MANDT` `KONA.BOLIF == LFA1.LIFNR`
Rebate recipient	`KONA.MANDT == KNA1.MANDT` `KONA.BONEM == KNA1.KUNNR`
Company code for subsequent settlement	`KONA.MANDT == T001.MANDT` `KONA.BUKRS == T001.BUKRS`
Purchasing group for volume-based rebate (purchasing) Purchasing Group Client	`KONA.EKGRP == T024.EKGRP` `KONA.MANDT == T024.MANDT`
Purchasing organization	`KONA.MANDT == T024E.MANDT` `KONA.EKORG == T024E.EKORG`
Settlement calendar for rebate arrangements	`KONA.IDENT1 == TFACD.IDENT`
Arrangement calendar for rebate arrangements	`KONA.IDENT2 == TFACD.IDENT`
Settlement periods for agreements	`KONA.IDENT3 == TFACD.IDENT`
Application	`KONA.KAPPL == T681A.KAPPL`
Condition Type/Table Group Condition Type/Table Group Application Client	`KONA.KOBOG == T6B2.KOBOG` `KONA.KAPPL == T6B2.KAPPL` `KONA.MANDT == T6B2.MANDT`
Client	`KONA.MANDT == T000.MANDT`
Default Summarization Level: "Statement of Settlement Docs" Default Summarization Level: "Statement of Settlement Docs" Client ? Application	`KONA.NAUMF_ANAW == TMAB.NAUMF` `KONA.MANDT == TMAB.MANDT` `KONA.[column in domain "CONDENSE_TYPE"] == TMAB.CONDENSE_TYPE` `KONA.KAPPL == TMAB.KAPPL`
Default aggregation level "Detailed statement" Default aggregation level "Detailed statement" Client ? Application	`KONA.NAUMF_ENAW == TMAB.NAUMF` `KONA.MANDT == TMAB.MANDT` `KONA.[column in domain "CONDENSE_TYPE"] == TMAB.CONDENSE_TYPE` `KONA.KAPPL == TMAB.KAPPL`
Default aggregation level "Statement of statistical data" Default aggregation level "Statement of statistical data" Client ? Application	`KONA.NAUMF_SNAW == TMAB.NAUMF` `KONA.MANDT == TMAB.MANDT` `KONA.[column in domain "CONDENSE_TYPE"] == TMAB.CONDENSE_TYPE` `KONA.KAPPL == TMAB.KAPPL`
Division Sales Organization Distribution Channel Division Client	`KONA.VKORG == TVTA.VKORG` `KONA.VTWEG == TVTA.VTWEG` `KONA.SPART == TVTA.SPART` `KONA.MANDT == TVTA.MANDT`
Higher-level agreement Higher-level agreement Client	`KONA.UKNUMA == KONA.KNUMA` `KONA.MANDT == KONA.MANDT`
Sales group Sales group Sales office	`KONA.MANDT == TVBVK.MANDT` `KONA.VKGRP == TVBVK.VKGRP` `KONA.VKBUR == TVBVK.VKBUR`
Preceding arrangement for automatic renewal Preceding arrangement for automatic renewal Client	`KONA.VKNUMA == KONA.KNUMA` `KONA.MANDT == KONA.MANDT`
Sales Organization	`KONA.MANDT == TVKO.MANDT` `KONA.VKORG == TVKO.VKORG`
Distribution Channel Sales Organization Client Distribution Channel	`KONA.VKORG == TVKOV.VKORG` `KONA.MANDT == TVKOV.MANDT` `KONA.VTWEG == TVKOV.VTWEG`
Currency Key	`KONA.MANDT == TCURC.MANDT` `KONA.WAERS == TCURC.WAERS`
Payment Method Payment Method ?	`KONA.MANDT == T042Z.MANDT` `KONA.ZLSCH == T042Z.ZLSCH` `KONA.[column in domain "LAND1"] == T042Z.LAND1`

Other Relations \| to Master Data Relations ↑	Join Conditions
Trigger condition, message determination Trigger condition, message determination Client ? Trigger Group Message Determination	`KONA.ANBEDNFE == TMAN3.ANBEDNFE` `KONA.MANDT == TMAN3.MANDT` `KONA.[column in domain "ANOBJTYP"] == TMAN3.ANOBJTYP` `KONA.ANGRP == TMAN3.ANGRP`
Sales office Sales Organization Client Distribution Channel Division Sales office	`KONA.VKORG == TVKBZ.VKORG` `KONA.MANDT == TVKBZ.MANDT` `KONA.VTWEG == TVKBZ.VTWEG` `KONA.SPART == TVKBZ.SPART` `KONA.VKBUR == TVKBZ.VKBUR`