SAP ABAP Table MCKONA (Subseq. settlem.: Vend. bus. and reb. income comm. structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WBON (Package) WWS: Bonus

Basic Data

Table Category	INTTAB	Structure
Structure	MCKONA	Table Relationship Diagram
Short Description	Subseq. settlem.: Vend. bus. and reb. income comm. structure

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	.INCLUDE	☐				0	0	LIS Characteristics: Subsequent Settlement
3	KNUMA	☐	KNUMA_BO	KNUMA	CHAR	10	0	Agreement (subsequent settlement)	KONA
4	KNUMH	☐	KNUMH	KNUMB	CHAR	10	0	Condition record number
5	KOPOS	☐	KOPOS	NUM02	NUMC	2	0	Sequential number of the condition
6	LIFNR	☐	BELIF	LIFNR	CHAR	10	0	Vendor (PO, vendor billing document, settlement request)	LFA1
7	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
8	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
9	BOLIF	☐	BOPAR	LIFNR	CHAR	10	0	Settlement partner (vendor or customer)	*
10	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
11	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
12	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
13	DATBI	☐	MC_DATBI	DATUM	DATS	8	0	End date of validity period of an arrangement
14	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
15	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
16	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
17	KUNRE	☐	KUNRE	KUNNR	CHAR	10	0	Bill-to party	KNA1
18	.INCLUDE	☐				0	0	LIS Key Figures: Subsequent Settlement
19	MENGEST	☐	MC_BOMNGST	MENGV15	QUAN	15	3	Vendor business volume: quantity in scale unit
20	MENGE	☐	MC_BOMNG	MENGV13	QUAN	13	3	Vendor business volume: quantity in condition unit
21	KAWRTSTEK	☐	MC_BOUSTEK	WERTV9	CURR	17	2	Vendor busn. vol. value from purch. doc. in scale currency
22	BONBASTRE	☐	MC_BOUSTRE	WERTV9	CURR	17	2	Vendor busn. vol. value from invoice doc. in scale currency
23	KAWRTKDEK	☐	MC_BOUKDEK	WERTV9	CURR	17	2	Vendor busn. vol.: value from purch. doc. in cond. currency
24	BONBAKDRE	☐	MC_BOUKDRE	WERTV9	CURR	17	2	Vendor busn. vol.: value from inv. doc. in cond. currency
25	KAWRT	☐	MC_BOUABEK	WERTV8	CURR	15	2	Vendor busn. volume: value from purch. doc. in arr. currency
26	BONBA	☐	MC_BOUABRE	WERTV8	CURR	15	2	Vendor busn. vol.: value from invoice doc. in arr. currency
27	BRGEW	☐	MC_BOBRGEW	MENGV15_3	QUAN	15	3	Vendor business volume: gross weight (subsequent settlement)
28	NTGEW	☐	MC_BONTGEW	MENGV15_3	QUAN	15	3	Vendor business volume: net weight (subsequent settlement)
29	VOLUM	☐	MC_BOVOLUM	MENGV15_3	QUAN	15	3	Vendor business volume: physical volume (subseq. settlement)
30	ANZPU	☐	MC_BOANZPU	MENGV13	QUAN	13	3	Vendor business volume: no. of points (subseq. settlement)
31	AGWRT	☐	MC_AGWRT	WERTV10	CURR	19	2	Rebate income from final settlement
32	AUWRT	☐	MC_BOERT	WERTV10	CURR	19	2	Rebate income from settlement w. regard to condition record
33	RUWRT	☐	MC_BORUW	WERTV10	CURR	19	2	Provision for accrued condition income
34	RRWRT	☐	MC_BORRW	WERTV10	CURR	19	2	Dissolved (reversed) provision for accrued condition income
35	ABSPW	☐	ABSPW	WAERS	CUKY	5	0	Currency of rebate arrangement	TCURC
36	KONWA	☐	KONWA	WAERS	CUKY	5	0	Rate unit (currency or percentage)	TCURC
37	KONWS	☐	KONWS	WAERS	CUKY	5	0	Currency Key: Condition Scale	TCURC
38	MEINS	☐	KVMEI	MEINS	UNIT	3	0	Condition unit in the document	T006
39	KONMS	☐	KONMS	MEINS	UNIT	3	0	Condition scale unit of measure	T006
40	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
41	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
42	PUNEI	☐	PUNEI	MEINS	UNIT	3	0	Points unit	T006
43	BUDAT	☐	FODAT	DATUM	DATS	8	0	Date of LIS update (subsequent settlement)
44	.INCLUDE	☐				0	0	Additional Fields: Updating: Subseq. Settlement (Purchasing)
45	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
46	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
47	WAERS	☐	BSTWA	WAERS	CUKY	5	0	Purchase order currency	*
48	WAERSST	☐	WAERSST	WAERS	CUKY	5	0	Currency key: vendor business volume: scale	*
49	WAERSKD	☐	WAERSKD	WAERS	CUKY	5	0	Currency key: vendor business volume: condition	*
50	BLTYPN	☐	BLTYPN	BLTYPN	CHAR	2	0	Document category price determination (subseq. settlement)
51	BELNR	☐	BELNR_FO	VBELN	CHAR	10	0	Document number: statistical update (subsequent settlement)	*
52	POSNR	☐	POSNR_FO	POSNR	NUMC	6	0	Item number: statistical update (subsequent settlement)	*
53	ETENR	☐	FETEN	EETEN	NUMC	4	0	Delivery Schedule Line Counter	*
54	BLTYPF	☐	BLTYPF	BLTYPF	CHAR	2	0	Doc. type: updating of vendor business volumes
55	BELNR_TO	☐	FBLNR	BELNR	CHAR	10	0	Number of a document (updating of business volumes)
56	POSNR_TO	☐	FBLPO	NUMC6	NUMC	6	0	Document item (updating of cum. vendor business volumes)
57	ZEKKN	☐	DZEKKN	NUM02	NUMC	2	0	Sequential Number of Account Assignment
58	VGABE	☐	VGABE	VGABE	CHAR	1	0	Transaction/event type, purchase order history
59	GJAHR	☐	FJAHR	GJAHR	NUMC	4	0	Document year: updating of business volumes
60	BOBAS	☐	BOBAS	BOBAS	CHAR	1	0	Settlement basis (for purchasing documents only)
61	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	TMCB
62	AKURS	☐	AKURS_D	KKURS	DEC	9	5	Exch. rate: translation of loc. curr. into arrangement curr.
63	KKURS	☐	KKURSA	KURSP	DEC	9	5	E/rate f. transln. into local curr. (reb. arrangement curr.)
64	STKURS	☐	STKURS	KKURS	DEC	9	5	Exch. rate for transl. of local curr. -> cond. scale curr.
65	KKURSST	☐	KKURSST	KURSP	DEC	9	5	Exch. rate for transl. into local currency (scale currency)
66	KDKURS	☐	KDKURS	KKURS	DEC	9	5	Exchange rate for transl. of local into condition currency
67	KKURSKD	☐	KKURSKD	KURSP	DEC	9	5	Exch. rate for transln. into loc. currency (condition curr.)
68	FSTORNO	☐	FSTORNO	XFELD	CHAR	1	0	Indicator: cancel update
69	FORZP	☐	FORZP	FORZP	CHAR	1	0	Subsequent settlement: time of LIS update
70	FORZPA	☐	FORZPA	FORZP	CHAR	1	0	Time at which updating is carried out
71	FOART	☐	FOART_NA	XFELD	CHAR	1	0	Subsequent settlement: update type (scale/condition basis)
72	KRUEK	☐	KRUEK	XFELD	CHAR	1	0	Condition is Relevant for Accrual (e.g. Freight)
73	ABPAR	☐	WABPAR	WABPAR	CHAR	1	0	Indicator for type of settlement partner (vendor/customer)
74	.INCLUDE	☐				0	0	Enhancement of MCKONA through MMS
75	SEKORG	☐	MCW_SEKORG	EKORG	CHAR	4	0	Master data: purchasing organization (Retail)	T024E
76	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
77	BTRKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
78	EKSGB	☐	EKSGB	EKSGB	CHAR	4	0	Purchasing area	T026
79	ABTNR	☐	ABTNR	ABTNR	CHAR	4	0	Department number	TSAB
80	WGRU2	☐	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
81	WGRU1	☐	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
82	LAND1	☐	MCW_LANDLF	LAND1	CHAR	3	0	Country of vendor	T005
83	WRKGR2	☐	MCW_WRKGR2	KLASSE	CHAR	18	0	Plant group hierarchy 2
84	WRKGR1	☐	MCW_WRKGR1	KLASSE	CHAR	18	0	Plant group hierarchy 1
85	WKUNNR	☐	KUNNR_WK	KUNNR	CHAR	10	0	Customer number of plant	KNA1
86	.INCLUDE	☐				0	0	Additional Data: External Data Transfer
87	BBBNR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
88	BBSNR	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
89	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
90	ILNNR	☐	ILNNR	NUM13	NUMC	13	0	International location number (total)
91	.INCLUDE	☐				0	0	User Structure: Condition Statistics, Purchasing
92	DUMMYUSR	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCKONA	ABSPW	TCURC	WAERS
2	MCKONA	ABTNR	TSAB	ABTNR
3	MCKONA	BZIRK	T171	BZIRK
4	MCKONA	EKGRP	T024	EKGRP
5	MCKONA	EKORG	T024E	EKORG
6	MCKONA	EKSGB	T026	EKSGB
7	MCKONA	GEWEI	T006	MSEHI
8	MCKONA	HWAER	TCURC	WAERS
9	MCKONA	KNUMA	KONA	KNUMA
10	MCKONA	KONMS	T006	MSEHI
11	MCKONA	KONWA	TCURC	WAERS
12	MCKONA	KONWS	TCURC	WAERS
13	MCKONA	KUNRE	KNA1	KUNNR	KEY
14	MCKONA	LAND1	T005	LAND1
15	MCKONA	LIFNR	LFA1	LIFNR
16	MCKONA	MATKL	T023	MATKL
17	MCKONA	MEINS	T006	MSEHI
18	MCKONA	PUNEI	T006	MSEHI
19	MCKONA	SEKORG	T024E	EKORG
20	MCKONA	SPART	TSPA	SPART	KEY
21	MCKONA	STAFO	TMCB	STAFO
22	MCKONA	VKORG	TVKO	VKORG
23	MCKONA	VOLEH	T006	MSEHI
24	MCKONA	VTWEG	TVTW	VTWEG
25	MCKONA	WERKS	T001W	WERKS
26	MCKONA	WKUNNR	KNA1	KUNNR

History

Last changed by/on	SAP	20130529
SAP Release Created in