SAP ABAP Table MCISEGWWS (IS-R Enhancements to MCISEG)

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	MCISEGWWS	Table Relationship Diagram
Short Description	IS-R Enhancements to MCISEG

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	LANDLF	☐	MCW_LANDLF	LAND1	CHAR	3	0	Country of vendor	T005
33	RLIFN	☐	MCW_RLIFN	LIFNR	CHAR	10	0	Account number of regular vendor	LFA1
34	LAND1	☐	MCW_LANDRL	LAND1	CHAR	3	0	Country of regular vendor	T005
35	RLTSNR	☐	MCW_LTSNR	LTSNR	CHAR	6	0	Vendor sub-range at regular vendor	*
36	RIDNLF	☐	MCW_IDNLF	IDNEX	CHAR	35	0	Material number at regular vendor
37	RKOLIF	☐	MCW_KOLIF	LIFNR	CHAR	10	0	Prior vendor of regular vendor	*
38	WMINR	☐	WMINR	WMINR	CHAR	10	0	Product catalog number	WWMI
39	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
40	WMAKG	☐	WMAK	WMAK	CHAR	1	0	Material type ID
41	WRKGR2	☐	MCW_WRKGR2	KLASSE	CHAR	18	0	Plant group hierarchy 2
42	WRKGR1	☐	MCW_WRKGR1	KLASSE	CHAR	18	0	Plant group hierarchy 1
43	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
44	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
45	KOLIF	☐	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	LFA1
46	ATINM1	☐	MCW_ATINM1	ATINN	NUMC	10	0	Internal characteristic number, characteristic 1	*
47	ATINM2	☐	MCW_ATINM2	ATINN	NUMC	10	0	Internal characteristic number, characteristic 2	*
48	ATINM3	☐	MCW_ATINM3	ATINN	NUMC	10	0	Internal characteristic number, characteristic 3	*
49	STRNR	☐	STRNR	MATNR	CHAR	18	0	Structured material	MARA
50	WKUNNR	☐	KUNNR_WK	KUNNR	CHAR	10	0	Customer number of plant	KNA1
51	IBUMNG	☐	MCW_IBUMNG	MENGV15_3	QUAN	15	3	Book inventory balance, quantity in base unit of measure
52	IBUGEO	☐	MCW_IBUGEO	WERTV9	CURR	17	2	Book inventory balance at cost
53	IBUGVO	☐	MCW_IBUGVO	WERTV9	CURR	17	2	Book inventory balance at retail
54	IBUGVP	☐	MCW_IBUGVP	WERTV9	CURR	17	2	Book inventory balance at retail with tax
55	IZLMNG	☐	MCW_IZLMNG	MENGV15_3	QUAN	15	3	Quantity of stock, counted in base unit of measure
56	IZLGEO	☐	MCW_IZLGEO	WERTV9	CURR	17	2	Quantity of stock counted at cost
57	IZLGVO	☐	MCW_IZLGVO	WERTV9	CURR	17	2	Quantity of stock counted at retail
58	IZLGVP	☐	MCW_IZLGVP	WERTV9	CURR	17	2	Quantity of stock counted at retail with tax
59	IDPMNG	☐	MCW_IDPMNG	MENGV15_3	QUAN	15	3	Plus inventory difference quantity in BUn
60	IDPGEO	☐	MCW_IDPGEO	WERTV9	CURR	17	2	Plus inventory difference at cost
61	IDPGVO	☐	MCW_IDPGVO	WERTV9	CURR	17	2	Plus inventory difference at retail
62	IDPGVP	☐	MCW_IDPGVP	WERTV9	CURR	17	2	Plus inventory difference at retail with tax
63	IDMMNG	☐	MCW_IDMMNG	MENGV15_3	QUAN	15	3	Minus inventory difference quantity in BUn
64	IDMGEO	☐	MCW_IDMGEO	WERTV9	CURR	17	2	Minus inventory difference at cost
65	IDMGVO	☐	MCW_IDMGVO	WERTV9	CURR	17	2	Minus inventory difference at retail
66	IDMGVP	☐	MCW_IDMGVP	WERTV9	CURR	17	2	Minus inventory difference at retail
67	IVSTAT	☐	IVSTATUS	IVSTATUS	NUMC	2	0	Statistical status of physical inventory

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in