C_PH_InventoryQuery

Ph Inventory Query Philippines | view: CPHINVENTORYQRY | Extraction: Not supported | Component: Financials Philippines
Column Name Description
Plant FK Valuation area
Material FK Material Number
ValuationType Valuation Type
CompanyCode FK Company Code
FiscalYearCurrentPeriod Fiscal Year of Current Period
IsCurrentFiscalPeriod Current period (posting period)
Column Name Description
MovingAveragePrice Moving Average Price/Periodic Unit Price
StandardPrice Standard price
TotalValStockValue Value of Total Valuated Stock
ItemPrice Standard price
Column Name Description
TotalValStockQuantity Total Valuated Stock
Column Name Description
Column Name Description
ProductPriceControl Price control indicator Show values
Column Name Description Domain name
MaterialName null
Master Data Relations Join Conditions
Company code
  • Client
  • Company Code
  • C_PH_INVENTORYQUERY.MANDT == T001.MANDT
  • C_PH_INVENTORYQUERY.COMPANYCODE == T001.BUKRS
Currency Key
  • Currency Key
  • Client
  • C_PH_INVENTORYQUERY.CURRENCY == TCURC.WAERS
  • C_PH_INVENTORYQUERY.MANDT == TCURC.MANDT
Material Number
  • Material Number
  • Client
  • C_PH_INVENTORYQUERY.MATERIAL == MARA.MATNR
  • C_PH_INVENTORYQUERY.MANDT == MARA.MANDT
Unit of Measure
  • Client
  • Base Unit of Measure
  • C_PH_INVENTORYQUERY.MANDT == T006.MANDT
  • C_PH_INVENTORYQUERY.MATERIALBASEUNIT == T006.MSEHI
Material type
  • Material type
  • Client
  • C_PH_INVENTORYQUERY.MATERIALTYPE == T134.MTART
  • C_PH_INVENTORYQUERY.MANDT == T134.MANDT
Valuation area
  • Client
  • Valuation area
  • C_PH_INVENTORYQUERY.MANDT == T001K.MANDT
  • C_PH_INVENTORYQUERY.PLANT == T001K.BWKEY
Valuation Class
  • Client
  • Valuation Class
  • C_PH_INVENTORYQUERY.MANDT == T025.MANDT
  • C_PH_INVENTORYQUERY.VALUATIONCLASS == T025.BKLAS