I_CurrentMaterialValuations

Current Material Valuations | view: IMATVALMANAGEC | Extraction: Not supported | Component: Actual Costing
Tables used: FMLT_PRICE, ACDOCA_M_EXTRACT, ACDOCA_M_EXTRACT, ACDOCA_M_EXTRACT, CKMLCR, CKMLPP, T001, TKA02, FINSC_LEDGER, FINSC_LEDGER_T, MAKT, T001W, FINSC_CURTYPE, FINSC_CURTYPE, FINSC_CURTYPET, FINSC_LEDGER, MARV, T001K, MARV, MBEW, T001K, CKMLHD, CKMLPR, MBEW, PRPS, T001K, CKMLHD, MARV, T001K, CKMLHD, MARA, MARC, MARV, PRPS, T001K, MARA, MARC, MARV, PRPS, CKMLHD, MARV, T001K, EBEW, MBEW, OBEW, QBEW, FINSC_CURTYPET, FINSC_VALSUBTYPT, FINSC_VALUTYPT, FINSC_ACTVE_APPL, FINSC_FISC_DATE, FINSC_PERIOD, FMLC_TOGGLE, FMLT_CURTP_ML
Column Name Description
CostEstimate Cost Estimate Number - Product Costing
LedgerValuationCurrencyRole Currency Type
Column Name Description
FuturePrice Future Price
FuturePlannedPrice Future planned price
TotalValuatedStockAmount Value of Total Valuated Stock
AmountInCompanyCodeCurrency Amount in Company Code Currency
TaxPricel1InCoCodeCrcy Valuation price based on tax law: level 1
CommercialPrice1InCoCodeCrcy Valuation price based on commercial law: level 1
TaxPrice3InCoCodeCrcy Valuation price based on tax law: level 3
CommercialPrice3InCoCodeCrcy Valuation price based on commercial law: level 3
PlannedPriceInCoCodeCrcy Future planned price
PlannedPrice1InCoCodeCrcy Future Planned Price 1
PlannedPrice2InCoCodeCrcy Future Planned Price 2
PlannedPrice3InCoCodeCrcy Future Planned Price 3
CommercialPrice2InCoCodeCrcy Valuation price based on commercial law: level 2
TaxPrice2InCoCodeCrcy Valuation price based on tax law: level 2
PreviousPlanPriceInCoCodeCrcy Previous Planned Price
CurrentPlanPriceInCoCodeCrcy Current Planned Price
TotStkValAtSlsPrcInCoCodeCrcy Value of Total Valuated Stock at Sales Price
FxdPortnOfPlanPrcInCoCodeCrcy Fixed Portion of Current Planned Price
FxdPortOfPrevPlPrcInCoCodeCrcy Fixed Portion of Previous Planned Price
FxdPortnOfFutPlPrcInCoCodeCrcy Fixed Portion of Future Planned Price
💲 Currency Key (Currency):
MovingAveragePrice Periodic Unit Price
StandardPrice Standard Price
Column Name Description
TotalVltdStockQuantity Valuation Quantity
📏 Base Unit of Measure (BaseUnit):
CostingLotSize Lot Size for Product Costing
Column Name Description
FuturePriceValidityStartDate Date from Which a Future Valuation Price Is to Be Valid
PriceLastChangeDate Date of Last Price Change
FuturePlndPrice1ValdtyDate Date from Which Future Planned Price 1 Is Valid
FuturePlndPrice2ValdtyDate Date from Which Future Planned Price 2 Is Valid
FuturePlndPrice3ValdtyDate Date from Which Future Planned Price 3 Is Valid
DateOfLastPostedCntUnRstrcdStk Date of Last Posted Count
FiscalPeriodEndDate End Date of Fiscal Period
NextFiscalPeriodStartDate null
Column Name Description
AccountingValuationView Valuation View (for Transfer Prices) Show values
MaterialPriceControl Price Control Show values
PriceDeterminationControl Price Determination Show values
PlntMatlIsMarkedForDeletion Flag Material for Deletion at Plant Level Show values
MaterialProcurementCategory Procurement Type Show values
HasProductionVersion Version Indicator Show values
IsCoProduct Indicator: Material can be co-product Show values
IsBulkMaterial Indicator: bulk material Show values
IsFixedPriceCoProduct Fixed-Price Co-Product Show values
IsBlockedForCosting Do Not Cost Show values
IsMatlOfValnTypeMarkedForDeltn Deletion flag for all material data of a valuation type Show values
HasStdCostEstForFuturePeriod Indicator: standard cost estimate for future period Show values
HasStdCostEstForCurrentPeriod Standard Cost Estimate for Current Period Show values
HasStdCostEstForPreviousPeriod Indicator: Standard Cost Estimate for Previous Period Show values
IsLIFOAndFIFORelevant Is LIFO/FIFO Relevant Show values
IsMaterialCostedWithQtyStruc Material Is Costed with Quantity Structure Show values
IsMaterialRelatedOrigin Is Material Related Origin Show values
PhysicalInventoryBlockInd Physical Inventory Blocking Indicator Show values
CurPlanProjSlsOrdValnStrategy Val. Strat. for Current Plan Price, Sales Order/Proj. Stock Show values
PrevPlanProjSlsOrdValnStrategy Valuation Strategy for Previous Planned Price, Special Stock Show values
FutrPlanProjSlsOrdValnStrategy Valuation Strategy for Future Planned Price, Special Stock Show values
ProductUsageType Usage of the material Show values
ProductOriginType Origin of the material Show values
IsProducedInhouse Produced in-house Show values
ValnIsBsdOnBatchSpecificUnit Valuation based on the batch-specific unit of measure Show values
ControllingValuationType Valuation View (for Transfer Prices) 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
CurrencyRole External Currency Type and Valuation View FINS_CURTYPE
LegalCurrencyRoleName Legal Currency Type Description TEXT60
AccountingValuationViewName Description TEXT60
AccountingValuationSubviewName Description TEXT60
AcctgValnVwSubviewCombinedName Accounting Valuation View Name TEXT60
LedgerName Ledger Name TEXT60
InventoryValuationType Valuation Type BWTAR
InvtryValnSpecialStockType Special Stock Indicator SOBKZ
SalesOrder Sales and Distribution Document Number VBELN
SalesOrderItem Item number of the SD document POSNR
Supplier Account Number of Supplier LIFNR
WBSElementInternalID Work Breakdown Structure Element (WBS Element) PS_POSNR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
MaterialPriceUnitQty Price Unit PACK3
AssemblyScrapPercent Assembly scrap in percent DEC3_2
ProfitCenter Profit Center PRCTR
AlternativeBillOfMaterial Alternative BOM ALTNR
TaskListGroup Key for Task List Group PLNNR
TaskListGroupCounter Group Counter ALTNR
ComponentScrapInPercent Component Scrap in Percent DEC3_2
CostingProductionVersion Production Version To Be Costed VERID
CurrentFiscalYear Posting Date YYYY GJAHR
CurrentFiscalPeriod Posting period POPER
PreviousFiscalPeriodFiscalYear Posting Date YYYY GJAHR
PreviousFiscalPeriod Posting period POPER
PreviousFiscalYear Posting Date YYYY GJAHR
PreviousFiscalYearPeriod Posting period POPER
DevaluationYearCount Lowest value: devaluation indicator NUMC2
MaintenanceStatus Maintenance status PSTAT
FutureCostEstCostingVersion Costing Version of Future Standard Cost Estimate CK_VERSION
CurrentCostEstCostingVersion Costing Version of Current Standard Cost Estimate CK_VERSION
PreviousCostEstCostingVersion Costing Version of Previous Standard Cost Estimate CK_VERSION
FutureCostEstimateFiscalPeriod Period of Future Standard Cost Estimate POPER
CurrentCostEstFiscalPeriod Period of Current Standard Cost Estimate POPER
PreviousCostEstFiscalPeriod Period of Previous Standard Cost Estimate POPER
FutureCostEstFiscalYear Fiscal Year of Future Standard Cost Estimate GJAHR
CurrentCostEstFiscalYear Fiscal Year of Current Standard Cost Estimate GJAHR
PreviousCostEstFiscalYear Fiscal Year of Previous Standard Cost Estimate GJAHR
InventoryForCycleCountInd Physical Inventory Indicator for Cycle Counting ABCIN
ValuationMargin Valuation margin PRZ32V
TaxBasedPricesPriceUnitQty Price unit for valuation prices based on tax/commercial law PACK3
MaterialName Material Description TEXT40
CompanyCodeName Name of Company Code or Company TEXT25
Plant Plant WERKS
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
  • Client
  • Base Unit of Measure
  • I_CURRENTMATERIALVALUATIONS.MANDT == T006.MANDT
  • I_CURRENTMATERIALVALUATIONS.BASEUNIT == T006.MSEHI
