P_DMVCMaterial

DMVC: Material | view: PDMVCMATERIAL | Extraction: Not supported | Component: Fiori FXU Cost Controlling CO-FIO
Column Name Description
CostEstimate Cost Estimate Number for Cost Est. w/o Qty Structure
FiscalYearPeriod Year / Period YYYYPPP of Posting
LedgerValuationCurrencyRole External Currency Type and Valuation View
ProcessCategory Process Category for Procurement Alt. or Consuption Alt.
Column Name Description
💲 Currency Key (Currency):
InventoryAmtInCCCrcy Inventory Value of Transaction
MaterialConsumptionValue Inventory Value of Transaction
Column Name Description
📏 Quantity Unit for Valuation (ValuationQuantityUnit):
ValuationQuantity Transaction Quantity in Valuation Quantity Unit of Mesure
MaterialConsumptionQty 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
MaterialTypeName Description of Material Type TEXT25
MaterialName Material Description TEXT40
ProfitCenter Profit Center PRCTR
FiscalYear Fiscal Year GJAHR
AccountingDocument Journal Entry BELNR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
Timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
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
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • P_DMVCMATERIAL.COMPANYCODE == T001.BUKRS
  • P_DMVCMATERIAL.MANDT == T001.MANDT
Valuation type
  • Client
  • Valuation Type
  • P_DMVCMATERIAL.MANDT == T149D.MANDT
  • P_DMVCMATERIAL.INVENTORYVALUATIONTYPE == T149D.BWTAR
Material Number
  • Material Number
  • Client
  • P_DMVCMATERIAL.MATERIAL == MARA.MATNR
  • P_DMVCMATERIAL.MANDT == MARA.MANDT
Material type
  • Client
  • Material type
  • P_DMVCMATERIAL.MANDT == T134.MANDT
  • P_DMVCMATERIAL.MATERIALTYPE == T134.MTART
Valuation Class
  • Valuation Class
  • Client
  • P_DMVCMATERIAL.MATERIALVALUATIONCLASS == T025.BKLAS
  • P_DMVCMATERIAL.MANDT == T025.MANDT
Company Code
  • Client
  • Company Code
  • P_DMVCMATERIAL.MANDT == T001.MANDT
  • P_DMVCMATERIAL.SOURCECOMPANYCODE == T001.BUKRS
Source Ledger
  • Client
  • Source Ledger
Valuation area
  • Client
  • Valuation area
  • P_DMVCMATERIAL.MANDT == T001K.MANDT
  • P_DMVCMATERIAL.VALUATIONAREA == T001K.BWKEY