P_Matval_Manage_Md2

Base View for Mat.Val., Master Data | view: PMATVALMGMMD2 | Extraction: Not supported | Component: Actual Costing
Tables used: T001, TKA02, FINSC_LEDGER, FINSC_LEDGER_T, FINSC_CURTYPE, FINSC_CURTYPET, MARA, MARC, MARV, PRPS, T001K, EBEW, MBEW, OBEW, QBEW, FINSC_ACTVE_APPL, FMLC_TOGGLE, FMLT_CURTP_ML
Column Name Description
CostEstimate Cost Estimate Number - Product Costing
LedgerValuationCurrencyRole External Currency Type and Valuation View
Material FK Material Number
ValuationArea FK Valuation area
InventoryValuationType Valuation Type
Column Name Description
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
Column Name Description
📏 Base Unit of Measure (BaseUnit):
CostingLotSize Lot Size for Product Costing
Column Name Description
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
Column Name Description
/cwm/xcwmat Material Is Activated for CW 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
mlmaa Material Ledger Activated at Material Level Show values
Column Name Description Domain name
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
Ledger Ledger in General Ledger Accounting FINS_LEDGER
LedgerName Ledger Name TEXT60
rcolumn Character Field of Length 1 CHAR1
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
LeadingLedger Ledger in General Ledger Accounting FINS_LEDGER
Master Data Relations Join Conditions
Unit of Measure
  • Client
  • Base Unit of Measure
  • P_MATVAL_MANAGE_MD2.MANDT == T006.MANDT
  • P_MATVAL_MANAGE_MD2.BASEUNIT == T006.MSEHI
Alternative BOM
  • Client
  • BOM Usage
  • P_MATVAL_MANAGE_MD2.MANDT == T416.MANDT
  • P_MATVAL_MANAGE_MD2.BILLOFMATERIALVARIANTUSAGE == T416.STLAN
Task List Type
  • Client
  • Task List Type
  • P_MATVAL_MANAGE_MD2.MANDT == TCA01.MANDT
  • P_MATVAL_MANAGE_MD2.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Company code
  • Client
  • Company Code
  • P_MATVAL_MANAGE_MD2.MANDT == T001.MANDT
  • P_MATVAL_MANAGE_MD2.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • Currency Key
  • P_MATVAL_MANAGE_MD2.MANDT == TCURC.MANDT
  • P_MATVAL_MANAGE_MD2.COMPANYCODECURRENCY == TCURC.WAERS
  • P_MATVAL_MANAGE_MD2.CURRENCY == TCURC.WAERS
Special procurement key for costing
  • Client
  • Special Procurement Type for Costing
  • ?
  • P_MATVAL_MANAGE_MD2.MANDT == T460A.MANDT
  • P_MATVAL_MANAGE_MD2.COSTINGMATPROCUREMENTPROFILE == T460A.SOBSL
  • P_MATVAL_MANAGE_MD2.[column in domain "WERKS_D"] == T460A.WERKS
Overhead group
  • Valuation area
  • Client
  • Costing Overhead Group
  • P_MATVAL_MANAGE_MD2.VALUATIONAREA == TCK14.BWKEY
  • P_MATVAL_MANAGE_MD2.MANDT == TCK14.MANDT
  • P_MATVAL_MANAGE_MD2.COSTINGOVERHEADGROUP == TCK14.KOSGR
Origin of cost estimate
  • Origin Group as Subdivision of Cost Element
  • Client
  • ?
  • ?
  • P_MATVAL_MANAGE_MD2.COSTORIGINGROUP == TKKH1.HRKFT
  • P_MATVAL_MANAGE_MD2.MANDT == TKKH1.MANDT
  • P_MATVAL_MANAGE_MD2.[column in domain "HRKTYP"] == TKKH1.KOATY
  • P_MATVAL_MANAGE_MD2.[column in domain "KOKRS"] == TKKH1.KOKRS
Valuation variant for current period
  • Client
  • Valuation Variant for Current Standard Cost Estimate
  • P_MATVAL_MANAGE_MD2.MANDT == TCK05.MANDT
  • P_MATVAL_MANAGE_MD2.CURCOSTESTVALUATIONVARIANT == TCK05.BWVAR
Valuation variant for future period
  • Client
  • Valuation Variant for Future Standard Cost Estimate
  • P_MATVAL_MANAGE_MD2.MANDT == TCK05.MANDT
  • P_MATVAL_MANAGE_MD2.FUTRCOSTESTVALUATIONVARIANT == TCK05.BWVAR
