SAP ABAP Table U_26111 (Generated Table for View U_26111)

Basic Data

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

Delivery and Maintenance

Pool/cluster	USEG
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	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	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
21	VKLAB_OLD	☐	VKLAB	WERT13N	CURR	13	2	Stock value of a value-only material at sales price
22	VKLABN_OLD	☐	VKLAB_NET	WERT13N	CURR	13	2	Stock value of a value-only material at retail w/o tax
23	VKSAL_OLD	☐	VKSAL	WERT13N	CURR	13	2	Value of Total Valuated Stock at Sales Price
24	VKSALN_OLD	☐	VKSAL_NET	WERT13N	CURR	13	2	Total inventory value at retail without tax
25	VKSAD	☐	VKSALD	WERT13N	CURR	13	2	Difference Between New and Previous Stock Value
26	VKSADN	☐	VKSALD_NET	WERT13N	CURR	13	2	Difference in retail value without tax
27	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
28	ERFMG	☐	VKUMG	MENG13V	QUAN	13	3	Quantity in unit of entry for revaluation at retail
29	MENGE	☐	MENGV	MENG13V	QUAN	13	3	Quantity with +/- sign in base unit of measure
30	LBKUM	☐	LBKUM	MENG13V	QUAN	13	3	Total Valuated Stock
31	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
32	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
33	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
34	SPANN	☐	SPANN	XFELD	CHAR	1	0	Flag: not affecting margins
35	EKPA	☐	EKPA_D	WERT11	CURR	11	2	Old cost price
36	EKPN	☐	NPREI	WERT11	CURR	11	2	New Price
37	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
38	SALK3_OLD	☐	SALK3	WERT13N	CURR	13	2	Value of Total Valuated Stock
39	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
40	VWAER	☐	VWAER	WAERS	CUKY	5	0	Sales currency	TCURC

Foreign Keys

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

History

Last changed by/on	SAP	20050409
SAP Release Created in