I_RO_SAFTPurInvoiceTaxAmount

@AbapCatalog.sqlViewName: 'IROSAFTPUTAXAMT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'RO SAFT Purchase Invoice Tax Amount'
define view I_RO_SAFTPurInvoiceTaxAmount as select from bset as _TaxData
  inner join t001 as _Country on _Country.bukrs = _TaxData.bukrs
  inner join t005 as _Procedure on _Procedure.land1 = _Country.land1
  join bkpf as _AccountingDocument
    on  _TaxData.bukrs = _AccountingDocument.bukrs 
    and _TaxData.belnr = _AccountingDocument.belnr 
    and _TaxData.gjahr = _AccountingDocument.gjahr    
        {
    _TaxData.bukrs as CompanyCode,
    _TaxData.belnr as AccountingDocument,
    _TaxData.gjahr as FiscalYear,
    _TaxData.buzei as AccountingDocumentItem,
    
    _TaxData.hwste as TotalVATAmtInCoCodeCrcy,
    _AccountingDocument.waers as TransactionCurrency,
    _TaxData.fwste as TaxAmountInDocCry,
    _TaxData.ktosl as TransactionTypeDetermination,
    _TaxData.mwskz as TaxCode,
    _Country.land1 as CountryCode,
    _Procedure.kalsm as PricingProcedure,
//    bkpf.kursf as ExchangeRate

   cast(round(_AccountingDocument.kursf, 4) as saft_ro_exchange_rate) as ExchangeRate
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BKPF",
"BSET",
"T001",
"T005"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/