SAP ABAP Table USEGD (Structure for Revaluation Item Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WBEF (Package) IS-R: Inventory Management

Basic Data

Table Category	INTTAB	Structure
Structure	USEGD	Table Relationship Diagram
Short Description	Structure for Revaluation 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	VKUNR	☐	UBLNR	UBLNR	CHAR	10	0	Retail revaluation document number	UKPF
57	MATN1	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
58	MATN2	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
59	WNAME	☐	NAME1	TEXT30	CHAR	30	0	Name
60	PV_GRTXT	☐	BEZEI30	TEXT30	CHAR	30	0	Description
61	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
62	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
63	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*

Foreign Keys

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

History

Last changed by/on	SAP	20100310
SAP Release Created in