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 (belnr as fis_belnr) AS AccountingDocument,
  data.mwskz AS TaxCode,
  data.tax_country AS TaxCountry,
  txdat_from AS TaxRateValidityStartDate,
  gjahr AS FiscalYear,
  ktosl AS TransactionTypeDetermination,
  buzei AS AccountingDocumentItem,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast (dmbtr as dmbtr_shl) AS TaxBaseAmountInCoCodeCrcy,
  cast (txbhw as txbfw_shl) AS OriginalTaxBaseAmount,
  cast (round(calculated,2) as fot_tax_recon_amt) AS CalculatedTxAmtInCoCodeCrcy,
  cast (cast (posted as abap.curr(23,2)) as fot_tax_recon_posted_tax_amt) AS TaxRecnclnAmtInCoCodeCrcy,
  cast (division(kbetr,10,3) as kbetr_tax) AS TaxRate,
  hkont AS GLAccount,
  lokkt AS AlternativeGLAccount,
  altkt AS CorporateGroupAccount,
  prctr AS ProfitCenter,
  bupla AS BusinessPlace,
  cast (h_blart as fis_blart) AS DocumentType,
  h_monat AS PostingFiscalPeriod,
  h_budat AS PostingDate,
  cast (h_bldat as fis_bldat) AS DocumentDate,
  h_hwaer AS CompanyCodeCurrency,
  cast (subtotal as fot_tax_recon_subtotal_amt) AS SubTotalAmountInCoCodeCrcy,
  cast (zbd1p as dzbd1p_farp) AS CashDiscount1Percent,
  _CompanyCode._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  _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_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
;