C_MatlValnManage

Material Valuations | view: CMATLVALNMANAGE | 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
💲 Currency Key (Currency):
TotalValuatedStockAmount Value of Total Valuated Stock
InventoryPrice Inventory Price
FuturePrice Future Price
FuturePlannedPrice Future planned price
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
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
PlannedPrice1InCoCodeCrcy Future Planned Price 1
PlannedPrice2InCoCodeCrcy Future Planned Price 2
PlannedPrice3InCoCodeCrcy Future Planned Price 3
TotStkValAtSlsPrcInCoCodeCrcy Value of Total Valuated Stock at Sales Price
FxdPortnOfPlanPrcInCoCodeCrcy Fixed Portion of Current Planned Price
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
Column Name Description
📏 Valuation Unit of Measure (ValuationQuantityUnit):
TotalVltdStockQuantity Valuation Quantity
CostingLotSize Lot Size for Product Costing
Column Name Description
FuturePriceValidityStartDate Date from Which a Future Valuation Price Is to Be Valid
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
PriceDeterminationControl Price Determination Show values
IsBlockedForCosting Do Not Cost Show values
IsMaterialCostedWithQtyStruc Material Is Costed with Quantity Structure Show values
IsMaterialRelatedOrigin Is Material Related Origin Show values
IsCoProduct Indicator: Material can be co-product Show values
IsFixedPriceCoProduct Fixed-Price Co-Product Show values
HasProductionVersion Version Indicator Show values
PhysicalInventoryBlockInd Physical Inventory Blocking Indicator Show values
ProductUsageType Usage of the material Show values
ProductOriginType Origin of the material Show values
IsProducedInhouse Produced in-house Show values
MaterialPriceControl Price Control Show values
IsLIFOAndFIFORelevant Is LIFO/FIFO Relevant Show values
ControllingValuationType Valuation View (for Transfer Prices) Show values
PriceTranslationSource Price Translation Source Name Show values
IsCloudSystem Is Cloud System 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
AccountingValuationViewName Description TEXT60
AccountingValuationSubviewName Description TEXT60
AcctgValnVwSubviewCombinedName Accounting Valuation View Name TEXT60
LedgerName Ledger Name TEXT60
LegalCurrencyRoleName Legal Currency Type Description TEXT60
CurrencyRole External Currency Type and Valuation View FINS_CURTYPE
Plant Plant WERKS
PlantName Plant Name TEXT30
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
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSElementInternalID Work Breakdown Structure Element (WBS Element) PS_POSNR
ProfitCenter Profit Center PRCTR
CurrentFiscalYear Posting Date YYYY GJAHR
CurrentFiscalPeriod Posting period POPER
MaterialName Material Description TEXT40
ProductImageURL Image URL
CompanyCodeName Name of Company Code or Company TEXT25
MaterialPriceUnitQty Price Unit PACK3
TaxBasedPricesPriceUnitQty Price unit for valuation prices based on tax/commercial law PACK3
AlternativeBillOfMaterial Alternative BOM ALTNR
TaskListGroup Key for Task List Group PLNNR
TaskListGroupCounter Group Counter ALTNR
CostingProductionVersion Production Version To Be Costed VERID
InventoryForCycleCountInd Physical Inventory Indicator for Cycle Counting ABCIN
ValuationMargin Valuation margin PRZ32V
DevaluationYearCount Lowest value: devaluation indicator NUMC2
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
  • C_MATLVALNMANAGE.MANDT == T006.MANDT
  • C_MATLVALNMANAGE.BASEUNIT == T006.MSEHI
Alternative BOM
  • Client
  • BOM Usage
  • C_MATLVALNMANAGE.MANDT == T416.MANDT
  • C_MATLVALNMANAGE.BILLOFMATERIALVARIANTUSAGE == T416.STLAN
Task List Type
  • Client
  • Task List Type
  • C_MATLVALNMANAGE.MANDT == TCA01.MANDT
  • C_MATLVALNMANAGE.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Company code
  • Client
  • Company Code
  • C_MATLVALNMANAGE.MANDT == T001.MANDT
  • C_MATLVALNMANAGE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Company Code Currency
  • Currency Key
  • Client
  • C_MATLVALNMANAGE.COMPANYCODECURRENCY == TCURC.WAERS
  • C_MATLVALNMANAGE.CURRENCY == TCURC.WAERS
  • C_MATLVALNMANAGE.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_MATLVALNMANAGE.CONTROLLINGAREA == TKA01.KOKRS
  • C_MATLVALNMANAGE.MANDT == TKA01.MANDT
