SAP WBEW Active Ingredient Valuation Table
Overview
WBEW is a standard SAP S/4HANA table that stores Active Ingredient Valuation data. There are total 37 fields in the WBEW table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WBEW belongs to Batches (LO-BM) module and is located in the package Batch Management Proportion/Product Units (VBWS).
In addition, following links provide an overview of foreign key relationships, if any, that link WBEW to other SAP tables and standard CDS views available based on WBEW table in S/4HANA 2020.
Techincal Settings of WBEW
Below are technical details of the table WBEW
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WBEW Fields
The following table gives you an overview of the fields available in WBEW
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| MATNR | Material Number | MATNR | MARM | CHAR | 40 |
| BWKEY | Valuation area | BWKEY | MBEW | CHAR | 4 |
| BWTAR | Valuation Type | BWTAR_D | T149D | CHAR | 10 |
| MEINH | Alternative Unit of Measure for Stockkeeping Unit | LRMEI | MARM | UNIT | 3 |
| LBKUM | Total Valuated Stock | LBKUM | QUAN | 13 | |
| SALK3 | Value of Total Valuated Stock | SALK3 | CURR | 13 | |
| VPRSV | Price control indicator | VPRSV | CHAR | 1 | |
| VERPR | Moving Average Price/Periodic Unit Price | VERPR | CURR | 11 | |
| STPRS | Standard price | STPRS | CURR | 11 | |
| PEINH | Price unit | PEINH | DEC | 5 | |
| BKLAS | Valuation Class | BKLAS | T025 | CHAR | 4 |
| SALKV | Value based on moving average price (only with price ctrl S) | SALKV | CURR | 13 | |
| VMKUM | Total valuated stock in previous period | VMKUM | QUAN | 13 | |
| VMSAL | Value of total valuated stock in previous period | VMSAL | CURR | 13 | |
| VMVPR | Price Control Indicator in Previous Period | VMVPR | CHAR | 1 | |
| VMVER | Moving Average Price/Periodic Unit Price in Previous Period | VMVER | CURR | 11 | |
| VMSTP | Standard price in the previous period | VMSTP | CURR | 11 | |
| VMPEI | Price unit of previous period | VMPEI | DEC | 5 | |
| VMBKL | Valuation Class in Previous Period | VMBKL | T025 | CHAR | 4 |
| VMSAV | Value based on moving average price (previous period) | VMSAV | CURR | 13 | |
| VJKUM | Total Valuated Stock in Previous Year | VJKUM | QUAN | 13 | |
| VJSAL | Value of total valuated stock in previous year | VJSAL | CURR | 13 | |
| VJVPR | Price Control Indicator in Previous Year | VJVPR | CHAR | 1 | |
| VJVER | Moving Average Price/Periodic Unit Price in Previous Year | VJVER | CURR | 11 | |
| VJSTP | Standard price in previous year | VJSTP | CURR | 11 | |
| VJPEI | Price unit of previous year | VJPEI | DEC | 5 | |
| VJBKL | Valuation Class in Previous Year | VJBKL | T025 | CHAR | 4 |
| VJSAV | Value based on moving average price (previous year) | VJSAV | CURR | 13 | |
| LFGJA | Fiscal Year of Current Period | LFGJA | NUMC | 4 | |
| LFMON | Current period (posting period) | LFMON | NUMC | 2 | |
| BWTTY | Valuation Category | BWTTY_D | T149C | CHAR | 1 |
| STPRV | Previous price | STPRV | CURR | 11 | |
| LAEPR | Date of the last price change | LAEPR | DATS | 8 | |
| ZKPRS | Future price | DZKPRS | CURR | 11 | |
| ZKDAT | Date as of which the price is valid | DZKDAT | DATS | 8 | |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WBEW
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WBEW | BKLAS | C: CN | T025 |
| WBEW | BWKEY | 1: CN | MBEW |
| WBEW | BWTAR | : | T149D |
| WBEW | BWTTY | C: CN | T149C |
| WBEW | MANDT | 1: CN | T000 |
| WBEW | MATNR | 1: CN | MARM |
| WBEW | MEINH | 1: CN | MARM |
| WBEW | VJBKL | C: CN | T025 |
| WBEW | VMBKL | C: CN | T025 |