SAP table EBEW (Sales Order Stock Valuation)

SAP table EBEW has 7 primary key fields being MANDT,MATNR,BWKEY,BWTAR,SOBKZ,VBELN,POSNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
MATNR Material Number CHAR 40 0 MATNR
BWKEY Valuation area CHAR 4 0 BWKEY
BWTAR Valuation Type CHAR 10 0 BWTAR_D
SOBKZ Special Stock Indicator CHAR 1 0 SOBKZ
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
POSNR Item number of the SD document NUMC 6 0 POSNR
LBKUM Total Valuated Stock QUAN 13 3 LBKUM
SALK3 Value of Total Valuated Stock CURR 13 2 SALK3
VPRSV Price control indicator CHAR 1 0 VPRSV
S Standard price
V Moving average price/periodic unit price
VERPR Moving Average Price/Periodic Unit Price CURR 11 2 VERPR
STPRS Standard price CURR 11 2 STPRS
PEINH Price unit DEC 5 0 PEINH
BKLAS Valuation Class CHAR 4 0 T025 BKLAS
SALKV Value based on moving average price (only with price ctrl S) CURR 13 2 SALKV
VMKUM Total valuated stock in previous period QUAN 13 3 VMKUM
VMSAL Value of total valuated stock in previous period CURR 13 2 VMSAL
VMVPR Price Control Indicator in Previous Period CHAR 1 0 VMVPR
VMVER Moving Average Price/Periodic Unit Price in Previous Period CURR 11 2 VMVER
VMSTP Standard price in the previous period CURR 11 2 VMSTP
VMPEI Price unit of previous period DEC 5 0 VMPEI
VMBKL Valuation Class in Previous Period CHAR 4 0 T025 VMBKL
VMSAV Value based on moving average price (previous period) CURR 13 2 VMSAV
VJKUM Total Valuated Stock in Previous Year QUAN 13 3 VJKUM
VJSAL Value of total valuated stock in previous year CURR 13 2 VJSAL
VJVPR Price Control Indicator in Previous Year CHAR 1 0 VJVPR
VJVER Moving Average Price/Periodic Unit Price in Previous Year CURR 11 2 VJVER
VJSTP Standard price in previous year CURR 11 2 VJSTP
VJPEI Price unit of previous year DEC 5 0 VJPEI
VJBKL Valuation Class in Previous Year CHAR 4 0 T025 VJBKL
VJSAV Value based on moving average price (previous year) CURR 13 2 VJSAV
LFGJA Fiscal Year of Current Period NUMC 4 0 LFGJA
LFMON Current period (posting period) NUMC 2 0 LFMON
BWTTY Valuation Category CHAR 1 0 T149C BWTTY_D
STPRV Previous Price CURR 11 2 STPRV
LAEPR Date of Last Price Change DATS 8 0 LAEPR
ZKPRS Future Price CURR 11 2 DZKPRS
ZKDAT Date as of which the price is valid DATS 8 0 DZKDAT
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
ZPLPR Future planned price CURR 11 2 DZPLPR
KALKZ Indicator: standard cost estimate for future period CHAR 1 0 KAXKZ
KALKL Standard Cost Estimate for Current Period CHAR 1 0 KALKL
KALKV Indicator: Standard Cost Estimate for Previous Period CHAR 1 0 KALKV
KALN1 Cost Estimate Number - Product Costing NUMC 12 0 * CK_KALNR1
BWVA1 Valuation Variant for Future Standard Cost Estimate CHAR 3 0 TCK05 CK_BWVA1
BWVA2 Valuation Variant for Current Standard Cost Estimate CHAR 3 0 TCK05 CK_BWVA2
BWVA3 Valuation Variant for Previous Standard Cost Estimate CHAR 3 0 TCK05 CK_BWVA3
VERS1 Costing Version of Future Standard Cost Estimate NUMC 2 0 CK_TVERS1
VERS2 Costing Version of Current Standard Cost Estimate NUMC 2 0 CK_TVERS2
VERS3 Costing Version of Previous Standard Cost Estimate NUMC 2 0 CK_TVERS3
HRKFT Origin Group as Subdivision of Cost Element CHAR 4 0 TKKH1 HRKFT
KOSGR Costing Overhead Group CHAR 10 0 TCK14 CK_KOSGR
PPRDZ Period of Future Standard Cost Estimate NUMC 3 0 CK_PPRDZ
PPRDL Period of Current Standard Cost Estimate NUMC 3 0 CK_PPRDL
PPRDV Period of Previous Standard Cost Estimate NUMC 3 0 CK_PPRDV
PDATZ Fiscal Year of Future Standard Cost Estimate NUMC 4 0 CK_PDATZ
PDATL Fiscal Year of Current Standard Cost Estimate NUMC 4 0 CK_PDATL
PDATV Fiscal Year of Previous Standard Cost Estimate NUMC 4 0 CK_PDATV
EKALR Material Is Costed with Quantity Structure CHAR 1 0 CK_EKALREL
VPLPR Previous Planned Price CURR 11 2 VPLPR
MLMAA Material Ledger Activated at Material Level CHAR 1 0 CK_ML_MAAC
MLAST Material Price Determination: Control CHAR 1 0 CK_ML_ABST
2 Transaction-Based
3 Single-/Multilevel
LPLPR Current Planned Price CURR 11 2 CK_LPLPR
VKSAL Value of Total Valuated Stock at Sales Price CURR 13 2 VKSAL
HKMAT Material-related origin CHAR 1 0 HKMAT
No material-related origin
X Keep costs/quantities under material number
BWSPA Valuation margin DEC 6 2 BWSPA
LPLPX Fixed Portion of Current Planned Price CURR 11 2 CK_LPLPX
VPLPX Fixed Portion of Previous Planned Price CURR 11 2 CK_VPLPX
FPLPX Fixed Portion of Future Planned Price CURR 11 2 CK_ZPLPX
LBWST Val. Strat. for Current Plan Price, Sales Order/Proj. Stock CHAR 1 0 CK_LBWST
VBWST Valuation Strategy for Previous Planned Price, Special Stock CHAR 1 0 CK_VBWST
FBWST Valuation Strategy for Future Planned Price, Special Stock CHAR 1 0 CK_ZBWST
MBRUE MBEWH rec. already exists for per. before last of MBEW per. CHAR 1 0 MBRUE
OKLAS Valuation Class for Special Stock at the Vendor CHAR 4 0 T025 OKLAS

