SAP ABAP Table MGV_USEG (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MGV_USEG	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	UBLNR	☑	UBLNR	UBLNR	CHAR	10	0	Retail revaluation document number
3	UBJAHR	☑	UBJAHR	GJAHR	NUMC	4	0	Retail revaluation: document year
4	UZEIL	☑	UZEIL	UZEIL	NUMC	4	0	Item number in retail revaluation document
5	UPSTA	☐	UPSTA	UPSTA	CHAR	1	0	Item status of retail revaluation document
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
7	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
8	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
9	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
10	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
11	MATBF	☐	MATBF	MATNR	CHAR	18	0	Material in Respect of Which Stock is Managed	MARA
12	PV_GRUND	☐	PV_GRUND	PV_GRUND	CHAR	4	0	Reason for retail price change	TWBN
13	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	MBEW
14	VPDAT	☐	VPDAT_D	DATUM	DATS	8	0	Date of retail price change
15	ENDPR	☐	ENDPR	WERTV6	CURR	11	2	Final price
16	VPNEU	☐	VPNEU	WERTV6	CURR	11	2	New retail price
17	VPALT	☐	VPALT	WERTV6	CURR	11	2	Old retail price
18	VRKPE	☐	VRKPE	DEC5	DEC	5	0	Sales price unit
19	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
20	VWAER	☐	VWAER	WAERS	CUKY	5	0	Sales currency	TCURC
21	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
22	VKLAB_OLD	☐	VKLAB	WERT13N	CURR	13	2	Stock value of a value-only material at sales price
23	VKLABN_OLD	☐	VKLAB_NET	WERT13N	CURR	13	2	Stock value of a value-only material at retail w/o tax
24	VKSAL_OLD	☐	VKSAL	WERT13N	CURR	13	2	Value of Total Valuated Stock at Sales Price
25	VKSALN_OLD	☐	VKSAL_NET	WERT13N	CURR	13	2	Total inventory value at retail without tax
26	VKSAD	☐	VKSALD	WERT13N	CURR	13	2	Difference Between New and Previous Stock Value
27	VKSADN	☐	VKSALD_NET	WERT13N	CURR	13	2	Difference in retail value without tax
28	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
29	ERFMG	☐	VKUMG	MENG13V	QUAN	13	3	Quantity in unit of entry for revaluation at retail
30	MENGE	☐	MENGV	MENG13V	QUAN	13	3	Quantity with +/- sign in base unit of measure
31	LBKUM	☐	LBKUM	MENG13V	QUAN	13	3	Total Valuated Stock
32	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
33	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
34	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
35	SPANN	☐	SPANN	XFELD	CHAR	1	0	Flag: not affecting margins
36	EKPA	☐	EKPA_D	WERT11	CURR	11	2	Old cost price
37	EKPN	☐	NPREI	WERT11	CURR	11	2	New Price
38	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
39	SALK3_OLD	☐	SALK3	WERT13N	CURR	13	2	Value of Total Valuated Stock
40	XIVNE	☐	XIVNE	XFELD	CHAR	1	0	Indicates that change in retail value does not affect stock
41	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
42	UAKT	☐	UAKT	PRICE_ORIG_CHG_TYPE	CHAR	2	0	Change Category of Sales Price Origin from Old to New Price
43	SALES_VAL_SIGN	☐	VALUE_CHANGE_SIGN	VALUE_CHANGE_SIGN	CHAR	1	0	Sign of Sales Value Change
44	AFFECT_COST_VAL	☐	AFFECT_COST_VAL_RESULT	AFFECT_COST_VAL_RESULT	CHAR	1	0	Adjust Cost Value (Result)
45	VORGA_CREATE	☐	VKPU_VORGA	VKPU_VORGA	CHAR	1	0	Indicates the transaction triggering revaluation at retail
46	MOD_CREATE	☐	MODIFIER_COST_VAL	MODIFIER_COST_VAL	CHAR	1	0	Cost Value Changed By
47	TIME_CREATE	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
48	VORGA_CHANGE	☐	VKPU_VORGA	VKPU_VORGA	CHAR	1	0	Indicates the transaction triggering revaluation at retail
49	MOD_CHANGE	☐	MODIFIER_COST_VAL	MODIFIER_COST_VAL	CHAR	1	0	Cost Value Changed By
50	TIME_CHANGE	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
51	MATNR_EXT	☐	MATNR_EXT	MATNR_EXT	CHAR	40	0	External Long Material Number
52	MATNR_VERS	☐	MATNR_VERS	MATNR_VERS	CHAR	10	0	Material Version Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MGV_USEG	AKTNR	WAKH	AKTNR
2	MGV_USEG	BUKRS	T001	BUKRS
3	MGV_USEG	BWKEY	T001K	BWKEY
4	MGV_USEG	BWTAR	MBEW	BWTAR	KEY	1	CN
5	MGV_USEG	HWAER	TCURC	WAERS
6	MGV_USEG	LGORT	T001L	LGORT
7	MGV_USEG	MANDT	T000	MANDT
8	MGV_USEG	MATBF	MARA	MATNR
9	MGV_USEG	MATNR	MARA	MATNR
10	MGV_USEG	MEINS	T006	MSEHI
11	MGV_USEG	PV_GRUND	TWBN	PV_GRUND
12	MGV_USEG	VRKME	T006	MSEHI
13	MGV_USEG	VWAER	TCURC	WAERS	REF	1	CN
14	MGV_USEG	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20100310
SAP Release Created in