The EBEW table in SAP ERP or S/4HANA stores Sales Order Stock Valuation data. There are total 74 fields in EBEW table. The Sales Order Stock Valuation table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of EBEW table. It is in Application development R/3 material master from 3.0 (MGA) ABAP package and is part of the Material Master (LO-MD-MM) module.
SAP EBEW Table Fields
Following is the list of fields that are available in SAP EBEW table. The primary key fields of the table are MANDT (Client), MATNR (Material Number), BWKEY (Valuation area), BWTAR (Valuation Type), SOBKZ (Special Stock Indicator), VBELN (Sales and Distribution Document Number), POSNR (Item number of the SD document).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| MATNR | Material Number | MATNR | CHAR (40) | |
| BWKEY | Valuation area | BWKEY | CHAR (4) | |
| BWTAR | Valuation Type | BWTAR_D | CHAR (10) | |
| SOBKZ | Special Stock Indicator | SOBKZ | CHAR (1) | |
| VBELN | Sales and Distribution Document Number | VBELN | CHAR (10) | |
| POSNR | Item number of the SD document | POSNR | NUMC (6) | |
| 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) | |
| ZPLPR | Future planned price | DZPLPR | CURR (11) | |
| KALKZ | Indicator: standard cost estimate for future period | KAXKZ | CHAR (1) | |
| KALKL | Standard Cost Estimate for Current Period | KALKL | CHAR (1) | |
| KALKV | Indicator: standard cost estimate for previous period | KALKV | CHAR (1) | |
| KALN1 | Cost Estimate Number – Product Costing | CK_KALNR1 | * | NUMC (12) |
| BWVA1 | Valuation Variant for Future Standard Cost Estimate | CK_BWVA1 | TCK05 | CHAR (3) |
| BWVA2 | Valuation Variant for Current Standard Cost Estimate | CK_BWVA2 | TCK05 | CHAR (3) |
| BWVA3 | Valuation Variant for Previous Standard Cost Estimate | CK_BWVA3 | TCK05 | CHAR (3) |
| VERS1 | Costing Version of Future Standard Cost Estimate | CK_TVERS1 | NUMC (2) | |
| VERS2 | Costing Version of Current Standard Cost Estimate | CK_TVERS2 | NUMC (2) | |
| VERS3 | Costing Version of Previous Standard Cost Estimate | CK_TVERS3 | NUMC (2) | |
| HRKFT | Origin Group as Subdivision of Cost Element | HRKFT | TKKH1 | CHAR (4) |
| KOSGR | Costing Overhead Group | CK_KOSGR | TCK14 | CHAR (10) |
| PPRDZ | Period of Future Standard Cost Estimate | CK_PPRDZ | NUMC (3) | |
| PPRDL | Period of Current Standard Cost Estimate | CK_PPRDL | NUMC (3) | |
| PPRDV | Period of Previous Standard Cost Estimate | CK_PPRDV | NUMC (3) | |
| PDATZ | Fiscal Year of Future Standard Cost Estimate | CK_PDATZ | NUMC (4) | |
| PDATL | Fiscal Year of Current Standard Cost Estimate | CK_PDATL | NUMC (4) | |
| PDATV | Fiscal Year of Previous Standard Cost Estimate | CK_PDATV | NUMC (4) | |
| EKALR | Material Is Costed with Quantity Structure | CK_EKALREL | CHAR (1) | |
| VPLPR | Previous planned price | VPLPR | CURR (11) | |
| MLMAA | Material Ledger Activated at Material Level | CK_ML_MAAC | CHAR (1) | |
| MLAST | Material Price Determination: Control | CK_ML_ABST | CHAR (1) | |
| LPLPR | Current Planned Price | CK_LPLPR | CURR (11) | |
| VKSAL | Value of Total Valuated Stock at Sales Price | VKSAL | CURR (13) | |
| HKMAT | Material-related origin | HKMAT | CHAR (1) | |
| BWSPA | Valuation margin | BWSPA | DEC (6) | |
| LPLPX | Fixed Portion of Current Planned Price | CK_LPLPX | CURR (11) | |
| VPLPX | Fixed Portion of Previous Planned Price | CK_VPLPX | CURR (11) | |
| FPLPX | Fixed Portion of Future Planned Price | CK_ZPLPX | CURR (11) | |
| LBWST | Val. Strat. for Current Plan Price, Sales Order/Proj. Stock | CK_LBWST | CHAR (1) | |
| VBWST | Valuation Strategy for Previous Planned Price, Special Stock | CK_VBWST | CHAR (1) | |
| FBWST | Valuation Strategy for Future Planned Price, Special Stock | CK_ZBWST | CHAR (1) | |
| MBRUE | MBEWH rec. already exists for per. before last of MBEW per. | MBRUE | CHAR (1) | |
| OKLAS | Valuation Class for Special Stock at the Vendor | OKLAS | T025 | CHAR (4) |
