SAP ABAP Table MCEKPOWWS (Enhancements MCEKPO through IS-R)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-RIS (Application Component) Retail Information System (RIS)
     ⤷ MCW (Package) R/3 application development: Retail Information System

Basic Data

Table Category	INTTAB	Structure
Structure	MCEKPOWWS	Table Relationship Diagram
Short Description	Enhancements MCEKPO through IS-R

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	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
2	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
3	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
4	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
5	BTRKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
6	ABTNR	☐	ABTNR	ABTNR	CHAR	4	0	Department number	TSAB
7	WGRU2	☐	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
8	WGRU1	☐	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
9	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
10	MERK1	☐	MCW_MERK1	ATWRT	CHAR	30	0	Characteristic 1
11	MERK2	☐	MCW_MERK2	ATWRT	CHAR	30	0	Characteristic 2
12	MERK3	☐	MCW_MERK3	ATWRT	CHAR	30	0	Characteristic 3
13	AKTYP	☐	W_AKTYP	AKTTY	CHAR	4	0	Promotion Category	TWTY
14	AKTHE	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
15	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
16	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
17	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
18	BWVOR	☐	BWVOR	BWVOR	CHAR	1	0	Procurement rule	T6WP1
19	BWSCL	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	T6WP2
20	SERVG	☐	W_SERVGRD	W_SERVGRD	CHAR	1	0	IS-R service level	TWSG
21	WRKGR2	☐	MCW_WRKGR2	KLASSE	CHAR	18	0	Plant group hierarchy 2
22	WRKGR1	☐	MCW_WRKGR1	KLASSE	CHAR	18	0	Plant group hierarchy 1
23	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
24	WMAKG	☐	WMAK	WMAK	CHAR	1	0	Material type ID
25	RLIFNR	☐	MCW_RLIFN	LIFNR	CHAR	10	0	Account number of regular vendor	LFA1
26	LAND1	☐	MCW_LANDRL	LAND1	CHAR	3	0	Country of regular vendor	T005
27	RLTSNR	☐	MCW_LTSNR	LTSNR	CHAR	6	0	Vendor sub-range at regular vendor	*
28	RKOLIF	☐	MCW_KOLIF	LIFNR	CHAR	10	0	Prior vendor of regular vendor	*
29	RIDNLF	☐	MCW_IDNLF	IDNEX	CHAR	35	0	Material number at regular vendor
30	EKORG	☐	MCW_SEKORG	EKORG	CHAR	4	0	Master data: purchasing organization (Retail)	T024E
31	EKSGB	☐	EKSGB	EKSGB	CHAR	4	0	Purchasing area	T026
32	EKGRP	☐	MCW_SEKGRP	EKGRP	CHAR	3	0	Master data: purchasing group (Retail)	T024
33	SMATKL	☐	MCW_SMATKL	MATKL	CHAR	9	0	Master data: material group (Retail)	T023
34	SEAN11	☐	SEAN11	EAN11	CHAR	18	0	European article number (master data)
35	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
36	KOLIF	☐	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	LFA1
37	ATINM1	☐	MCW_ATINM1	ATINN	NUMC	10	0	Internal characteristic number, characteristic 1	*
38	ATINM2	☐	MCW_ATINM2	ATINN	NUMC	10	0	Internal characteristic number, characteristic 2	*
39	ATINM3	☐	MCW_ATINM3	ATINN	NUMC	10	0	Internal characteristic number, characteristic 3	*
40	ULEKGRP	☐	MCW_SEKGRP	EKGRP	CHAR	3	0	Master data: purchasing group (Retail)	T024
41	ULEKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
42	ULVKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
43	ULVTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
44	ULBZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
45	ULBTRKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
46	STRNR	☐	STRNR	MATNR	CHAR	18	0	Structured material	MARA
47	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
48	SSTUF	☐	SSTUF	SSTUF	CHAR	2	0	Assortment grade	TWSS
49	BVLMNG	☐	MCW_BVLMNG	MENGV15_3	QUAN	15	3	Order volume quantity Retail
50	BVLGEO	☐	MCW_BVLGEO	WERTV10	CURR	19	2	Order volume at cost
51	BVLGVO	☐	MCW_BVLGVO	WERTV10	CURR	19	2	Order volume at retail
52	BVLGVP	☐	MCW_BVLGVP	WERTV10	CURR	19	2	Order volume at retail with tax
53	BVLGEW	☐	MCW_BVLGEW	MENGV15_3	QUAN	15	3	Order volume weight
54	BVLVOL	☐	MCW_BVLVOL	MENGV15_3	QUAN	15	3	Order volume volume
55	VKWRT	☐	VKWRT	WERT7	CURR	13	2	Value at sales prices including value-added tax
56	VKWRA	☐	VKWRT	WERT7	CURR	13	2	Value at sales prices including value-added tax
57	ABELN	☐	ABELN	ABELN	CHAR	10	0	Allocation Table Number	AUKO
58	WKUNNR	☐	KUNNR_WK	KUNNR	CHAR	10	0	Customer number of plant	KNA1
59	AUREL	☐	AUREL	AUREL	CHAR	1	0	Relevant to Allocation Table
60	RPLREL	☐	WRPL_RELEV	BOOLE	CHAR	1	0	ID: relevant for Replenishment?
61	ADDMNG	☐	MCW_ADDMNG	MENGV15_3	QUAN	15	3	Quantity of materials with additionals in base unit of meas.
62	ADDANZ	☐	MCW_ADDANZ	MCZAEHLINT	INT4	10	0	Number of affixed additionals
63	ADDTIM	☐	MCW_ADDTIM	DEC17_5	DEC	17	5	Processing time to affix the additionals
64	ADDKMW	☐	MCW_ADDKMW	WERTV10	CURR	19	2	Material costs of additionals
65	ADDKAL	☐	MCW_ADDKAL	WERTV10	CURR	19	2	Handling costs for additionals
66	ADDIAPPL	☐	ADDI_APPL	ADDI_APPL	CHAR	2	0	Application for triggering follow-up actions for additionals
67	ADDI1	☐	MCW_ADDI1	MATNR	CHAR	18	0	Additional 1	*
68	ADDI2	☐	MCW_ADDI2	MATNR	CHAR	18	0	Additional 2	*
69	ADDI3	☐	MCW_ADDI3	MATNR	CHAR	18	0	Additional 3	*
70	BWVORG	☐	MCW_BWVORG	NUM3	NUMC	3	0	SAP BW transaction key
71	.INCLUDE	☐				0	0	IS-R Enhancement to MCEKPO: Additional MAC Fields
72	.INCLUDE	☐				0	0	Characteristic Enhancement for MAC (all Comm. Structures)
73	FILGRP	☐	WISP_FILGRP	WISP_FILGRP	NUMC	2	0	Store Group	TWISPC_FILGRP
74	PSWAE	☐	WISP_PSWAE	WAERS	CUKY	5	0	Database Currency for Planning Data in a Planning Scenario	TCURC
75	PLMHT	☐	WISP_PLMHT	MEINS	UNIT	3	0	Planned Unit of Measure	T006
76	ASORT	☐	ASORT	ASORT	CHAR	10	0	Assortment	WRS1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCEKPOWWS	ABELN	AUKO	ABELN
2	MCEKPOWWS	ABTNR	TSAB	ABTNR
3	MCEKPOWWS	AKTHE	TWAT	AKTHE
4	MCEKPOWWS	AKTYP	TWTY	AKTYP
5	MCEKPOWWS	ASORT	WRS1	ASORT
6	MCEKPOWWS	BWSCL	T6WP2	BWSCL
7	MCEKPOWWS	BWVOR	T6WP1	BWVOR
8	MCEKPOWWS	BZIRK	T171	BZIRK
9	MCEKPOWWS	DISPO	T024D	DISPO
10	MCEKPOWWS	EKGRP	T024	EKGRP
11	MCEKPOWWS	EKORG	T024E	EKORG
12	MCEKPOWWS	EKSGB	T026	EKSGB
13	MCEKPOWWS	FILGRP	TWISPC_FILGRP	FILGRP
14	MCEKPOWWS	KOLIF	LFA1	LIFNR
15	MCEKPOWWS	LAND1	T005	LAND1
16	MCEKPOWWS	MTART	T134	MTART
17	MCEKPOWWS	PLGTP	TWPT	PLGTP
18	MCEKPOWWS	PLMHT	T006	MSEHI
19	MCEKPOWWS	PRDHA	T179	PRODH
20	MCEKPOWWS	PSWAE	TCURC	WAERS
21	MCEKPOWWS	RLIFNR	LFA1	LIFNR
22	MCEKPOWWS	SAISO	T6WSP	SAISO
23	MCEKPOWWS	SERVG	TWSG	SERVG
24	MCEKPOWWS	SMATKL	T023	MATKL
25	MCEKPOWWS	SSTUF	TWSS	SSTUF
26	MCEKPOWWS	STRNR	MARA	MATNR
27	MCEKPOWWS	ULBZIRK	T171	BZIRK
28	MCEKPOWWS	ULEKGRP	T024	EKGRP
29	MCEKPOWWS	ULEKORG	T024E	EKORG
30	MCEKPOWWS	ULVKORG	TVKO	VKORG
31	MCEKPOWWS	ULVTWEG	TVTW	VTWEG
32	MCEKPOWWS	VKORG	TVKO	VKORG
33	MCEKPOWWS	VTWEG	TVTW	VTWEG
34	MCEKPOWWS	WKUNNR	KNA1	KUNNR

History

Last changed by/on	SAP	20110901
SAP Release Created in