SAP ABAP View MGV_USEG (Selection USEG with material version, see: http://material)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ LO-MD-MM (Application Component) Material Master
     ⤷ MGV_MATNR (Package) Material number conversion (long mat. no.)

Basic Data

View Type	D	Database View
Database View	MGV_USEG
Short Description	Selection USEG with material version, see: http://material
Root table	USEG	Retail Revaluation Document: Revaluation Segment

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	USEG	USEG
2	MATERIALID

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	USEG	MANDT	JL	EQ				0	0
2	MATERIALID	MANDT	JR	EQ			AND	0	0
3	USEG	MATNR	JL	EQ				0	0
4	MATERIALID	MATNR_INT	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20100310
SAP Release Created in