SIBEW SAP (Material-Values-Block Table Include) Structure details
Description: Material-Values-Block Table Include
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 |
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
XRUEM | Allow Posting to Previous Period (Backposting) | XRUEM | CHAR | 1 | XFELD | ||||
XRUEJ | Indicator: post to previous year | XRUEJ | CHAR | 1 | XFELD | ||||
RMBEW | Return code MBEW | RMBEW | CHAR | 1 | XFELD | ||||
LBKUM | Total Valuated Stock | LBKUM | QUAN | 13(3) | MENG13V | ||||
SALK3 | Value of Total Valuated Stock | SALK3 | CURR | 13(2) | WERT13N | ||||
SALKV | Value based on moving average price (only with price ctrl S) | SALKV | CURR | 13(2) | WERT13N | ||||
VKSAL | Value of Total Valuated Stock at Sales Price | VKSAL | CURR | 13(2) | WERT13N | ||||
VMKUM | Total valuated stock in previous period | VMKUM | QUAN | 13(3) | MENG13V | ||||
VMSAL | Value of total valuated stock in previous period | VMSAL | CURR | 13(2) | WERT13N | ||||
VMSAV | Value based on moving average price (previous period) | VMSAV | CURR | 13(2) | WERT13N | ||||
VJKUM | Total Valuated Stock in Previous Year | VJKUM | QUAN | 13(3) | MENG13V | ||||
VJSAL | Value of total valuated stock in previous year | VJSAL | CURR | 13(2) | WERT13N | ||||
VJSAV | Value based on moving average price (previous year) | VJSAV | CURR | 13(2) | WERT13N | ||||
LFGJA | Fiscal Year of Current Period | LFGJA | NUMC | 4 | GJAHR | GJAHR | |||
LFMON | Current period (posting period) | LFMON | NUMC | 2 | MONAT | ||||
BWTTY | Valuation Category | BWTTY_D | CHAR | 1 | T149C | BWTTY | |||
BKLAS | Valuation Class | BKLAS | CHAR | 4 | T025 | BKLAS | |||
EKLAS | Valuation Class for Sales Order Stock | EKLAS | CHAR | 4 | Assigned to domain | BKLAS | |||
QKLAS | Valuation Class for Project Stock | QKLAS | CHAR | 4 | Assigned to domain | BKLAS | |||
OKLAS | Valuation Class for Special Stock at the Vendor | OKLAS | CHAR | 4 | Assigned to domain | BKLAS | |||
LBKUM_OLD | Total Valuated Stock | LBKUM | QUAN | 13(3) | MENG13V | ||||
SALK3_OLD | Value of Total Valuated Stock | SALK3 | CURR | 13(2) | WERT13N | ||||
SALKV_OLD | Value based on moving average price (only with price ctrl S) | SALKV | CURR | 13(2) | WERT13N | ||||
VKSAL_OLD | Value of Total Valuated Stock at Sales Price | VKSAL | CURR | 13(2) | WERT13N | ||||
VMKUM_OLD | Total valuated stock in previous period | VMKUM | QUAN | 13(3) | MENG13V | ||||
VMSAL_OLD | Value of total valuated stock in previous period | VMSAL | CURR | 13(2) | WERT13N | ||||
VMSAV_OLD | Value based on moving average price (previous period) | VMSAV | CURR | 13(2) | WERT13N | ||||
VJKUM_OLD | Total Valuated Stock in Previous Year | VJKUM | QUAN | 13(3) | MENG13V | ||||
VJSAL_OLD | Value of total valuated stock in previous year | VJSAL | CURR | 13(2) | WERT13N | ||||
VJSAV_OLD | Value based on moving average price (previous year) | VJSAV | CURR | 13(2) | WERT13N | ||||
VPRSV | Price control indicator | VPRSV | CHAR | 1 | VPRSV | ||||
VERPR | Moving Average Price/Periodic Unit Price | VERPR | CURR | 11(2) | WERT11V | ||||
STPRS | Standard price | STPRS | CURR | 11(2) | WERT11V | ||||
PEINH | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
VMVER | Moving Average Price/Periodic Unit Price in Previous Period | VMVER | CURR | 11(2) | WERT11V | ||||
VMPEI | Price unit of previous period | VMPEI | DEC | 5 | PACK3 | ||||
VMSTP | Standard price in the previous period | VMSTP | CURR | 11(2) | WERT11V | ||||
VJVER | Moving Average Price/Periodic Unit Price in Previous Year | VJVER | CURR | 11(2) | WERT11V | ||||
VJPEI | Price unit of previous year | VJPEI | DEC | 5 | PACK3 | ||||
VJSTP | Standard price in previous year | VJSTP | CURR | 11(2) | WERT11V | ||||
REMNG | Quantity invoiced | REMNG | QUAN | 13(3) | MENG13 | ||||
LVPVP | Subcontracting: periodic unit price (PUP) | CK_LVPVP_1 | CURR | 11(2) | WERT11 | ||||
VMLPV | Subcontracting: periodic unit price (PUP) | CK_LVPVP_1 | CURR | 11(2) | WERT11 | ||||
MENGU | Quantity Updating in Material Master Record | MENGU | CHAR | 1 | XFELD | ||||
WERTU | Value Update in Material Master Record | WERTU | CHAR | 1 | XFELD | ||||
MLAST | Material Price Determination: Control | CK_ML_ABST | CHAR | 1 | CK_ML_ABST | ||||
MLMAA | Material ledger activated at material level | CK_ML_MAAC | CHAR | 1 | XFELD | ||||
KVERU | Do Not Update Moving Price | CK_KVERU | CHAR | 1 | XFELD | ||||
KALN1 | Cost Estimate Number - Product Costing | CK_KALNR1 | NUMC | 12 | Assigned to domain | CK_KALNR | KNE | ||
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | Assigned to domain | CK_KALNR | KNR | ||
XEXEQ | Exclusive enqueue for MBEW required | XEXEQ | CHAR | 1 | XFELD | ||||
LPLPR | Current Planned Price | CK_LPLPR | CURR | 11(2) | WERT11 | ||||
LPLPX | Fixed Portion of Current Planned Price | CK_LPLPX | CURR | 11(2) | WERT11V | ||||
LBWST | Val. Strat. for Current Plan Price, Sales Order/Proj. Stock | CK_LBWST | CHAR | 1 | CK_BWST | ||||
HKMAT | Material-related origin | HKMAT | CHAR | 1 | HKMAT | ||||
HRKFT | Origin Group as Subdivision of Cost Element | HRKFT | CHAR | 4 | Assigned to domain | HRKFT | |||
EKALR | Material Is Costed with Quantity Structure | CK_EKALREL | CHAR | 1 | XFELD | ||||
RMBEWH | Data content X or blank | XWERT | CHAR | 1 | XFELD | ||||
MBLFM | Current period (posting period) | LFMON | NUMC | 2 | MONAT | ||||
MBGJA | Fiscal Year of Current Period | LFGJA | NUMC | 4 | GJAHR | GJAHR | |||
MBRUE | MxxxH rec. already exists for per. before last of Mxxx per. | SBRUE | CHAR | 1 | XFELD | ||||
VMVKS | Value of Tot. Valuated Stock at Sales Price in Previous Per. | VMVKS | CURR | 13(2) | WERT13N | ||||
VJVKS | Value of Tot. Valuated Stock at Sales Price in Previous Year | VJVKS | CURR | 13(2) | WERT13N | ||||
VMVKS_OLD | Value of Tot. Valuated Stock at Sales Price in Previous Per. | VMVKS | CURR | 13(2) | WERT13N | ||||
VJVKS_OLD | Value of Tot. Valuated Stock at Sales Price in Previous Year | VJVKS | CURR | 13(2) | WERT13N | ||||
STPRS_OLD | Standard price | STPRS | CURR | 11(2) | WERT11V | ||||
VERPR_OLD | Moving Average Price/Periodic Unit Price | VERPR | CURR | 11(2) | WERT11V | ||||
PEINH_OLD | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
VMSTP_OLD | Standard price | STPRS | CURR | 11(2) | WERT11V | ||||
VMVER_OLD | Moving Average Price/Periodic Unit Price | VERPR | CURR | 11(2) | WERT11V | ||||
VMPEI_OLD | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
VJSTP_OLD | Standard price | STPRS | CURR | 11(2) | WERT11V | ||||
VJVER_OLD | Moving Average Price/Periodic Unit Price | VERPR | CURR | 11(2) | WERT11V | ||||
VJPEI_OLD | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
STPRV | Previous price | STPRV | CURR | 11(2) | WERT11V | ||||
ZKPRS | Future price | DZKPRS | CURR | 11(2) | WERT11 | ||||
ZKDAT | Date as of which the price is valid | DZKDAT | DATS | 8 | DATUM | ||||
LAEPR | Date of the last price change | LAEPR | DATS | 8 | DATUM | ||||
PRCHG | Data content X or blank | XWERT | CHAR | 1 | XFELD | ||||
VMVPR | Price control indicator | VPRSV | CHAR | 1 | VPRSV | ||||
VJVPR | Price control indicator | VPRSV | CHAR | 1 | VPRSV | ||||
PRCHV | Data content X or blank | XWERT | CHAR | 1 | XFELD | ||||
INS_OBLIG | Data content X or blank | XWERT | CHAR | 1 | XFELD |
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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects