SAP ABAP Table V_USEG (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_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	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	MBEW
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	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
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	VWAER	☐	VWAER	WAERS	CUKY	5	0	Sales currency	TCURC
20	VRKPE	☐	VRKPE	DEC5	DEC	5	0	Sales price unit
21	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
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	SALK3_OLD	☐	SALK3	WERT13N	CURR	13	2	Value of Total Valuated Stock
40	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
41	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
42	XIVNE	☐	XIVNE	XFELD	CHAR	1	0	Indicates that change in retail value does not affect stock
43	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
44	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
45	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
46	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
47	UBSTA	☐	UBSTA	UBSTA	CHAR	1	0	Status of retail revaluation document
48	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
49	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
50	UAKT	☐	UAKT	PRICE_ORIG_CHG_TYPE	CHAR	2	0	Change Category of Sales Price Origin from Old to New Price
51	SALES_VAL_SIGN	☐	VALUE_CHANGE_SIGN	VALUE_CHANGE_SIGN	CHAR	1	0	Sign of Sales Value Change
52	AFFECT_COST_VAL	☐	AFFECT_COST_VAL_RESULT	AFFECT_COST_VAL_RESULT	CHAR	1	0	Adjust Cost Value (Result)

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in