SIBEW SAP (Material-Values-Block Table Include) Structure details

Dictionary Type: Structure
Description: Material-Values-Block Table Include




ABAP Code to SELECT data from SIBEW
Related tables to SIBEW
Access table SIBEW




Structure field list including key, data, relationships and ABAP select examples

SIBEW is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Material-Values-Block Table Include" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_SIBEW TYPE SIBEW.

The SIBEW table consists of various fields, each holding specific information or linking keys about Material-Values-Block Table Include data available in SAP. These include XRUEM (Allow Posting to Previous Period (Backposting)), XRUEJ (Indicator: post to previous year), RMBEW (Return code MBEW), LBKUM (Total Valuated Stock).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP SIBEW structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
XRUEMAllow Posting to Previous Period (Backposting) XRUEMCHAR1XFELD
XRUEJIndicator: post to previous year XRUEJCHAR1XFELD
RMBEWReturn code MBEW RMBEWCHAR1XFELD
LBKUMTotal Valuated Stock LBKUMQUAN13(3) MENG13V
SALK3Value of Total Valuated Stock SALK3CURR13(2) WERT13N
SALKVValue based on moving average price (only with price ctrl S) SALKVCURR13(2) WERT13N
VKSALValue of Total Valuated Stock at Sales Price VKSALCURR13(2) WERT13N
VMKUMTotal valuated stock in previous period VMKUMQUAN13(3) MENG13V
VMSALValue of total valuated stock in previous period VMSALCURR13(2) WERT13N
VMSAVValue based on moving average price (previous period) VMSAVCURR13(2) WERT13N
VJKUMTotal Valuated Stock in Previous Year VJKUMQUAN13(3) MENG13V
VJSALValue of total valuated stock in previous year VJSALCURR13(2) WERT13N
VJSAVValue based on moving average price (previous year) VJSAVCURR13(2) WERT13N
LFGJAFiscal Year of Current Period LFGJANUMC4GJAHRGJAHR
LFMONCurrent period (posting period) LFMONNUMC2MONAT
BWTTYValuation Category BWTTY_DCHAR1T149CBWTTY
BKLASValuation Class BKLASCHAR4T025BKLAS
EKLASValuation Class for Sales Order Stock EKLASCHAR4Assigned to domainBKLAS
QKLASValuation Class for Project Stock QKLASCHAR4Assigned to domainBKLAS
OKLASValuation Class for Special Stock at the Vendor OKLASCHAR4Assigned to domainBKLAS
LBKUM_OLDTotal Valuated Stock LBKUMQUAN13(3) MENG13V
SALK3_OLDValue of Total Valuated Stock SALK3CURR13(2) WERT13N
SALKV_OLDValue based on moving average price (only with price ctrl S) SALKVCURR13(2) WERT13N
VKSAL_OLDValue of Total Valuated Stock at Sales Price VKSALCURR13(2) WERT13N
VMKUM_OLDTotal valuated stock in previous period VMKUMQUAN13(3) MENG13V
VMSAL_OLDValue of total valuated stock in previous period VMSALCURR13(2) WERT13N
VMSAV_OLDValue based on moving average price (previous period) VMSAVCURR13(2) WERT13N
VJKUM_OLDTotal Valuated Stock in Previous Year VJKUMQUAN13(3) MENG13V
VJSAL_OLDValue of total valuated stock in previous year VJSALCURR13(2) WERT13N
VJSAV_OLDValue based on moving average price (previous year) VJSAVCURR13(2) WERT13N
VPRSVPrice control indicator VPRSVCHAR1VPRSV
VERPRMoving Average Price/Periodic Unit Price VERPRCURR11(2) WERT11V
STPRSStandard price STPRSCURR11(2) WERT11V
PEINHPrice Unit PEINHDEC5PACK3
VMVERMoving Average Price/Periodic Unit Price in Previous Period VMVERCURR11(2) WERT11V
VMPEIPrice unit of previous period VMPEIDEC5PACK3
VMSTPStandard price in the previous period VMSTPCURR11(2) WERT11V
VJVERMoving Average Price/Periodic Unit Price in Previous Year VJVERCURR11(2) WERT11V
VJPEIPrice unit of previous year VJPEIDEC5PACK3
VJSTPStandard price in previous year VJSTPCURR11(2) WERT11V
REMNGQuantity invoiced REMNGQUAN13(3) MENG13
LVPVPSubcontracting: periodic unit price (PUP) CK_LVPVP_1CURR11(2) WERT11
VMLPVSubcontracting: periodic unit price (PUP) CK_LVPVP_1CURR11(2) WERT11
MENGUQuantity Updating in Material Master Record MENGUCHAR1XFELD
WERTUValue Update in Material Master Record WERTUCHAR1XFELD
MLASTMaterial Price Determination: Control CK_ML_ABSTCHAR1CK_ML_ABST
MLMAAMaterial ledger activated at material level CK_ML_MAACCHAR1XFELD
KVERUDo Not Update Moving Price CK_KVERUCHAR1XFELD
KALN1Cost Estimate Number - Product Costing CK_KALNR1NUMC12Assigned to domainCK_KALNRKNE
KALNRCost Estimate Number for Cost Est. w/o Qty Structure CK_KALNRNUMC12Assigned to domainCK_KALNRKNR
XEXEQExclusive enqueue for MBEW required XEXEQCHAR1XFELD
LPLPRCurrent Planned Price CK_LPLPRCURR11(2) WERT11
LPLPXFixed Portion of Current Planned Price CK_LPLPXCURR11(2) WERT11V
LBWSTVal. Strat. for Current Plan Price, Sales Order/Proj. Stock CK_LBWSTCHAR1CK_BWST
HKMATMaterial-related origin HKMATCHAR1HKMAT
HRKFTOrigin Group as Subdivision of Cost Element HRKFTCHAR4Assigned to domainHRKFT
EKALRMaterial Is Costed with Quantity Structure CK_EKALRELCHAR1XFELD
RMBEWHData content X or blank XWERTCHAR1XFELD
MBLFMCurrent period (posting period) LFMONNUMC2MONAT
MBGJAFiscal Year of Current Period LFGJANUMC4GJAHRGJAHR
MBRUEMxxxH rec. already exists for per. before last of Mxxx per. SBRUECHAR1XFELD
VMVKSValue of Tot. Valuated Stock at Sales Price in Previous Per. VMVKSCURR13(2) WERT13N
VJVKSValue of Tot. Valuated Stock at Sales Price in Previous Year VJVKSCURR13(2) WERT13N
VMVKS_OLDValue of Tot. Valuated Stock at Sales Price in Previous Per. VMVKSCURR13(2) WERT13N
VJVKS_OLDValue of Tot. Valuated Stock at Sales Price in Previous Year VJVKSCURR13(2) WERT13N
STPRS_OLDStandard price STPRSCURR11(2) WERT11V
VERPR_OLDMoving Average Price/Periodic Unit Price VERPRCURR11(2) WERT11V
PEINH_OLDPrice Unit PEINHDEC5PACK3
VMSTP_OLDStandard price STPRSCURR11(2) WERT11V
VMVER_OLDMoving Average Price/Periodic Unit Price VERPRCURR11(2) WERT11V
VMPEI_OLDPrice Unit PEINHDEC5PACK3
VJSTP_OLDStandard price STPRSCURR11(2) WERT11V
VJVER_OLDMoving Average Price/Periodic Unit Price VERPRCURR11(2) WERT11V
VJPEI_OLDPrice Unit PEINHDEC5PACK3
STPRVPrevious price STPRVCURR11(2) WERT11V
ZKPRSFuture price DZKPRSCURR11(2) WERT11
ZKDATDate as of which the price is valid DZKDATDATS8DATUM
LAEPRDate of the last price change LAEPRDATS8DATUM
PRCHGData content X or blank XWERTCHAR1XFELD
VMVPRPrice control indicator VPRSVCHAR1VPRSV
VJVPRPrice control indicator VPRSVCHAR1VPRSV
PRCHVData content X or blank XWERTCHAR1XFELD
INS_OBLIGData content X or blank XWERTCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP structure SIBEW using ABAP code?

As SIBEW is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SIBEW as there is no data to select.

How to access SAP table SIBEW

Within an ECC or HANA version of SAP you can also view further information about SIBEW and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!