1. Home
  2. Resources
  3. SAP Tables
  4. EBEW - Sales Order Stock Valuation

SAP Table EBEW

Sales Order Stock Valuation

EBEW (Sales Order Stock Valuation) 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 EBEW to other SAP tables.

EBEW table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
MATNR Material Number MATNR CHAR 18 0
BWKEY Valuation Area BWKEY CHAR 4 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
POSNR Item number of the SD document POSNR NUMC 6 0
LBKUM Total Valuated Stock LBKUM QUAN 13 3
SALK3 Value of Total Valuated Stock SALK3 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
BKLAS Valuation Class BKLAS T025 CHAR 4 0
SALKV Value based on moving average price (only with price ctrl S) SALKV 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
VMVPR Price Control Indicator in Previous Period VMVPR CHAR 1 0
S Standard price
V Moving average price/periodic unit price
VMVER Moving Average Price/Periodic Unit Price in Previous Period VMVER CURR 11 2
VMSTP Standard price in the previous period VMSTP CURR 11 2
VMPEI Price unit of previous period VMPEI DEC 5 0
VMBKL Valuation Class in Previous Period VMBKL T025 CHAR 4 0
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
VJVPR Price Control Indicator in Previous Year VJVPR CHAR 1 0
S Standard price
V Moving average price/periodic unit price
VJVER Moving Average Price/Periodic Unit Price in Previous Year VJVER CURR 11 2
VJSTP Standard price in previous year VJSTP CURR 11 2
VJPEI Price unit of previous year VJPEI DEC 5 0
VJBKL Valuation Class in Previous Year VJBKL T025 CHAR 4 0
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
STPRV Previous price STPRV CURR 11 2
LAEPR Date of the last price change LAEPR DATS 8 0
ZKPRS Future price DZKPRS CURR 11 2
ZKDAT Date as of which the price is valid DZKDAT DATS 8 0
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
ZPLPR Future planned price DZPLPR CURR 11 2
KALKZ Indicator: standard cost estimate for future period KAXKZ CHAR 1 0
X Yes
NULL No
KALKL Standard Cost Estimate for Current Period KALKL CHAR 1 0
X Yes
NULL No
KALKV Indicator: standard cost estimate for previous period KALKV CHAR 1 0
X Yes
NULL No
KALN1 Cost Estimate Number - Product Costing CK_KALNR1 NUMC 12 0
BWVA1 Valuation Variant for Future Standard Cost Estimate CK_BWVA1 TCK05 CHAR 3 0
BWVA2 Valuation Variant for Current Standard Cost Estimate CK_BWVA2 TCK05 CHAR 3 0
BWVA3 Valuation Variant for Previous Standard Cost Estimate CK_BWVA3 TCK05 CHAR 3 0
VERS1 Costing Version of Future Standard Cost Estimate CK_TVERS1 NUMC 2 0
VERS2 Costing Version of Current Standard Cost Estimate CK_TVERS2 NUMC 2 0
VERS3 Costing Version of Previous Standard Cost Estimate CK_TVERS3 NUMC 2 0
HRKFT Origin Group as Subdivision of Cost Element HRKFT TKKH1 CHAR 4 0
KOSGR Costing Overhead Group CK_KOSGR TCK14 CHAR 10 0
PPRDZ Period of Future Standard Cost Estimate CK_PPRDZ NUMC 3 0
PPRDL Period of Current Standard Cost Estimate CK_PPRDL NUMC 3 0
PPRDV Period of Previous Standard Cost Estimate CK_PPRDV NUMC 3 0
PDATZ Fiscal Year of Future Standard Cost Estimate CK_PDATZ NUMC 4 0
PDATL Fiscal Year of Current Standard Cost Estimate CK_PDATL NUMC 4 0
PDATV Fiscal Year of Previous Standard Cost Estimate CK_PDATV NUMC 4 0
EKALR Material Is Costed with Quantity Structure CK_EKALREL CHAR 1 0
X Yes
NULL No
VPLPR Previous planned price VPLPR CURR 11 2
MLMAA Material ledger activated at material level CK_ML_MAAC CHAR 1 0
X Yes
NULL No
MLAST Material Price Determination: Control CK_ML_ABST CHAR 1 0
2 Transaction-Based
3 Single-/Multilevel
LPLPR Current Planned Price CK_LPLPR CURR 11 2
VKSAL Value of Total Valuated Stock at Sales Price VKSAL CURR 13 2
HKMAT Material-related origin HKMAT CHAR 1 0
NULL No material-related origin
X Keep costs/quantities under material number
BWSPA Valuation margin BWSPA DEC 6 2
LPLPX Fixed Portion of Current Planned Price CK_LPLPX CURR 11 2
VPLPX Fixed Portion of Previous Planned Price CK_VPLPX CURR 11 2
FPLPX Fixed Portion of Future Planned Price CK_ZPLPX 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
VBWST Valuation Strategy for Previous Plan Price, Special Stock CK_VBWST 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
FBWST Valuation Strategy for Future Planned Price, Special Stock CK_ZBWST 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
MBRUE MBEWH rec. already exists for per. before last of MBEW per. MBRUE CHAR 1 0
X Yes
NULL No
OKLAS Valuation Class for Special Stock at the Vendor OKLAS T025 CHAR 4 0
OICURVAL Current value OIH_CURVAL CURR 13 2
OICURDATE Current date OIH_CURDAT DATS 8 0
OICURQTY Current quantity OIH_CURQTY QUAN 13 3
OICURUT Current unit of measure OIH_CURUT UNIT 3 0
OIFUTVAL Future value OIH_FUTVAL CURR 13 2
OIFUTDATE Future date OIH_FUTDAT DATS 8 0
OIFUTQTY Future quantity OIH_FUTQTY QUAN 13 3
OIFUTUT Future unit of measure OIH_FUTUT UNIT 3 0
OINVALQTY Not to be used!!! (non valuated quantity) OIH_NVALQT QUAN 13 3
OIREQUAT Quantity to be revaluated OIH_REQUAT QUAN 13 3
OITAXKEY Excise Duty Status OIH_TAXKEY OIH4 CHAR 2 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP OIH5 CHAR 2 0
OIHMTXGR Material tax group OIH_J1B_MTXGR OIH2M_J1B CHAR 4 0

