C_TaxReconcilAccountQry

DDL: C_TAXRECONCILACCOUNTQRY SQL: CTAXRECONCIL Type: view CONSUMPTION
34 Fields 1 Data Sources 2 Associations

Account Tax Reconciliation

C_TaxReconcilAccountQry is a Consumption CDS View that provides data about "Account Tax Reconciliation" in SAP S/4HANA. It reads from 1 data source (I_TaxReconciliationAccountCube) and exposes 34 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, TaxCode. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_TaxReconciliationAccountCube I_TaxReconciliationAccountCube from

Associations (2)

CardinalityTargetAliasCondition
[1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1] I_TaxCode _TaxCode $projection.TaxCode = _TaxCode.TaxCode and $projection.TaxCalculationProcedure = _TaxCode.TaxCalculationProcedure

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CTAXRECONCIL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.auditFilter #ENABLED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
EndUserText.label Account Tax Reconciliation view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.typeName Item view
UI.headerInfo.typeNamePlural Items view
UI.textArrangement #TEXT_LAST view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
KEY TaxCode TaxCode Tax Code
KEY TaxCountry TaxCountry Tax Ctry/Reg.
KEY TransactionTypeDetermination TransactionTypeDetermination Transaction Key
KEY TaxRateValidityStartDate TaxRateValidityStartDate Tax Rate Validity Start Date
TaxCodeName
DocumentType DocumentType Order Type
CompanyCodeName CompanyCodeName Company Name
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
GLAccount GLAccount General Ledger
PostingFiscalPeriod PostingFiscalPeriod Period
TaxRate TaxRate Tax Rate
CompanyCodeCurrency CompanyCodeCurrency Local Currency
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxRecnclnAmtInCoCodeCrcy
CalculatedTxAmtInCoCodeCrcy CalculatedTxAmtInCoCodeCrcy
TaxRecnclnDiffAmtInCoCodeCrcy
OriginalTaxBaseAmount OriginalTaxBaseAmount
CorporateGroupAccount CorporateGroupAccount Group Account Number
AlternativeGLAccount AlternativeGLAccount Group Account
SubTotalAmountInCoCodeCrcy SubTotalAmountInCoCodeCrcy
CashDiscount1Percent CashDiscount1Percent Disc. Percent 1
TaxCalculationProcedure I_TaxReconciliationAccountCube TaxCalculationProcedure Tax Procedure
AuthorizationGroup AuthorizationGroup AuthorizGroup
ProfitCenter ProfitCenter Profit Center
BusinessPlace Business place
_CompanyCode _CompanyCode
_GLAccountInCompanyCode _GLAccountInCompanyCode
_TaxCode _TaxCode
_TaxCalculationProcedure _TaxCalculationProcedure

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]
;

Learn More