SAP ABAP Table MCUSEGWWS (MCUSEG Enhancement by 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	MCUSEGWWS	Table Relationship Diagram
Short Description	MCUSEG Enhancement by 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	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
2	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
3	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
4	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
5	EKSGB	☐	EKSGB	EKSGB	CHAR	4	0	Purchasing area	T026
6	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
7	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
8	LTSNR	☐	LTSNR	LTSNR	CHAR	6	0	Vendor Subrange	WYT1
9	BTRKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
10	ABTNR	☐	ABTNR	ABTNR	CHAR	4	0	Department number	TSAB
11	WGRU2	☐	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
12	WGRU1	☐	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
13	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
14	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
15	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
16	MERK1	☐	MCW_MERK1	ATWRT	CHAR	30	0	Characteristic 1
17	MERK2	☐	MCW_MERK2	ATWRT	CHAR	30	0	Characteristic 2
18	MERK3	☐	MCW_MERK3	ATWRT	CHAR	30	0	Characteristic 3
19	AKTYP	☐	W_AKTYP	AKTTY	CHAR	4	0	Promotion Category	TWTY
20	AKTHE	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
21	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
22	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
23	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
24	BWVOR	☐	BWVOR	BWVOR	CHAR	1	0	Procurement rule	T6WP1
25	BWSCL	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	T6WP2
26	SERVG	☐	W_SERVGRD	W_SERVGRD	CHAR	1	0	IS-R service level	TWSG
27	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
28	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
29	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
30	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
31	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
32	LIFNR	☐	MCW_RLIFN	LIFNR	CHAR	10	0	Account number of regular vendor	LFA1
33	LAND1	☐	MCW_LANDRL	LAND1	CHAR	3	0	Country of regular vendor	T005
34	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
35	WMAKG	☐	WMAK	WMAK	CHAR	1	0	Material type ID
36	WRKGR2	☐	MCW_WRKGR2	KLASSE	CHAR	18	0	Plant group hierarchy 2
37	WRKGR1	☐	MCW_WRKGR1	KLASSE	CHAR	18	0	Plant group hierarchy 1
38	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
39	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
40	KOLIF	☐	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	LFA1
41	ATINM1	☐	MCW_ATINM1	ATINN	NUMC	10	0	Internal characteristic number, characteristic 1	*
42	ATINM2	☐	MCW_ATINM2	ATINN	NUMC	10	0	Internal characteristic number, characteristic 2	*
43	ATINM3	☐	MCW_ATINM3	ATINN	NUMC	10	0	Internal characteristic number, characteristic 3	*
44	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
45	STRNR	☐	STRNR	MATNR	CHAR	18	0	Structured material	MARA
46	UBPEPM	☐	MCW_UBPEPM	MENGV15_3	QUAN	15	3	Revaluation at cost, plus, quantity
47	UBPGEO	☐	MCW_UBPGEO	WERTV10	CURR	19	2	Revaluation at cost, plus
48	UBMEPM	☐	MCW_UBMEPM	MENGV15_3	QUAN	15	3	Revaluation at cost minus, quantity
49	UBMGEO	☐	MCW_UBMGEO	WERTV10	CURR	19	2	Revaluation at cost, minus
50	UBPVPM	☐	MCW_UBPVPM	MENGV15_3	QUAN	15	3	Revaluation at retail, plus, quantity
51	UBPGVO	☐	MCW_UBPGVO	WERTV10	CURR	19	2	Revaluation at retail, plus
52	UBPGVP	☐	MCW_UBPGVP	WERTV10	CURR	19	2	Revaluation at retail, plus, at retail with tax
53	UBMVPM	☐	MCW_UBMVPM	MENGV15_3	QUAN	15	3	Revaluation at retail, minus, quantity
54	UBMGVO	☐	MCW_UBMGVO	WERTV10	CURR	19	2	Revaluation at retail, minus
55	UBMGVP	☐	MCW_UBMGVP	WERTV10	CURR	19	2	Revaluation at retail, minus, at retail with tax
56	ABGGEO	☐	MCW_ABGGEO	WERTV10	CURR	19	2	Issues at cost
57	ABGGVO	☐	MCW_ABGGVO	WERTV10	CURR	19	2	Issues at retail
58	ABGGVP	☐	MCW_ABGGVP	WERTV10	CURR	19	2	Issues at retail with tax
59	ZUGGEO	☐	MCW_ZUGGEO	WERTV10	CURR	19	2	Receipts at cost
60	ZUGGVO	☐	MCW_ZUGGVO	WERTV10	CURR	19	2	Receipts at retail
61	ZUGGVP	☐	MCW_ZUGGVP	WERTV10	CURR	19	2	Receipts at retail with tax
62	DPFLG	☐	MCW_DPFLAG	XFELD	CHAR	1	0	Indicator: duplicated record
63	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
64	WKUNNR	☐	KUNNR_WK	KUNNR	CHAR	10	0	Customer number of plant	KNA1
65	BIWMNG	☐	MCW_BIWMNG	MENGV15_3	QUAN	15	3	RIS/Reporting Server - Transfer base quantity
66	BIWMVE	☐	MCW_BIWMVE	MENGV15_3	QUAN	15	3	RIS/Reporting Server - Transfer quantity sold
67	BIWGEO	☐	MCW_BIWGEO	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer cost price
68	BIWGVO	☐	MCW_BIWGVO	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer retail price
69	BIWGVP	☐	MCW_BIWGVP	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer retail price with tax
70	BRELEV	☐	MCW_BRELEV	MCW_BRELEV	CHAR	1	0	RIS/Reporting Server - stock relevance
71	NEUAUF_BEW	☐	NEUAUF_BEW	CHAR1	CHAR	1	0	Indicator: Statistical setup - Inventory Controlling
72	BWVORG	☐	MCW_BWVORG	NUM3	NUMC	3	0	SAP BW transaction key
73	.INCLUDE	☐				0	0	IS-R Enhancements to MCUSEG: Additional MAC Fields
74	.INCLUDE	☐				0	0	Characteristic Enhancement for MAC (all Comm. Structures)
75	FILGRP	☐	WISP_FILGRP	WISP_FILGRP	NUMC	2	0	Store Group	TWISPC_FILGRP
76	PSWAE	☐	WISP_PSWAE	WAERS	CUKY	5	0	Database Currency for Planning Data in a Planning Scenario	TCURC
77	PLMHT	☐	WISP_PLMHT	MEINS	UNIT	3	0	Planned Unit of Measure	T006
78	ASORT	☐	ASORT	ASORT	CHAR	10	0	Assortment	WRS1
79	.INCLUDE	☐				0	0	MAC Char. Enhancements: Only Changes to Retail Price
80	AVGW1	☐	WISP_AVGW1	WAERS	CUKY	5	0	Memory Currency 1 in Currency Fields for Average Retail	TCURC
81	AVGW2	☐	WISP_AVGW2	WAERS	CUKY	5	0	Memory Currency 2 for Currency Fields for Average Retail	TCURC

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in