EBEW foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EBEW BKLAS SYST MANDT T025 Valuation Classes MANDT
EBEW BKLAS EBEW BKLAS T025 Valuation Classes BKLAS
EBEW BWTTY SYST MANDT T149C Global Valuation Categories MANDT
EBEW BWTTY EBEW BWTTY T149C Global Valuation Categories BWTTY
EBEW BWVA1 SYST MANDT TCK05 Valuation Variants in Costing MANDT
EBEW BWVA1 EBEW BWVA1 TCK05 Valuation Variants in Costing BWVAR
EBEW BWVA2 EBEW BWVA2 TCK05 Valuation Variants in Costing BWVAR
EBEW BWVA2 SYST MANDT TCK05 Valuation Variants in Costing MANDT
EBEW BWVA3 SYST MANDT TCK05 Valuation Variants in Costing MANDT
EBEW BWVA3 EBEW BWVA3 TCK05 Valuation Variants in Costing BWVAR
EBEW HRKFT SYST MANDT TKKH1 Origin in CO Object MANDT
EBEW HRKFT RM03M KOKRS TKKH1 Origin in CO Object KOKRS
EBEW HRKFT '02' TKKH1 Origin in CO Object KOATY
EBEW HRKFT EBEW HRKFT TKKH1 Origin in CO Object HRKFT
EBEW KOSGR EBEW KOSGR TCK14 Overhead Groups KOSGR
EBEW KOSGR SYST MANDT TCK14 Overhead Groups MANDT
EBEW KOSGR MBEW BWKEY TCK14 Overhead Groups BWKEY
EBEW OIHANTYP SYST MANDT OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) MANDT
EBEW OIHANTYP EBEW OIHANTYP OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) HANTYP
EBEW OIHMTXGR SYST MANDT OIH2M_J1B Check table for material tax group MANDT
EBEW OIHMTXGR EBEW OIHMTXGR OIH2M_J1B Check table for material tax group OIHMTXGR
EBEW OITAXKEY EBEW OITAXKEY OIH4 Excise duty tax status (IS-Oil TDP standard/core object) TAXKEY
EBEW OITAXKEY SYST MANDT OIH4 Excise duty tax status (IS-Oil TDP standard/core object) MANDT
EBEW OKLAS SYST MANDT T025 Valuation Classes MANDT
EBEW OKLAS EBEW OKLAS T025 Valuation Classes BKLAS
EBEW VJBKL SYST MANDT T025 Valuation Classes MANDT
EBEW VJBKL EBEW VJBKL T025 Valuation Classes BKLAS
EBEW VMBKL SYST MANDT T025 Valuation Classes MANDT
EBEW VMBKL EBEW VMBKL T025 Valuation Classes BKLAS