- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
Mbv_Mbew_Old
Direct access on original MBEW table
| view: MBVMBEWOLD
| Extraction:
Not supported
| Component: Basic Functions
Tables used:
MBEW
- 🔑 Keys (3)
- 💰 Amounts (32)
- ∑ Quantities (5)
- 📅 Dates (6)
- ☰ Categorical (22)
- Other (28)
- 🔗 Relations (15)
| Column Name | Description | |
|---|---|---|
| MATNR FK | Material Number | |
| BWKEY FK | Valuation area | |
| BWTAR | Valuation Type |
| Column Name | Description | |
|---|---|---|
| SALK3 | Value of Total Valuated Stock | |
| VERPR | Moving Average Price/Periodic Unit Price | |
| STPRS | Standard price | |
| SALKV | Value based on moving average price (only with price ctrl S) | |
| VMSAL | Value of total valuated stock in previous period | |
| VMVER | Moving Average Price/Periodic Unit Price in Previous Period | |
| VMSTP | Standard price in the previous period | |
| VMSAV | Value based on moving average price (previous period) | |
| VJSAL | Value of total valuated stock in previous year | |
| VJVER | Moving Average Price/Periodic Unit Price in Previous Year | |
| VJSTP | Standard price in previous year | |
| VJSAV | Value based on moving average price (previous year) | |
| STPRV | Previous Price | |
| ZKPRS | Future Price | |
| BWPRS | Valuation price based on tax law: level 1 | |
| BWPRH | Valuation price based on commercial law: level 1 | |
| VJBWS | Valuation price based on tax law: level 3 | |
| VJBWH | Valuation price based on commercial law: level 3 | |
| VVJSL | Value of total valuated stock in year before last | |
| VVSAL | Value of total valuated stock in period before last | |
| ZPLPR | Future planned price | |
| ZPLP1 | Future Planned Price 1 | |
| ZPLP2 | Future Planned Price 2 | |
| ZPLP3 | Future Planned Price 3 | |
| BWPH1 | Valuation price based on commercial law: level 2 | |
| BWPS1 | Valuation price based on tax law: level 2 | |
| VPLPR | Previous Planned Price | |
| LPLPR | Current Planned Price | |
| VKSAL | Value of Total Valuated Stock at Sales Price | |
| LPLPX | Fixed Portion of Current Planned Price | |
| VPLPX | Fixed Portion of Previous Planned Price | |
| FPLPX | Fixed Portion of Future Planned Price |
| Column Name | Description | |
|---|---|---|
| LBKUM | Total Valuated Stock | |
| VMKUM | Total valuated stock in previous period | |
| VJKUM | Total Valuated Stock in Previous Year | |
| VVJLB | Total valuated stock in year before last | |
| VVMLB | Total valuated stock in period before last |
| Column Name | Description | |
|---|---|---|
| LAEPR | Date of Last Price Change | |
| ZKDAT | Date as of which the price is valid | |
| ZPLD1 | Date from Which Future Planned Price 1 Is Valid | |
| ZPLD2 | Date from Which Future Planned Price 2 Is Valid | |
| ZPLD3 | Date from Which Future Planned Price 3 Is Valid | |
| WLINL | Date of Last Posted Count |
| Column Name | Description | |
|---|---|---|
| LVORM | Deletion flag for all material data of a valuation type | Show values |
| VPRSV | Price control indicator | Show values |
| VMVPR | Price Control Indicator in Previous Period | Show values |
| VJVPR | Price Control Indicator in Previous Year | Show values |
| KALKZ | Indicator: standard cost estimate for future period | Show values |
| KALKL | Standard Cost Estimate for Current Period | Show values |
| KALKV | Indicator: Standard Cost Estimate for Previous Period | Show values |
| XLIFO | LIFO/FIFO-Relevant | Show values |
| EKALR | Material Is Costed with Quantity Structure | Show values |
| MLMAA | Material Ledger Activated at Material Level | Show values |
| MLAST | Material Price Determination: Control | Show values |
| HKMAT | Material-related origin | Show values |
| SPERW | Physical Inventory Blocking Indicator | Show values |
| LBWST | Val. Strat. for Current Plan Price, Sales Order/Proj. Stock | Show values |
| VBWST | Valuation Strategy for Previous Planned Price, Special Stock | Show values |
| FBWST | Valuation Strategy for Future Planned Price, Special Stock | Show values |
| MTUSE | Usage of the material | Show values |
| MTORG | Origin of the material | Show values |
| OWNPR | Produced in-house | Show values |
| XBEWM | Valuation based on the batch-specific unit of measure | Show values |
| MBRUE | MBEWH rec. already exists for per. before last of MBEW per. | Show values |
| OIPPINV | Prepaid Inventory Flag for Material Valuation Type Segment | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| PEINH | Price unit | PACK3 | |
| VMPEI | Price unit of previous period | PACK3 | |
| VJPEI | Price unit of previous year | PACK3 | |
| LFGJA | Fiscal Year of Current Period | GJAHR | |
| LFMON | Current period (posting period) | MONAT | |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |
| PPERZ | Period for future standard cost estimate (deactivated) | BUPER | |
| PPERL | Period for current standard cost estimate (deactivated) | BUPER | |
| PPERV | Period for previous standard cost estimate (deactivated) | BUPER | |
| KALSC | Overhead key (deactivated) | KALSC | |
| ABWKZ | Lowest value: devaluation indicator | NUMC2 | |
| PSTAT | Maintenance status | PSTAT | |
| KALN1 | Cost Estimate Number - Product Costing | CK_KALNR | |
| KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | |
| VERS1 | Costing Version of Future Standard Cost Estimate | CK_VERSION | |
| VERS2 | Costing Version of Current Standard Cost Estimate | CK_VERSION | |
| VERS3 | Costing Version of Previous Standard Cost Estimate | CK_VERSION | |
| PPRDZ | Period of Future Standard Cost Estimate | POPER | |
| PPRDL | Period of Current Standard Cost Estimate | POPER | |
| PPRDV | Period of Previous Standard Cost Estimate | POPER | |
| PDATZ | Fiscal Year of Future Standard Cost Estimate | GJAHR | |
| PDATL | Fiscal Year of Current Standard Cost Estimate | GJAHR | |
| PDATV | Fiscal Year of Previous Standard Cost Estimate | GJAHR | |
| KZIWL | Phys. inventory indicator for value-only material | INVKZ | |
| ABCIW | Physical Inventory Indicator for Cycle Counting | ABCIN | |
| BWSPA | Valuation margin | PRZ32V | |
| BWPEI | Price unit for valuation prices based on tax/commercial law | PACK3 | |
| DUMMY_VAL_INCL_EEW_PS | MD Product valuation extension field element | VAL_INCL_EEW |
| Master Data Relations | Join Conditions |
|---|---|
Valuation Class
| |
Valuation area
| |
Valuation area/valuation category
| |
Valuation variant for future period
| |
Valuation variant for current period
| |
Valuation variant for previous period
| |
Valuation Class for Sales Order Stock
| |
Origin of cost estimate
| |
Overhead group
| |
Material Number
| |
LIFO valuation key/pool number
| |
Valuation Class for Special Stock at the Vendor
| |
Valuation Class for Project Stock
| |
Valuation Class in Previous Year
| |
Valuation Class in Previous Period
|