P_ProductValuationBasic

Product Valuation | view: PPRDVALUATION | Extraction: Not supported | Component: Material Master
Tables used: MBEW
Column Name Description
Product FK Product Number
ValuationArea FK Valuation area
ValuationType Valuation Type
Column Name Description
MovingAveragePrice Moving Average Price/Periodic Unit Price
StandardPrice Standard price
DairyPrevPerdStandardPrice Standard price in the previous period
StandardPricePrevYear Standard price in previous year
PrevInvtryPriceInCoCodeCrcy Previous Price
FuturePrice Future 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
PlannedPrice 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
DairyCurrentPlannedPrice Current Planned Price
FxdPortnOfPlanPrcInCoCodeCrcy Fixed Portion of Current Planned Price
FxdPortOfPrevPlPrcInCoCodeCrcy Fixed Portion of Previous Planned Price
Column Name Description
Column Name Description
PriceLastChangeDate Date of Last Price Change
FuturePriceValidityStartDate Date as of which the price is valid
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
Column Name Description
IsMarkedForDeletion Deletion flag for all material data of a valuation type Show values
InventoryValuationProcedure Price Control Show values
OperationIsIncludedInCosting 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 Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
IsMaterialCostedWithQtyStruc Material Is Costed with Quantity Structure Show values
PriceDeterminationControl Material Price Determination: Control Show values
IsMaterialRelatedOrigin Material-related origin 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
ProductUsageType Usage of the Product Show values
ProductOriginType Origin of the Product Show values
IsProducedInhouse Produced in-house Show values
Column Name Description Domain name
PriceUnitQty Price unit PACK3
PriceUnitPrevPeriod Price unit of previous period PACK3
FiscalYearCurrentPeriod Fiscal Year of Current Period GJAHR
FiscalMonthCurrentPeriod Current period (posting period) MONAT
ProdSpecCompUpperLimitQuantity Period for current standard cost estimate (deactivated) BUPER
PCEctxPHScaleUprValTxt Period for previous standard cost estimate (deactivated) BUPER
DevaluationYearCount Lowest value: devaluation indicator NUMC2
MaintenanceStatus Maintenance status PSTAT
ProdCostEstNumber Cost Estimate Number - Product Costing CK_KALNR
CostEstimateNumberOfOutput Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR
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
ValuationMargin Valuation margin PRZ32V
TaxBasedPricesPriceUnitQty Price unit for valuation prices based on tax/commercial law PACK3
Master Data Relations Join Conditions
Overhead group
  • Valuation area
  • Client
  • Costing Overhead Group
  • P_PRODUCTVALUATIONBASIC.VALUATIONAREA == TCK14.BWKEY
  • P_PRODUCTVALUATIONBASIC.MANDT == TCK14.MANDT
  • P_PRODUCTVALUATIONBASIC.COSTINGOVERHEADGROUP == TCK14.KOSGR
Origin of cost estimate
  • Client
  • ?
  • Origin Group as Subdivision of Cost Element
  • ?
  • P_PRODUCTVALUATIONBASIC.MANDT == TKKH1.MANDT
  • P_PRODUCTVALUATIONBASIC.[column in domain "HRKTYP"] == TKKH1.KOATY
  • P_PRODUCTVALUATIONBASIC.COSTORIGINGROUP == TKKH1.HRKFT
  • P_PRODUCTVALUATIONBASIC.[column in domain "KOKRS"] == TKKH1.KOKRS
Valuation variant for current period
  • Client
  • Valuation Variant for Current Standard Cost Estimate
  • P_PRODUCTVALUATIONBASIC.MANDT == TCK05.MANDT
  • P_PRODUCTVALUATIONBASIC.CURCOSTESTVALUATIONVARIANT == TCK05.BWVAR
Valuation variant for future period
  • Valuation Variant for Future Standard Cost Estimate
  • Client
  • P_PRODUCTVALUATIONBASIC.FUTRCOSTESTVALUATIONVARIANT == TCK05.BWVAR
  • P_PRODUCTVALUATIONBASIC.MANDT == TCK05.MANDT
LIFO valuation key/pool number
  • Client
  • ?
  • Pool number for LIFO valuation
  • P_PRODUCTVALUATIONBASIC.MANDT == TPOOL.MANDT
  • P_PRODUCTVALUATIONBASIC.[column in domain "MYKEY"] == TPOOL.MYKEY
  • P_PRODUCTVALUATIONBASIC.LIFOVALUATIONPOOLNUMBER == TPOOL.MYPOOL
Valuation variant for previous period
  • Client
  • Valuation Variant for Previous Standard Cost Estimate
  • P_PRODUCTVALUATIONBASIC.MANDT == TCK05.MANDT
  • P_PRODUCTVALUATIONBASIC.PREVCOSTESTVALUATIONVARIANT == TCK05.BWVAR
Product Number
  • Client
  • Product Number
  • P_PRODUCTVALUATIONBASIC.MANDT == MARA.MANDT
  • P_PRODUCTVALUATIONBASIC.PRODUCT == MARA.MATNR
Valuation Class for Project Stock
  • Client
  • Valuation Class for Project Stock
  • P_PRODUCTVALUATIONBASIC.MANDT == T025.MANDT
  • P_PRODUCTVALUATIONBASIC.PROJECTSTOCKVALUATIONCLASS == T025.BKLAS
Valuation area
  • Valuation area
  • Client
  • P_PRODUCTVALUATIONBASIC.VALUATIONAREA == T001K.BWKEY
  • P_PRODUCTVALUATIONBASIC.MANDT == T001K.MANDT
Valuation area/valuation category
  • Valuation area
  • Valuation Category
  • Client
  • P_PRODUCTVALUATIONBASIC.VALUATIONAREA == T149.BWKEY
  • P_PRODUCTVALUATIONBASIC.VALUATIONCATEGORY == T149.BWTTY
  • P_PRODUCTVALUATIONBASIC.MANDT == T149.MANDT
Valuation Class
  • Client
  • Valuation Class
  • P_PRODUCTVALUATIONBASIC.MANDT == T025.MANDT
  • P_PRODUCTVALUATIONBASIC.VALUATIONCLASS == T025.BKLAS
Valuation Class in Previous Period
  • Client
  • Valuation Class in Previous Period
  • P_PRODUCTVALUATIONBASIC.MANDT == T025.MANDT
  • P_PRODUCTVALUATIONBASIC.VALUATIONCLASSINPREVPERIOD == T025.BKLAS
Valuation Class in Previous Year
  • Client
  • Valuation Class in Previous Year
  • P_PRODUCTVALUATIONBASIC.MANDT == T025.MANDT
  • P_PRODUCTVALUATIONBASIC.VALUATIONCLASSINPREVYEAR == T025.BKLAS
Valuation Class for Sales Order Stock
  • Valuation Class for Sales Order Stock
  • Client
  • P_PRODUCTVALUATIONBASIC.VALUATIONCLASSSALESORDERSTOCK == T025.BKLAS
  • P_PRODUCTVALUATIONBASIC.MANDT == T025.MANDT