CKF_MBEW SAP (MBEW + currency key + currency type) Structure details

Dictionary Type: Structure
Description: MBEW + currency key + currency type




ABAP Code to SELECT data from CKF_MBEW
Related tables to CKF_MBEW
Access table CKF_MBEW




Structure field list including key, data, relationships and ABAP select examples

CKF_MBEW is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "MBEW + currency key + currency type" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CKF_MBEW TYPE CKF_MBEW.

The CKF_MBEW table consists of various fields, each holding specific information or linking keys about MBEW + currency key + currency type data available in SAP. These include CURRENCY (Currency Key), MBEW (), MANDT (Client), MATNR (Material Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CKF_MBEW structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CURRENCY_TYPECurrency Type CURRTYPCHAR2CURRTYP
CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
MBEW 0
MANDTClient MANDTCLNT3MANDT
MATNRMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
BWKEYValuation Area BWKEYCHAR4BWKEYBWK
BWTARValuation Type BWTAR_DCHAR10BWTARBWT
LVORMDeletion flag for all material data of a valuation type LVOBACHAR1XFELD
LBKUMTotal Valuated Stock LBKUMQUAN13(3) MENG13V
SALK3Value of Total Valuated Stock SALK3CURR13(2) WERT13N
VPRSVPrice control indicator VPRSVCHAR1VPRSV
VERPRMoving Average Price/Periodic Unit Price VERPRCURR11(2) WERT11V
STPRSStandard price STPRSCURR11(2) WERT11V
PEINHPrice Unit PEINHDEC5PACK3
BKLASValuation Class BKLASCHAR4BKLAS
SALKVValue based on moving average price (only with price ctrl S) SALKVCURR13(2) WERT13N
VMKUMTotal valuated stock in previous period VMKUMQUAN13(3) MENG13V
VMSALValue of total valuated stock in previous period VMSALCURR13(2) WERT13N
VMVPRPrice Control Indicator in Previous Period VMVPRCHAR1VPRSV
VMVERMoving Average Price/Periodic Unit Price in Previous Period VMVERCURR11(2) WERT11V
VMSTPStandard price in the previous period VMSTPCURR11(2) WERT11V
VMPEIPrice unit of previous period VMPEIDEC5PACK3
VMBKLValuation Class in Previous Period VMBKLCHAR4BKLAS
VMSAVValue based on moving average price (previous period) VMSAVCURR13(2) WERT13N
VJKUMTotal Valuated Stock in Previous Year VJKUMQUAN13(3) MENG13V
VJSALValue of total valuated stock in previous year VJSALCURR13(2) WERT13N
VJVPRPrice Control Indicator in Previous Year VJVPRCHAR1VPRSV
VJVERMoving Average Price/Periodic Unit Price in Previous Year VJVERCURR11(2) WERT11V
VJSTPStandard price in previous year VJSTPCURR11(2) WERT11V
VJPEIPrice unit of previous year VJPEIDEC5PACK3
VJBKLValuation Class in Previous Year VJBKLCHAR4BKLAS
VJSAVValue based on moving average price (previous year) VJSAVCURR13(2) WERT13N
LFGJAFiscal Year of Current Period LFGJANUMC4GJAHRGJAHR
LFMONCurrent period (posting period) LFMONNUMC2MONAT
BWTTYValuation Category BWTTY_DCHAR1BWTTY
STPRVPrevious price STPRVCURR11(2) WERT11V
LAEPRDate of the last price change LAEPRDATS8DATUM
ZKPRSFuture price DZKPRSCURR11(2) WERT11
ZKDATDate as of which the price is valid DZKDATDATS8DATUM
TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
BWPRSValuation price based on tax law: level 1 BWPRSCURR11(2) WERT11
BWPRHValuation price based on commercial law: level 1 BWPRHCURR11(2) WERT11
VJBWSValuation price based on tax law: level 3 VJBWSCURR11(2) WERT11
VJBWHValuation price based on commercial law: level 3 VJBWHCURR11(2) WERT11
VVJSLValue of total valuated stock in year before last VVJSLCURR13(2) WERT13N
VVJLBTotal valuated stock in year before last VVJLBQUAN13(3) MENG13V
VVMLBTotal valuated stock in period before last VVMLBQUAN13(3) MENG13V
VVSALValue of total valuated stock in period before last VVSALCURR13(2) WERT13N
ZPLPRFuture planned price DZPLPRCURR11(2) WERT11
ZPLP1Future Planned Price 1 DZPLP1CURR11(2) WERT11
ZPLP2Future Planned Price 2 DZPLP2CURR11(2) WERT11
ZPLP3Future Planned Price 3 DZPLP3CURR11(2) WERT11
ZPLD1Date from Which Future Planned Price 1 Is Valid DZPLD1DATS8DATUM
ZPLD2Date from Which Future Planned Price 2 Is Valid DZPLD2DATS8DATUM
ZPLD3Date from Which Future Planned Price 3 Is Valid DZPLD3DATS8DATUM
PPERZPeriod for future standard cost estimate (deactivated) PPERZACCP6BUPER
PPERLPeriod for current standard cost estimate (deactivated) PPERLACCP6BUPER
PPERVPeriod for previous standard cost estimate (deactivated) PPERVACCP6BUPER
KALKZIndicator: standard cost estimate for future period KAXKZCHAR1XFELD
KALKLStandard Cost Estimate for Current Period KALKLCHAR1XFELD
KALKVIndicator: standard cost estimate for previous period KALKVCHAR1XFELD
KALSCOverhead key (deactivated) KALSCCHAR6KALSC
XLIFOLIFO/FIFO-Relevant XLIFOCHAR1LIFO_FIFO
MYPOLPool number for LIFO valuation MYPOOLCHAR4LIFO_POOLPOL
BWPH1Valuation price based on commercial law: level 2 BWPH1CURR11(2) WERT11
BWPS1Valuation price based on tax law: level 2 BWPS1CURR11(2) WERT11
ABWKZLowest value: devaluation indicator ABWKZNUMC2NUMC2
PSTATMaintenance status PSTAT_DCHAR15PSTAT
KALN1Cost Estimate Number - Product Costing CK_KALNR1NUMC12CK_KALNRKNE
KALNRCost Estimate Number for Cost Est. w/o Qty Structure CK_KALNRNUMC12CK_KALNRKNR
BWVA1Valuation Variant for Future Standard Cost Estimate CK_BWVA1CHAR3CK_BWVAR
BWVA2Valuation Variant for Current Standard Cost Estimate CK_BWVA2CHAR3CK_BWVAR
BWVA3Valuation Variant for Previous Standard Cost Estimate CK_BWVA3CHAR3CK_BWVAR
VERS1Costing Version of Future Standard Cost Estimate CK_TVERS1NUMC2CK_VERSIONVSN
VERS2Costing Version of Current Standard Cost Estimate CK_TVERS2NUMC2CK_VERSION
VERS3Costing Version of Previous Standard Cost Estimate CK_TVERS3NUMC2CK_VERSION
HRKFTOrigin Group as Subdivision of Cost Element HRKFTCHAR4HRKFT
KOSGRCosting Overhead Group CK_KOSGRCHAR10CK_KOSGR
PPRDZPeriod of Future Standard Cost Estimate CK_PPRDZNUMC3POPERBUP
PPRDLPeriod of Current Standard Cost Estimate CK_PPRDLNUMC3POPER
PPRDVPeriod of Previous Standard Cost Estimate CK_PPRDVNUMC3POPER
PDATZFiscal Year of Future Standard Cost Estimate CK_PDATZNUMC4GJAHRGJAHRGEJ
PDATLFiscal Year of Current Standard Cost Estimate CK_PDATLNUMC4GJAHRGJAHR
PDATVFiscal Year of Previous Standard Cost Estimate CK_PDATVNUMC4GJAHRGJAHR
EKALRMaterial Is Costed with Quantity Structure CK_EKALRELCHAR1XFELD
VPLPRPrevious planned price VPLPRCURR11(2) WERT11
MLMAAMaterial ledger activated at material level CK_ML_MAACCHAR1XFELD
MLASTMaterial Price Determination: Control CK_ML_ABSTCHAR1CK_ML_ABST
LPLPRCurrent Planned Price CK_LPLPRCURR11(2) WERT11
VKSALValue of Total Valuated Stock at Sales Price VKSALCURR13(2) WERT13N
HKMATMaterial-related origin HKMATCHAR1HKMAT
SPERWPhysical Inventory Blocking Indicator SPERRCHAR1SPERR
KZIWLPhys. inventory indicator for value-only material KZIWLCHAR3INVKZ
WLINLDate of Last Posted Count for Unrestricted-Use Stock DLINLDATS8DATS
ABCIWPhysical inventory indicator for cycle counting ABCINCHAR1ABCIN
BWSPAValuation margin BWSPADEC6(2) PRZ32V
LPLPXFixed Portion of Current Planned Price CK_LPLPXCURR11(2) WERT11V
VPLPXFixed Portion of Previous Planned Price CK_VPLPXCURR11(2) WERT11V
FPLPXFixed Portion of Future Planned Price CK_ZPLPXCURR11(2) WERT11V
LBWSTVal. Strat. for Current Plan Price, Sales Order/Proj. Stock CK_LBWSTCHAR1CK_BWST
VBWSTValuation Strategy for Previous Plan Price, Special Stock CK_VBWSTCHAR1CK_BWST
FBWSTValuation Strategy for Future Planned Price, Special Stock CK_ZBWSTCHAR1CK_BWST
EKLASValuation Class for Sales Order Stock EKLASCHAR4BKLAS
QKLASValuation Class for Project Stock QKLASCHAR4BKLAS
MTUSEUsage of the material J_1BMATUSECHAR1J_1BMATUSE
MTORGOrigin of the material J_1BMATORGCHAR1J_1BMATORG
OWNPRProduced in-house J_1BOWNPROCHAR1XFELD
XBEWMValuation based on the batch-specific unit of measure XBEWWCHAR1XFELD
BWPEIPrice unit for valuation prices based on tax/commercial law BWPEIDEC5PACK3
MBRUEMBEWH rec. already exists for per. before last of MBEW per. MBRUECHAR1XFELD
OKLASValuation Class for Special Stock at the Vendor OKLASCHAR4BKLAS
.INCLU--AP 0
OIPPINVPrepaid Inventory Flag for Material Valuation Type Segment JV_PPINVCHAR1JV_PPINV

Key field Non-key field



How do I retrieve data from SAP structure CKF_MBEW using ABAP code?

As CKF_MBEW is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CKF_MBEW as there is no data to select.

How to access SAP table CKF_MBEW

Within an ECC or HANA version of SAP you can also view further information about CKF_MBEW and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!