P_SlowMovingMaterialGroup

@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PSLOWNOMOMATGP'
@AbapCatalog.compiler.compareFilter: 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

define view P_SlowMovingMaterialGroup
  with parameters
    P_KeyDate                   : abap.dats,
    P_InventoryConsumptionGroup : inventory_consumption_group

  as select from I_MaterialDocumentRecord
{
  key StockIdentifyingMaterial  as Material,
  key Plant,
  key StockIdfgStorageLocation  as StorageLocation,
  key StockIdentifyingBatch,
  key SpecialStockIdfgSupplier,
  key SpecialStockIdfgSalesOrder,
  key SpecialStockIdfgSalesOrderItem,
  key SpecialStockIdfgWBSElement,
  key SpecialStockIdfgCustomer,
  key SpecialStockIdfgStockOwner,
  key InventorySpecialStockType,
  key InventoryStockType,
  key MaterialBaseUnit,
  key CompanyCodeCurrency as Currency,

      MatlStkChangeQtyInBaseUnit,
      MatlCnsmpnQtyInMatlBaseUnit,
      GoodsMovementType,
      PostingDate,
      dats_days_between(PostingDate,$parameters.P_KeyDate) as DaysBeforeKeydate,
      $parameters.P_InventoryConsumptionGroup as InventoryConsumptionGroup
 }

where  PostingDate <= $parameters.P_KeyDate and                  //2940195

       MaterialDocumentRecordType = 'MDOC'                       //2940195


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIALDOCUMENTRECORD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/