SAP ABAP Table MCKONA_OLD (Communication Structure: Subsequent Settlement: Release 3.0)

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_OLD	Table Relationship Diagram
Short Description	Communication Structure: Subsequent Settlement: Release 3.0

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	KNUMA	☐	KNUMA	KNUMA	CHAR	10	0	Agreement (various conditions grouped together)	*
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
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)	*
7	KAWRT	☐	MC_BOUHW	WERTV8	CURR	15	2	Vendor business volume: value in rebate arrangement currency
8	WAERS	☐	BSTWA	WAERS	CUKY	5	0	Purchase order currency	*
9	KKURS	☐	KKURS	KKURS	DEC	9	5	Condition exchange rate for conversion to local currency
10	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
11	BOLIF	☐	BOGEW	LIFNR	CHAR	10	0	Condition granter	*
12	DATBI	☐	MC_DATBI	DATUM	DATS	8	0	End date of validity period of an arrangement
13	ABSPW	☐	ABSPW	WAERS	CUKY	5	0	Currency of rebate arrangement	*
14	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
15	AKURS	☐	AKURS_D	KKURS	DEC	9	5	Exch. rate: translation of loc. curr. into arrangement curr.
16	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
17	AGWRT	☐	MC_AGWRT	WERTV10	CURR	19	2	Rebate income from final settlement
18	AUWRT	☐	MC_BOERT	WERTV10	CURR	19	2	Rebate income from settlement w. regard to condition record
19	RUWRT	☐	MC_BORUW	WERTV10	CURR	19	2	Provision for accrued condition income
20	RRWRT	☐	MC_BORRW	WERTV10	CURR	19	2	Dissolved (reversed) provision for accrued condition income
21	BONBA	☐	MC_BOUHW	WERTV8	CURR	15	2	Vendor business volume: value in rebate arrangement currency
22	MENGE	☐	MC_BOMNG	MENGV13	QUAN	13	3	Vendor business volume: quantity in condition unit
23	BELNR	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
24	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
25	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
26	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
27	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
28	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
29	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
30	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
31	BRGEW	☐	MC_BOBRGEW	MENGV15_3	QUAN	15	3	Vendor business volume: gross weight (subsequent settlement)
32	NTGEW	☐	MC_BONTGEW	MENGV15_3	QUAN	15	3	Vendor business volume: net weight (subsequent settlement)
33	VOLUM	☐	MC_BOVOLUM	MENGV15_3	QUAN	15	3	Vendor business volume: physical volume (subseq. settlement)
34	ANZPU	☐	MC_BOANZPU	MENGV13	QUAN	13	3	Vendor business volume: no. of points (subseq. settlement)
35	PUNEI	☐	PUNEI	MEINS	UNIT	3	0	Points unit	T006
36	MEINS	☐	KVMEI	MEINS	UNIT	3	0	Condition unit in the document	T006
37	BOBAS	☐	BOBAS	BOBAS	CHAR	1	0	Settlement basis (for purchasing documents only)
38	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	TMCB
39	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
40	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
41	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
42	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	*
43	BTRKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
44	EKSGB	☐	EKSGB	EKSGB	CHAR	4	0	Purchasing area	*
45	ABTNR	☐	ABTNR	ABTNR	CHAR	4	0	Department number	*
46	WGRU2	☐	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
47	WGRU1	☐	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
48	LAND1	☐	MCW_LANDLF	LAND1	CHAR	3	0	Country of vendor	*
49	WRKGR2	☐	MCW_WRKGR2	KLASSE	CHAR	18	0	Plant group hierarchy 2
50	WRKGR1	☐	MCW_WRKGR1	KLASSE	CHAR	18	0	Plant group hierarchy 1
51	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_OLD	HWAER	TCURC	WAERS	KEY
2	MCKONA_OLD	MEINS	T006	MSEHI	KEY
3	MCKONA_OLD	PUNEI	T006	MSEHI	KEY
4	MCKONA_OLD	STAFO	TMCB	STAFO	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in