SAP ABAP Table SEBEW (Material-Values-Block Table Valuated Sales Order Stock)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MB (Package) Application development R/3 inventory management

Basic Data

Table Category	INTTAB	Structure
Structure	SEBEW	Table Relationship Diagram
Short Description	Material-Values-Block Table Valuated Sales Order Stock

Delivery and Maintenance

Pool/cluster
Delivery Class
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	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
2	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
3	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
4	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
5	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
6	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
7	CURTP	☐	CURTP	CURTP	CHAR	2	0	Currency type and valuation view
8	.INCLUDE	☐				0	0	Material-Values-Block Table Include
9	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
10	XRUEM	☐	XRUEM	XFELD	CHAR	1	0	Allow Posting to Previous Period (Backposting)
11	XRUEJ	☐	XRUEJ	XFELD	CHAR	1	0	Indicator: post to previous year
12	RMBEW	☐	RMBEW	XFELD	CHAR	1	0	Return code MBEW
13	LBKUM	☐	LBKUM	MENG13V	QUAN	13	3	Total Valuated Stock
14	SALK3	☐	SALK3	WERT13N	CURR	13	2	Value of Total Valuated Stock
15	SALKV	☐	SALKV	WERT13N	CURR	13	2	Value based on moving average price (only with price ctrl S)
16	VKSAL	☐	VKSAL	WERT13N	CURR	13	2	Value of Total Valuated Stock at Sales Price
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	VMSAV	☐	VMSAV	WERT13N	CURR	13	2	Value based on moving average price (previous period)
20	VJKUM	☐	VJKUM	MENG13V	QUAN	13	3	Total valuated stock in previous year
21	VJSAL	☐	VJSAL	WERT13N	CURR	13	2	Value of total valuated stock in previous year
22	VJSAV	☐	VJSAV	WERT13N	CURR	13	2	Value based on moving average price (previous year)
23	LFGJA	☐	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
24	LFMON	☐	LFMON	MONAT	NUMC	2	0	Current period (posting period)
25	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	T149C
26	BKLAS	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	T025
27	EKLAS	☐	EKLAS	BKLAS	CHAR	4	0	Valuation Class for Sales Order Stock	*
28	QKLAS	☐	QKLAS	BKLAS	CHAR	4	0	Valuation Class for Project Stock	*
29	OKLAS	☐	OKLAS	BKLAS	CHAR	4	0	Valuation Class for Special Stock at the Vendor	*
30	LBKUM_OLD	☐	LBKUM	MENG13V	QUAN	13	3	Total Valuated Stock
31	SALK3_OLD	☐	SALK3	WERT13N	CURR	13	2	Value of Total Valuated Stock
32	SALKV_OLD	☐	SALKV	WERT13N	CURR	13	2	Value based on moving average price (only with price ctrl S)
33	VKSAL_OLD	☐	VKSAL	WERT13N	CURR	13	2	Value of Total Valuated Stock at Sales Price
34	VMKUM_OLD	☐	VMKUM	MENG13V	QUAN	13	3	Total valuated stock in previous period
35	VMSAL_OLD	☐	VMSAL	WERT13N	CURR	13	2	Value of total valuated stock in previous period
36	VMSAV_OLD	☐	VMSAV	WERT13N	CURR	13	2	Value based on moving average price (previous period)
37	VJKUM_OLD	☐	VJKUM	MENG13V	QUAN	13	3	Total valuated stock in previous year
38	VJSAL_OLD	☐	VJSAL	WERT13N	CURR	13	2	Value of total valuated stock in previous year
39	VJSAV_OLD	☐	VJSAV	WERT13N	CURR	13	2	Value based on moving average price (previous year)
40	VPRSV	☐	VPRSV	VPRSV	CHAR	1	0	Price control indicator
41	VERPR	☐	VERPR	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price
42	STPRS	☐	STPRS	WERT11V	CURR	11	2	Standard price
43	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
44	VMVER	☐	VMVER	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price in Previous Period
45	VMPEI	☐	VMPEI	PACK3	DEC	5	0	Price unit of previous period
46	VMSTP	☐	VMSTP	WERT11V	CURR	11	2	Standard price in the previous period
47	VJVER	☐	VJVER	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price in Previous Year
48	VJPEI	☐	VJPEI	PACK3	DEC	5	0	Price unit of previous year
49	VJSTP	☐	VJSTP	WERT11V	CURR	11	2	Standard price in previous year
50	REMNG	☐	REMNG	MENG13	QUAN	13	3	Quantity invoiced
51	LVPVP	☐	CK_LVPVP_1	WERT11	CURR	11	2	Subcontracting: periodic unit price (PUP)
52	VMLPV	☐	CK_LVPVP_1	WERT11	CURR	11	2	Subcontracting: periodic unit price (PUP)
53	MENGU	☐	MENGU	XFELD	CHAR	1	0	Quantity Updating in Material Master Record
54	WERTU	☐	WERTU	XFELD	CHAR	1	0	Value Updating in Material Master Record
55	MLAST	☐	CK_ML_ABST	CK_ML_ABST	CHAR	1	0	Material Price Determination: Control
56	MLMAA	☐	CK_ML_MAAC	XFELD	CHAR	1	0	Material ledger activated at material level
57	KVERU	☐	CK_KVERU	XFELD	CHAR	1	0	Do Not Update Moving Price
58	KALN1	☐	CK_KALNR1	CK_KALNR	NUMC	12	0	Cost Estimate Number - Product Costing	*
59	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
60	XEXEQ	☐	XEXEQ	XFELD	CHAR	1	0	Exclusive enqueue for MBEW required
61	LPLPR	☐	CK_LPLPR	WERT11	CURR	11	2	Current Planned Price
62	LPLPX	☐	CK_LPLPX	WERT11V	CURR	11	2	Fixed Portion of Current Planned Price
63	LBWST	☐	CK_LBWST	CK_BWST	CHAR	1	0	Val. strat. for current plan price, sales order/proj. stock
64	HKMAT	☐	HKMAT	HKMAT	CHAR	1	0	Material-related origin
65	HRKFT	☐	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	*
66	EKALR	☐	CK_EKALREL	XFELD	CHAR	1	0	Material Is Costed with Quantity Structure
67	RMBEWH	☐	XWERT	XFELD	CHAR	1	0	Data content X or blank
68	MBLFM	☐	LFMON	MONAT	NUMC	2	0	Current period (posting period)
69	MBGJA	☐	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
70	MBRUE	☐	SBRUE	XFELD	CHAR	1	0	MxxxH rec. already exists for per. before last of Mxxx per.
71	VMVKS	☐	VMVKS	WERT13N	CURR	13	2	Value of Tot. Valuated Stock at Sales Price in Previous Per.
72	VJVKS	☐	VJVKS	WERT13N	CURR	13	2	Value of Tot. Valuated Stock at Sales Price in Previous Year
73	VMVKS_OLD	☐	VMVKS	WERT13N	CURR	13	2	Value of Tot. Valuated Stock at Sales Price in Previous Per.
74	VJVKS_OLD	☐	VJVKS	WERT13N	CURR	13	2	Value of Tot. Valuated Stock at Sales Price in Previous Year
75	STPRS_OLD	☐	STPRS	WERT11V	CURR	11	2	Standard price
76	VERPR_OLD	☐	VERPR	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price
77	PEINH_OLD	☐	PEINH	PACK3	DEC	5	0	Price unit
78	VMSTP_OLD	☐	STPRS	WERT11V	CURR	11	2	Standard price
79	VMVER_OLD	☐	VERPR	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price
80	VMPEI_OLD	☐	PEINH	PACK3	DEC	5	0	Price unit
81	VJSTP_OLD	☐	STPRS	WERT11V	CURR	11	2	Standard price
82	VJVER_OLD	☐	VERPR	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price
83	VJPEI_OLD	☐	PEINH	PACK3	DEC	5	0	Price unit
84	STPRV	☐	STPRV	WERT11V	CURR	11	2	Previous price
85	ZKPRS	☐	DZKPRS	WERT11	CURR	11	2	Future price
86	ZKDAT	☐	DZKDAT	DATUM	DATS	8	0	Date as of which the price is valid
87	LAEPR	☐	LAEPR	DATUM	DATS	8	0	Date of the last price change
88	PRCHG	☐	XWERT	XFELD	CHAR	1	0	Data content X or blank
89	VMVPR	☐	VPRSV	VPRSV	CHAR	1	0	Price control indicator
90	VJVPR	☐	VPRSV	VPRSV	CHAR	1	0	Price control indicator
91	PRCHV	☐	XWERT	XFELD	CHAR	1	0	Data content X or blank
92	INS_OBLIG	☐	XWERT	XFELD	CHAR	1	0	Data content X or blank

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SEBEW	BKLAS	T025	BKLAS
2	SEBEW	BWKEY	T001K	BWKEY
3	SEBEW	BWTAR	T149D	BWTAR
4	SEBEW	BWTTY	T149C	BWTTY
5	SEBEW	MATNR	MARA	MATNR

History

Last changed by/on	SAP	20091125
SAP Release Created in