I_MaterialValuationPrices

Material Valuation Prices | view: IMATVALPRICES | Extraction: Not supported | Component: Information System
Column Name Description
CostEstimate Cost Estimate Number for Cost Est. w/o Qty Structure
Ledger null
FiscalYear Fiscal Year of Current Period
FiscalPeriod Current period (posting period)
CurrencyRole Currency Type
PeriodType null
Column Name Description
💲 Currency Key (Currency):
MovingAveragePrice Periodic Unit Price
StandardPrice Standard Price
InventoryPrice null
FuturePrice Future Price
PlannedPrice Cost
FixedPortionOfPlannedPrice Fixed Cost
Column Name Description
Column Name Description
FuturePriceValidityStartDate Date from Which a Future Valuation Price Is to Be Valid
Column Name Description
InventorySpecialStockValnType Valuation of Special Stock Show values
IsSupplierStockValuation Vendor Stock Valuation Indicator Show values
PriceDeterminationControl Material Price Determination: Control Show values
MaterialPriceControl Price control indicator Show values
LedgerValnCrcyRoleIsUsedInLogs Indicator: currency type is used in logistic reporting Show values
Column Name Description Domain name
ValuationArea Valuation area BWKEY
SalesOrder Sales and Distribution Document Number VBELN
SalesOrderItem Item number of the SD document POSNR
Supplier Account Number of Supplier LIFNR
WBSElementInternalID WBS Element PS_S4_PSPNR
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
InvtryValnSpecialStockType Special Stock Indicator SOBKZ
MaterialPriceUnitQty Price Unit PACK3
FutrCostEstValuationVariant Valuation Variant for Future Standard Cost Estimate CK_BWVAR
FutureCostEstFiscalYear Fiscal Year of Future Standard Cost Estimate GJAHR
FutureCostEstimateFiscalPeriod Period of Future Standard Cost Estimate POPER
FutureCostEstCostingVersion Costing Version of Future Standard Cost Estimate CK_VERSION
LedgerName Ledger Name TEXT60
CurrencyRoleName Currency Type Description TEXT60
LegalCurrencyRole Currency Type (Reference in Legal Valuation Ledger) for ML FINS_CURTYPE
LegalCurrencyRoleName Legal Currency Type Description TEXT60
AccountingValuationView Valuation View FINS_VALUTYP
AcctgValnVwSubviewCombinedName Accounting Valuation View Name TEXT60
Master Data Relations Join Conditions
Company code
  • Client
  • Company Code
  • I_MATERIALVALUATIONPRICES.MANDT == T001.MANDT
  • I_MATERIALVALUATIONPRICES.COMPANYCODE == T001.BUKRS
Valuation type
  • Valuation Type
  • Client
  • I_MATERIALVALUATIONPRICES.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • I_MATERIALVALUATIONPRICES.MANDT == T149D.MANDT
Material Number
  • Client
  • Material Number
  • I_MATERIALVALUATIONPRICES.MANDT == MARA.MANDT
  • I_MATERIALVALUATIONPRICES.MATERIAL == MARA.MATNR