I_MaterialValuationsByPeriods

Material Valuations by Currtp/Period | view: IMATVALMGMPNV | Extraction: Not supported | Component: Actual Costing
Column Name Description
CostEstimate Cost Estimate Number for Cost Est. w/o Qty Structure
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
LedgerValuationCurrencyRole External Currency Type and Valuation View
ValuationArea FK Valuation area
Column Name Description
MovingAveragePrice Periodic Unit Price
StandardPrice Standard Price
FuturePrice Future Price
FuturePlannedPrice Future planned price
TotalValuatedStockAmount Value of Total Valuated Stock
Column Name Description
TotalVltdStockQuantity Valuation Quantity
Column Name Description
FuturePriceValidityStartDate Date from Which a Future Valuation Price Is to Be Valid
Column Name Description
AccountingValuationView Valuation View (for Transfer Prices) Show values
LedgerValnCrcyRoleIsUsedInLogs Indicator: currency type is used in logistic reporting Show values
ControllingValuationType Valuation View Show values
InventorySpecialStockValnType Valuation of Special Stock Show values
MaterialPriceControl Price Control Show values
PriceDeterminationControl Price Determination Show values
Column Name Description Domain name
LegalCurrencyRole Currency Type (Reference in Legal Valuation Ledger) for ML FINS_CURTYPE
Ledger Ledger in General Ledger Accounting FINS_LEDGER
LegalCurrencyRoleName Legal Currency Type Description TEXT60
LedgerName Ledger Name TEXT60
AccountingValuationViewName Description TEXT60
AccountingValuationSubviewName Description TEXT60
AcctgValnVwSubviewCombinedName Accounting Valuation View Name TEXT60
CurrencyRole External Currency Type and Valuation View FINS_CURTYPE
MaterialPriceUnitQty Price Unit PACK3
InvtryValnSpecialStockType Special Stock Indicator SOBKZ
MaterialName Material Description TEXT40
InventoryValuationType Valuation Type BWTAR
PlantName Plant Name TEXT30
Master Data Relations Join Conditions
Subtype of Valuation View (for Transfer Prices)
  • Client
  • Subtype of Valuation View (for Transfer Prices)
Unit of Measure
  • Base Unit of Measure
  • Client
  • I_MATERIALVALUATIONSBYPERIODS.BASEUNIT == T006.MSEHI
  • I_MATERIALVALUATIONSBYPERIODS.MANDT == T006.MANDT
Company code
  • Company Code
  • Client
  • I_MATERIALVALUATIONSBYPERIODS.COMPANYCODE == T001.BUKRS
  • I_MATERIALVALUATIONSBYPERIODS.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_MATERIALVALUATIONSBYPERIODS.CONTROLLINGAREA == TKA01.KOKRS
  • I_MATERIALVALUATIONSBYPERIODS.MANDT == TKA01.MANDT
Valuation area/valuation category
  • Plant
  • Valuation area
  • Valuation Category
  • Client
  • I_MATERIALVALUATIONSBYPERIODS.PLANT == T149.BWKEY
  • I_MATERIALVALUATIONSBYPERIODS.VALUATIONAREA == T149.BWKEY
  • I_MATERIALVALUATIONSBYPERIODS.INVENTORYVALUATIONCATEGORY == T149.BWTTY
  • I_MATERIALVALUATIONSBYPERIODS.MANDT == T149.MANDT
Material Number
  • Material Number
  • Client
  • I_MATERIALVALUATIONSBYPERIODS.MATERIAL == MARA.MATNR
  • I_MATERIALVALUATIONSBYPERIODS.MANDT == MARA.MANDT
Valuation area
  • Plant
  • Valuation area
  • Client
  • I_MATERIALVALUATIONSBYPERIODS.PLANT == T001K.BWKEY
  • I_MATERIALVALUATIONSBYPERIODS.VALUATIONAREA == T001K.BWKEY
  • I_MATERIALVALUATIONSBYPERIODS.MANDT == T001K.MANDT
Valuation area
  • Plant
  • Valuation area
  • Client
  • I_MATERIALVALUATIONSBYPERIODS.PLANT == T001K.BWKEY
  • I_MATERIALVALUATIONSBYPERIODS.VALUATIONAREA == T001K.BWKEY
  • I_MATERIALVALUATIONSBYPERIODS.MANDT == T001K.MANDT