C_TaxReconcilAccountQry

Account Tax Reconciliation | view: CTAXRECONCIL | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: BSEGBSETBSEGBSETT001TKA02T005SKB1T007AT007ST001T007BT001
Column Name Description
CompanyCode Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Number of Line Item Within Accounting Document
TaxCode Tax on sales/purchases code
TaxCountry Tax Reporting Country/Region
TransactionTypeDetermination Transaction Key
TaxRateValidityStartDate Valid-From Date of the Tax Rate
Column Name Description
💲 Local Currency (CompanyCodeCurrency):
TaxRate Tax Rate
TaxBaseAmountInCoCodeCrcy Signed Amount in Local Currency (Long)
TaxRecnclnAmtInCoCodeCrcy Tax Reconciliation Posted Tax Amount
CalculatedTxAmtInCoCodeCrcy Tax Reconciliation Calculated Tax Amount
TaxRecnclnDiffAmtInCoCodeCrcy Tax Reconciliation Calculated Tax Amount Difference
OriginalTaxBaseAmount Original Tax Base Amount in Transaction Currency
SubTotalAmountInCoCodeCrcy Subtotal in company code currency
Column Name Description
Column Name Description
TaxRateValidityStartDate Valid-From Date of the Tax Rate
PostingDate Posting Date in the Document
DocumentDate Journal Entry Date
Column Name Description
AcctgDocHasAmountDiff Indicates if the Accounting Document has Amount Difference Show values
Column Name Description Domain name
TaxCodeName Tax Code Name TEXT50
DocumentType Journal Entry Type BLART
CompanyCodeName Name of Company Code or Company TEXT25
GLAccount General Ledger Account SAKNR
PostingFiscalPeriod Fiscal period MONAT
CorporateGroupAccount Group Account Number SAKNR
AlternativeGLAccount Alternative Account Number in Company Code SAKNR
CashDiscount1Percent Cash Discount Percentage 1 PRZ23
AuthorizationGroup Authorization Group BRGRU
ProfitCenter Profit Center PRCTR
BusinessPlace Business Place J_1BBRANCH
Master Data Relations Join Conditions
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • C_TAXRECONCILACCOUNTQRY.[column in domain "KVEWE"] == T683.KVEWE
  • C_TAXRECONCILACCOUNTQRY.[column in domain "KAPPL"] == T683.KAPPL
  • C_TAXRECONCILACCOUNTQRY.TAXCALCULATIONPROCEDURE == T683.KALSM
  • C_TAXRECONCILACCOUNTQRY.MANDT == T683.MANDT