I_TransactionalTaxItemCube

Transactional Tax Items Cube | view: ITRNSTXITMCUBE | TRAN | Extraction: Not supported | Component: Transactional Tax Operations
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxLineItemNumber Number of Line Item within Tax Register
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Company Code Currency
TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
TaxBaseAmountInTransCrcy Tax Base Amount in Transaction Currency
TaxAmountInTransCrcy Tax Amount in Transaction Currency
💲 Tax Reporting Currency (ReportingCurrency):
TaxBaseAmountInRptgCrcy Tax Base Amount in Reporting Currency
TaxAmountInRptgCrcy Tax Amount in Reporting Currency
Column Name Description
Column Name Description
PostingDate Posting Date in the Document
DocumentDate Document Date in Document
TaxFulfillmentDate Tax Fulfillment Date
TaxReportingDate Tax Reporting Date
TaxRateValidityStartDate Valid-From Date of the Tax Rate
TaxReportingCurrencyCnvrsnDate Currency Exchange Date
ClearingDate Clearing Date
Column Name Description
TransactionalTaxationType Taxation Type Show values
DebitCreditCode Debit/Credit Indicator Show values
TaxDueCategory Due Category of TaxItem Show values
TaxLineItemStatus Line Item Status Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
TaxEntityType Tax Entity Type Show values
TaxIsNotDeductible Indicator: Tax not deductible Show values
TaxType Tax Type Show values
TaxLineItemPayableStatus Tax Line Item Payable Status Show values
Criticality Criticality Show values
Column Name Description Domain name
SourceReferenceDocumentType Source Document Type AWTYP
SourceLogicalSystem Source Document System LOGSYS
SourceReferenceDocumentCntxt Organizational Unit of Source Document AWORG
SuccessorReferenceDocument Source Document Number AWREF
SourceReferenceDocumentItem Line Item in Source Document NUMC6
TransactionTypeDetermination Transaction Key CHAR3
AccountingDocumentType Document Type BLART
AccountingDocumentItem Number of Line Item Within Accounting Document BUZEI
TaxRateInPercent Tax Rate TXRG_RATE
BusinessPartner Business Partner Number BU_PARTNER
TaxItemGroup Group Indicator for Tax Line Items NUM03
TaxItemAcctgDocItemRef Tax document item number NUM6
TaxExemptionRateInPercent Exemption Rate TXRG_RATE
TaxExemptionReason Exemption Reason TXRG_EXMP_REASON
TaxExemptionNumber Exemption Number CHAR25
TaxExchangeRate Exchange Rate FIS_UKURS
ClearingDocumentNumber Document Number of the Clearing Document BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Document GJAHR
TaxPayableDocument Tax Payable Document Number TXRG_TAXPYBL_DOCN
TaxPayableDocumentFiscalYear Tax payable Fiscal Year GJAHR
TaxPayableDocumentItem Item number in the payable document TXRG_BUZEI
BusinessPartnerTaxNumber Business Partner Tax Number BPTAXNUMXL
AdditionalTaxReportingEntity Additional Tax Reporting Entity TXRG_ADDL_TAX_ENTITY
AdditionalTaxEntityTypeDesc Name TEXT30
BusinessPlace Business Place J_1BBRANCH
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • I_TRANSACTIONALTAXITEMCUBE.MANDT == T001.MANDT
  • I_TRANSACTIONALTAXITEMCUBE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Company Code Currency
  • Client
  • I_TRANSACTIONALTAXITEMCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • I_TRANSACTIONALTAXITEMCUBE.MANDT == TCURC.MANDT
Condition Type
  • Client
  • ?
  • ?
  • Condition Type
  • I_TRANSACTIONALTAXITEMCUBE.MANDT == T685.MANDT
  • I_TRANSACTIONALTAXITEMCUBE.[column in domain "KAPPL"] == T685.KAPPL
  • I_TRANSACTIONALTAXITEMCUBE.[column in domain "KVEWE"] == T685.KVEWE
  • I_TRANSACTIONALTAXITEMCUBE.CONDITIONTYPE == T685.KSCHL
Customer Number
  • Client
  • Customer Number
  • I_TRANSACTIONALTAXITEMCUBE.MANDT == KNA1.MANDT
  • I_TRANSACTIONALTAXITEMCUBE.CUSTOMER == KNA1.KUNNR
Country/Region of Destination for Delivery of Goods
  • Client
  • Country/Region of Destination for Delivery of Goods
  • I_TRANSACTIONALTAXITEMCUBE.MANDT == T005.MANDT
  • I_TRANSACTIONALTAXITEMCUBE.DESTINATIONCOUNTRY == T005.LAND1
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • I_TRANSACTIONALTAXITEMCUBE.EXCHANGERATETYPE == TCURV.KURST
  • I_TRANSACTIONALTAXITEMCUBE.MANDT == TCURV.MANDT
G/L Account
  • Client
  • G/L Account
  • ?
  • I_TRANSACTIONALTAXITEMCUBE.MANDT == SKA1.MANDT
  • I_TRANSACTIONALTAXITEMCUBE.GLACCOUNT == SKA1.SAKNR
  • I_TRANSACTIONALTAXITEMCUBE.[column in domain "KTOPL"] == SKA1.KTOPL
Tax Reporting Currency
  • Client
  • Tax Reporting Currency
  • I_TRANSACTIONALTAXITEMCUBE.MANDT == TCURC.MANDT
  • I_TRANSACTIONALTAXITEMCUBE.REPORTINGCURRENCY == TCURC.WAERS
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • I_TRANSACTIONALTAXITEMCUBE.SUPPLIER == LFA1.LIFNR
  • I_TRANSACTIONALTAXITEMCUBE.MANDT == LFA1.MANDT
Supplying Country/Region for Delivery of Goods
  • Client
  • Supplying Country/Region for Delivery of Goods
  • I_TRANSACTIONALTAXITEMCUBE.MANDT == T005.MANDT
  • I_TRANSACTIONALTAXITEMCUBE.SUPPLYINGCOUNTRY == T005.LAND1
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • ?
  • ?
  • I_TRANSACTIONALTAXITEMCUBE.TAXCALCULATIONPROCEDURE == T683.KALSM
  • I_TRANSACTIONALTAXITEMCUBE.MANDT == T683.MANDT
  • I_TRANSACTIONALTAXITEMCUBE.[column in domain "KVEWE"] == T683.KVEWE
  • I_TRANSACTIONALTAXITEMCUBE.[column in domain "KAPPL"] == T683.KAPPL
Tax on sales/purchases code
  • Tax on sales/purchases code
  • Client
  • ?
  • I_TRANSACTIONALTAXITEMCUBE.TAXCODE == T007A.MWSKZ
  • I_TRANSACTIONALTAXITEMCUBE.MANDT == T007A.MANDT
  • I_TRANSACTIONALTAXITEMCUBE.[column in domain "KALSM_D"] == T007A.KALSM
Tax Reporting Country/Region
  • Tax Reporting Country/Region
  • Client
  • I_TRANSACTIONALTAXITEMCUBE.TAXCOUNTRY == T005.LAND1
  • I_TRANSACTIONALTAXITEMCUBE.MANDT == T005.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • I_TRANSACTIONALTAXITEMCUBE.MANDT == TCURC.MANDT
  • I_TRANSACTIONALTAXITEMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS