P_PCCOrderOutPutQtyByPeriod

@AbapCatalog.sqlViewName: 'PPCCORDOUTQTY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
//@EndUserText.label: 'PCC: Order Out Put Qty by Period'

@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.private:true
@VDM.viewType: #COMPOSITE
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_PCCOrderOutPutQtyByPeriod
  with parameters
    P_FromFiscalYearPeriod : fis_jahrper,
    P_ToFiscalYearPeriod   : fis_jahrper
  as select from P_ProductCostCtrlgOrderAndItem as _Order
    inner join   I_COActivityTypeTotalsByPeriod as _OrderQty         on _OrderQty.ControllingObject = _Order.ObjectInternalID
    inner join   I_FiscalYearPeriodForCmpnyCode as _FiscalYearPeriod on  _Order.CompanyCode             = _FiscalYearPeriod.CompanyCode
                                                                     and _FiscalYearPeriod.FiscalYear   = _OrderQty.FiscalYear
                                                                     and _FiscalYearPeriod.FiscalPeriod = _OrderQty.FiscalPeriod
{
  key ControllingObject,

      _Order.OrderID,
      _Order.OrderItem,
      _Order.CompanyCode,
      Plant,
      Material,
      SalesOrder,
      SalesOrderItem,

      @Semantics.unitOfMeasure:true
      CostCtrActivityTypeQtyUnit,

      @Semantics: { quantity : {unitOfMeasure: 'CostCtrActivityTypeQtyUnit'} }
      sum( CostCtrActivityTypeQty )              as ActualOutputQuantity,

      max(_FiscalYearPeriod.FiscalPeriodEndDate) as FiscalPeriodEndDate

}
where
      ControllingValueType       =  '04'
  and CostCtrActivityTypeQty     <> 0
  and _OrderQty.FiscalYearPeriod >= $parameters.P_FromFiscalYearPeriod
  and _OrderQty.FiscalYearPeriod <= $parameters.P_ToFiscalYearPeriod

group by
  ControllingObject,
  _Order.OrderID,
  _Order.OrderItem,
  _Order.CompanyCode,
  Plant,
  Material,
  SalesOrder,
  SalesOrderItem,
  CostCtrActivityTypeQtyUnit


//  as select from I_COActivityTypeTotalsByPeriod as _OrdQty

////    left outer to one join P_ProductCostCtrlgOrderAndItem as _Order on _OrdQty.ControllingObject = _Order.ObjectInternalID  //P_ProductCostCtrlgOrderAndItem

//{

//  key ControllingObject,

//  key FiscalYearPeriod,

//  key FiscalYear,

//  key FiscalPeriod,

//

////      _Order.OrderID,

////      _Order.OrderItem,

////      _Order.CompanyCode,

////      _Order.Plant,

////      _Order.Material,

////      _Order.SalesOrder,

////      _Order.SalesOrderItem,

//

////      _Order.TechnicalCompletionDate,

////      _Order.ActualDeliveryDate,

//

//      @Semantics.unitOfMeasure:true

//      CostCtrActivityTypeQtyUnit,

//

//

//      @DefaultAggregation: #SUM

//      @Semantics: { quantity : {unitOfMeasure: 'CostCtrActivityTypeQtyUnit'} }

//      sum(case when ControllingValueType = '01'

//                then CostCtrActivityTypeQty

//               else 0 end ) as PlanOutputQuantity,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { quantity : {unitOfMeasure: 'CostCtrActivityTypeQtyUnit'} }

//      sum(case when ControllingValueType = '04'

//                then CostCtrActivityTypeQty

//               else 0 end)  as ActualOutputQuantity

//

//}

//where

//  (

//    (

//          ControllingValueType =  '04'

//      and FiscalYearPeriod     >= $parameters.P_FromFiscalYearPeriod

//      and FiscalYearPeriod     <= $parameters.P_ToFiscalYearPeriod

//    )

//    or(

//          ControllingValueType =  '01'

//    )

//  )

//group by

//  ControllingObject,

//  FiscalYearPeriod,

//  FiscalYear,

//  FiscalPeriod,

////  _Order.OrderID,

////  _Order.OrderItem,

////  _Order.CompanyCode,

////  _Order.Plant,

////  _Order.Material,

////  _Order.SalesOrder,

////  _Order.SalesOrderItem,

////  _Order.TechnicalCompletionDate,

////  _Order.ActualDeliveryDate,

//  CostCtrActivityTypeQtyUnit

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