SAP ABAP View V_USEG (Selection of Retail Revaluation Docs (Header and Itm Crit.))

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

View Type	D	Database View
Database View	V_USEG
Short Description	Selection of Retail Revaluation Docs (Header and Itm Crit.)
Root table	UKPF	Retail Revaluation Document: Revaluation Header

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	UKPF	MANDT	JL	EQ				0	0
2	USEG	MANDT	JR	EQ			AND	0	0
3	UKPF	UBLNR	JL	EQ				0	0
4	USEG	UBLNR	JR	EQ			AND	0	0
5	UKPF	UBJAHR	JL	EQ				0	0
6	USEG	UBJAHR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	USEG	MANDT		☐	MANDT	☐	Client
2	UBLNR	USEG	UBLNR		☐	UBLNR	☐	Retail revaluation document number
3	UBJAHR	USEG	UBJAHR		☐	UBJAHR	☐	Retail revaluation: document year
4	UZEIL	USEG	UZEIL		☐	UZEIL	☐	Item number in retail revaluation document
5	UPSTA	USEG	UPSTA		☐	UPSTA	☐	Item status of retail revaluation document
6	BUKRS	USEG	BUKRS		☐	BUKRS	☐	Company Code
7	BWKEY	USEG	BWKEY		☐	BWKEY	☐	Valuation area
8	WERKS	USEG	WERKS		☐	WERKS_D	☐	Plant
9	LGORT	USEG	LGORT		☐	LGORT_D	☐	Storage location
10	BWTAR	USEG	BWTAR		☐	BWTAR_D	☐	Valuation type
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	BUDAT	UKPF	BUDAT		☐	BUDAT	☐	Posting Date in the Document
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	VWAER	USEG	VWAER		☐	VWAER	☐	Sales currency
20	VRKPE	USEG	VRKPE		☐	VRKPE	☐	Sales price unit
21	VRKME	USEG	VRKME		☐	VRKME	☐	Sales unit
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	SALK3_OLD	USEG	SALK3_OLD		☐	SALK3	☐	Value of Total Valuated Stock
40	WRBTR	USEG	WRBTR		☐	WRBTR	☐	Amount in document currency
41	SHKZG	USEG	SHKZG		☐	SHKZG	☐	Debit/Credit Indicator
42	XIVNE	USEG	XIVNE		☐	XIVNE	☐	Indicates that change in retail value does not affect stock
43	ERDAT	UKPF	ERDAT		☐	ERDAT	☐	Date on which the record was created
44	ERNAM	UKPF	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
45	AEDAT	UKPF	AEDAT		☐	AEDAT	☐	Last Changed On
46	AENAM	UKPF	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
47	UBSTA	UKPF	UBSTA		☐	UBSTA	☐	Status of retail revaluation document
48	BELNR	UKPF	BELNR		☐	BELNR_D	☐	Accounting Document Number
49	MBLNR	UKPF	MBLNR		☐	MBLNR	☐	Number of Material Document
50	.APPEND	HYBRID_V_USEG			☐		☐
51	UAKT	USEG	UAKT		☐	UAKT	☐	Change Category of Sales Price Origin from Old to New Price
52	SALES_VAL_SIGN	USEG	SALES_VAL_SIGN		☐	VALUE_CHANGE_SIGN	☐	Sign of Sales Value Change
53	AFFECT_COST_VAL	USEG	AFFECT_COST_VAL		☐	AFFECT_COST_VAL_RESULT	☐	Adjust Cost Value (Result)

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	20110901
SAP Release Created in