SAP ABAP Table MCUSEG (Sales Price Change: Item Data)

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	MCUSEG	Table Relationship Diagram
Short Description	Sales Price Change: Item Data

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	.INCLUDE	☐				0	0	Retail Revaluation Document: Revaluation Segment
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	UBLNR	☐	UBLNR	UBLNR	CHAR	10	0	Retail revaluation document number	*
4	UBJAHR	☐	UBJAHR	GJAHR	NUMC	4	0	Retail revaluation: document year
5	UZEIL	☐	UZEIL	UZEIL	NUMC	4	0	Item number in retail revaluation document
6	UPSTA	☐	UPSTA	UPSTA	CHAR	1	0	Item status of retail revaluation document
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
9	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
11	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
12	MATBF	☐	MATBF	MATNR	CHAR	18	0	Material in Respect of Which Stock is Managed	MARA
13	PV_GRUND	☐	PV_GRUND	PV_GRUND	CHAR	4	0	Reason for retail price change	TWBN
14	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	MBEW
15	VPDAT	☐	VPDAT_D	DATUM	DATS	8	0	Date of retail price change
16	ENDPR	☐	ENDPR	WERTV6	CURR	11	2	Final price
17	VPNEU	☐	VPNEU	WERTV6	CURR	11	2	New retail price
18	VPALT	☐	VPALT	WERTV6	CURR	11	2	Old retail price
19	VRKPE	☐	VRKPE	DEC5	DEC	5	0	Sales price unit
20	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
21	VWAER	☐	VWAER	WAERS	CUKY	5	0	Sales currency	TCURC
22	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
23	VKLAB_OLD	☐	VKLAB	WERT13N	CURR	13	2	Stock value of a value-only material at sales price
24	VKLABN_OLD	☐	VKLAB_NET	WERT13N	CURR	13	2	Stock value of a value-only material at retail w/o tax
25	VKSAL_OLD	☐	VKSAL	WERT13N	CURR	13	2	Value of Total Valuated Stock at Sales Price
26	VKSALN_OLD	☐	VKSAL_NET	WERT13N	CURR	13	2	Total inventory value at retail without tax
27	VKSAD	☐	VKSALD	WERT13N	CURR	13	2	Difference Between New and Previous Stock Value
28	VKSADN	☐	VKSALD_NET	WERT13N	CURR	13	2	Difference in retail value without tax
29	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
30	ERFMG	☐	VKUMG	MENG13V	QUAN	13	3	Quantity in unit of entry for revaluation at retail
31	MENGE	☐	MENGV	MENG13V	QUAN	13	3	Quantity with +/- sign in base unit of measure
32	LBKUM	☐	LBKUM	MENG13V	QUAN	13	3	Total Valuated Stock
33	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
34	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
35	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
36	SPANN	☐	SPANN	XFELD	CHAR	1	0	Flag: not affecting margins
37	EKPA	☐	EKPA_D	WERT11	CURR	11	2	Old cost price
38	EKPN	☐	NPREI	WERT11	CURR	11	2	New Price
39	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
40	SALK3_OLD	☐	SALK3	WERT13N	CURR	13	2	Value of Total Valuated Stock
41	XIVNE	☐	XIVNE	XFELD	CHAR	1	0	Indicates that change in retail value does not affect stock
42	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
43	.INCLU--AP	☐				0	0	Data for Hybrid Method
44	.INCLUDE	☐				0	0	Data for Hybrid Method for Table USEG (Append)
45	.INCLUDE	☐				0	0	Result & Valuation Parameters for Purchase Val. Chg Profile
46	UAKT	☐	UAKT	PRICE_ORIG_CHG_TYPE	CHAR	2	0	Change Category of Sales Price Origin from Old to New Price
47	SALES_VAL_SIGN	☐	VALUE_CHANGE_SIGN	VALUE_CHANGE_SIGN	CHAR	1	0	Sign of Sales Value Change
48	AFFECT_COST_VAL	☐	AFFECT_COST_VAL_RESULT	AFFECT_COST_VAL_RESULT	CHAR	1	0	Adjust Cost Value (Result)
49	.INCLUDE	☐				0	0	History of Revaluation Document
50	VORGA_CREATE	☐	VKPU_VORGA	VKPU_VORGA	CHAR	1	0	Indicates the transaction triggering revaluation at retail
51	MOD_CREATE	☐	MODIFIER_COST_VAL	MODIFIER_COST_VAL	CHAR	1	0	Cost Value Changed By
52	TIME_CREATE	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
53	VORGA_CHANGE	☐	VKPU_VORGA	VKPU_VORGA	CHAR	1	0	Indicates the transaction triggering revaluation at retail
54	MOD_CHANGE	☐	MODIFIER_COST_VAL	MODIFIER_COST_VAL	CHAR	1	0	Cost Value Changed By
55	TIME_CHANGE	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
56	.INCLUDE	☐				0	0	MCUSEG Enhancement by IS-R
57	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
58	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
59	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
60	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
61	EKSGB	☐	EKSGB	EKSGB	CHAR	4	0	Purchasing area	T026
62	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
63	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
64	LTSNR	☐	LTSNR	LTSNR	CHAR	6	0	Vendor Subrange	WYT1
65	BTRKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
66	ABTNR	☐	ABTNR	ABTNR	CHAR	4	0	Department number	TSAB
67	WGRU2	☐	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
68	WGRU1	☐	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
69	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
70	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
71	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
72	MERK1	☐	MCW_MERK1	ATWRT	CHAR	30	0	Characteristic 1
73	MERK2	☐	MCW_MERK2	ATWRT	CHAR	30	0	Characteristic 2
74	MERK3	☐	MCW_MERK3	ATWRT	CHAR	30	0	Characteristic 3
75	AKTYP	☐	W_AKTYP	AKTTY	CHAR	4	0	Promotion Category	TWTY
76	AKTHE	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
77	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
78	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
79	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
80	BWVOR	☐	BWVOR	BWVOR	CHAR	1	0	Procurement rule	T6WP1
81	BWSCL	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	T6WP2
82	SERVG	☐	W_SERVGRD	W_SERVGRD	CHAR	1	0	IS-R service level	TWSG
83	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
84	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
85	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
86	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
87	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
88	LIFNR	☐	MCW_RLIFN	LIFNR	CHAR	10	0	Account number of regular vendor	LFA1
89	LAND1	☐	MCW_LANDRL	LAND1	CHAR	3	0	Country of regular vendor	T005
90	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
91	WMAKG	☐	WMAK	WMAK	CHAR	1	0	Material type ID
92	WRKGR2	☐	MCW_WRKGR2	KLASSE	CHAR	18	0	Plant group hierarchy 2
93	WRKGR1	☐	MCW_WRKGR1	KLASSE	CHAR	18	0	Plant group hierarchy 1
94	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
95	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
96	KOLIF	☐	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	LFA1
97	ATINM1	☐	MCW_ATINM1	ATINN	NUMC	10	0	Internal characteristic number, characteristic 1	*
98	ATINM2	☐	MCW_ATINM2	ATINN	NUMC	10	0	Internal characteristic number, characteristic 2	*
99	ATINM3	☐	MCW_ATINM3	ATINN	NUMC	10	0	Internal characteristic number, characteristic 3	*
100	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
101	STRNR	☐	STRNR	MATNR	CHAR	18	0	Structured material	MARA
102	UBPEPM	☐	MCW_UBPEPM	MENGV15_3	QUAN	15	3	Revaluation at cost, plus, quantity
103	UBPGEO	☐	MCW_UBPGEO	WERTV10	CURR	19	2	Revaluation at cost, plus
104	UBMEPM	☐	MCW_UBMEPM	MENGV15_3	QUAN	15	3	Revaluation at cost minus, quantity
105	UBMGEO	☐	MCW_UBMGEO	WERTV10	CURR	19	2	Revaluation at cost, minus
106	UBPVPM	☐	MCW_UBPVPM	MENGV15_3	QUAN	15	3	Revaluation at retail, plus, quantity
107	UBPGVO	☐	MCW_UBPGVO	WERTV10	CURR	19	2	Revaluation at retail, plus
108	UBPGVP	☐	MCW_UBPGVP	WERTV10	CURR	19	2	Revaluation at retail, plus, at retail with tax
109	UBMVPM	☐	MCW_UBMVPM	MENGV15_3	QUAN	15	3	Revaluation at retail, minus, quantity
110	UBMGVO	☐	MCW_UBMGVO	WERTV10	CURR	19	2	Revaluation at retail, minus
111	UBMGVP	☐	MCW_UBMGVP	WERTV10	CURR	19	2	Revaluation at retail, minus, at retail with tax
112	ABGGEO	☐	MCW_ABGGEO	WERTV10	CURR	19	2	Issues at cost
113	ABGGVO	☐	MCW_ABGGVO	WERTV10	CURR	19	2	Issues at retail
114	ABGGVP	☐	MCW_ABGGVP	WERTV10	CURR	19	2	Issues at retail with tax
115	ZUGGEO	☐	MCW_ZUGGEO	WERTV10	CURR	19	2	Receipts at cost
116	ZUGGVO	☐	MCW_ZUGGVO	WERTV10	CURR	19	2	Receipts at retail
117	ZUGGVP	☐	MCW_ZUGGVP	WERTV10	CURR	19	2	Receipts at retail with tax
118	DPFLG	☐	MCW_DPFLAG	XFELD	CHAR	1	0	Indicator: duplicated record
119	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
120	WKUNNR	☐	KUNNR_WK	KUNNR	CHAR	10	0	Customer number of plant	KNA1
121	BIWMNG	☐	MCW_BIWMNG	MENGV15_3	QUAN	15	3	RIS/Reporting Server - Transfer base quantity
122	BIWMVE	☐	MCW_BIWMVE	MENGV15_3	QUAN	15	3	RIS/Reporting Server - Transfer quantity sold
123	BIWGEO	☐	MCW_BIWGEO	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer cost price
124	BIWGVO	☐	MCW_BIWGVO	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer retail price
125	BIWGVP	☐	MCW_BIWGVP	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer retail price with tax
126	BRELEV	☐	MCW_BRELEV	MCW_BRELEV	CHAR	1	0	RIS/Reporting Server - stock relevance
127	NEUAUF_BEW	☐	NEUAUF_BEW	CHAR1	CHAR	1	0	Indicator: Statistical setup - Inventory Controlling
128	BWVORG	☐	MCW_BWVORG	NUM3	NUMC	3	0	SAP BW transaction key
129	.INCLUDE	☐				0	0	IS-R Enhancements to MCUSEG: Additional MAC Fields
130	.INCLUDE	☐				0	0	Characteristic Enhancement for MAC (all Comm. Structures)
131	FILGRP	☐	WISP_FILGRP	WISP_FILGRP	NUMC	2	0	Store Group	TWISPC_FILGRP
132	PSWAE	☐	WISP_PSWAE	WAERS	CUKY	5	0	Database Currency for Planning Data in a Planning Scenario	TCURC
133	PLMHT	☐	WISP_PLMHT	MEINS	UNIT	3	0	Planned Unit of Measure	T006
134	ASORT	☐	ASORT	ASORT	CHAR	10	0	Assortment	WRS1
135	.INCLUDE	☐				0	0	MAC Char. Enhancements: Only Changes to Retail Price
136	AVGW1	☐	WISP_AVGW1	WAERS	CUKY	5	0	Memory Currency 1 in Currency Fields for Average Retail	TCURC
137	AVGW2	☐	WISP_AVGW2	WAERS	CUKY	5	0	Memory Currency 2 for Currency Fields for Average Retail	TCURC
138	.INCLUDE	☐				0	0	User Structure: Sales Price Change Item Data
139	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
140	.INCLU--AP	☐				0	0	Append for BW Transfer
141	.INCLUDE	☐				0	0	Enhancement MCUSEG for BW Transfer
142	BWMNG	☐	MCBW_MNG	MENGV15_3	QUAN	15	3	BW: Quantity in Base Unit of Measure
143	BWMVE	☐	MCBW_MVE	MENGV15_3	QUAN	15	3	BW: Quantity in Sales Unit
144	BWGEO	☐	MCBW_GEO	WERTV10	CURR	19	2	BW: Cost Value in Local Currency
145	BWGVO	☐	MCBW_GVO	WERTV10	CURR	19	2	BW: Retail Value in Local Currency
146	BWGVP	☐	MCBW_GVP	WERTV10	CURR	19	2	BW: Retail Value with Tax in Local Currency
147	BWBREL	☐	MCBW_BREL	MCBW_BREL	CHAR	1	0	BW: Stock Relevance
148	BWAPPLNM	☐	RSAPPLNM	RSAPPLNM	CHAR	30	0	Application Component

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCUSEG	ABTNR	TSAB	ABTNR
2	MCUSEG	AKTHE	TWAT	AKTHE
3	MCUSEG	AKTNR	WAKH	AKTNR
4	MCUSEG	AKTYP	TWTY	AKTYP
5	MCUSEG	ASORT	WRS1	ASORT
6	MCUSEG	AVGW1	TCURC	WAERS
7	MCUSEG	AVGW2	TCURC	WAERS
8	MCUSEG	BUKRS	T001	BUKRS
9	MCUSEG	BWKEY	T001K	BWKEY
10	MCUSEG	BWSCL	T6WP2	BWSCL
11	MCUSEG	BWTAR	MBEW	BWTAR
12	MCUSEG	BWVOR	T6WP1	BWVOR
13	MCUSEG	BZIRK	T171	BZIRK
14	MCUSEG	DISPO	T024D	DISPO
15	MCUSEG	EKGRP	T024	EKGRP
16	MCUSEG	EKORG	T024E	EKORG
17	MCUSEG	EKSGB	T026	EKSGB
18	MCUSEG	ERFME	T006	MSEHI
19	MCUSEG	FILGRP	TWISPC_FILGRP	FILGRP
20	MCUSEG	GEWEI	T006	MSEHI
21	MCUSEG	HWAER	TCURC	WAERS
22	MCUSEG	KOLIF	LFA1	LIFNR
23	MCUSEG	LAND1	T005	LAND1
24	MCUSEG	LGORT	T001L	LGORT
25	MCUSEG	LIFNR	LFA1	LIFNR
26	MCUSEG	LTSNR	WYT1	LTSNR
27	MCUSEG	MANDT	T000	MANDT
28	MCUSEG	MATBF	MARA	MATNR
29	MCUSEG	MATKL	T023	MATKL
30	MCUSEG	MATNR	MARA	MATNR
31	MCUSEG	MEINS	T006	MSEHI
32	MCUSEG	MTART	T134	MTART
33	MCUSEG	PLGTP	TWPT	PLGTP
34	MCUSEG	PLMHT	T006	MSEHI
35	MCUSEG	PRDHA	T179	PRODH
36	MCUSEG	PSWAE	TCURC	WAERS
37	MCUSEG	PV_GRUND	TWBN	PV_GRUND
38	MCUSEG	SAISO	T6WSP	SAISO
39	MCUSEG	SATNR	MARA	MATNR
40	MCUSEG	SERVG	TWSG	SERVG
41	MCUSEG	STRNR	MARA	MATNR
42	MCUSEG	VKORG	TVKO	VKORG
43	MCUSEG	VOLEH	T006	MSEHI
44	MCUSEG	VRKME	T006	MSEHI
45	MCUSEG	VTWEG	TVTW	VTWEG
46	MCUSEG	VWAER	TCURC	WAERS	REF	1	CN
47	MCUSEG	WERKS	T001W	WERKS
48	MCUSEG	WKUNNR	KNA1	KUNNR

History

Last changed by/on	SAP	20110901
SAP Release Created in