P_Matval_Manage_Xbew

Base View for Mat.Val., Master Data | view: PMATVALMGMXBEW | Extraction: Not supported | Component: Actual Costing

Tables used: EBEW, MBEW, OBEW, QBEW

🔑 Keys (4)
💰 Amounts (16)
∑ Quantities
📅 Dates (5)
☰ Categorical (17)
Other (19)
🔗 Relations (15)

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

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
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
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
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
Overhead group Costing Overhead Group Valuation area Client	`P_MATVAL_MANAGE_XBEW.COSTINGOVERHEADGROUP == TCK14.KOSGR` `P_MATVAL_MANAGE_XBEW.VALUATIONAREA == TCK14.BWKEY` `P_MATVAL_MANAGE_XBEW.MANDT == TCK14.MANDT`
Origin of cost estimate ? ? Client Origin Group as Subdivision of Cost Element	`P_MATVAL_MANAGE_XBEW.[column in domain "KOKRS"] == TKKH1.KOKRS` `P_MATVAL_MANAGE_XBEW.[column in domain "HRKTYP"] == TKKH1.KOATY` `P_MATVAL_MANAGE_XBEW.MANDT == TKKH1.MANDT` `P_MATVAL_MANAGE_XBEW.COSTORIGINGROUP == TKKH1.HRKFT`
Valuation variant for current period Valuation Variant for Current Standard Cost Estimate Client	`P_MATVAL_MANAGE_XBEW.CURCOSTESTVALUATIONVARIANT == TCK05.BWVAR` `P_MATVAL_MANAGE_XBEW.MANDT == TCK05.MANDT`
Valuation variant for future period Valuation Variant for Future Standard Cost Estimate Client	`P_MATVAL_MANAGE_XBEW.FUTRCOSTESTVALUATIONVARIANT == TCK05.BWVAR` `P_MATVAL_MANAGE_XBEW.MANDT == TCK05.MANDT`
Valuation area/valuation category Valuation Category Valuation area Client	`P_MATVAL_MANAGE_XBEW.INVENTORYVALUATIONCATEGORY == T149.BWTTY` `P_MATVAL_MANAGE_XBEW.VALUATIONAREA == T149.BWKEY` `P_MATVAL_MANAGE_XBEW.MANDT == T149.MANDT`
LIFO valuation key/pool number Client ? Pool number for LIFO valuation	`P_MATVAL_MANAGE_XBEW.MANDT == TPOOL.MANDT` `P_MATVAL_MANAGE_XBEW.[column in domain "MYKEY"] == TPOOL.MYKEY` `P_MATVAL_MANAGE_XBEW.LIFOVALUATIONPOOLNUMBER == TPOOL.MYPOOL`
Material Number Material Number Client	`P_MATVAL_MANAGE_XBEW.MATERIAL == MARA.MATNR` `P_MATVAL_MANAGE_XBEW.MANDT == MARA.MANDT`
Valuation Class Valuation Class Client	`P_MATVAL_MANAGE_XBEW.MATERIALVALUATIONCLASS == T025.BKLAS` `P_MATVAL_MANAGE_XBEW.MANDT == T025.MANDT`
Valuation variant for previous period Valuation Variant for Previous Standard Cost Estimate Client	`P_MATVAL_MANAGE_XBEW.PREVCOSTESTVALUATIONVARIANT == TCK05.BWVAR` `P_MATVAL_MANAGE_XBEW.MANDT == TCK05.MANDT`
Valuation Class for Project Stock Client Valuation Class for Project Stock	`P_MATVAL_MANAGE_XBEW.MANDT == T025.MANDT` `P_MATVAL_MANAGE_XBEW.PROJECTSTOCKVALUATIONCLASS == T025.BKLAS`
Valuation Class for Special Stock at the Vendor Valuation Class for Special Stock at the Vendor Client	`P_MATVAL_MANAGE_XBEW.VALNCLSFORSPCLSTKATVNDR == T025.BKLAS` `P_MATVAL_MANAGE_XBEW.MANDT == T025.MANDT`
Valuation area Valuation area Client	`P_MATVAL_MANAGE_XBEW.VALUATIONAREA == T001K.BWKEY` `P_MATVAL_MANAGE_XBEW.MANDT == T001K.MANDT`
Valuation Class in Previous Period Valuation Class in Previous Period Client	`P_MATVAL_MANAGE_XBEW.VALUATIONCLASSINPREVPERIOD == T025.BKLAS` `P_MATVAL_MANAGE_XBEW.MANDT == T025.MANDT`
Valuation Class in Previous Year Client Valuation Class in Previous Year	`P_MATVAL_MANAGE_XBEW.MANDT == T025.MANDT` `P_MATVAL_MANAGE_XBEW.VALUATIONCLASSINPREVYEAR == T025.BKLAS`
Valuation Class for Sales Order Stock Valuation Class for Sales Order Stock Client	`P_MATVAL_MANAGE_XBEW.VALUATIONCLASSSALESORDERSTOCK == T025.BKLAS` `P_MATVAL_MANAGE_XBEW.MANDT == T025.MANDT`