P_MATVAL_MANAGE_MD_FMLT

Master Data for Material Valuations | view: PMATVALMGMMDF | Extraction: Not supported | Component: Actual Costing
Tables used: FMLT_PRICE, MARA, MARC, MARV, PRPS, EBEW, MBEW, OBEW, QBEW
Column Name Description
CostEstimate Cost Estimate Number for Cost Est. w/o Qty Structure
Ledger Ledger in General Ledger Accounting
CurrencyRole External Currency Type and Valuation View
Material Material Number
ValuationArea Valuation area
Column Name Description
FuturePrice Material Ledger Price
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
FuturePriceValidityStartDate Valid From
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
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
PriceDeterminationControl Price Determination 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
Column Name Description Domain name
CompanyCode Company Code BUKRS
InventoryValuationType Valuation Type BWTAR
MaterialPriceUnitQty Price unit PACK3
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
Unit of Measure
  • Client
  • Base Unit of Measure
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == T006.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.BASEUNIT == T006.MSEHI
Alternative BOM
  • Client
  • BOM Usage
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == T416.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.BILLOFMATERIALVARIANTUSAGE == T416.STLAN
Task List Type
  • Client
  • Task List Type
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == TCA01.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Special procurement key for costing
  • Client
  • ?
  • Special Procurement Type for Costing
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == T460A.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.[column in domain "WERKS_D"] == T460A.WERKS
  • P_MATVAL_MANAGE_MD_FMLT.COSTINGMATPROCUREMENTPROFILE == T460A.SOBSL
Overhead group
  • Client
  • Valuation area
  • Costing Overhead Group
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == TCK14.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.VALUATIONAREA == TCK14.BWKEY
  • P_MATVAL_MANAGE_MD_FMLT.COSTINGOVERHEADGROUP == TCK14.KOSGR
Origin of cost estimate
  • ?
  • Origin Group as Subdivision of Cost Element
  • ?
  • Client
  • P_MATVAL_MANAGE_MD_FMLT.[column in domain "HRKTYP"] == TKKH1.KOATY
  • P_MATVAL_MANAGE_MD_FMLT.COSTORIGINGROUP == TKKH1.HRKFT
  • P_MATVAL_MANAGE_MD_FMLT.[column in domain "KOKRS"] == TKKH1.KOKRS
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == TKKH1.MANDT
Valuation variant for current period
  • Client
  • Valuation Variant for Current Standard Cost Estimate
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == TCK05.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.CURCOSTESTVALUATIONVARIANT == TCK05.BWVAR
Valuation variant for future period
  • Client
  • Valuation Variant for Future Standard Cost Estimate
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == TCK05.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.FUTRCOSTESTVALUATIONVARIANT == TCK05.BWVAR
Valuation area/valuation category
  • Client
  • Valuation area
  • Valuation Category
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == T149.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.VALUATIONAREA == T149.BWKEY
  • P_MATVAL_MANAGE_MD_FMLT.INVENTORYVALUATIONCATEGORY == T149.BWTTY
LIFO valuation key/pool number
  • Client
  • Pool number for LIFO valuation
  • ?
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == TPOOL.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.LIFOVALUATIONPOOLNUMBER == TPOOL.MYPOOL
  • P_MATVAL_MANAGE_MD_FMLT.[column in domain "MYKEY"] == TPOOL.MYKEY
Material Group
  • Client
  • Material Group
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == T023.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.MATERIALGROUP == T023.MATKL
Special procurement key
  • Client
  • ?
  • Special procurement type
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == T460A.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.[column in domain "WERKS_D"] == T460A.WERKS
  • P_MATVAL_MANAGE_MD_FMLT.MATERIALPROCUREMENTPROFILE == T460A.SOBSL
Material type
  • Client
  • Material type
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == T134.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.MATERIALTYPE == T134.MTART
Plant-Specific Material Status
  • Client
  • Plant-Specific Material Status
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == T141.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.MATERIALUSABILITYPROFILE == T141.MMSTA
Valuation Class
  • Client
  • Valuation Class
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == T025.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.MATERIALVALUATIONCLASS == T025.BKLAS
Valuation variant for previous period
  • Client
  • Valuation Variant for Previous Standard Cost Estimate
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == TCK05.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.PREVCOSTESTVALUATIONVARIANT == TCK05.BWVAR
Valuation Class for Project Stock
  • Client
  • Valuation Class for Project Stock
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == T025.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.PROJECTSTOCKVALUATIONCLASS == T025.BKLAS
Valuation Class for Special Stock at the Vendor
  • Client
  • Valuation Class for Special Stock at the Vendor
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == T025.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.VALNCLSFORSPCLSTKATVNDR == T025.BKLAS
Valuation Class in Previous Period
  • Client
  • Valuation Class in Previous Period
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == T025.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.VALUATIONCLASSINPREVPERIOD == T025.BKLAS
Valuation Class in Previous Year
  • Client
  • Valuation Class in Previous Year
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == T025.MANDT
  • P_MATVAL_MANAGE_MD_FMLT.VALUATIONCLASSINPREVYEAR == T025.BKLAS
Valuation Class for Sales Order Stock
  • Valuation Class for Sales Order Stock
  • Client
  • P_MATVAL_MANAGE_MD_FMLT.VALUATIONCLASSSALESORDERSTOCK == T025.BKLAS
  • P_MATVAL_MANAGE_MD_FMLT.MANDT == T025.MANDT