SAP ABAP Table KONA (Agreements)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ AP-PRC-PR (Application Component) Pricing
     ⤷ VKON (Package) Application development R/3 conditions

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	KONA	Table Relationship Diagram
Short Description	Agreements

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	KNUMA	☑	KNUMA	KNUMA	CHAR	10	0	Agreement (various conditions grouped together)
3	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
4	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
5	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
6	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
7	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
8	BOART	☐	BOART	BOART	CHAR	4	0	Agreement type	T6B1
9	ABTYP	☐	BOABTYP	ABTYP	CHAR	1	0	Category of the rebate agreement
10	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
11	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
12	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
13	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
14	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
15	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
16	AEZET	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
17	BONEM	☐	BONEM	KUNNR	CHAR	10	0	Rebate recipient	KNA1
18	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
19	MAXBO	☐	MAXBO	WERTV7	CURR	13	2	Maximum rebate (not used)
20	ABREX	☐	ABREX	CHAR20	CHAR	20	0	External description for agreement
21	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
22	BOLIF	☐	BOGEW	LIFNR	CHAR	10	0	Condition granter	LFA1
23	ABSPZ	☐	ABSPZ	ABSPZ	CHAR	1	0	Scope of verification level of rebate agreement
24	BOSTA	☐	BOSTA	BOSTA	CHAR	1	0	Status of the agreement
25	DATAB	☐	ABDATAB	DATUM	DATS	8	0	Agreement valid-from date
26	DATBI	☐	ABDATBI	DATUM	DATS	8	0	Agreement valid-to date
27	KOBOG	☐	KOBOG	KOBOG	CHAR	4	0	Condition type/table group for agreements	T6B2
28	BOTEXT	☐	BOTEXT	TEXT40	CHAR	40	0	Description of agreement (e.g. sales deal, promotion)
29	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
30	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
31	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
32	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
33	UKNUMA	☐	KNUMA_UEB	KNUMA	CHAR	10	0	Higher-level agreement	KONA
34	IDENT1	☐	WFCID1	WFCID	CHAR	2	0	Settlement calendar for rebate arrangements	TFACD
35	IDENT2	☐	WFCID2	WFCID	CHAR	2	0	Arrangement calendar for rebate arrangements	TFACD
36	UMNAM	☐	UMNAM	USNAM	CHAR	12	0	Person responsible for BVol. comparison f. final settlement
37	UMSDA	☐	UMSDA	DATUM	DATS	8	0	Date of last business volume comparison for final settlement
38	UMSAE	☐	UMSAEF	XFELD	CHAR	1	0	Business volume comparison required for final settlement
39	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
40	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
41	ABEIN	☐	ABEIN	ABEIN	CHAR	1	0	Scope of statem. f. rebate arr. (Purchasing) -no longer used
42	BUKRS	☐	BUKRS_AB	BUKRS	CHAR	4	0	Company code for subsequent settlement	T001
43	VKNUMA	☐	KNUMA_VOR	KNUMA	CHAR	10	0	Preceding arrangement for automatic renewal	KONA
44	FORZP	☐	FORZP	FORZP	CHAR	1	0	Subsequent settlement: time of LIS update
45	FOART	☐	FOART_NA	XFELD	CHAR	1	0	Subsequent settlement: update type (scale/condition basis)
46	IDENT3	☐	WFCID3	WFCID	CHAR	2	0	Settlement periods for agreements	TFACD
47	ABPAR	☐	WABPAR	WABPAR	CHAR	1	0	Indicator for type of settlement partner (vendor/customer)
48	KFRST	☐	KFRST	KFRST	CHAR	1	0	Release Status
49	ANGRP	☐	ANGRP	CHAR2	CHAR	2	0	Trigger Group Message Determination	TMAN2
50	ANBEDNFE	☐	ANBEDNFE	CHAR4	CHAR	4	0	Trigger condition, message determination	TMAN3
51	NAUMF_ENAW	☐	NAUMF_ENAW	CHAR02	CHAR	2	0	Default aggregation level "Detailed statement"	TMAB
52	NAUMF_SNAW	☐	NAUMF_SNAW	CHAR02	CHAR	2	0	Default aggregation level "Statement of statistical data"	TMAB
53	NAUMF_ANAW	☐	NAUMF_ANAW	CHAR02	CHAR	2	0	Default Summarization Level: "Statement of Settlement Docs"	TMAB
54	UMSAEP	☐	UMSAEP	XFELD	CHAR	1	0	Business volume comparison required for parital settlement
55	UMNAMP	☐	UMNAMP	USNAM	CHAR	12	0	Pers. responsible for last BVol. comparison, partial settlm.
56	UMSDAP	☐	UMSDAP	DATUM	DATS	8	0	Date of last business vol. comparison for partial settlement
57	.INCLU--AP	☐				0	0	Contract Information Rebate
58	/BEV1/RBRTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
59	/BEV1/RBRTN	☐	RANL	RANL	CHAR	13	0	Contract Number
60	/BEV1/RBEWA	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
61	.INCLU--AP	☐				0	0	Indicates Enhanced Rebate Settlement
62	.INCLUDE	☐				0	0	Structure for Append Enhanced Rebate
63	BON_ENH_VAKEY	☐	BON_ENH_VAKEY	XFELD	CHAR	1	0	Indicates Enhanced Rebate Settlement
64	BON_ENH_INDIRECT	☐	BON_ENH_INDIRECT	XFELD	CHAR	1	0	Indicator for Indirect Settlement Types
65	BON_ENH_PERIOD_S	☐	BON_ENH_PERIOD_S	XFELD	CHAR	1	0	Indicates Periodic Settlement
66	.INCLU--AP	☐				0	0	Contract Information for Enhanced Rebate
67	.INCLUDE	☐				0	0	Structure for Append Contract Data
68	BON_ENH_CTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
69	BON_ENH_CNO	☐	RANL	RANL	CHAR	13	0	Contract Number
70	BON_ENH_TTYP	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	KONA	AKTNR	WAKH	AKTNR
2	KONA	ANBEDNFE	TMAN3	ANBEDNFE	KEY	1	CN
3	KONA	ANGRP	TMAN2	ANGRP	KEY	1	CN
4	KONA	BOART	T6B1	BOART	KEY	1	CN
5	KONA	BOLIF	LFA1	LIFNR	KEY	1	CN
6	KONA	BONEM	KNA1	KUNNR	KEY	1	CN
7	KONA	BUKRS	T001	BUKRS
8	KONA	EKGRP	T024	EKGRP
9	KONA	EKORG	T024E	EKORG	KEY	1	CN
10	KONA	IDENT1	TFACD	IDENT
11	KONA	IDENT2	TFACD	IDENT
12	KONA	IDENT3	TFACD	IDENT
13	KONA	KAPPL	T681A	KAPPL	REF	1	CN
14	KONA	KOBOG	T6B2	KOBOG	KEY	1	CN
15	KONA	MANDT	T000	MANDT	KEY	1	CN
16	KONA	NAUMF_ANAW	TMAB	NAUMF	KEY
17	KONA	NAUMF_ENAW	TMAB	NAUMF	KEY
18	KONA	NAUMF_SNAW	TMAB	NAUMF	KEY
19	KONA	SPART	TVTA	SPART	KEY	1	CN
20	KONA	UKNUMA	KONA	KNUMA	REF	C	CN
21	KONA	VKBUR	TVKBZ	VKBUR	KEY	1	CN
22	KONA	VKGRP	TVBVK	VKGRP	KEY	1	CN
23	KONA	VKNUMA	KONA	KNUMA		C	N
24	KONA	VKORG	TVKO	VKORG	KEY	1	CN
25	KONA	VTWEG	TVKOV	VTWEG	KEY	1	CN
26	KONA	WAERS	TCURC	WAERS	KEY	1	CN
27	KONA	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20100310
SAP Release Created in