I_PT_SAFTAccountingTax

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 I_PT_SAFTAccountingTax.
-- 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: IPTSAFTACCTAX

CREATE VIEW I_PT_SAFTAccountingTax AS
SELECT
  dig_sign_fi.PortugueseInvoiceNumber AS PortugueseInvoiceNumber,
  taxtable.TaxCode AS TaxCode,
  acctax.FiscalYear AS FiscalYear,
  acctax.AccountingDocument AS AccountingDocument,
  acctax.CompanyCode AS CompanyCode,
  dig_sign_fi.PortugueseInvoiceDate AS InvoiceDate,
  taxtable.TaxType AS TaxType,
  taxtable.TaxReturnCountry AS TaxReturnCountry,
  taxtable.TargetTaxCode AS TargetTaxCode,
  taxtable.TaxCodeDescription AS TaxCodeDescription,
  taxtable.EndDate AS EndDate,
  taxtable.ExemptionReason AS ExemptionReason,
  taxtable.ExemptionReasonText AS ExemptionReasonText,
  acctax.CompanyCodeCurrency AS CompanyCodeCurrency,
  ( case when taxtable.TaxType = 'IVA' and acctax.TaxRate is not initial then acctax.TaxRate when taxtable.TaxType = 'IS' and taxtable.TaxAmount is initial then acctax.TaxRate else 0 end ) as TaxRate AS TaxRateelse0endasTaxRate,
  ( case when taxtable.TaxType = 'IS' and acctax.TaxRate is not initial then taxtable.TaxAmount else 0 end ) as TaxAmount AS TaxAmountelse0endasTaxAmount
INNER JOIN I_PT_AcctgDocDgtlSgntr AS dig_sign_fi ON /* join condition not captured in parsed metadata */
INNER JOIN I_PT_SAFTTax AS taxtable ON /* join condition not captured in parsed metadata */
;