P_TAX_ITEM

Tax Item from Tax Register | view: PTAXITEM | Extraction: Not supported | Component: Transactional Tax Operations
Tables used: TAX_ITEM
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
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
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
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_TAX_ITEM.MANDT == T001.MANDT
  • P_TAX_ITEM.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Company Code Currency
  • Client
  • P_TAX_ITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • P_TAX_ITEM.MANDT == TCURC.MANDT
Condition Type
  • ?
  • ?
  • Client
  • Condition Type
  • P_TAX_ITEM.[column in domain "KAPPL"] == T685.KAPPL
  • P_TAX_ITEM.[column in domain "KVEWE"] == T685.KVEWE
  • P_TAX_ITEM.MANDT == T685.MANDT
  • P_TAX_ITEM.CONDITIONTYPE == T685.KSCHL
Customer Number
  • Client
  • Customer Number
  • P_TAX_ITEM.MANDT == KNA1.MANDT
  • P_TAX_ITEM.CUSTOMER == KNA1.KUNNR
Country/Region of Destination for Delivery of Goods
  • Country/Region of Destination for Delivery of Goods
  • Client
  • P_TAX_ITEM.DESTINATIONCOUNTRY == T005.LAND1
  • P_TAX_ITEM.MANDT == T005.MANDT
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • P_TAX_ITEM.EXCHANGERATETYPE == TCURV.KURST
  • P_TAX_ITEM.MANDT == TCURV.MANDT
G/L Account
  • ?
  • G/L Account
  • Client
  • P_TAX_ITEM.[column in domain "KTOPL"] == SKA1.KTOPL
  • P_TAX_ITEM.GLACCOUNT == SKA1.SAKNR
  • P_TAX_ITEM.MANDT == SKA1.MANDT
Tax Reporting Currency
  • Client
  • Tax Reporting Currency
  • P_TAX_ITEM.MANDT == TCURC.MANDT
  • P_TAX_ITEM.REPORTINGCURRENCY == TCURC.WAERS
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • P_TAX_ITEM.SUPPLIER == LFA1.LIFNR
  • P_TAX_ITEM.MANDT == LFA1.MANDT
Supplying Country/Region for Delivery of Goods
  • Client
  • Supplying Country/Region for Delivery of Goods
  • P_TAX_ITEM.MANDT == T005.MANDT
  • P_TAX_ITEM.SUPPLYINGCOUNTRY == T005.LAND1
Tax on sales/purchases code
  • ?
  • Client
  • Tax on sales/purchases code
  • P_TAX_ITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • P_TAX_ITEM.MANDT == T007A.MANDT
  • P_TAX_ITEM.TAXCODE == T007A.MWSKZ
Tax Reporting Country/Region
  • Client
  • Tax Reporting Country/Region
  • P_TAX_ITEM.MANDT == T005.MANDT
  • P_TAX_ITEM.TAXCOUNTRY == T005.LAND1
Transaction Currency
  • Client
  • Transaction Currency
  • P_TAX_ITEM.MANDT == TCURC.MANDT
  • P_TAX_ITEM.TRANSACTIONCURRENCY == TCURC.WAERS