SAP ABAP View V_EBEW_VBAK (DB view for joining EBEW & VBAK. Perf. optimization TA MBBS)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM-IM (Application Component) Inventory Management
     ⤷ MB_OPT (Package) Additional application development R/3 inventory management

Basic Data

View Type	D	Database View
Database View	V_EBEW_VBAK
Short Description	DB view for joining EBEW & VBAK. Perf. optimization TA MBBS
Root table	EBEW	Sales Order Stock Valuation

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EBEW	EBEW
2	VBAK

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EBEW	MANDT	JL	EQ				0	0
2	VBAK	MANDT	JR	EQ			AND	0	0
3	EBEW	VBELN	JL	EQ				0	0
4	VBAK	VBELN	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EBEW	MANDT		☐	MANDT	☐	Client
2	MATNR	EBEW	MATNR		☐	MATNR	☐	Material Number
3	BWKEY	EBEW	BWKEY		☐	BWKEY	☐	Valuation area
4	BWTAR	EBEW	BWTAR		☐	BWTAR_D	☐	Valuation type
5	SOBKZ	EBEW	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
6	VBELN	EBEW	VBELN		☐	VBELN	☐	Sales and Distribution Document Number
7	POSNR	EBEW	POSNR		☐	POSNR	☐	Item number of the SD document
8	LBKUM	EBEW	LBKUM		☐	LBKUM	☐	Total Valuated Stock
9	SALK3	EBEW	SALK3		☐	SALK3	☐	Value of Total Valuated Stock
10	VPRSV	EBEW	VPRSV		☐	VPRSV	☐	Price control indicator
11	VERPR	EBEW	VERPR		☐	VERPR	☐	Moving Average Price/Periodic Unit Price
12	STPRS	EBEW	STPRS		☐	STPRS	☐	Standard price
13	PEINH	EBEW	PEINH		☐	PEINH	☐	Price unit
14	BKLAS	EBEW	BKLAS		☐	BKLAS	☐	Valuation Class
15	SALKV	EBEW	SALKV		☐	SALKV	☐	Value based on moving average price (only with price ctrl S)
16	BWTTY	EBEW	BWTTY		☐	BWTTY_D	☐	Valuation Category
17	KUNNR	VBAK	KUNNR		☐	KUNAG	☐	Sold-to party

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