I_ProductValuationBasic

Product Valuation | view: IPRDVALBASIC | Extraction: Full or Incremental | Component: Material Master
Tables used: MARAMARAMARVT001T001KMBEW
Column Name Description
Product FK Product Number
ValuationArea FK Valuation area
ValuationType Valuation Type
Column Name Description
💲 Currency Key (Currency):
StandardPrice Standard price
PrevInvtryPriceInCoCodeCrcy Previous Price
MovingAveragePrice Moving Average Price/Periodic Unit Price
FuturePrice Future Price
Column Name Description
Column Name Description
FuturePriceValidityStartDate Date as of which the price is valid
PriceLastChangeDate Date of Last Price Change
Column Name Description
PriceDeterminationControl Material Price Determination: Control Show values
InventoryValuationProcedure Price Control Show values
ProductUsageType Usage of the Product Show values
ProductOriginType Origin of the Product Show values
IsProducedInhouse Produced in-house Show values
IsMarkedForDeletion Deletion flag for all material data of a valuation type Show values
IsActiveEntity Draft - Indicator - Is active document Show values
Column Name Description Domain name
FiscalMonthCurrentPeriod Current period (posting period) MONAT
FiscalYearCurrentPeriod Fiscal Year of Current Period GJAHR
PriceUnitQty Price unit PACK3
ProdCostEstNumber Cost Estimate Number - Product Costing CK_KALNR
ValuationMargin Valuation margin PRZ32V
TaxBasedPricesPriceUnitQty Price unit for valuation prices based on tax/commercial law PACK3
Master Data Relations Join Conditions
Unit of Measure
  • Base Unit of Measure
  • Client
  • I_PRODUCTVALUATIONBASIC.BASEUNIT == T006.MSEHI
  • I_PRODUCTVALUATIONBASIC.MANDT == T006.MANDT
Company code
  • Company Code
  • Client
  • I_PRODUCTVALUATIONBASIC.COMPANYCODE == T001.BUKRS
  • I_PRODUCTVALUATIONBASIC.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • I_PRODUCTVALUATIONBASIC.CURRENCY == TCURC.WAERS
  • I_PRODUCTVALUATIONBASIC.MANDT == TCURC.MANDT
Product Number
  • Product Number
  • Client
  • I_PRODUCTVALUATIONBASIC.PRODUCT == MARA.MATNR
  • I_PRODUCTVALUATIONBASIC.MANDT == MARA.MANDT
Valuation Class for Project Stock
  • Valuation Class for Project Stock
  • Client
  • I_PRODUCTVALUATIONBASIC.PROJECTSTOCKVALUATIONCLASS == T025.BKLAS
  • I_PRODUCTVALUATIONBASIC.MANDT == T025.MANDT
Valuation area
  • Valuation area
  • Client
  • I_PRODUCTVALUATIONBASIC.VALUATIONAREA == T001K.BWKEY
  • I_PRODUCTVALUATIONBASIC.MANDT == T001K.MANDT
Valuation area/valuation category
  • Valuation Category
  • Valuation area
  • Client
  • I_PRODUCTVALUATIONBASIC.VALUATIONCATEGORY == T149.BWTTY
  • I_PRODUCTVALUATIONBASIC.VALUATIONAREA == T149.BWKEY
  • I_PRODUCTVALUATIONBASIC.MANDT == T149.MANDT
Valuation Class
  • Valuation Class
  • Client
  • I_PRODUCTVALUATIONBASIC.VALUATIONCLASS == T025.BKLAS
  • I_PRODUCTVALUATIONBASIC.MANDT == T025.MANDT
Valuation Class for Sales Order Stock
  • Valuation Class for Sales Order Stock
  • Client
  • I_PRODUCTVALUATIONBASIC.VALUATIONCLASSSALESORDERSTOCK == T025.BKLAS
  • I_PRODUCTVALUATIONBASIC.MANDT == T025.MANDT