SAP ABAP Table MCKONAB (PURCHIS Communication Structure for KONA)

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	MCKONAB	Table Relationship Diagram
Short Description	PURCHIS Communication Structure for KONA

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

History

Last changed by/on	SAP	20130529
SAP Release Created in