P_RealTimePCCInspPostedVarc

@AbapCatalog.sqlViewName: 'PRTPCCINSPPSTVAR'
@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 Variance'


define view P_RealTimePCCInspPostedVarc
  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 = 'EBVP' 
  )
  and _item.ReferenceDocumentType = 'EBWI'
  and _item.OriginObjectType = '04'
  and _item.PostingDate      >= $parameters.P_FiscalPeriodStartDate
  and _item.PostingDate      <= $parameters.P_FiscalPeriodEndDate
  and _item.OrderCategory    = '05'
group by
  _item.OrderID,
  _item.SourceLedger
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTLINEITEMRAWDATA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/