SAP ABAP Table ORIG_PR_MBEW (Sales Price Origin of Last Total Revaluation at Retail)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM-IM (Application Component) Inventory Management
     ⤷ WBEF_HYBRID (Package) IS-R: Inventory Management (Hybrid Method)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ORIG_PR_MBEW	Table Relationship Diagram
Short Description	Sales Price Origin of Last Total Revaluation at Retail

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	BWKEY	☑	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
4	BWTAR	☑	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
5	.INCLUDE	☐				0	0	Data Part for Price Origin for Revaluation at Retail
6	UAKT	☐	UAKT	PRICE_ORIG_CHG_TYPE	CHAR	2	0	Change Category of Sales Price Origin from Old to New Price
7	SALES_VAL_SIGN	☐	VALUE_CHANGE_SIGN	VALUE_CHANGE_SIGN	CHAR	1	0	Sign of Sales Value Change
8	AFFECT_COST_VAL	☐	AFFECT_COST_VAL_RESULT	AFFECT_COST_VAL_RESULT	CHAR	1	0	Adjust Cost Value (Result)
9	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	VPDAT	☐	VPDAT_D	DATUM	DATS	8	0	Date of retail price change
11	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
12	VPNEU	☐	VPNEU	WERTV6	CURR	11	2	New retail price
13	VRKPE	☐	VRKPE	DEC5	DEC	5	0	Sales price unit
14	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
15	VWAER	☐	VWAER	WAERS	CUKY	5	0	Sales currency	TCURC
16	VKPU_VORGA	☐	VKPU_VORGA	VKPU_VORGA	CHAR	1	0	Indicates the transaction triggering revaluation at retail
17	MOD_COST_VAL	☐	MODIFIER_COST_VAL	MODIFIER_COST_VAL	CHAR	1	0	Cost Value Changed By
18	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
19	.INCLUDE	☐				0	0	Last Regular Price Used for Total Revaluation
20	VPDAT_NP	☐	VPDAT_D	DATUM	DATS	8	0	Date of retail price change
21	VPNEU_NP	☐	VPNEU	WERTV6	CURR	11	2	New retail price
22	VRKPE_NP	☐	VRKPE	DEC5	DEC	5	0	Sales price unit
23	VRKME_NP	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
24	VWAER_NP	☐	VWAER	WAERS	CUKY	5	0	Sales currency	*
25	TIMESTAMP_NP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
26	VPDAT_CHG	☐	VPDAT_D	DATUM	DATS	8	0	Date of retail price change
27	UAKT_CHG	☐	UAKT	PRICE_ORIG_CHG_TYPE	CHAR	2	0	Change Category of Sales Price Origin from Old to New Price
28	SIGN_CHG	☐	VALUE_CHANGE_SIGN	VALUE_CHANGE_SIGN	CHAR	1	0	Sign of Sales Value Change

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ORIG_PR_MBEW	BWKEY	T001K	BWKEY	KEY	1	CN
2	ORIG_PR_MBEW	MANDT	T000	MANDT	KEY	1	CN
3	ORIG_PR_MBEW	MATNR	MARA	MATNR	KEY	1	CN
4	ORIG_PR_MBEW	VRKME	T006	MSEHI	REF	1	CN
5	ORIG_PR_MBEW	VWAER	TCURC	WAERS	REF	1	CN
6	ORIG_PR_MBEW	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20100310
SAP Release Created in	700