P_DMVCMaterialValuation

DMVC: Material Valuation | view: PDMVCMATLVAL | Extraction: Not supported | Component: Fiori FXU Cost Controlling CO-FIO
Column Name Description
CostEstimate Cost Estimate Number for Cost Est. w/o Qty Structure
ProcessCategory Process Category for Procurement Alt. or Consuption Alt.
Column Name Description
💲 Currency Key (Currency):
MaterialConsumptionValue Inventory Value of Transaction
InventoryAmtInCCCrcy Inventory Value of Transaction
Column Name Description
📏 Quantity Unit for Valuation (ValuationQuantityUnit):
MaterialConsumptionQty Transaction Quantity in Valuation Quantity Unit of Mesure
ValuationQuantity Transaction Quantity in Valuation Quantity Unit of Mesure
Column Name Description
Column Name Description
MaterialProcurementType Procurement Type Show values
Column Name Description Domain name
Plant Plant WERKS
MaterialName Material Description TEXT40
MaterialTypeName Description of Material Type TEXT25
LedgerValuationCurrencyRole External Currency Type and Valuation View FINS_CURTYPE
ProfitCenter Profit Center PRCTR
SalesDocument Sales and Distribution Document Number VBELN
SalesDocumentItem Item number of the SD document POSNR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSNR
Supplier Account Number of Supplier LIFNR
FiscalYear Fiscal Year GJAHR
AccountingDocument Journal Entry BELNR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
Timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ProfitCenterMD Profit Center PRCTR
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • P_DMVCMATERIALVALUATION.COMPANYCODE == T001.BUKRS
  • P_DMVCMATERIALVALUATION.MANDT == T001.MANDT
Valuation type
  • Valuation Type
  • Client
  • P_DMVCMATERIALVALUATION.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • P_DMVCMATERIALVALUATION.MANDT == T149D.MANDT
Material Number
  • Client
  • Material Number
  • P_DMVCMATERIALVALUATION.MANDT == MARA.MANDT
  • P_DMVCMATERIALVALUATION.MATERIAL == MARA.MATNR
Material type
  • Client
  • Material type
  • P_DMVCMATERIALVALUATION.MANDT == T134.MANDT
  • P_DMVCMATERIALVALUATION.MATERIALTYPE == T134.MTART
Valuation Class
  • Valuation Class
  • Client
  • P_DMVCMATERIALVALUATION.MATERIALVALUATIONCLASS == T025.BKLAS
  • P_DMVCMATERIALVALUATION.MANDT == T025.MANDT
Company Code
  • Company Code
  • Client
  • P_DMVCMATERIALVALUATION.SOURCECOMPANYCODE == T001.BUKRS
  • P_DMVCMATERIALVALUATION.MANDT == T001.MANDT
Source Ledger
  • Source Ledger
  • Client
Valuation area
  • Valuation area
  • Client
  • P_DMVCMATERIALVALUATION.VALUATIONAREA == T001K.BWKEY
  • P_DMVCMATERIALVALUATION.MANDT == T001K.MANDT