SAP ABAP Table MCVBAPWWS (IS-R Enhancements to MCVBAP)

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

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	ABTNR	☐	ABTNR	ABTNR	CHAR	4	0	Department number	TSAB
9	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
10	SWGRU1	☐	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
11	SWGRU2	☐	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
12	MERK1	☐	MCW_MERK1	ATWRT	CHAR	30	0	Characteristic 1
13	MERK2	☐	MCW_MERK2	ATWRT	CHAR	30	0	Characteristic 2
14	MERK3	☐	MCW_MERK3	ATWRT	CHAR	30	0	Characteristic 3
15	AKTYP	☐	W_AKTYP	AKTTY	CHAR	4	0	Promotion Category	TWTY
16	AKTHE	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
17	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
18	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
19	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
20	BWVOR	☐	BWVOR	BWVOR	CHAR	1	0	Procurement rule	T6WP1
21	BWSCL	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	TMBW1
22	SERVG	☐	W_SERVGRD	W_SERVGRD	CHAR	1	0	IS-R service level	TWSG
23	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
24	LAND1	☐	MCW_LANDRL	LAND1	CHAR	3	0	Country of regular vendor	T005
25	WRKGR2	☐	MCW_WRKGR2	KLASSE	CHAR	18	0	Plant group hierarchy 2
26	WRKGR1	☐	MCW_WRKGR1	KLASSE	CHAR	18	0	Plant group hierarchy 1
27	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
28	WMAKG	☐	WMAK	WMAK	CHAR	1	0	Material type ID
29	ASCAR	☐	ASORT	ASORT	CHAR	10	0	Assortment	*
30	SVKORG	☐	MCW_SVKORG	VKORG	CHAR	4	0	Master data: sales organization (Retail)	TVKO
31	SVTWEG	☐	MCW_SVTWEG	VTWEG	CHAR	2	0	Master data: distribution channel (Retail)	TVTW
32	SBZIRK	☐	MCW_SBZIRK	BZIRK	CHAR	6	0	Master data: customer district (Retail)	T171
33	SMATKL	☐	MCW_SMATKL	MATKL	CHAR	9	0	Master data: material group (Retail)	T023
34	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
35	KOLIF	☐	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	*
36	ATINM1	☐	MCW_ATINM1	ATINN	NUMC	10	0	Internal characteristic number, characteristic 1	*
37	ATINM2	☐	MCW_ATINM2	ATINN	NUMC	10	0	Internal characteristic number, characteristic 2	*
38	ATINM3	☐	MCW_ATINM3	ATINN	NUMC	10	0	Internal characteristic number, characteristic 3	*
39	STRNR	☐	STRNR	MATNR	CHAR	18	0	Structured material	MARA
40	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
41	SEAN11	☐	SEAN11	EAN11	CHAR	18	0	European article number (master data)
42	KAVMNG	☐	MCW_KAVMNG	MENGV15_3	QUAN	15	3	Sales order volume quantity
43	KAVGEO	☐	MCW_KAVGEO	WERTV10	CURR	19	2	Sales order volume at cost
44	KAVGVO	☐	MCW_KAVGVO	WERTV10	CURR	19	2	Sales order volume at retail
45	KAVGVP	☐	MCW_KAVGVP	WERTV10	CURR	19	2	Sales order volume at retail with tax
46	KAVGEW	☐	MCW_KAVGEW	MENGV15_3	QUAN	15	3	Sales order volume weight
47	KAVVOL	☐	MCW_KAVVOL	MENGV15_3	QUAN	15	3	Sales order volume volume
48	WKUNNR	☐	KUNNR_WK	KUNNR	CHAR	10	0	Customer number of plant	KNA1
49	RPLREL	☐	WRPL_RELEV	BOOLE	CHAR	1	0	ID: relevant for Replenishment?
50	BIWMNG	☐	MCW_BIWMNG	MENGV15_3	QUAN	15	3	RIS/Reporting Server - Transfer base quantity
51	BIWMVE	☐	MCW_BIWMVE	MENGV15_3	QUAN	15	3	RIS/Reporting Server - Transfer quantity sold
52	BIWGEO	☐	MCW_BIWGEO	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer cost price
53	BIWGVO	☐	MCW_BIWGVO	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer retail price
54	BIWGVP	☐	MCW_BIWGVP	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer retail price with tax
55	BWVORG	☐	MCW_BWVORG	NUM3	NUMC	3	0	SAP BW transaction key
56	ADDMNG	☐	MCW_ADDMNG	MENGV15_3	QUAN	15	3	Quantity of materials with additionals in base unit of meas.
57	ADDANZ	☐	MCW_ADDANZ	MCZAEHLINT	INT4	10	0	Number of affixed additionals
58	ADDTIM	☐	MCW_ADDTIM	DEC17_5	DEC	17	5	Processing time to affix the additionals
59	ADDKMW	☐	MCW_ADDKMW	WERTV10	CURR	19	2	Material costs of additionals
60	ADDKAL	☐	MCW_ADDKAL	WERTV10	CURR	19	2	Handling costs for additionals
61	ADDIAPPL	☐	ADDI_APPL	ADDI_APPL	CHAR	2	0	Application for triggering follow-up actions for additionals
62	ADDI1	☐	MCW_ADDI1	MATNR	CHAR	18	0	Additional 1	*
63	ADDI2	☐	MCW_ADDI2	MATNR	CHAR	18	0	Additional 2	*
64	ADDI3	☐	MCW_ADDI3	MATNR	CHAR	18	0	Additional 3	*
65	HSUPKZ	☐	MCW_SUPKZ	SUPKZ	CHAR	1	0	Auxiliary statistics update indicator
66	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	MCVBAPWWS	ABTNR	TSAB	ABTNR
2	MCVBAPWWS	AKTHE	TWAT	AKTHE
3	MCVBAPWWS	AKTYP	TWTY	AKTYP
4	MCVBAPWWS	BWSCL	TMBW1	BWSCL
5	MCVBAPWWS	BWVOR	T6WP1	BWVOR
6	MCVBAPWWS	DISPO	T024D	DISPO
7	MCVBAPWWS	EKGRP	T024	EKGRP
8	MCVBAPWWS	EKORG	T024E	EKORG
9	MCVBAPWWS	EKSGB	T026	EKSGB
10	MCVBAPWWS	LAND1	T005	LAND1
11	MCVBAPWWS	LIFNR	LFA1	LIFNR
12	MCVBAPWWS	LTSNR	WYT1	LTSNR
13	MCVBAPWWS	MTART	T134	MTART
14	MCVBAPWWS	PLGTP	TWPT	PLGTP
15	MCVBAPWWS	PRDHA	T179	PRODH
16	MCVBAPWWS	SAISO	T6WSP	SAISO
17	MCVBAPWWS	SATNR	MARA	MATNR
18	MCVBAPWWS	SBZIRK	T171	BZIRK
19	MCVBAPWWS	SERVG	TWSG	SERVG
20	MCVBAPWWS	SMATKL	T023	MATKL
21	MCVBAPWWS	STRNR	MARA	MATNR
22	MCVBAPWWS	SVKORG	TVKO	VKORG
23	MCVBAPWWS	SVTWEG	TVTW	VTWEG
24	MCVBAPWWS	WKUNNR	KNA1	KUNNR

History

Last changed by/on	SAP	20110901
SAP Release Created in