P_SLOWMOMATPREDCONSQTY

@AbapCatalog.sqlViewName: 'PSLOWMOMATCNSQTY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck:#NOT_REQUIRED
//@EndUserText.label: 'Consumption Quantity'

define view P_SlowMoMatPredConsQty as select from P_SlowMoMatPredConsDocRec  as rec
                                  left outer join I_InvtryCnsmpnMvtType      as mtyp
                                             on  rec.GoodsMovementType         = mtyp.GoodsMovementType
                                             and rec.InventoryConsumptionGroup = mtyp.InventoryConsumptionGroup

{
  key rec.InventoryConsumptionGroup as InventoryConsumptionGroup,
  key Material,
  key Plant,
  key StorageLocation, 
  key StockIdentifyingBatch,
  key SpecialStockIdfgSupplier,
  key SpecialStockIdfgSalesOrder,
  key SpecialStockIdfgSalesOrderItem,
  key SpecialStockIdfgWBSElement,
  key SpecialStockIdfgCustomer,
  key SpecialStockIdfgStockOwner,
  key InventorySpecialStockType,
  key InventoryStockType,
  key MaterialBaseUnit,  
      PostingDate,
      rec.GoodsMovementType,
    
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      case 
      when rec.InventoryConsumptionGroup = '000' 
           then MatlCnsmpnQtyInMatlBaseUnit
      when mtyp.GoodsMovementType is not null
           then ( 0 - MatlStkChangeQtyInBaseUnit )
           else  0
      end as MatlCnsmpnQtyInMatlBaseUnit   
  
}