SAP ABAP Table SMBEW (Blocking Table for Material Values)

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	SMBEW	Table Relationship Diagram
Short Description	Blocking Table for Material Values

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in