MDG_BS_MAT_S_MBEW_PDF SAP (MDG BS MAT: Material Master Valuation Data Structure) Structure details

Dictionary Type: Structure
Description: MDG BS MAT: Material Master Valuation Data Structure




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




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

MDG_BS_MAT_S_MBEW_PDF 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 "MDG BS MAT: Material Master Valuation Data Structure" 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_MDG_BS_MAT_S_MBEW_PDF TYPE MDG_BS_MAT_S_MBEW_PDF.

The MDG_BS_MAT_S_MBEW_PDF table consists of various fields, each holding specific information or linking keys about MDG BS MAT: Material Master Valuation Data Structure data available in SAP. These include MANDT (Client), MATNR (Material Number), BWKEY (Valuation Area), BWTAR (Valuation Type).. 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: Can be enhanced (character-type or numeric)


SAP MDG_BS_MAT_S_MBEW_PDF 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
MANDTClient MANDTCLNT3T000MANDT
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
BWKEYValuation Area BWKEYCHAR4T001KBWKEYBWK
BWTARValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
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 BKLASCHAR4T025BKLAS
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 VMBKLCHAR4T025BKLAS
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 VJBKLCHAR4T025BKLAS
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_DCHAR1T149BWTTY
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 MYPOOLCHAR4TPOOLLIFO_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_KALNR1NUMC12Assigned to domainCK_KALNRKNE
KALNRCost Estimate Number for Cost Est. w/o Qty Structure CK_KALNRNUMC12Assigned to domainCK_KALNRKNR
BWVA1Valuation Variant for Future Standard Cost Estimate CK_BWVA1CHAR3TCK05CK_BWVAR
BWVA2Valuation Variant for Current Standard Cost Estimate CK_BWVA2CHAR3TCK05CK_BWVAR
BWVA3Valuation Variant for Previous Standard Cost Estimate CK_BWVA3CHAR3TCK05CK_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 HRKFTCHAR4TKKH1HRKFT
KOSGRCosting Overhead Group CK_KOSGRCHAR10TCK14CK_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 ABCINCHAR1Assigned to domainABCIN
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 EKLASCHAR4T025BKLAS
QKLASValuation Class for Project Stock QKLASCHAR4T025BKLAS
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 OKLASCHAR4T025BKLAS
.INCLU--AP 0
OIPPINVPrepaid Inventory Flag for Material Valuation Type Segment JV_PPINVCHAR1JV_PPINV
MTARTMaterial Type MTARTCHAR4Assigned to domainMTARTMTA
USMD_DESCRIPTION 0
BKLASDescription (long text) USMD_TXTLGCHAR60TEXT60
HKMATDescription (long text) USMD_TXTLGCHAR60TEXT60
HRKFTDescription (long text) USMD_TXTLGCHAR60TEXT60
KOSGRDescription (long text) USMD_TXTLGCHAR60TEXT60
EKALRDescription (long text) USMD_TXTLGCHAR60TEXT60
MLASTDescription (long text) USMD_TXTLGCHAR60TEXT60
MLMAADescription (long text) USMD_TXTLGCHAR60TEXT60
ABWKZDescription (long text) USMD_TXTLGCHAR60TEXT60
MYPOLDescription (long text) USMD_TXTLGCHAR60TEXT60
XLIFODescription (long text) USMD_TXTLGCHAR60TEXT60
BWTTYDescription (long text) USMD_TXTLGCHAR60TEXT60
QKLASDescription (long text) USMD_TXTLGCHAR60TEXT60
EKLASDescription (long text) USMD_TXTLGCHAR60TEXT60
MTORGDescription (long text) USMD_TXTLGCHAR60TEXT60
MTUSEDescription (long text) USMD_TXTLGCHAR60TEXT60
OWNPRDescription (long text) USMD_TXTLGCHAR60TEXT60

Key field Non-key field



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

As MDG_BS_MAT_S_MBEW_PDF 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 MDG_BS_MAT_S_MBEW_PDF as there is no data to select.

How to access SAP table MDG_BS_MAT_S_MBEW_PDF

Within an ECC or HANA version of SAP you can also view further information about MDG_BS_MAT_S_MBEW_PDF 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!