I_TaxReconciliation

DDL: I_TAXRECONCILIATION Type: view_entity BASIC
26 Fields 1 Data Sources

Tax Reconciliation

I_TaxReconciliation is a Basic CDS View that provides data about "Tax Reconciliation" in SAP S/4HANA. It reads from 1 data source (fot_recon) and exposes 26 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxCode, TaxCountry.

Data Sources (1)

SourceAliasJoin Type
fot_recon fot_recon from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Tax Reconciliation view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs Value
KEY AccountingDocument belnr SD Document
KEY FiscalYear gjahr Settlement Year
KEY TaxCode mwskz Tax Code
KEY TaxCountry tax_country Tax Ctry/Rgn
KEY TaxRateValidityStartDate txdat_from Tax Rate Valid-From
KEY AccountingDocumentItem buzei Posting View Item
KEY TransactionTypeDetermination ktosl Transaction
TaxBaseAmountInCoCodeCrcy dmbtr Loc. amount
OriginalTaxBaseAmount txbhw Original Tax Base Amount
CalculatedTxAmtInCoCodeCrcy calculated Rating Calculated
SubTotalAmountInCoCodeCrcy subtotal
TaxRecnclnAmtInCoCodeCrcy posted Postings exist
TaxAmountInCoCodeCrcy hwste LC Tax
TaxRate Tax Rate
GLAccount hkont Transfer acct
AlternativeGLAccount lokkt Local Acct No.
CorporateGroupAccount altkt Group Account Number
ProfitCenter prctr Profit Centers
BusinessPlace bupla Business place
PostingFiscalPeriod h_monat Period
AccountingDocumentType Document Type
PostingDate h_budat Posting Date
DocumentDate h_bldat Document Date
CompanyCodeCurrency h_hwaer Local Currency
CashDiscount1Percent zbd1p Max. Cash Dis. (%)

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_TaxReconciliation.
-- 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.

CREATE VIEW I_TaxReconciliation AS
SELECT
  bukrs AS CompanyCode,
  belnr AS AccountingDocument,
  gjahr AS FiscalYear,
  mwskz AS TaxCode,
  tax_country AS TaxCountry,
  txdat_from AS TaxRateValidityStartDate,
  buzei AS AccountingDocumentItem,
  ktosl AS TransactionTypeDetermination,
  dmbtr AS TaxBaseAmountInCoCodeCrcy,
  txbhw AS OriginalTaxBaseAmount,
  calculated AS CalculatedTxAmtInCoCodeCrcy,
  subtotal AS SubTotalAmountInCoCodeCrcy,
  posted AS TaxRecnclnAmtInCoCodeCrcy,
  hwste AS TaxAmountInCoCodeCrcy,
  cast ( kbetr as fitaxrate ) AS TaxRate,
  hkont AS GLAccount,
  lokkt AS AlternativeGLAccount,
  altkt AS CorporateGroupAccount,
  prctr AS ProfitCenter,
  bupla AS BusinessPlace,
  h_monat AS PostingFiscalPeriod,
  cast (h_blart as fis_blart) AS AccountingDocumentType,
  h_budat AS PostingDate,
  h_bldat AS DocumentDate,
  h_hwaer AS CompanyCodeCurrency,
  zbd1p AS CashDiscount1Percent
FROM fot_recon
;

Learn More