I_ProductValuationAcct

Product Valuation Account | view: IPRDVALACCT | Extraction: Full or Incremental | Component: Material Master
Tables used: MARAMARAT001T001KMBEW
Column Name Description
Product FK Product Number
ValuationArea FK Valuation area
ValuationType Valuation Type
Column Name Description
💲 Currency Key (Currency):
CommercialPrice1InCoCodeCrcy Valuation price based on commercial law: level 1
CommercialPrice2InCoCodeCrcy Valuation price based on commercial law: level 2
CommercialPrice3InCoCodeCrcy Valuation price based on commercial law: level 3
StandardPricePrevYear Standard price in previous year
TaxPricel1InCoCodeCrcy Valuation price based on tax law: level 1
TaxPrice2InCoCodeCrcy Valuation price based on tax law: level 2
TaxPrice3InCoCodeCrcy Valuation price based on tax law: level 3
FutureEvaluatedAmountValue Future Price
Column Name Description
Column Name Description
FuturePriceValidityStartDate Date as of which the price is valid
Column Name Description
IsLIFOAndFIFORelevant Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
Column Name Description Domain name
DevaluationYearCount Lowest value: devaluation indicator NUMC2
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_PRODUCTVALUATIONACCT.BASEUNIT == T006.MSEHI
  • I_PRODUCTVALUATIONACCT.MANDT == T006.MANDT
Company code
  • Company Code
  • Client
  • I_PRODUCTVALUATIONACCT.COMPANYCODE == T001.BUKRS
  • I_PRODUCTVALUATIONACCT.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • I_PRODUCTVALUATIONACCT.CURRENCY == TCURC.WAERS
  • I_PRODUCTVALUATIONACCT.MANDT == TCURC.MANDT
LIFO valuation key/pool number
  • ?
  • Pool number for LIFO valuation
  • Client
  • I_PRODUCTVALUATIONACCT.[column in domain "MYKEY"] == TPOOL.MYKEY
  • I_PRODUCTVALUATIONACCT.LIFOVALUATIONPOOLNUMBER == TPOOL.MYPOOL
  • I_PRODUCTVALUATIONACCT.MANDT == TPOOL.MANDT
Product Number
  • Product Number
  • Client
  • I_PRODUCTVALUATIONACCT.PRODUCT == MARA.MATNR
  • I_PRODUCTVALUATIONACCT.MANDT == MARA.MANDT
Valuation area
  • Valuation area
  • Client
  • I_PRODUCTVALUATIONACCT.VALUATIONAREA == T001K.BWKEY
  • I_PRODUCTVALUATIONACCT.MANDT == T001K.MANDT