Overhead group
  • Valuation area
  • Client
  • Costing Overhead Group
  • C_MATLVALNMANAGE.VALUATIONAREA == TCK14.BWKEY
  • C_MATLVALNMANAGE.MANDT == TCK14.MANDT
  • C_MATLVALNMANAGE.COSTINGOVERHEADGROUP == TCK14.KOSGR
Origin of cost estimate
  • Origin Group as Subdivision of Cost Element
  • Controlling Area
  • ?
  • Client
  • C_MATLVALNMANAGE.COSTORIGINGROUP == TKKH1.HRKFT
  • C_MATLVALNMANAGE.CONTROLLINGAREA == TKKH1.KOKRS
  • C_MATLVALNMANAGE.[column in domain "HRKTYP"] == TKKH1.KOATY
  • C_MATLVALNMANAGE.MANDT == TKKH1.MANDT
Valuation area/valuation category
  • Valuation area
  • Valuation Category
  • Client
  • C_MATLVALNMANAGE.VALUATIONAREA == T149.BWKEY
  • C_MATLVALNMANAGE.INVENTORYVALUATIONCATEGORY == T149.BWTTY
  • C_MATLVALNMANAGE.MANDT == T149.MANDT
LIFO valuation key/pool number
  • ?
  • Pool number for LIFO valuation
  • Client
  • C_MATLVALNMANAGE.[column in domain "MYKEY"] == TPOOL.MYKEY
  • C_MATLVALNMANAGE.LIFOVALUATIONPOOLNUMBER == TPOOL.MYPOOL
  • C_MATLVALNMANAGE.MANDT == TPOOL.MANDT
Material Number
  • Material Number
  • Client
  • C_MATLVALNMANAGE.MATERIAL == MARA.MATNR
  • C_MATLVALNMANAGE.MANDT == MARA.MANDT
Plant-Specific Material Status
  • Plant-Specific Material Status
  • Client
  • C_MATLVALNMANAGE.MATERIALUSABILITYPROFILE == T141.MMSTA
  • C_MATLVALNMANAGE.MANDT == T141.MANDT
Valuation Class
  • Client
  • Valuation Class
  • C_MATLVALNMANAGE.MANDT == T025.MANDT
  • C_MATLVALNMANAGE.MATERIALVALUATIONCLASS == T025.BKLAS
Valuation Class for Project Stock
  • Client
  • Valuation Class for Project Stock
  • C_MATLVALNMANAGE.MANDT == T025.MANDT
  • C_MATLVALNMANAGE.PROJECTSTOCKVALUATIONCLASS == T025.BKLAS
Valuation Class for Special Stock at the Vendor
  • Valuation Class for Special Stock at the Vendor
  • Client
  • C_MATLVALNMANAGE.VALNCLSFORSPCLSTKATVNDR == T025.BKLAS
  • C_MATLVALNMANAGE.MANDT == T025.MANDT
Valuation area
  • Valuation area
  • Client
  • C_MATLVALNMANAGE.VALUATIONAREA == T001K.BWKEY
  • C_MATLVALNMANAGE.MANDT == T001K.MANDT
Valuation Class in Previous Period
  • Client
  • Valuation Class in Previous Period
  • C_MATLVALNMANAGE.MANDT == T025.MANDT
  • C_MATLVALNMANAGE.VALUATIONCLASSINPREVPERIOD == T025.BKLAS
Valuation Class in Previous Year
  • Client
  • Valuation Class in Previous Year
  • C_MATLVALNMANAGE.MANDT == T025.MANDT
  • C_MATLVALNMANAGE.VALUATIONCLASSINPREVYEAR == T025.BKLAS
Valuation Class for Sales Order Stock
  • Valuation Class for Sales Order Stock
  • Client
  • C_MATLVALNMANAGE.VALUATIONCLASSSALESORDERSTOCK == T025.BKLAS
  • C_MATLVALNMANAGE.MANDT == T025.MANDT