I_TaxReconciliationAccountCube

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_TaxReconciliationAccountCube.
-- 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: ITAXRECCUBE

CREATE VIEW I_TaxReconciliationAccountCube AS
SELECT
  data.bukrs AS CompanyCode,
  cast (data.belnr as fis_belnr) AS AccountingDocument,
  data.mwskz AS TaxCode,
  data.tax_country AS TaxCountry,
  data.txdat_from AS TaxRateValidityStartDate,
  data.gjahr AS FiscalYear,
  data.ktosl AS TransactionTypeDetermination,
  data.buzei AS AccountingDocumentItem,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast (data.dmbtr as dmbtr_shl) AS TaxBaseAmountInCoCodeCrcy,
  cast (data.txbhw as txbfw_shl) AS OriginalTaxBaseAmount,
  cast (round(data.calculated,2) as fot_tax_recon_amt) AS CalculatedTxAmtInCoCodeCrcy,
  cast (cast (data.posted as abap.curr(23,2)) as fot_tax_recon_posted_tax_amt) AS TaxRecnclnAmtInCoCodeCrcy,
  cast (division(data.kbetr,10,3) as kbetr_tax) AS TaxRate,
  data.hkont AS GLAccount,
  data.lokkt AS AlternativeGLAccount,
  data.altkt AS CorporateGroupAccount,
  data.prctr AS ProfitCenter,
  data.bupla AS BusinessPlace,
  cast (data.h_blart as fis_blart) AS DocumentType,
  data.h_monat AS PostingFiscalPeriod,
  data.h_budat AS PostingDate,
  cast (data.h_bldat as fis_bldat) AS DocumentDate,
  data.h_hwaer AS CompanyCodeCurrency,
  cast (data.subtotal as fot_tax_recon_subtotal_amt) AS SubTotalAmountInCoCodeCrcy,
  cast (data.zbd1p as dzbd1p_farp) AS CashDiscount1Percent,
  _GLAccountInCompanyCode.AuthorizationGroup AS AuthorizationGroup
FROM P_TaxRecon01 AS data
INNER JOIN R_MigrationStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Country AS _TaxCountry ON _TaxCountry.Country = TaxCountry  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON _GLAccountInCompanyCode.CompanyCode = CompanyCode AND _GLAccountInCompanyCode.GLAccount = GLAccount  -- association [0..1]
LEFT OUTER JOIN I_TaxCalculationProcedure AS _TaxCalculationProcedure ON TaxCalculationProcedure = _TaxCalculationProcedure.TaxCalculationProcedure  -- association [0..1]
-- UNION ALL with additional select branch(es): I_TaxReconciliation
;