SAP ABAP Table KONADB2 (KONA: Structure for Update)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-MD-AM-RAG (Application Component) Rebate Agreements
     ⤷ AGR_EXCHANGE_GENERAL (Package) Exchange Agreements General

Basic Data

Table Category	INTTAB	Structure
Structure	KONADB2	Table Relationship Diagram
Short Description	KONA: Structure for Update

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20100310
SAP Release Created in	463