SAP ABAP Table MCVBRPWWS (Enhancements MCVBRP 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	MCVBRPWWS	Table Relationship Diagram
Short Description	Enhancements MCVBRP 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	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	LFA1
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	UMSMNG	☐	MCW_UMSMNG	MENGV15_3	QUAN	15	3	Sales quantity in base unit of measure
43	UMSGEO	☐	MCW_UMSGEO	WERTV10	CURR	19	2	Sales at cost
44	UMSGVO	☐	MCW_UMSGVO	WERTV10	CURR	19	2	Sales at retail
45	UMSGVP	☐	MCW_UMSGVP	WERTV10	CURR	19	2	Sales at retail with tax
46	PRSNLS	☐	MCW_PRSNLS	WERTV10	CURR	19	2	Sales deviation during sales
47	WKUNNR	☐	KUNNR_WK	KUNNR	CHAR	10	0	Customer number of plant	KNA1
48	BIWMNG	☐	MCW_BIWMNG	MENGV15_3	QUAN	15	3	RIS/Reporting Server - Transfer base quantity
49	BIWMVE	☐	MCW_BIWMVE	MENGV15_3	QUAN	15	3	RIS/Reporting Server - Transfer quantity sold
50	BIWGEO	☐	MCW_BIWGEO	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer cost price
51	BIWGVO	☐	MCW_BIWGVO	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer retail price
52	BIWGVP	☐	MCW_BIWGVP	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer retail price with tax
53	BIWPNL	☐	MCW_BIWPNL	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer price reduction
54	BWVORG	☐	MCW_BWVORG	NUM3	NUMC	3	0	SAP BW transaction key
55	HSUPKZ	☐	MCW_SUPKZ	SUPKZ	CHAR	1	0	Auxiliary statistics update indicator
56	HERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
57	.INCLUDE	☐				0	0	IS-R Enhancements to MCVBRP: Additional MAC Fields
58	.INCLUDE	☐				0	0	Characteristic Enhancement for MAC (all Comm. Structures)
59	FILGRP	☐	WISP_FILGRP	WISP_FILGRP	NUMC	2	0	Store Group	TWISPC_FILGRP
60	PSWAE	☐	WISP_PSWAE	WAERS	CUKY	5	0	Database Currency for Planning Data in a Planning Scenario	TCURC
61	PLMHT	☐	WISP_PLMHT	MEINS	UNIT	3	0	Planned Unit of Measure	T006
62	ASORT	☐	ASORT	ASORT	CHAR	10	0	Assortment	WRS1
63	.INCLUDE	☐				0	0	MAC Char. Enhancement: Only VD (Invoice)
64	AVGW1	☐	WISP_AVGW1	WAERS	CUKY	5	0	Memory Currency 1 in Currency Fields for Average Retail	TCURC
65	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	MCVBRPWWS	ABTNR	TSAB	ABTNR
2	MCVBRPWWS	AKTHE	TWAT	AKTHE
3	MCVBRPWWS	AKTYP	TWTY	AKTYP
4	MCVBRPWWS	ASORT	WRS1	ASORT
5	MCVBRPWWS	AVGW1	TCURC	WAERS
6	MCVBRPWWS	AVGW2	TCURC	WAERS
7	MCVBRPWWS	BWSCL	TMBW1	BWSCL
8	MCVBRPWWS	BWVOR	T6WP1	BWVOR
9	MCVBRPWWS	DISPO	T024D	DISPO
10	MCVBRPWWS	EKGRP	T024	EKGRP
11	MCVBRPWWS	EKORG	T024E	EKORG
12	MCVBRPWWS	EKSGB	T026	EKSGB
13	MCVBRPWWS	FILGRP	TWISPC_FILGRP	FILGRP
14	MCVBRPWWS	KOLIF	LFA1	LIFNR
15	MCVBRPWWS	LAND1	T005	LAND1
16	MCVBRPWWS	LIFNR	LFA1	LIFNR
17	MCVBRPWWS	LTSNR	WYT1	LTSNR
18	MCVBRPWWS	MTART	T134	MTART
19	MCVBRPWWS	PLGTP	TWPT	PLGTP
20	MCVBRPWWS	PLMHT	T006	MSEHI
21	MCVBRPWWS	PRDHA	T179	PRODH
22	MCVBRPWWS	PSWAE	TCURC	WAERS
23	MCVBRPWWS	SAISO	T6WSP	SAISO
24	MCVBRPWWS	SATNR	MARA	MATNR
25	MCVBRPWWS	SBZIRK	T171	BZIRK
26	MCVBRPWWS	SERVG	TWSG	SERVG
27	MCVBRPWWS	SMATKL	T023	MATKL
28	MCVBRPWWS	STRNR	MARA	MATNR
29	MCVBRPWWS	SVKORG	TVKO	VKORG
30	MCVBRPWWS	SVTWEG	TVTW	VTWEG
31	MCVBRPWWS	WKUNNR	KNA1	KUNNR

History

Last changed by/on	SAP	20110901
SAP Release Created in