P_PL_SAFTMapTaxCode

@AbapCatalog.sqlViewName: 'PPLSAFTMAPTXCD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #X
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_PL_SAFTMapTaxCode
  as select from I_JournalEntry            as Entry
    inner join   I_OperationalAcctgDocItem as Item on  Item.CompanyCode          =  Entry.CompanyCode
                                                   and Item.AccountingDocument   =  Entry.AccountingDocument
                                                   and Item.FiscalYear           =  Entry.FiscalYear
                                                   and Item.FinancialAccountType <> 'D'
                                                   
    inner join   P_PL_SAFTINVOICETAXD       as Tax  on  Tax.CompanyCode        = Item.CompanyCode
                                                   and Tax.AccountingDocument = Item.AccountingDocument
                                                   and Tax.FiscalYear         = Item.FiscalYear
                                                   and Tax.TaxCode            = Item.TaxCode

{
  key Entry.CompanyCode,
  key Entry.AccountingDocument,
  key Entry.FiscalYear,
      
      sum(AmountInTransactionCurrency) as AmountInTransactionCurrency,
      sum(AmountInCompanyCodeCurrency) as AmountInCompanyCodeCurrency
      
//      Tax.PL_SAFTTaxPercentageCode

}
group by
  Entry.CompanyCode,
  Entry.AccountingDocument,
  Entry.FiscalYear
//  Tax.PL_SAFTTaxPercentageCode