P_LU_SAFTTaxRatioCalculation

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_LU_SAFTTaxRatioCalculation.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PLUSAFTTAXRATCAL

CREATE VIEW P_LU_SAFTTaxRatioCalculation AS
SELECT
  JournalEntryItem.CompanyCode AS CompanyCode,
  JournalEntryItem.FiscalYear AS FiscalYear,
  JournalEntryItem.AccountingDocument AS AccountingDocument,
  JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  JournalEntryItem.Ledger AS Ledger,
  JournalEntryItem.ChartOfAccounts AS ChartOfAccounts,
  JournalEntryItem.PostingDate AS PostingDate,
  JournalEntryItem.FinancialAccountType AS FinancialAccountType,
  JournalEntryItem.GLAccount AS GLAccount,
  JournalEntryItem.DocumentItemText AS DocumentItemText,
  JournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntryItem.TransactionCurrency AS TransactionCurrency,
  case when JournalEntryItem.TransactionTypeDetermination = ' ' and JournalEntryItem.FinancialAccountType = 'S' then JournalEntryItem.TaxCode else ' ' end as TaxCode AS TaxCodeelseendasTaxCode,
  case when JournalEntryItem.TransactionTypeDetermination = ' ' and JournalEntryItem.FinancialAccountType = 'S' then coalesce(division(abs(TaxAmountSum.TaxRate),10,2) , 0) else 0 end as TaxRate AS TaxRate1020else0endasTaxRate,
  case when TaxAmountSum.TaxAmountInCoCodeCrcy is not initial and TaxAmountSum.TaxAmountInCoCodeCrcy is not null and JournalItemTaxSum.TotalGrossAmountInCoCodeCrcy is not initial and JournalItemTaxSum.TotalGrossAmountInCoCodeCrcy is not null and JournalEntryItem.TransactionTypeDetermination = ' ' and JournalEntryItem.FinancialAccountType = 'S' then ( cast( TaxAmountSum.TaxAmountInCoCodeCrcy as abap.fltp) * (cast( abs(JournalEntryItem.AmountInCompanyCodeCurrency) as abap.fltp) / cast( JournalItemTaxSum.TotalGrossAmountInCoCodeCrcy as abap.fltp))) else 0 end as TaxRatioCalculated AS fltpelse0endasTaxRatioCalculated,
  case when TaxAmountSum.TaxBaseAmountInCoCodeCrcy is not initial and TaxAmountSum.TaxBaseAmountInCoCodeCrcy is not null and JournalItemTaxSum.TotalGrossAmountInCoCodeCrcy is not initial and JournalItemTaxSum.TotalGrossAmountInCoCodeCrcy is not null and JournalEntryItem.TransactionTypeDetermination = ' ' and JournalEntryItem.FinancialAccountType = 'S' then ( cast( TaxAmountSum.TaxBaseAmountInCoCodeCrcy as abap.fltp) * (cast( abs(JournalEntryItem.AmountInCompanyCodeCurrency) as abap.fltp) / cast( JournalItemTaxSum.TotalGrossAmountInCoCodeCrcy as abap.fltp))) else 0 end as TaxBaseRatioCalculated AS fltpelse0endasTaxBaseRatioCalculated,
  case when TaxAmountSum.TaxBaseAmountInTransCrcy is not initial and TaxAmountSum.TaxBaseAmountInTransCrcy is not null and JournalItemTaxSum.TotalGrossAmountInTransCrcy is not initial and JournalItemTaxSum.TotalGrossAmountInTransCrcy is not null and JournalEntryItem.TransactionTypeDetermination = ' ' and JournalEntryItem.FinancialAccountType = 'S' then ( cast( TaxAmountSum.TaxBaseAmountInTransCrcy as abap.fltp) * (cast( abs(JournalEntryItem.AmountInTransactionCurrency) as abap.fltp) / cast( JournalItemTaxSum.TotalGrossAmountInTransCrcy as abap.fltp))) else 0 end as TaxBaseRatioCalculatedTC AS fltpelse0endasTaxBaseRatioCalculatedTC,
  cast( abs(round( JournalEntryItem.Quantity, 0)) as abap.int8 ) AS Quantity,
  JournalEntryItem.Customer AS Customer,
  JournalEntryItem.Supplier AS Supplier,
  JournalEntryItem.ExchangeRate AS ExchangeRate,
  ' ' AS CAIsDownPaymentRequest,
  JournalEntryItem.IsReversal AS IsReversal,
  JournalEntryItem.AccountingDocumentItemType AS AccountingDocumentItemType,
  JournalEntryItem.AccountingDocumentType AS AccountingDocumentType,
  JournalEntryItem.AlternativeGLAccount AS AlternativeGLAccount,
  DP.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  DP.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  DP.DebitCreditCode AS DebitCreditCode,
  DP.TaxCode AS TaxCode,
  DP.TaxRate AS TaxRate,
  DP.TaxRatioCalculated AS TaxRatioCalculated,
  DP.TaxRatioCalculatedTransCrcy AS TaxRatioCalculatedTransCrcy,
  DP.TaxBaseRatioCalculated AS TaxBaseRatioCalculated,
  DP.TaxBaseRatioCalculatedTC AS TaxBaseRatioCalculatedTC
FROM I_LU_SAFTJournalEntry AS JournalEntryItem
-- UNION with additional select branch(es): P_LU_SAFTTAXRATIODPCALC
;