Alternative BOM
  • Client
  • BOM Usage
  • I_CURRENTMATERIALVALUATIONS.MANDT == T416.MANDT
  • I_CURRENTMATERIALVALUATIONS.BILLOFMATERIALVARIANTUSAGE == T416.STLAN
Task List Type
  • Client
  • Task List Type
  • I_CURRENTMATERIALVALUATIONS.MANDT == TCA01.MANDT
  • I_CURRENTMATERIALVALUATIONS.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Company code
  • Company Code
  • Client
  • I_CURRENTMATERIALVALUATIONS.COMPANYCODE == T001.BUKRS
  • I_CURRENTMATERIALVALUATIONS.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Currency Key
  • Client
  • I_CURRENTMATERIALVALUATIONS.COMPANYCODECURRENCY == TCURC.WAERS
  • I_CURRENTMATERIALVALUATIONS.CURRENCY == TCURC.WAERS
  • I_CURRENTMATERIALVALUATIONS.MANDT == TCURC.MANDT
Controlling Area
  • Client
  • Controlling Area
  • I_CURRENTMATERIALVALUATIONS.MANDT == TKA01.MANDT
  • I_CURRENTMATERIALVALUATIONS.CONTROLLINGAREA == TKA01.KOKRS
Special procurement key for costing
  • Special Procurement Type for Costing
  • Plant
  • Client
  • I_CURRENTMATERIALVALUATIONS.COSTINGMATPROCUREMENTPROFILE == T460A.SOBSL
  • I_CURRENTMATERIALVALUATIONS.PLANT == T460A.WERKS
  • I_CURRENTMATERIALVALUATIONS.MANDT == T460A.MANDT