Valuation area/valuation category
  • Valuation area
  • Client
  • Valuation Category
  • P_MATVAL_MANAGE_MD2.VALUATIONAREA == T149.BWKEY
  • P_MATVAL_MANAGE_MD2.MANDT == T149.MANDT
  • P_MATVAL_MANAGE_MD2.INVENTORYVALUATIONCATEGORY == T149.BWTTY
LIFO valuation key/pool number
  • Client
  • ?
  • Pool number for LIFO valuation
  • P_MATVAL_MANAGE_MD2.MANDT == TPOOL.MANDT
  • P_MATVAL_MANAGE_MD2.[column in domain "MYKEY"] == TPOOL.MYKEY
  • P_MATVAL_MANAGE_MD2.LIFOVALUATIONPOOLNUMBER == TPOOL.MYPOOL
Material Number
  • Client
  • Material Number
  • P_MATVAL_MANAGE_MD2.MANDT == MARA.MANDT
  • P_MATVAL_MANAGE_MD2.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_MATVAL_MANAGE_MD2.MANDT == T023.MANDT
  • P_MATVAL_MANAGE_MD2.MATERIALGROUP == T023.MATKL
Special procurement key
  • Client
  • Special procurement type
  • ?
  • P_MATVAL_MANAGE_MD2.MANDT == T460A.MANDT
  • P_MATVAL_MANAGE_MD2.MATERIALPROCUREMENTPROFILE == T460A.SOBSL
  • P_MATVAL_MANAGE_MD2.[column in domain "WERKS_D"] == T460A.WERKS
Material type
  • Client
  • Material type
  • P_MATVAL_MANAGE_MD2.MANDT == T134.MANDT
  • P_MATVAL_MANAGE_MD2.MATERIALTYPE == T134.MTART
Plant-Specific Material Status
  • Client
  • Plant-Specific Material Status
  • P_MATVAL_MANAGE_MD2.MANDT == T141.MANDT
  • P_MATVAL_MANAGE_MD2.MATERIALUSABILITYPROFILE == T141.MMSTA
Valuation Class
  • Valuation Class
  • Client
  • P_MATVAL_MANAGE_MD2.MATERIALVALUATIONCLASS == T025.BKLAS
  • P_MATVAL_MANAGE_MD2.MANDT == T025.MANDT
Valuation variant for previous period
  • Valuation Variant for Previous Standard Cost Estimate
  • Client
  • P_MATVAL_MANAGE_MD2.PREVCOSTESTVALUATIONVARIANT == TCK05.BWVAR
  • P_MATVAL_MANAGE_MD2.MANDT == TCK05.MANDT
Valuation Class for Project Stock
  • Client
  • Valuation Class for Project Stock
  • P_MATVAL_MANAGE_MD2.MANDT == T025.MANDT
  • P_MATVAL_MANAGE_MD2.PROJECTSTOCKVALUATIONCLASS == T025.BKLAS
Valuation Class for Special Stock at the Vendor
  • Client
  • Valuation Class for Special Stock at the Vendor
  • P_MATVAL_MANAGE_MD2.MANDT == T025.MANDT
  • P_MATVAL_MANAGE_MD2.VALNCLSFORSPCLSTKATVNDR == T025.BKLAS
Valuation area
  • Valuation area
  • Client
  • P_MATVAL_MANAGE_MD2.VALUATIONAREA == T001K.BWKEY
  • P_MATVAL_MANAGE_MD2.MANDT == T001K.MANDT
Valuation Class in Previous Period
  • Client
  • Valuation Class in Previous Period
  • P_MATVAL_MANAGE_MD2.MANDT == T025.MANDT
  • P_MATVAL_MANAGE_MD2.VALUATIONCLASSINPREVPERIOD == T025.BKLAS
Valuation Class in Previous Year
  • Client
  • Valuation Class in Previous Year
  • P_MATVAL_MANAGE_MD2.MANDT == T025.MANDT
  • P_MATVAL_MANAGE_MD2.VALUATIONCLASSINPREVYEAR == T025.BKLAS
Valuation Class for Sales Order Stock
  • Valuation Class for Sales Order Stock
  • Client
  • P_MATVAL_MANAGE_MD2.VALUATIONCLASSSALESORDERSTOCK == T025.BKLAS
  • P_MATVAL_MANAGE_MD2.MANDT == T025.MANDT