P_MY_TDTTAXRATE

@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog: {sqlViewName: 'PMYTDTTAXRATE', preserveKey: true}
@AbapCatalog.compiler.compareFilter: true
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_MY_TDTTAXRATE
  with parameters
    P_TaxIsDeferredRelevant : figen_deferred_check,
    P_TaxIsMossRelevant     : figen_moss_check,
    P_StatryRptgEntity      : srf_reporting_entity,
    P_StatryRptCategory     : srf_rep_cat_id,
    P_StatryRptRunID        : srf_report_run_id,
    P_ReportingCountry      : land1,
    P_TaxBoxConfiguration   : figen_tdt_taxbox_config
  as select from    I_StRpTaxReturnBoxCube(
                               P_TaxIsDeferredRelevant: $parameters.P_TaxIsDeferredRelevant,
                               P_TaxIsMossRelevant    : $parameters.P_TaxIsMossRelevant,
                               P_StatryRptgEntity     : $parameters.P_StatryRptgEntity ,
                               P_StatryRptCategory    : $parameters.P_StatryRptCategory,
                               P_StatryRptRunID       : $parameters.P_StatryRptRunID,
                               P_ReportingCountry     : $parameters.P_ReportingCountry,
                               P_TaxBoxConfiguration  : $parameters.P_TaxBoxConfiguration
                               ) as P_StRpCalTaxReturnBox
    left outer to one join I_AdvancedTaxReportingCountry on I_AdvancedTaxReportingCountry.Country = $parameters.P_ReportingCountry
{
  key  P_StRpCalTaxReturnBox.CompanyCode,
  key  P_StRpCalTaxReturnBox.AccountingDocument,
  key  P_StRpCalTaxReturnBox.FiscalYear,
  key  P_StRpCalTaxReturnBox.TaxItem,
  key  P_StRpCalTaxReturnBox.TransactionTypeDetermination,
  key  P_StRpCalTaxReturnBox.DebitCreditCode,
  key  P_StRpCalTaxReturnBox.AccountingDocumentType,
  key  P_StRpCalTaxReturnBox.SupplierAccountGroup,
  key  P_StRpCalTaxReturnBox.TaxBox,
  key  P_StRpCalTaxReturnBox.TaxDeclnAmountType,
  key  P_StRpCalTaxReturnBox.TaxBoxStrucValidityStartDate,
  key  P_StRpCalTaxReturnBox.UnifiedTaxBoxStructureType,
  key  P_StRpCalTaxReturnBox.TaxGroup,
  key  P_StRpCalTaxReturnBox.TaxItemGrpgDebitCreditCode,
  key  TaxItemGrpgAcctgDocumentType,
  key  TaxItemGrpgSupplierAcctGroup,
  key  P_StRpCalTaxReturnBox.TaxItemGrpgSpecialGLCode,
  key  P_StRpCalTaxReturnBox.StatryRptgEntity,
  key  P_StRpCalTaxReturnBox.StatryRptCategory,
  key  P_StRpCalTaxReturnBox.StatryRptRunID,

       P_StRpCalTaxReturnBox.ValidFrom,

       P_StRpCalTaxReturnBox.Country,
       P_StRpCalTaxReturnBox.TaxCode,
       P_StRpCalTaxReturnBox.TaxItemGroupingVersion,
       P_StRpCalTaxReturnBox.TaxBoxStructureType,

       P_StRpCalTaxReturnBox.ValidTo,
       TaxBoxStrucValidityEndDate,
       TaxCalculationProcedure,

       TaxRate,
       P_StRpCalTaxReturnBox.TaxRateValidityStartDate,
       IPITaxRate,

       case
       when I_AdvancedTaxReportingCountry.Country is null or TaxGroupOperation = ''
        then
        P_StRpCalTaxReturnBox.TaxCodeRatePointer
        else
         division ( cast( cast (TaxGroupFreeClassification as abap.numc( 5 )) as abap.dec(5,2) )  ,100,2)        
        end as TaxCodeRatePointer,
       Customer,
       GLAccount,
       TaxItemGroup,
       BusinessPlace,
       P_StRpCalTaxReturnBox.TaxJurisdiction,
       LowestLevelTaxJurisdiction,
       ReferenceDocumentType,
       AlternativeReferenceDocument,
       ReverseDocument,
       ReverseDocumentFiscalYear,
       ConditionRecord,
       RoundingDecimalPlaces,
       DocumentReferenceID,
       Ledger,
       LedgerGroup,
       PostingDate,
       DocumentDate,
       TaxReportingDate,
       ReportingDate,
       TaxReportingDocumentDate,
       FiscalPeriod,

       ExchangeRate,
       IsReversal,
       IsReversed,
       AccountingDocumentHeaderText,
       CompanyCodeCountry,
       ReportingCountry,
       TaxReturnCountry,
       @Semantics.currencyCode:true
       CompanyCodeCurrency,
       @Semantics.currencyCode:true
       CountryCurrency,
       @Semantics.currencyCode:true
       DocumentCurrency,
       @Semantics.currencyCode:true
       ReportingCurrency,
       @Semantics.currencyCode: true
       AdditionalCurrency1,
       @Semantics.currencyCode: true
       AdditionalCurrency2,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'ReportingCurrency'
       TaxBaseAmountInRptgCrcy,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'ReportingCurrency'
       TaxAmountInRptgCrcy,


       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'ReportingCurrency'

       AmountInReportingCurrency,


       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
       TaxBaseAmountInCoCodeCrcy,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
       TaxAmountInCoCodeCrcy,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'DocumentCurrency'
       TaxBaseAmountInTransCrcy,
       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'DocumentCurrency'
       TaxAmount,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'CountryCurrency'
       TaxBaseAmountInCountryCrcy,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'CountryCurrency'
       TaxAmountInCountryCrcy,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'AdditionalCurrency1'
       TaxBaseAmtInAdditionalCrcy1,
       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'AdditionalCurrency2'
       TaxBaseAmtInAdditionalCrcy2,
       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'AdditionalCurrency1'
       TaxAmountInAdditionalCurrency1,
       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'AdditionalCurrency2'
       TaxAmountInAdditionalCurrency2,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
       DifferenceTaxAmtInCoCodeCrcy,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
       DiffTaxBaseAmountInCoCodeCrcy,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
       TotalGrossAmountInCoCodeCrcy,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'ReportingCurrency'
       TotalGrossAmount,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'DocumentCurrency'
       TotalGrossAmountInTransCrcy,

       TaxType,
       BPTaxNumber,
       ReportingVATRegistration,
       TaxNumber1, //Stock Transfer Scenario is handled


       ShippingPointCountry,

       TargetTaxCode,
       TaxNumber2,
       ActiveTaxType,
       TaxNumber3,
       TaxIsDeferredRelevant,
       TaxIsMossRelevant,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
       CalculatedTxAmtInCoCodeCrcy,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'DocumentCurrency'
       CalculatedTaxAmountInTransCrcy,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'DocumentCurrency'
       CalculatedTxBaseAmtInTransCrcy,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'DocumentCurrency'
       AmountInTransactionCurrency,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
       AmountInCompanyCodeCurrency,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'CompanyCodeCurrency'

       CalcdTxBaseAmtInCoCodeCrcy,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'AdditionalCurrency1'
       AmountInAdditionalCurrency1,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'AdditionalCurrency2'
       AmountInAdditionalCurrency2,



       BusinessPartner,
       CAReconciliationKey,
       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'ReportingCurrency'
       NonDeductibleInputTaxAmount,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'ReportingCurrency'
       DcblVATIncrdCostInRptgCrcy,
       BusinessPartnerName,
       BusinessPartnerCountry,
       TaxTypeName,
       CustomerSupplierAddress,
       P_StRpCalTaxReturnBox.TaxIsNotDeductible,
       SenderCompanyCode,
       SenderAccountingDocument,
       SenderFiscalYear,
       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
       BalanceAmountInTransacCurrency,
       P_StRpCalTaxReturnBox.TaxBoxStructure,
       TaxBoxStructureName,
       P_StRpCalTaxReturnBox.TaxBoxName,
       P_StRpCalTaxReturnBox.TaxBoxCondition,
       P_StRpCalTaxReturnBox.TaxBoxAggregationOperation,
       P_StRpCalTaxReturnBox.TaxGroupOperation,
       ConditionType,

       IsVATRelevant,

       IsNegativePosting,
       P_StRpCalTaxReturnBox.TaxCountry,
       TaxCntryOrCompanyCodeCntry,


       _ReportedItemsLog,
       _ReportingCurrency,
       _OneTimeAccountBP,
       _JournalEntry,
       _AccountingDocument,
       _GLAccount,
       _TaxJurisdiction,
       _DebtorCreditorRblsPyblsItem,
       _ReceivablesPayablesItem,
       _TaxReceivablesPayablesItem,
       _CompanyCodeCountry,
       _TaxTypeText,
       _TaxCodeText

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADVANCEDTAXREPORTINGCOUNTRY",
"I_STRPTAXRETURNBOXCUBE"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENT",
"I_COUNTRY",
"I_CURRENCY",
"I_GLACCOUNT",
"I_JOURNALENTRY",
"I_ONETIMEACCOUNTBP",
"I_OPERATIONALACCTGDOCITEM",
"I_STRPJOURNALENTRYLOG",
"I_TAXCODETEXT",
"I_TAXJURISDICTION",
"I_TAXTYPETEXT"
],
"BASE":
[
"I_STRPTAXRETURNBOXCUBE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/