Overhead group
  • Valuation area
  • Client
  • Costing Overhead Group
  • I_CURRENTMATERIALVALUATIONS.VALUATIONAREA == TCK14.BWKEY
  • I_CURRENTMATERIALVALUATIONS.MANDT == TCK14.MANDT
  • I_CURRENTMATERIALVALUATIONS.COSTINGOVERHEADGROUP == TCK14.KOSGR
Origin of cost estimate
  • ?
  • Client
  • Origin Group as Subdivision of Cost Element
  • Controlling Area
  • I_CURRENTMATERIALVALUATIONS.[column in domain "HRKTYP"] == TKKH1.KOATY
  • I_CURRENTMATERIALVALUATIONS.MANDT == TKKH1.MANDT
  • I_CURRENTMATERIALVALUATIONS.COSTORIGINGROUP == TKKH1.HRKFT
  • I_CURRENTMATERIALVALUATIONS.CONTROLLINGAREA == TKKH1.KOKRS
Valuation variant for current period
  • Client
  • Valuation Variant for Current Standard Cost Estimate
  • I_CURRENTMATERIALVALUATIONS.MANDT == TCK05.MANDT
  • I_CURRENTMATERIALVALUATIONS.CURCOSTESTVALUATIONVARIANT == TCK05.BWVAR
Valuation variant for future period
  • Valuation Variant for Future Standard Cost Estimate
  • Client
  • I_CURRENTMATERIALVALUATIONS.FUTRCOSTESTVALUATIONVARIANT == TCK05.BWVAR
  • I_CURRENTMATERIALVALUATIONS.MANDT == TCK05.MANDT
Valuation area/valuation category
  • Valuation Category
  • Valuation area
  • Client
  • I_CURRENTMATERIALVALUATIONS.INVENTORYVALUATIONCATEGORY == T149.BWTTY
  • I_CURRENTMATERIALVALUATIONS.VALUATIONAREA == T149.BWKEY
  • I_CURRENTMATERIALVALUATIONS.MANDT == T149.MANDT
