P_StRpTaxItmWithEUTaxClass3

EU Sales tax Item View for Statutory Reporting | view: PSRTIEUTAXCLS3 | Extraction: Not supported | Component: Localization Financials (generic parts)
Tables used: BKPFBKPFBSEGBSETT001TKA02T005T001T014
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxCode FK Tax on sales/purchases code
TransactionTypeDetermination Transaction Key
TaxItem Number of Tax Line Item
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy null
💲 Currency Key (DocumentCurrency):
TaxBaseAmountInTransCrcy null
💲 Reporting Currency (CountryCurrency):
TaxBaseAmountInCountryCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
TaxReportingDate Tax Reporting Date
Column Name Description
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
TaxDebitCreditCode Debit/Credit Indicator Show values
Column Name Description Domain name
VATRegistration null
TaxCountry Tax Reporting Country/Region LAND1
ReportingCountry Country/Region Key LAND1
TaxReturnCountry Country/Region for Tax Report LAND1
TaxItemGroup Group Indicator for Tax Line Items NUM03
ReferenceDocumentType Reference Document Type AWTYP
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_STRPTAXITMWITHEUTAXCLASS3.MANDT == T001.MANDT
  • P_STRPTAXITMWITHEUTAXCLASS3.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • P_STRPTAXITMWITHEUTAXCLASS3.COUNTRY == T005.LAND1
  • P_STRPTAXITMWITHEUTAXCLASS3.COMPANYCODECOUNTRY == T005.LAND1
  • P_STRPTAXITMWITHEUTAXCLASS3.MANDT == T005.MANDT
Currency Key
  • Client
  • Currency Key
  • Reporting Currency
  • Currency Key
  • P_STRPTAXITMWITHEUTAXCLASS3.MANDT == TCURC.MANDT
  • P_STRPTAXITMWITHEUTAXCLASS3.COMPANYCODECURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS3.COUNTRYCURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS3.DOCUMENTCURRENCY == TCURC.WAERS
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • P_STRPTAXITMWITHEUTAXCLASS3.COUNTRY == T005.LAND1
  • P_STRPTAXITMWITHEUTAXCLASS3.COMPANYCODECOUNTRY == T005.LAND1
  • P_STRPTAXITMWITHEUTAXCLASS3.MANDT == T005.MANDT
Reporting Currency
  • Client
  • Currency Key
  • Reporting Currency
  • Currency Key
  • P_STRPTAXITMWITHEUTAXCLASS3.MANDT == TCURC.MANDT
  • P_STRPTAXITMWITHEUTAXCLASS3.COMPANYCODECURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS3.COUNTRYCURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS3.DOCUMENTCURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • Reporting Currency
  • Currency Key
  • P_STRPTAXITMWITHEUTAXCLASS3.MANDT == TCURC.MANDT
  • P_STRPTAXITMWITHEUTAXCLASS3.COMPANYCODECURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS3.COUNTRYCURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS3.DOCUMENTCURRENCY == TCURC.WAERS
Taxes on Sales/Purchases Group
  • Client
  • Taxes on Sales/Purchases Group
  • P_STRPTAXITMWITHEUTAXCLASS3.MANDT == T007F.MANDT
  • P_STRPTAXITMWITHEUTAXCLASS3.TAXABLEENTITY == T007F.UMKRS
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • Client
  • P_STRPTAXITMWITHEUTAXCLASS3.[column in domain "KALSM_D"] == T007A.KALSM
  • P_STRPTAXITMWITHEUTAXCLASS3.TAXCODE == T007A.MWSKZ
  • P_STRPTAXITMWITHEUTAXCLASS3.MANDT == T007A.MANDT
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • P_STRPTAXITMWITHEUTAXCLASS3.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • P_STRPTAXITMWITHEUTAXCLASS3.MANDT == TTXJ.MANDT
  • P_STRPTAXITMWITHEUTAXCLASS3.TAXJURISDICTION == TTXJ.TXJCD