1. Home
  2. Resources
  3. SAP Tables
  4. SIBEW - Material-Values-Block Table Include

SAP Table SIBEW

Material-Values-Block Table Include

SIBEW (Material-Values-Block Table Include) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SIBEW to other SAP tables.

SIBEW table fields

Field Data element Checktable Datatype Length Decimals
WAERS Currency Key WAERS CUKY 5 0
XRUEM Allow Posting to Previous Period (Backposting) XRUEM CHAR 1 0
X Yes
NULL No
XRUEJ Indicator: post to previous year XRUEJ CHAR 1 0
X Yes
NULL No
RMBEW Return code MBEW RMBEW CHAR 1 0
X Yes
NULL No
LBKUM Total Valuated Stock LBKUM QUAN 13 3
SALK3 Value of Total Valuated Stock SALK3 CURR 13 2
SALKV Value based on moving average price (only with price ctrl S) SALKV CURR 13 2
VKSAL Value of Total Valuated Stock at Sales Price VKSAL CURR 13 2
VMKUM Total valuated stock in previous period VMKUM QUAN 13 3
VMSAL Value of total valuated stock in previous period VMSAL CURR 13 2
VMSAV Value based on moving average price (previous period) VMSAV CURR 13 2
VJKUM Total Valuated Stock in Previous Year VJKUM QUAN 13 3
VJSAL Value of total valuated stock in previous year VJSAL CURR 13 2
VJSAV Value based on moving average price (previous year) VJSAV CURR 13 2
LFGJA Fiscal Year of Current Period LFGJA NUMC 4 0
LFMON Current period (posting period) LFMON NUMC 2 0
BWTTY Valuation Category BWTTY_D T149C CHAR 1 0
BKLAS Valuation Class BKLAS T025 CHAR 4 0
EKLAS Valuation Class for Sales Order Stock EKLAS CHAR 4 0
QKLAS Valuation Class for Project Stock QKLAS CHAR 4 0
OKLAS Valuation Class for Special Stock at the Vendor OKLAS CHAR 4 0
LBKUM_OLD Total Valuated Stock LBKUM QUAN 13 3
SALK3_OLD Value of Total Valuated Stock SALK3 CURR 13 2
SALKV_OLD Value based on moving average price (only with price ctrl S) SALKV CURR 13 2
VKSAL_OLD Value of Total Valuated Stock at Sales Price VKSAL CURR 13 2
VMKUM_OLD Total valuated stock in previous period VMKUM QUAN 13 3
VMSAL_OLD Value of total valuated stock in previous period VMSAL CURR 13 2
VMSAV_OLD Value based on moving average price (previous period) VMSAV CURR 13 2
VJKUM_OLD Total Valuated Stock in Previous Year VJKUM QUAN 13 3
VJSAL_OLD Value of total valuated stock in previous year VJSAL CURR 13 2
VJSAV_OLD Value based on moving average price (previous year) VJSAV CURR 13 2
VPRSV Price control indicator VPRSV CHAR 1 0
S Standard price
V Moving average price/periodic unit price
VERPR Moving Average Price/Periodic Unit Price VERPR CURR 11 2
STPRS Standard price STPRS CURR 11 2
PEINH Price Unit PEINH DEC 5 0
VMVER Moving Average Price/Periodic Unit Price in Previous Period VMVER CURR 11 2
VMPEI Price unit of previous period VMPEI DEC 5 0
VMSTP Standard price in the previous period VMSTP CURR 11 2
VJVER Moving Average Price/Periodic Unit Price in Previous Year VJVER CURR 11 2
VJPEI Price unit of previous year VJPEI DEC 5 0
VJSTP Standard price in previous year VJSTP CURR 11 2
REMNG Quantity invoiced REMNG QUAN 13 3
LVPVP Subcontracting: periodic unit price (PUP) CK_LVPVP_1 CURR 11 2
VMLPV Subcontracting: periodic unit price (PUP) CK_LVPVP_1 CURR 11 2
MENGU Quantity Updating in Material Master Record MENGU CHAR 1 0
X Yes
NULL No
WERTU Value Update in Material Master Record WERTU CHAR 1 0
X Yes
NULL No
MLAST Material Price Determination: Control CK_ML_ABST CHAR 1 0
2 Transaction-Based
3 Single-/Multilevel
MLMAA Material ledger activated at material level CK_ML_MAAC CHAR 1 0
X Yes
NULL No
KVERU Do Not Update Moving Price CK_KVERU CHAR 1 0
X Yes
NULL No
KALN1 Cost Estimate Number - Product Costing CK_KALNR1 NUMC 12 0
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
XEXEQ Exclusive enqueue for MBEW required XEXEQ CHAR 1 0
X Yes
NULL No
LPLPR Current Planned Price CK_LPLPR CURR 11 2
LPLPX Fixed Portion of Current Planned Price CK_LPLPX CURR 11 2
LBWST Val. Strat. for Current Plan Price, Sales Order/Proj. Stock CK_LBWST CHAR 1 0
1 Value from Product Cost Estimate for Sales Order
2 Value from Production Order Cost Estimate
3 Value from Make-to-Stock Inventory
4 Value from Make-to-Order Stock Segment
5 Value from Unit Cost Estimate for Sales Order
6 Value from User Exit
7 Value from Unit Cost Estimate for WBS Component
8 Value from Cost Estimate for a Configurable Material
9 Value from Production Lot Cost Estimate
HKMAT Material-related origin HKMAT CHAR 1 0
NULL No material-related origin
X Keep costs/quantities under material number
HRKFT Origin Group as Subdivision of Cost Element HRKFT CHAR 4 0
EKALR Material Is Costed with Quantity Structure CK_EKALREL CHAR 1 0
X Yes
NULL No
RMBEWH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
MBLFM Current period (posting period) LFMON NUMC 2 0
MBGJA Fiscal Year of Current Period LFGJA NUMC 4 0
MBRUE MxxxH rec. already exists for per. before last of Mxxx per. SBRUE CHAR 1 0
X Yes
NULL No
VMVKS Value of Tot. Valuated Stock at Sales Price in Previous Per. VMVKS CURR 13 2
VJVKS Value of Tot. Valuated Stock at Sales Price in Previous Year VJVKS CURR 13 2
VMVKS_OLD Value of Tot. Valuated Stock at Sales Price in Previous Per. VMVKS CURR 13 2
VJVKS_OLD Value of Tot. Valuated Stock at Sales Price in Previous Year VJVKS CURR 13 2
STPRS_OLD Standard price STPRS CURR 11 2
VERPR_OLD Moving Average Price/Periodic Unit Price VERPR CURR 11 2
PEINH_OLD Price Unit PEINH DEC 5 0
VMSTP_OLD Standard price STPRS CURR 11 2
VMVER_OLD Moving Average Price/Periodic Unit Price VERPR CURR 11 2
VMPEI_OLD Price Unit PEINH DEC 5 0
VJSTP_OLD Standard price STPRS CURR 11 2
VJVER_OLD Moving Average Price/Periodic Unit Price VERPR CURR 11 2
VJPEI_OLD Price Unit PEINH DEC 5 0
STPRV Previous price STPRV CURR 11 2
ZKPRS Future price DZKPRS CURR 11 2
ZKDAT Date as of which the price is valid DZKDAT DATS 8 0
LAEPR Date of the last price change LAEPR DATS 8 0
PRCHG Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
VMVPR Price control indicator VPRSV CHAR 1 0
S Standard price
V Moving average price/periodic unit price
VJVPR Price control indicator VPRSV CHAR 1 0
S Standard price
V Moving average price/periodic unit price
PRCHV Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
INS_OBLIG Data content X or blank XWERT CHAR 1 0
X Yes
NULL No

SIBEW foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SIBEW BKLAS SYST MANDT T025 Valuation Classes MANDT
SIBEW BKLAS SIBEW BKLAS T025 Valuation Classes BKLAS
SIBEW BWTTY SIBEW BWTTY T149C Global Valuation Categories BWTTY
SIBEW BWTTY SYST MANDT T149C Global Valuation Categories MANDT