LIFO valuation key/pool number
  • Pool number for LIFO valuation
  • Client
  • ?
  • I_CURRENTMATERIALVALUATIONS.LIFOVALUATIONPOOLNUMBER == TPOOL.MYPOOL
  • I_CURRENTMATERIALVALUATIONS.MANDT == TPOOL.MANDT
  • I_CURRENTMATERIALVALUATIONS.[column in domain "MYKEY"] == TPOOL.MYKEY
Material Number
  • Client
  • Material Number
  • I_CURRENTMATERIALVALUATIONS.MANDT == MARA.MANDT
  • I_CURRENTMATERIALVALUATIONS.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_CURRENTMATERIALVALUATIONS.MANDT == T023.MANDT
  • I_CURRENTMATERIALVALUATIONS.MATERIALGROUP == T023.MATKL
Special procurement key
  • Plant
  • Client
  • Special procurement type
  • I_CURRENTMATERIALVALUATIONS.PLANT == T460A.WERKS
  • I_CURRENTMATERIALVALUATIONS.MANDT == T460A.MANDT
  • I_CURRENTMATERIALVALUATIONS.MATERIALPROCUREMENTPROFILE == T460A.SOBSL
Material type
  • Client
  • Material type
  • I_CURRENTMATERIALVALUATIONS.MANDT == T134.MANDT
  • I_CURRENTMATERIALVALUATIONS.MATERIALTYPE == T134.MTART
Plant-Specific Material Status
  • Plant-Specific Material Status
  • Client
  • I_CURRENTMATERIALVALUATIONS.MATERIALUSABILITYPROFILE == T141.MMSTA
  • I_CURRENTMATERIALVALUATIONS.MANDT == T141.MANDT
Valuation Class
  • Client
  • Valuation Class
  • I_CURRENTMATERIALVALUATIONS.MANDT == T025.MANDT
  • I_CURRENTMATERIALVALUATIONS.MATERIALVALUATIONCLASS == T025.BKLAS
Valuation variant for previous period
  • Valuation Variant for Previous Standard Cost Estimate
  • Client
  • I_CURRENTMATERIALVALUATIONS.PREVCOSTESTVALUATIONVARIANT == TCK05.BWVAR
  • I_CURRENTMATERIALVALUATIONS.MANDT == TCK05.MANDT
Valuation Class for Project Stock
  • Client
  • Valuation Class for Project Stock
  • I_CURRENTMATERIALVALUATIONS.MANDT == T025.MANDT
  • I_CURRENTMATERIALVALUATIONS.PROJECTSTOCKVALUATIONCLASS == T025.BKLAS
Valuation Class for Special Stock at the Vendor
  • Client
  • Valuation Class for Special Stock at the Vendor
  • I_CURRENTMATERIALVALUATIONS.MANDT == T025.MANDT
  • I_CURRENTMATERIALVALUATIONS.VALNCLSFORSPCLSTKATVNDR == T025.BKLAS
Valuation area
  • Valuation area
  • Client
  • I_CURRENTMATERIALVALUATIONS.VALUATIONAREA == T001K.BWKEY
  • I_CURRENTMATERIALVALUATIONS.MANDT == T001K.MANDT
Valuation Class in Previous Period
  • Client
  • Valuation Class in Previous Period
  • I_CURRENTMATERIALVALUATIONS.MANDT == T025.MANDT
  • I_CURRENTMATERIALVALUATIONS.VALUATIONCLASSINPREVPERIOD == T025.BKLAS
Valuation Class in Previous Year
  • Valuation Class in Previous Year
  • Client
  • I_CURRENTMATERIALVALUATIONS.VALUATIONCLASSINPREVYEAR == T025.BKLAS
  • I_CURRENTMATERIALVALUATIONS.MANDT == T025.MANDT
Valuation Class for Sales Order Stock
  • Valuation Class for Sales Order Stock
  • Client
  • I_CURRENTMATERIALVALUATIONS.VALUATIONCLASSSALESORDERSTOCK == T025.BKLAS
  • I_CURRENTMATERIALVALUATIONS.MANDT == T025.MANDT