EBEW foreign key relationships

Table Field Check Table Check Field
0 EBEW BKLAS T025 Valuation Classes MANDT
0 EBEW BKLAS T025 Valuation Classes BKLAS
1 EBEW BWTTY T149C Global Valuation Categories BWTTY
0 EBEW BWVA1 TCK05 Valuation Variants in Costing MANDT
1 EBEW BWVA2 TCK05 Valuation Variants in Costing MANDT
0 EBEW BWVA3 TCK05 Valuation Variants in Costing MANDT
1 EBEW HRKFT TKKH1 Origin in CO Object KOKRS
1 EBEW HRKFT TKKH1 Origin in CO Object KOATY
1 EBEW HRKFT TKKH1 Origin in CO Object HRKFT
0 EBEW KOSGR TCK14 Overhead Groups MANDT
0 EBEW KOSGR TCK14 Overhead Groups KOSGR
1 EBEW OKLAS T025 Valuation Classes MANDT
1 EBEW OKLAS T025 Valuation Classes BKLAS
0 EBEW VJBKL T025 Valuation Classes MANDT
0 EBEW VJBKL T025 Valuation Classes BKLAS
1 EBEW VMBKL T025 Valuation Classes MANDT
1 EBEW VMBKL T025 Valuation Classes BKLAS