P_Matval_Manage_Md

Base View for Mat.Val., Master Data | view: PMATVALMGMMD | Extraction: Not supported | Component: Actual Costing
Tables used: MARA, MARC, MARV, PRPS, T001K, EBEW, MBEW, OBEW, QBEW
Column Name Description
CostEstimate Cost Estimate Number - Product Costing
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
CostingLotSize Lot Size for Product Costing
Column Name Description
mmstd Date from Which the Plant-Specific Material Status Is 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
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
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
Master Data Relations Join Conditions
Variance Key
  • ?
  • Variance Key
  • Client
  • P_MATVAL_MANAGE_MD.[column in domain "AWOBA"] == TKV01.AWOBA
  • P_MATVAL_MANAGE_MD.AWSLS == TKV01.AWSLS
  • P_MATVAL_MANAGE_MD.MANDT == TKV01.MANDT
Unit of Measure
  • Client
  • Base Unit of Measure
  • P_MATVAL_MANAGE_MD.MANDT == T006.MANDT
  • P_MATVAL_MANAGE_MD.BASEUNIT == T006.MSEHI
Alternative BOM
  • BOM Usage
  • Client
  • P_MATVAL_MANAGE_MD.BILLOFMATERIALVARIANTUSAGE == T416.STLAN
  • P_MATVAL_MANAGE_MD.MANDT == T416.MANDT
Task List Type
  • Task List Type
  • Client
  • P_MATVAL_MANAGE_MD.BILLOFOPERATIONSTYPE == TCA01.PLNTY
  • P_MATVAL_MANAGE_MD.MANDT == TCA01.MANDT
Company code
  • Company Code
  • Client
  • P_MATVAL_MANAGE_MD.COMPANYCODE == T001.BUKRS
  • P_MATVAL_MANAGE_MD.MANDT == T001.MANDT
Special procurement key for costing
  • ?
  • Client
  • Special Procurement Type for Costing
  • P_MATVAL_MANAGE_MD.[column in domain "WERKS_D"] == T460A.WERKS
  • P_MATVAL_MANAGE_MD.MANDT == T460A.MANDT
  • P_MATVAL_MANAGE_MD.COSTINGMATPROCUREMENTPROFILE == T460A.SOBSL
Overhead group
  • Valuation area
  • Costing Overhead Group
  • Client
  • P_MATVAL_MANAGE_MD.VALUATIONAREA == TCK14.BWKEY
  • P_MATVAL_MANAGE_MD.COSTINGOVERHEADGROUP == TCK14.KOSGR
  • P_MATVAL_MANAGE_MD.MANDT == TCK14.MANDT
Origin of cost estimate
  • Origin Group as Subdivision of Cost Element
  • ?
  • ?
  • Client
  • P_MATVAL_MANAGE_MD.COSTORIGINGROUP == TKKH1.HRKFT
  • P_MATVAL_MANAGE_MD.[column in domain "HRKTYP"] == TKKH1.KOATY
  • P_MATVAL_MANAGE_MD.[column in domain "KOKRS"] == TKKH1.KOKRS
  • P_MATVAL_MANAGE_MD.MANDT == TKKH1.MANDT
Valuation variant for current period
  • Valuation Variant for Current Standard Cost Estimate
  • Client
  • P_MATVAL_MANAGE_MD.CURCOSTESTVALUATIONVARIANT == TCK05.BWVAR
  • P_MATVAL_MANAGE_MD.MANDT == TCK05.MANDT
Valuation variant for future period
  • Valuation Variant for Future Standard Cost Estimate
  • Client
  • P_MATVAL_MANAGE_MD.FUTRCOSTESTVALUATIONVARIANT == TCK05.BWVAR
  • P_MATVAL_MANAGE_MD.MANDT == TCK05.MANDT
Valuation area/valuation category
  • Valuation area
  • Valuation Category
  • Client
  • P_MATVAL_MANAGE_MD.VALUATIONAREA == T149.BWKEY
  • P_MATVAL_MANAGE_MD.INVENTORYVALUATIONCATEGORY == T149.BWTTY
  • P_MATVAL_MANAGE_MD.MANDT == T149.MANDT
