P_RealTimePCCInspPostedWIP

@AbapCatalog.sqlViewName: 'PRTPCCINSPPSTWIP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
//@EndUserText.label: 'Private view of Event based Posted WIP'


define view P_RealTimePCCInspPostedWIP
  with parameters
    P_FiscalPeriodStartDate    : budat,
    P_FiscalPeriodEndDate      : budat
  as select from I_GLAccountLineItemRawData   as _item
    //inner join   I_Ledger                     as _ledger on  _ledger.Ledger          = _item.Ledger

                                                         //and _ledger.LedgerType      = '' //standard ledger only

{
  key _item.OrderID                           as OrderID,
  key _item.SourceLedger                      as Ledger,
  
      sum(_item.AmountInCompanyCodeCurrency)  as AmountInCompanyCodeCurrency,
      sum(_item.AmountInGlobalCurrency)       as AmountInGlobalCurrency,
      sum(_item.AmountInFreeDefinedCurrency1) as AmountInFreeDefinedCurrency1,
      sum(_item.AmountInFreeDefinedCurrency2) as AmountInFreeDefinedCurrency2,
      sum(_item.AmountInFreeDefinedCurrency3) as AmountInFreeDefinedCurrency3,
      sum(_item.AmountInFreeDefinedCurrency4) as AmountInFreeDefinedCurrency4,
      sum(_item.AmountInFreeDefinedCurrency5) as AmountInFreeDefinedCurrency5,
      sum(_item.AmountInFreeDefinedCurrency6) as AmountInFreeDefinedCurrency6,
      sum(_item.AmountInFreeDefinedCurrency7) as AmountInFreeDefinedCurrency7,
      sum(_item.AmountInFreeDefinedCurrency8) as AmountInFreeDefinedCurrency8,  
      
      max(_item.PostingDate)                  as PostingDate,      

      /////////////////////////////////////////////////////////////////////////////////////

      // Period Amount Fields

      /////////////////////////////////////////////////////////////////////////////////////

      sum(case
            when (_item.PostingDate >= $parameters.P_FiscalPeriodStartDate and _item.PostingDate <= $parameters.P_FiscalPeriodEndDate) then
                _item.AmountInCompanyCodeCurrency
            else 0 end) as PeriodAmountInCompanyCodeCrcy,
      sum(case
            when (_item.PostingDate >= $parameters.P_FiscalPeriodStartDate and _item.PostingDate <= $parameters.P_FiscalPeriodEndDate) then
                _item.AmountInGlobalCurrency
            else 0 end) as PeriodAmountInGlobalCurrency,
      sum(case
            when (_item.PostingDate >= $parameters.P_FiscalPeriodStartDate and _item.PostingDate <= $parameters.P_FiscalPeriodEndDate) then
                _item.AmountInFreeDefinedCurrency1
            else 0 end) as PeriodAmountInFreeDfndCrcy1,
      sum(case
            when (_item.PostingDate >= $parameters.P_FiscalPeriodStartDate and _item.PostingDate <= $parameters.P_FiscalPeriodEndDate) then
                _item.AmountInFreeDefinedCurrency2
            else 0 end) as PeriodAmountInFreeDfndCrcy2,
      sum(case
            when (_item.PostingDate >= $parameters.P_FiscalPeriodStartDate and _item.PostingDate <= $parameters.P_FiscalPeriodEndDate) then
                _item.AmountInFreeDefinedCurrency3
            else 0 end) as PeriodAmountInFreeDfndCrcy3,
      sum(case
            when (_item.PostingDate >= $parameters.P_FiscalPeriodStartDate and _item.PostingDate <= $parameters.P_FiscalPeriodEndDate) then
                _item.AmountInFreeDefinedCurrency4
            else 0 end) as PeriodAmountInFreeDfndCrcy4,
      sum(case
            when (_item.PostingDate >= $parameters.P_FiscalPeriodStartDate and _item.PostingDate <= $parameters.P_FiscalPeriodEndDate) then
                _item.AmountInFreeDefinedCurrency5
            else 0 end) as PeriodAmountInFreeDfndCrcy5,
      sum(case
            when (_item.PostingDate >= $parameters.P_FiscalPeriodStartDate and _item.PostingDate <= $parameters.P_FiscalPeriodEndDate) then
                _item.AmountInFreeDefinedCurrency6
            else 0 end) as PeriodAmountInFreeDfndCrcy6,
      sum(case
            when (_item.PostingDate >= $parameters.P_FiscalPeriodStartDate and _item.PostingDate <= $parameters.P_FiscalPeriodEndDate) then
                _item.AmountInFreeDefinedCurrency7
            else 0 end) as PeriodAmountInFreeDfndCrcy7,
      sum(case
            when (_item.PostingDate >= $parameters.P_FiscalPeriodStartDate and _item.PostingDate <= $parameters.P_FiscalPeriodEndDate) then
                _item.AmountInFreeDefinedCurrency8
            else 0 end) as PeriodAmountInFreeDfndCrcy8
            
}
where
  (    _item.BusinessTransactionCategory  = 'KOAE' 
    or _item.BusinessTransactionCategory  = 'EBWP' 
  )
  and _item.ReferenceDocumentType = 'EBWI'
  and _item.OriginObjectType = '23'
  and _item.PostingDate      >= $parameters.P_FiscalPeriodStartDate
  and _item.PostingDate      <= $parameters.P_FiscalPeriodEndDate
  and _item.OrderCategory    = '05'
  and _item.SubLedgerAcctLineItemType = '09100'
group by
  _item.OrderID,
  _item.SourceLedger