1. Home
  2. Resources
  3. SAP Tables
  4. CKF_MBEW - MBEW + currency key + currency type

SAP Table CKF_MBEW

MBEW + currency key + currency type

CKF_MBEW (MBEW + currency key + currency type) 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 CKF_MBEW to other SAP tables.

Source: CKF_MBEW (MBEW + currency key + currency type)

CKF_MBEW table fields

Field Data element Checktable Datatype Length Decimals
CURRENCY_TYPE Currency Type CURRTYP CHAR 2 0
00 Document currency
10 Company code currency
20 Controlling area currency
30 Group currency
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
80 Ledger currency
90 Profit center accounting currency
A0 Financial management area currency
B0 Operating concern currency
C0 Consolidation unit currency
CURRENCY Currency Key WAERS CUKY 5 0
MBEW MBEW STRU 0 0
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
LVORM Deletion flag for all material data of a valuation type LVOBA CHAR 1 0
X Yes
NULL No
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 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 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 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 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
BWPRS Valuation price based on tax law: level 1 BWPRS CURR 11 2
BWPRH Valuation price based on commercial law: level 1 BWPRH CURR 11 2
VJBWS Valuation price based on tax law: level 3 VJBWS CURR 11 2
VJBWH Valuation price based on commercial law: level 3 VJBWH CURR 11 2
VVJSL Value of total valuated stock in year before last VVJSL CURR 13 2
VVJLB Total valuated stock in year before last VVJLB QUAN 13 3
VVMLB Total valuated stock in period before last VVMLB QUAN 13 3
VVSAL Value of total valuated stock in period before last VVSAL CURR 13 2
ZPLPR Future planned price DZPLPR CURR 11 2
ZPLP1 Future Planned Price 1 DZPLP1 CURR 11 2
ZPLP2 Future Planned Price 2 DZPLP2 CURR 11 2
ZPLP3 Future Planned Price 3 DZPLP3 CURR 11 2
ZPLD1 Date from Which Future Planned Price 1 Is Valid DZPLD1 DATS 8 0
ZPLD2 Date from Which Future Planned Price 2 Is Valid DZPLD2 DATS 8 0
ZPLD3 Date from Which Future Planned Price 3 Is Valid DZPLD3 DATS 8 0
PPERZ Period for future standard cost estimate (deactivated) PPERZ ACCP 6 0
PPERL Period for current standard cost estimate (deactivated) PPERL ACCP 6 0
PPERV Period for previous standard cost estimate (deactivated) PPERV ACCP 6 0
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
KALSC Overhead key (deactivated) KALSC CHAR 6 0
XLIFO LIFO/FIFO-Relevant XLIFO CHAR 1 0
X LIFO and FIFO Relevant
NULL Not LIFO/FIFO Relevant
1 LIFO-relevant
2 FIFO-relevant
3 LIFO- and FIFO-relevant (obsolete)
MYPOL Pool number for LIFO valuation MYPOOL CHAR 4 0
BWPH1 Valuation price based on commercial law: level 2 BWPH1 CURR 11 2
BWPS1 Valuation price based on tax law: level 2 BWPS1 CURR 11 2
ABWKZ Lowest value: devaluation indicator ABWKZ NUMC 2 0
PSTAT Maintenance status PSTAT_D CHAR 15 0
KALN1 Cost Estimate Number - Product Costing CK_KALNR1 NUMC 12 0
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
BWVA1 Valuation Variant for Future Standard Cost Estimate CK_BWVA1 CHAR 3 0
BWVA2 Valuation Variant for Current Standard Cost Estimate CK_BWVA2 CHAR 3 0
BWVA3 Valuation Variant for Previous Standard Cost Estimate CK_BWVA3 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 CHAR 4 0
KOSGR Costing Overhead Group CK_KOSGR 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
SPERW Physical Inventory Blocking Indicator SPERR CHAR 1 0
NULL No physical inventory defined for material
X Due to phys. inv., material is blocked for movements
A Physical inventory not yet completed for material
KZIWL Phys. inventory indicator for value-only material KZIWL CHAR 3 0
WLINL Date of Last Posted Count for Unrestricted-Use Stock DLINL DATS 8 0
ABCIW Physical inventory indicator for cycle counting ABCIN CHAR 1 0
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
EKLAS Valuation Class for Sales Order Stock EKLAS CHAR 4 0
QKLAS Valuation Class for Project Stock QKLAS CHAR 4 0
MTUSE Usage of the material J_1BMATUSE CHAR 1 0
0 Resale
1 Industrialisation
2 Consumption
3 Asset
MTORG Origin of the material J_1BMATORG CHAR 1 0
1 Foreign - imported directly
2 Foreign - acquired nationally
0 National - except indicated for codes 3, 4, 5 or 8
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
OWNPR Produced in-house J_1BOWNPRO CHAR 1 0
X Yes
NULL No
XBEWM Valuation based on the batch-specific unit of measure XBEWW CHAR 1 0
X Yes
NULL No
BWPEI Price unit for valuation prices based on tax/commercial law BWPEI DEC 5 0
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 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 CHAR 2 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP CHAR 2 0
OIHMTXGR Material tax group OIH_J1B_MTXGR CHAR 4 0
OIPPINV Prepaid Inventory Flag for Material Valuation Type Segment JV_PPINV CHAR 1 0
NULL No - Material is not Prepaid Inventory
X Yes - Material is Prepaid Inventory
CON_FIN_VALLEVEL Valuation Level CON_FIN_VALLEVEL CHAR 3 0
CON_FIN_VALPROC Valuation Procedure CON_FIN_VALPROC CHAR 3 0