P_InventoryPriceByKeydate

Column Name Description
CostEstimate Cost Estimate Number for Cost Est. w/o Qty Structure
CurrencyRole Currency Type
Column Name Description
💲 Currency Key (Currency):
InventoryPrice null
Column Name Description
Column Name Description
Column Name Description
InventorySpecialStockValnType Valuation of Special Stock Show values
IsSupplierStockValuation Vendor Stock Valuation Indicator Show values
PriceDeterminationControl Material Price Determination: Control Show values
MaterialPriceControl Price control indicator Show values
LedgerValnCrcyRoleIsUsedInLogs Indicator: currency type is used in logistic reporting Show values
Column Name Description Domain name
Ledger null
FiscalPeriod Posting period POPER
FiscalYear Posting Date YYYY GJAHR
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
InventorySpecialStockType Special Stock Indicator SOBKZ
MaterialPriceUnitQty null
LedgerName Ledger Name TEXT60
CurrencyRoleName Currency Type Description TEXT60
LegalCurrencyRole Currency Type (Reference in Legal Valuation Ledger) for ML FINS_CURTYPE
LegalCurrencyRoleName Legal Currency Type Description TEXT60
AccountingValuationView Valuation View FINS_VALUTYP
AcctgValnVwSubviewCombinedName Accounting Valuation View Name TEXT60
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • P_INVENTORYPRICEBYKEYDATE.COMPANYCODE == T001.BUKRS
  • P_INVENTORYPRICEBYKEYDATE.MANDT == T001.MANDT
Valuation type
  • Valuation Type
  • Client
  • P_INVENTORYPRICEBYKEYDATE.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • P_INVENTORYPRICEBYKEYDATE.MANDT == T149D.MANDT
Material Number
  • Client
  • Material Number
  • P_INVENTORYPRICEBYKEYDATE.MANDT == MARA.MANDT
  • P_INVENTORYPRICEBYKEYDATE.MATERIAL == MARA.MATNR
Valuation area
  • Valuation area
  • Client
  • P_INVENTORYPRICEBYKEYDATE.VALUATIONAREA == T001K.BWKEY
  • P_INVENTORYPRICEBYKEYDATE.MANDT == T001K.MANDT