SAP ABAP Table EBEW (Sales Order Stock Valuation)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MGA (Package) Application development R/3 material master from 3.0

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	EBEW	Table Relationship Diagram
Short Description	Sales Order Stock Valuation

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	*
2	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	*
3	BWKEY	☑	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
4	BWTAR	☑	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
5	SOBKZ	☑	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
6	VBELN	☑	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
7	POSNR	☑	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
8	.INCLUDE	☐				0	0	Joint Data Part MBEW/EBEW/QBEW: Part 1
9	LBKUM	☐	LBKUM	MENG13V	QUAN	13	3	Total Valuated Stock
10	SALK3	☐	SALK3	WERT13N	CURR	13	2	Value of Total Valuated Stock
11	VPRSV	☐	VPRSV	VPRSV	CHAR	1	0	Price control indicator
12	VERPR	☐	VERPR	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price
13	STPRS	☐	STPRS	WERT11V	CURR	11	2	Standard price
14	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
15	BKLAS	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	T025
16	SALKV	☐	SALKV	WERT13N	CURR	13	2	Value based on moving average price (only with price ctrl S)
17	VMKUM	☐	VMKUM	MENG13V	QUAN	13	3	Total valuated stock in previous period
18	VMSAL	☐	VMSAL	WERT13N	CURR	13	2	Value of total valuated stock in previous period
19	VMVPR	☐	VMVPR	VPRSV	CHAR	1	0	Price control indicator for previous period
20	VMVER	☐	VMVER	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price in Previous Period
21	VMSTP	☐	VMSTP	WERT11V	CURR	11	2	Standard price in the previous period
22	VMPEI	☐	VMPEI	PACK3	DEC	5	0	Price unit of previous period
23	VMBKL	☐	VMBKL	BKLAS	CHAR	4	0	Valuation class of previous period	T025
24	VMSAV	☐	VMSAV	WERT13N	CURR	13	2	Value based on moving average price (previous period)
25	VJKUM	☐	VJKUM	MENG13V	QUAN	13	3	Total valuated stock in previous year
26	VJSAL	☐	VJSAL	WERT13N	CURR	13	2	Value of total valuated stock in previous year
27	VJVPR	☐	VJVPR	VPRSV	CHAR	1	0	Price control indicator for previous year
28	VJVER	☐	VJVER	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price in Previous Year
29	VJSTP	☐	VJSTP	WERT11V	CURR	11	2	Standard price in previous year
30	VJPEI	☐	VJPEI	PACK3	DEC	5	0	Price unit of previous year
31	VJBKL	☐	VJBKL	BKLAS	CHAR	4	0	Valuation class from previous year	T025
32	VJSAV	☐	VJSAV	WERT13N	CURR	13	2	Value based on moving average price (previous year)
33	LFGJA	☐	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
34	LFMON	☐	LFMON	MONAT	NUMC	2	0	Current period (posting period)
35	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	T149C
36	STPRV	☐	STPRV	WERT11V	CURR	11	2	Previous price
37	LAEPR	☐	LAEPR	DATUM	DATS	8	0	Date of the last price change
38	ZKPRS	☐	DZKPRS	WERT11	CURR	11	2	Future price
39	ZKDAT	☐	DZKDAT	DATUM	DATS	8	0	Date as of which the price is valid
40	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
41	.INCLUDE	☐				0	0	Joint Data Part MBEW/EBEW/QBEW: Part 2
42	ZPLPR	☐	DZPLPR	WERT11	CURR	11	2	Future planned price
43	.INCLUDE	☐				0	0	Joint Data Part MBEW/EBEW/QBEW: Part 3
44	KALKZ	☐	KAXKZ	XFELD	CHAR	1	0	Indicator: standard cost estimate for future period
45	KALKL	☐	KALKL	XFELD	CHAR	1	0	Indicator: standard cost estimate for current period
46	KALKV	☐	KALKV	XFELD	CHAR	1	0	Indicator: standard cost estimate for previous period
47	.INCLUDE	☐				0	0	Joint Data Part MBEW/EBEW/QBEW: Part 4
48	KALN1	☐	CK_KALNR1	CK_KALNR	NUMC	12	0	Cost Estimate Number - Product Costing	*
49	.INCLUDE	☐				0	0	Joint Data Part MBEW/EBEW/QBEW: Part 5
50	BWVA1	☐	CK_BWVA1	CK_BWVAR	CHAR	3	0	Valuation variant for the future standard cost estimate	TCK05
51	BWVA2	☐	CK_BWVA2	CK_BWVAR	CHAR	3	0	Valuation variant for the current standard cost estimate	TCK05
52	BWVA3	☐	CK_BWVA3	CK_BWVAR	CHAR	3	0	Valuation variant for past standard cost estimate	TCK05
53	VERS1	☐	CK_TVERS1	CK_VERSION	NUMC	2	0	Costing version of the future standard cost estimate
54	VERS2	☐	CK_TVERS2	CK_VERSION	NUMC	2	0	Costing version of the current standard cost estimate
55	VERS3	☐	CK_TVERS3	CK_VERSION	NUMC	2	0	Costing version of the previous standard cost estimate
56	HRKFT	☐	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	TKKH1
57	KOSGR	☐	CK_KOSGR	CK_KOSGR	CHAR	10	0	Costing overhead group	TCK14
58	PPRDZ	☐	CK_PPRDZ	POPER	NUMC	3	0	Period of future cost estimate
59	PPRDL	☐	CK_PPRDL	POPER	NUMC	3	0	Period of the current cost estimate
60	PPRDV	☐	CK_PPRDV	POPER	NUMC	3	0	Period of the previous cost estimate
61	PDATZ	☐	CK_PDATZ	GJAHR	NUMC	4	0	Future fiscal year
62	PDATL	☐	CK_PDATL	GJAHR	NUMC	4	0	Fiscal year for current cost estimate
63	PDATV	☐	CK_PDATV	GJAHR	NUMC	4	0	Fiscal year of previous cost estimate
64	EKALR	☐	CK_EKALREL	XFELD	CHAR	1	0	Material Is Costed with Quantity Structure
65	VPLPR	☐	VPLPR	WERT11	CURR	11	2	Previous planned price
66	MLMAA	☐	CK_ML_MAAC	XFELD	CHAR	1	0	Material ledger activated at material level
67	MLAST	☐	CK_ML_ABST	CK_ML_ABST	CHAR	1	0	Material Price Determination: Control
68	LPLPR	☐	CK_LPLPR	WERT11	CURR	11	2	Current Planned Price
69	VKSAL	☐	VKSAL	WERT13N	CURR	13	2	Value of Total Valuated Stock at Sales Price
70	HKMAT	☐	HKMAT	HKMAT	CHAR	1	0	Material-related origin
71	.INCLUDE	☐				0	0	Joint Data Part MBEW/EBEW/QBEW: Part 6
72	BWSPA	☐	BWSPA	PRZ32V	DEC	6	2	Valuation margin
73	LPLPX	☐	CK_LPLPX	WERT11V	CURR	11	2	Fixed Portion of Current Planned Price
74	VPLPX	☐	CK_VPLPX	WERT11V	CURR	11	2	Fixed Portion of Previous Planned Price
75	FPLPX	☐	CK_ZPLPX	WERT11V	CURR	11	2	Fixed Portion of Future Planned Price
76	LBWST	☐	CK_LBWST	CK_BWST	CHAR	1	0	Val. strat. for current plan price, sales order/proj. stock
77	VBWST	☐	CK_VBWST	CK_BWST	CHAR	1	0	Valn. strategy for prev. planned price, restricted use stock
78	FBWST	☐	CK_ZBWST	CK_BWST	CHAR	1	0	Valn strategy for future planned price, restr. use stock
79	.INCLUDE	☐				0	0	Joint Data Part MBEW/EBEW/QBEW: Part 7
80	MBRUE	☐	MBRUE	XFELD	CHAR	1	0	MBEWH rec. already exists for per. before last of MBEW per.
81	OKLAS	☐	OKLAS	BKLAS	CHAR	4	0	Valuation Class for Special Stock at the Vendor	T025

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EBEW	BKLAS	T025	BKLAS
2	EBEW	BWTTY	T149C	BWTTY
3	EBEW	BWVA1	TCK05	BWVAR
4	EBEW	BWVA2	TCK05	BWVAR
5	EBEW	BWVA3	TCK05	BWVAR
6	EBEW	HRKFT	TKKH1	HRKFT
7	EBEW	KOSGR	TCK14	KOSGR
8	EBEW	OKLAS	T025	BKLAS
9	EBEW	VJBKL	T025	BKLAS
10	EBEW	VMBKL	T025	BKLAS

History

Last changed by/on	SAP	20100310
SAP Release Created in