TAX_ITEM

Tax Register Persistency | #transactional | Component: Transactional Tax Operations
Column Name Description
RCLNT FK Client
RBUKRS FK Company Code
BELNR Document Number of an Accounting Document
GJAHR Fiscal Year
TAXRG_DOCLN Number of Line Item within Tax Register
Column Name Description
💲 Company Code Currency (COMPANY_CODE_CURRENCY):
BASE_AMT_CO_CRCY Tax Base Amount in Company Code Currency
TAX_AMT_CO_CRCY Tax Amount in Company Code Currency
💲 Transaction Currency (TRANSACTION_CURRENCY):
BASE_AMT_TRANS_CRCY Tax Base Amount in Transaction Currency
TAX_AMT_TRANS_CRCY Tax Amount in Transaction Currency
💲 Tax Reporting Currency (REPORTING_CURRENCY):
BASE_AMT_RPTG_CRCY Tax Base Amount in Reporting Currency
TAX_AMT_RPTG_CRCY Tax Amount in Reporting Currency
Column Name Description
Column Name Description
BUDAT Posting Date in the Document
BLDAT Document Date in Document
FULFILLDATE Tax Fulfillment Date
TAX_REPORTING_DATE Tax Reporting Date
TXDAT_FROM Valid-From Date of the Tax Rate
CURRENCY_EXCHANGE_DATE Currency Exchange Date
AUGDT Clearing Date
Column Name Description
TAXATION_TYPE Taxation Type Show values
DRCRK Debit/Credit Indicator Show values
DUE_CATEGORY Due Category of TaxItem Show values
LINE_ITEM_STATUS Line Item Status Show values
XDEFERRED_TAX Indicator: Deferred Tax Show values
XREVERSING Indicator: Item is Reversing Another Item Show values
XREVERSED Indicator: Item is Reversed Show values
XTAX_AMT_MODIFD Indicator: Tax Amount Modified Show values
XBASE_AMT_MODIFD Indicator: Tax Base Amount Modified Show values
ADDITIONAL_TAX_ENTITY_TYPE Tax Entity Type Show values
XREVERSE_CHARGED indicator: Is Reverse Charged? Show values
POSTING_INDICATOR Posting indicator Show values
XNONDEDUCTIBLE_TAX Indicator: Tax not deductible Show values
MWART Tax Type Show values
Column Name Description Domain name
TAXATION_REGIME Tax Regime TXRG_TXN_REGIME
DEF_TAX_DOC_NMBR Deferred Tax Document Number BELNR
DEF_TAX_DOC_FY Fiscal Year of Deferred Tax Document GJAHR
DEF_TAX_ITEM Deferred Tax Document Item Number NUM6
SRC_AWTYP Source Document Type AWTYP
SRC_AWSYS Source Document System LOGSYS
SRC_AWORG Organizational Unit of Source Document AWORG
SRC_AWREF Source Document Number AWREF
SRC_AWITEM Line Item in Source Document NUMC6
KTOSL Transaction Key CHAR3
BLART Document Type BLART
BUZEI Number of Line Item Within Accounting Document BUZEI
TAX_RATE Tax Rate TXRG_RATE
TAX_GROUP Group Indicator for Tax Line Items NUM03
TAX_POSITION Tax document item number NUM6
EXEMPTION_RATE Exemption Rate TXRG_RATE
EXEMPTION_REASON Exemption Reason TXRG_EXMP_REASON
EXEMPTION_NUMBER Exemption Number CHAR25
EXCHANGE_RATE Exchange Rate UKURS
AUGBL Document Number of the Clearing Document BELNR
AUGGJ Fiscal Year of Clearing Document GJAHR
TAX_PYBL_DOC_NMBR Tax Payable Document Number TXRG_TAXPYBL_DOCN
TAX_PYBL_FISCAL_YEAR Tax payable Fiscal Year GJAHR
TAX_PYBL_ITEM_NMBR Item number in the payable document TXRG_BUZEI
BP_TAXNUM Business Partner Tax Number BPTAXNUMXL
ADDITIONAL_TAX_ENTITY Additional Tax Reporting Entity TXRG_ADDL_TAX_ENTITY
Master Data Relations Join Conditions
Company Code Currency
  • TAX_ITEM.RCLNT == TCURC.MANDT
  • TAX_ITEM.COMPANY_CODE_CURRENCY == TCURC.WAERS
Condition Type
  • Condition Type
  • Client
  • ?
  • ?
  • TAX_ITEM.CONDITION_TYPE == T685.KSCHL
  • TAX_ITEM.RCLNT == T685.MANDT
  • TAX_ITEM.[column in domain "KVEWE"] == T685.KVEWE
  • TAX_ITEM.[column in domain "KAPPL"] == T685.KAPPL
Country/Region of Destination for Delivery of Goods
  • Country/Region of Destination for Delivery of Goods
  • Client
  • TAX_ITEM.DESTINATION_COUNTRY == T005.LAND1
  • TAX_ITEM.RCLNT == T005.MANDT
Exchange Rate Type
  • TAX_ITEM.RCLNT == TCURV.MANDT
  • TAX_ITEM.EXCHANGE_RATE_TYPE == TCURV.KURST
Customer Number
  • TAX_ITEM.RCLNT == KNA1.MANDT
  • TAX_ITEM.KUNNR == KNA1.KUNNR
Account Number of Supplier
  • TAX_ITEM.RCLNT == LFA1.MANDT
  • TAX_ITEM.LIFNR == LFA1.LIFNR
Material Number
  • Material Number
  • Client
  • TAX_ITEM.MATNR == MARA.MATNR
  • TAX_ITEM.RCLNT == MARA.MANDT
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • TAX_ITEM.RCLNT == T007A.MANDT
  • TAX_ITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • TAX_ITEM.MWSKZ == T007A.MWSKZ
Account Number
  • ?
  • Client
  • Account Number
  • TAX_ITEM.[column in domain "KTOPL"] == SKA1.KTOPL
  • TAX_ITEM.RCLNT == SKA1.MANDT
  • TAX_ITEM.RACCT == SKA1.SAKNR
Company Code
  • TAX_ITEM.RCLNT == T001.MANDT
  • TAX_ITEM.RBUKRS == T001.BUKRS
Client TAX_ITEM.RCLNT == T000.MANDT
Tax Reporting Currency
  • TAX_ITEM.RCLNT == TCURC.MANDT
  • TAX_ITEM.REPORTING_CURRENCY == TCURC.WAERS
Supplying Country/Region for Delivery of Goods
  • Supplying Country/Region for Delivery of Goods
  • Client
  • TAX_ITEM.SUPPLYING_COUNTRY == T005.LAND1
  • TAX_ITEM.RCLNT == T005.MANDT
Tax Reporting Country/Region
  • Tax Reporting Country/Region
  • Client
  • TAX_ITEM.TAX_COUNTRY == T005.LAND1
  • TAX_ITEM.RCLNT == T005.MANDT
Transaction Currency
  • TAX_ITEM.RCLNT == TCURC.MANDT
  • TAX_ITEM.TRANSACTION_CURRENCY == TCURC.WAERS