SAP ABAP Table MCLIPSWWS (MCLIPS Enhancements for 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	MCLIPSWWS	Table Relationship Diagram
Short Description	MCLIPS Enhancements for 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	EKSGB	☐	EKSGB	EKSGB	CHAR	4	0	Purchasing area	T026
3	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
4	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
5	LIFNR	☐	MCW_RLIFN	LIFNR	CHAR	10	0	Account number of regular vendor	LFA1
6	LTSNR	☐	LTSNR	LTSNR	CHAR	6	0	Vendor Subrange	WYT1
7	BTRKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
8	WGRU2	☐	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
9	WGRU1	☐	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
10	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
11	MERK1	☐	MCW_MERK1	ATWRT	CHAR	30	0	Characteristic 1
12	MERK2	☐	MCW_MERK2	ATWRT	CHAR	30	0	Characteristic 2
13	MERK3	☐	MCW_MERK3	ATWRT	CHAR	30	0	Characteristic 3
14	AKTYP	☐	W_AKTYP	AKTTY	CHAR	4	0	Promotion Category	TWTY
15	AKTHE	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
16	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
17	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
18	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
19	BWVOR	☐	BWVOR	BWVOR	CHAR	1	0	Procurement rule	T6WP1
20	BWSCL	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	TMBW1
21	SERVG	☐	W_SERVGRD	W_SERVGRD	CHAR	1	0	IS-R service level	TWSG
22	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
23	LAND1	☐	MCW_LANDRL	LAND1	CHAR	3	0	Country of regular vendor	T005
24	WRKGR2	☐	MCW_WRKGR2	KLASSE	CHAR	18	0	Plant group hierarchy 2
25	WRKGR1	☐	MCW_WRKGR1	KLASSE	CHAR	18	0	Plant group hierarchy 1
26	ASCAR	☐	ASORT	ASORT	CHAR	10	0	Assortment	*
27	SVKORG	☐	MCW_SVKORG	VKORG	CHAR	4	0	Master data: sales organization (Retail)	TVKO
28	SVTWEG	☐	MCW_SVTWEG	VTWEG	CHAR	2	0	Master data: distribution channel (Retail)	*
29	SBZIRK	☐	MCW_SBZIRK	BZIRK	CHAR	6	0	Master data: customer district (Retail)	T171
30	SMATKL	☐	MCW_SMATKL	MATKL	CHAR	9	0	Master data: material group (Retail)	T023
31	SABTNR	☐	MCW_SABTNR	ABTNR	CHAR	4	0	Retail master data department	TSAB
32	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
33	KOLIF	☐	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	LFA1
34	WMAKG	☐	WMAK	WMAK	CHAR	1	0	Material type ID
35	ATINM1	☐	MCW_ATINM1	ATINN	NUMC	10	0	Internal characteristic number, characteristic 1	*
36	ATINM2	☐	MCW_ATINM2	ATINN	NUMC	10	0	Internal characteristic number, characteristic 2	*
37	ATINM3	☐	MCW_ATINM3	ATINN	NUMC	10	0	Internal characteristic number, characteristic 3	*
38	STRNR	☐	STRNR	MATNR	CHAR	18	0	Structured material	MARA
39	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
40	SEAN11	☐	SEAN11	EAN11	CHAR	18	0	European article number (master data)
41	LIFMNG	☐	MCW_LIFMNG	MENGV15_3	QUAN	15	3	Deliveries to customers, quantity
42	LIFGEW	☐	MCW_LIFGEW	MENGV15_3	QUAN	15	3	Deliveries to customers, weight
43	LIFVOL	☐	MCW_LIFVOL	MENGV15_3	QUAN	15	3	Deliveries to customers, volume
44	WKUNNR	☐	KUNNR_WK	KUNNR	CHAR	10	0	Customer number of plant	KNA1
45	RPLREL	☐	WRPL_RELEV	BOOLE	CHAR	1	0	ID: relevant for Replenishment?
46	BIWMVE	☐	MCW_BIWMVE	MENGV15_3	QUAN	15	3	RIS/Reporting Server - Transfer quantity sold
47	BIWMNG	☐	MCW_BIWMNG	MENGV15_3	QUAN	15	3	RIS/Reporting Server - Transfer base quantity
48	BWVORG	☐	MCW_BWVORG	NUM3	NUMC	3	0	SAP BW transaction key
49	HSUPKZ	☐	MCW_SUPKZ	SUPKZ	CHAR	1	0	Auxiliary statistics update indicator
50	HERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCLIPSWWS	AKTHE	TWAT	AKTHE
2	MCLIPSWWS	AKTYP	TWTY	AKTYP
3	MCLIPSWWS	BWSCL	TMBW1	BWSCL
4	MCLIPSWWS	BWVOR	T6WP1	BWVOR
5	MCLIPSWWS	DISPO	T024D	DISPO
6	MCLIPSWWS	EKGRP	T024	EKGRP
7	MCLIPSWWS	EKORG	T024E	EKORG
8	MCLIPSWWS	EKSGB	T026	EKSGB
9	MCLIPSWWS	KOLIF	LFA1	LIFNR
10	MCLIPSWWS	LAND1	T005	LAND1
11	MCLIPSWWS	LIFNR	LFA1	LIFNR
12	MCLIPSWWS	LTSNR	WYT1	LTSNR
13	MCLIPSWWS	PLGTP	TWPT	PLGTP
14	MCLIPSWWS	PRDHA	T179	PRODH
15	MCLIPSWWS	SABTNR	TSAB	ABTNR
16	MCLIPSWWS	SAISO	T6WSP	SAISO
17	MCLIPSWWS	SATNR	MARA	MATNR
18	MCLIPSWWS	SBZIRK	T171	BZIRK
19	MCLIPSWWS	SERVG	TWSG	SERVG
20	MCLIPSWWS	SMATKL	T023	MATKL
21	MCLIPSWWS	STRNR	MARA	MATNR
22	MCLIPSWWS	SVKORG	TVKO	VKORG
23	MCLIPSWWS	WKUNNR	KNA1	KUNNR

History

Last changed by/on	SAP	20110901
SAP Release Created in