LIFO valuation key/pool number
  • ?
  • Client
  • Pool number for LIFO valuation
  • P_MATVAL_MANAGE_MD.[column in domain "MYKEY"] == TPOOL.MYKEY
  • P_MATVAL_MANAGE_MD.MANDT == TPOOL.MANDT
  • P_MATVAL_MANAGE_MD.LIFOVALUATIONPOOLNUMBER == TPOOL.MYPOOL
Material Number
  • Client
  • Material Number
  • P_MATVAL_MANAGE_MD.MANDT == MARA.MANDT
  • P_MATVAL_MANAGE_MD.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • P_MATVAL_MANAGE_MD.MATERIALGROUP == T023.MATKL
  • P_MATVAL_MANAGE_MD.MANDT == T023.MANDT
Special procurement key
  • ?
  • Client
  • Special procurement type
  • P_MATVAL_MANAGE_MD.[column in domain "WERKS_D"] == T460A.WERKS
  • P_MATVAL_MANAGE_MD.MANDT == T460A.MANDT
  • P_MATVAL_MANAGE_MD.MATERIALPROCUREMENTPROFILE == T460A.SOBSL
Material type
  • Material type
  • Client
  • P_MATVAL_MANAGE_MD.MATERIALTYPE == T134.MTART
  • P_MATVAL_MANAGE_MD.MANDT == T134.MANDT
Plant-Specific Material Status
  • Plant-Specific Material Status
  • Client
  • P_MATVAL_MANAGE_MD.MATERIALUSABILITYPROFILE == T141.MMSTA
  • P_MATVAL_MANAGE_MD.MANDT == T141.MANDT
Valuation Class
  • Valuation Class
  • Client
  • P_MATVAL_MANAGE_MD.MATERIALVALUATIONCLASS == T025.BKLAS
  • P_MATVAL_MANAGE_MD.MANDT == T025.MANDT
Valuation variant for previous period
  • Valuation Variant for Previous Standard Cost Estimate
  • Client
  • P_MATVAL_MANAGE_MD.PREVCOSTESTVALUATIONVARIANT == TCK05.BWVAR
  • P_MATVAL_MANAGE_MD.MANDT == TCK05.MANDT
Valuation Class for Project Stock
  • Valuation Class for Project Stock
  • Client
  • P_MATVAL_MANAGE_MD.PROJECTSTOCKVALUATIONCLASS == T025.BKLAS
  • P_MATVAL_MANAGE_MD.MANDT == T025.MANDT
Configurable material
  • Configurable material
  • Client
  • P_MATVAL_MANAGE_MD.STDPD == MARA.MATNR
  • P_MATVAL_MANAGE_MD.MANDT == MARA.MANDT
Valuation Class for Special Stock at the Vendor
  • Client
  • Valuation Class for Special Stock at the Vendor
  • P_MATVAL_MANAGE_MD.MANDT == T025.MANDT
  • P_MATVAL_MANAGE_MD.VALNCLSFORSPCLSTKATVNDR == T025.BKLAS
Valuation area
  • Valuation area
  • Client
  • P_MATVAL_MANAGE_MD.VALUATIONAREA == T001K.BWKEY
  • P_MATVAL_MANAGE_MD.MANDT == T001K.MANDT
Valuation Class in Previous Period
  • Valuation Class in Previous Period
  • Client
  • P_MATVAL_MANAGE_MD.VALUATIONCLASSINPREVPERIOD == T025.BKLAS
  • P_MATVAL_MANAGE_MD.MANDT == T025.MANDT
Valuation Class in Previous Year
  • Client
  • Valuation Class in Previous Year
  • P_MATVAL_MANAGE_MD.MANDT == T025.MANDT
  • P_MATVAL_MANAGE_MD.VALUATIONCLASSINPREVYEAR == T025.BKLAS
Valuation Class for Sales Order Stock
  • Valuation Class for Sales Order Stock
  • Client
  • P_MATVAL_MANAGE_MD.VALUATIONCLASSSALESORDERSTOCK == T025.BKLAS
  • P_MATVAL_MANAGE_MD.MANDT == T025.MANDT