SAP ABAP Table SIBEW (Material-Values-Block Table Include)

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	SIBEW	Table Relationship Diagram
Short Description	Material-Values-Block Table Include

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

History

Last changed by/on	SAP	20091125
SAP Release Created in