1. Home
  2. Resources
  3. SAP Tables
  4. QBEW - Project Stock Valuation

SAP Table QBEW

Project Stock Valuation

QBEW (Project 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 QBEW to other SAP tables.

QBEW 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
PSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 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

QBEW foreign key relationships

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