C_PH_STOCKQUERY

CDS View

Ph Stock Query Philippines

C_PH_STOCKQUERY is a CDS View in S/4HANA. Ph Stock Query Philippines. It contains 11 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 11 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_PH_InventoryQuery view from CONSUMPTION Ph Inventory Query Philippines

Fields (11)

KeyField CDS FieldsUsed in Views
KEY FiscalYearCurrentPeriod FiscalYearCurrentPeriod 1
KEY IsCurrentFiscalPeriod IsCurrentFiscalPeriod 1
KEY Material Material 1
KEY Plant Plant 1
KEY ValuationType ValuationType 1
MovingAveragePrice MovingAveragePrice 1
ProductPriceControl ProductPriceControl 1
StandardPrice StandardPrice 1
TotalValStockQuantity TotalValStockQuantity 1
TotalValStockValue TotalValStockValue 1
ValuationClass ValuationClass 1 
@AbapCatalog.sqlViewName: 'CPHSTOCKQRY'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@ObjectModel.usageType.serviceQuality:#D
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass:#MIXED
@ClientHandling.algorithm: #AUTOMATED
@EndUserText.label: 'Ph Stock Query Philippines'

define view C_PH_StockQuery
  as select from Mbv_Mbew
{
  key bwkey as Plant,
  key matnr as Material,
  key bwtar as ValuationType,
  key lfgja as FiscalYearCurrentPeriod,
  key lfmon as IsCurrentFiscalPeriod,
      lbkum as TotalValStockQuantity,
      salk3 as TotalValStockValue,
      verpr as MovingAveragePrice,
      stprs as StandardPrice,
      vprsv as ProductPriceControl,
      bklas as ValuationClass
}
union all select from Mbv_Mbewh
{
  key bwkey as Plant,
  key matnr as Material,
  key bwtar as ValuationType,
  key lfgja as FiscalYearCurrentPeriod,
  key lfmon as IsCurrentFiscalPeriod,
      lbkum as TotalValStockQuantity,
      salk3 as TotalValStockValue,
      verpr as MovingAveragePrice,
      stprs as StandardPrice,
      vprsv as ProductPriceControl,
      bklas as ValuationClass
}

Learn More