C_TaxReconcilAccountQry

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 C_TaxReconcilAccountQry.
-- 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: CTAXRECONCIL

CREATE VIEW C_TaxReconcilAccountQry AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  TaxCode,
  TaxCountry,
  TransactionTypeDetermination,
  TaxRateValidityStartDate,
  _TaxCode._Text[1:Language=$session.system_language].TaxCodeName AS TaxCodeName,
  DocumentType,
  CompanyCodeName,
  PostingDate,
  DocumentDate,
  GLAccount,
  PostingFiscalPeriod,
  TaxRate,
  CompanyCodeCurrency,
  TaxBaseAmountInCoCodeCrcy,
  cast (TaxRecnclnAmtInCoCodeCrcy as fot_tax_recon_posted_tax_amt) AS TaxRecnclnAmtInCoCodeCrcy,
  CalculatedTxAmtInCoCodeCrcy,
  cast (TaxRecnclnDiffAmtInCoCodeCrcy as fot_tax_recon_amt_dif) AS TaxRecnclnDiffAmtInCoCodeCrcy,
  OriginalTaxBaseAmount,
  CorporateGroupAccount,
  AlternativeGLAccount,
  SubTotalAmountInCoCodeCrcy,
  CashDiscount1Percent,
  I_TaxReconciliationAccountCube.TaxCalculationProcedure AS TaxCalculationProcedure,
  AuthorizationGroup,
  ProfitCenter,
  cast( BusinessPlace as farp_bupla ) AS BusinessPlace
FROM I_TaxReconciliationAccountCube
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1]
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON TaxCode = _TaxCode.TaxCode AND TaxCalculationProcedure = _TaxCode.TaxCalculationProcedure  -- association [1]
;