P_ES_TaxReturnBoxATR

@AbapCatalog.sqlViewName: 'PESTAXRETBOXATR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@AbapCatalog.preserveKey: true

define view P_ES_TaxReturnBoxATR
  with parameters
    P_StatryRptgEntity  : srf_reporting_entity,
    P_StatryRptCategory : srf_rep_cat_id,
    P_StatryRptRunID    : srf_report_run_id,
    P_ReportingCountry  : land1
  as select from    I_StRpTaxReturnBoxCube( P_TaxIsDeferredRelevant : 'N',
                                            P_TaxIsMossRelevant     : 'N',
                                            P_StatryRptgEntity      : $parameters.P_StatryRptgEntity ,
                                            P_StatryRptCategory     : $parameters.P_StatryRptCategory,
                                            P_StatryRptRunID        : $parameters.P_StatryRptRunID,
                                            P_ReportingCountry      : $parameters.P_ReportingCountry,
                                            P_TaxBoxConfiguration   : '2' // 1 = T007* 2 = VG_CUST 3 = T007* and VG_CUST

                                           )
    left outer join P_T007B_GLO                                                    on P_T007B_GLO.ktosl = I_StRpTaxReturnBoxCube.TransactionTypeDetermination
{
  key I_StRpTaxReturnBoxCube.CompanyCode,
  key AccountingDocument,
  key FiscalYear,
  key TaxItem,

  key I_StRpTaxReturnBoxCube.TaxCode,
  key I_StRpTaxReturnBoxCube.TransactionTypeDetermination,
  key TaxBox,
  key TaxGroup,
  key I_StRpTaxReturnBoxCube.Country,
  key I_StRpTaxReturnBoxCube.TaxDeclnAmountType,
  key I_StRpTaxReturnBoxCube.UnifiedTaxBoxStructureType,
  key ValidFrom,

  key StatryRptgEntity,
  key StatryRptCategory,
  key StatryRptRunID,
  
      I_StRpTaxReturnBoxCube.StatryRptRun,

      TaxItemGroupingVersion,
      TaxBoxStructureType,
      ValidTo,
      I_StRpTaxReturnBoxCube.DebitCreditCode,
      TaxCalculationProcedure,
      TaxRate,

      I_StRpTaxReturnBoxCube.TaxRateValidityStartDate,
      GLAccount,
      TaxItemGroup,
      BusinessPlace,
      TaxJurisdiction,
      LowestLevelTaxJurisdiction,
      I_StRpTaxReturnBoxCube.AccountingDocumentType,
      ReferenceDocumentType,
      I_StRpTaxReturnBoxCube.CAReconciliationKey,
      ReverseDocument,
      ReverseDocumentFiscalYear,
      DocumentReferenceID,
      Ledger,
      LedgerGroup,
      PostingDate,
      DocumentDate,
      TaxReportingDate,
      ReportingDate,

      TaxType,
      IsReversal,
      IsReversed,

      FiscalPeriod,
      ExchangeRate,
      AccountingDocumentHeaderText,
      CompanyCodeCountry,
      ReportingCountry,
      TaxReturnCountry,

      CompanyCodeCurrency,
      CountryCurrency,
      DocumentCurrency,
      ReportingCurrency,
      AdditionalCurrency1,
      AdditionalCurrency2,

      @Semantics.amount.currencyCode: 'ReportingCurrency'
      case P_T007B_GLO.stgrp
        when '2' then AmountInReportingCurrency
        else -AmountInReportingCurrency
      end as AmountInReportingCurrency,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      case P_T007B_GLO.stgrp
        when '2' then AmountInTransactionCurrency
        else -AmountInTransactionCurrency
      end as AmountInTransactionCurrency,

      @Semantics.amount.currencyCode: 'ReportingCurrency'
      case P_T007B_GLO.stgrp
        when '2' then TaxBaseAmountInRptgCrcy
        else -TaxBaseAmountInRptgCrcy
      end as TaxBaseAmountInRptgCrcy,
      @Semantics.amount.currencyCode: 'ReportingCurrency'
      case P_T007B_GLO.stgrp
        when '2' then TaxAmountInRptgCrcy
        else -TaxAmountInRptgCrcy
      end as TaxAmountInRptgCrcy,

      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      case P_T007B_GLO.stgrp
        when '2' then TaxBaseAmountInCoCodeCrcy
        else -TaxBaseAmountInCoCodeCrcy
      end as TaxBaseAmountInCoCodeCrcy,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      case P_T007B_GLO.stgrp
        when '2' then TaxAmountInCoCodeCrcy
        else -TaxAmountInCoCodeCrcy
      end as TaxAmountInCoCodeCrcy,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      case P_T007B_GLO.stgrp
        when '2' then TaxBaseAmountInTransCrcy
        else -TaxBaseAmountInTransCrcy
      end as TaxBaseAmountInTransCrcy,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      case P_T007B_GLO.stgrp
        when '2' then TaxAmount
        else -TaxAmount
      end as TaxAmount,

      @Semantics.amount.currencyCode: 'CountryCurrency'
      case P_T007B_GLO.stgrp
        when '2' then TaxBaseAmountInCountryCrcy
        else -TaxBaseAmountInCountryCrcy
      end as TaxBaseAmountInCountryCrcy,
      @Semantics.amount.currencyCode: 'CountryCurrency'
      case P_T007B_GLO.stgrp
        when '2' then TaxAmountInCountryCrcy
        else -TaxAmountInCountryCrcy
      end as TaxAmountInCountryCrcy,

      @Semantics.amount.currencyCode: 'AdditionalCurrency1'
      case P_T007B_GLO.stgrp
        when '2' then TaxBaseAmtInAdditionalCrcy1
        else -TaxBaseAmtInAdditionalCrcy1
      end as TaxBaseAmtInAdditionalCrcy1,
      @Semantics.amount.currencyCode: 'AdditionalCurrency1'
      case P_T007B_GLO.stgrp
        when '2' then TaxAmountInAdditionalCurrency1
        else -TaxAmountInAdditionalCurrency1
      end as TaxAmountInAdditionalCurrency1,

      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      case P_T007B_GLO.stgrp
        when '2' then TaxBaseAmtInAdditionalCrcy2
        else -TaxBaseAmtInAdditionalCrcy2
      end as TaxBaseAmtInAdditionalCrcy2,
      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      case P_T007B_GLO.stgrp
        when '2' then TaxAmountInAdditionalCurrency2
        else -TaxAmountInAdditionalCurrency2
      end as TaxAmountInAdditionalCurrency2,

      TargetTaxCode,
      TaxNumber1,
      TaxNumber2,
      TaxNumber3,

      BusinessPartner,
      BusinessPartnerName,
      I_StRpTaxReturnBoxCube.BusinessPartnerCountry,
      CustomerSupplierAddress,
      TaxIsNotDeductible,

      TaxBoxStructure,
      TaxBoxName,
      TaxBoxAggregationOperation,
      I_StRpTaxReturnBoxCube.TaxCountry
}
where
  IsVATRelevant = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STRPTAXRETURNBOXCUBE",
"P_T007B_GLO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/