P_StRpTaxItmWithEUTaxClass5

EU Sales tax Item View for Statutory Reporting | view: PSRTIEUTAXCLS5 | Extraction: Not supported | Component: Localization Financials (generic parts)
Tables used: BKPFBKPFBSEGBSETADCPADRCBUT000T001TKA02T005KNA1CVI_CUST_LINKLFA1CVI_VEND_LINKT001T014KNASLFAST001Z
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
AmountInReportingCurrency null
💲 Currency Key (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy null
💲 Currency Key (DocumentCurrency):
TaxBaseAmountInTransCrcy null
💲 Reporting Currency (CountryCurrency):
TaxBaseAmountInCountryCrcy null
Column Name Description
Column Name Description
ReportingDate Reporting Date
PostingDate Posting Date
DocumentDate Journal Entry Date
TaxReportingDate Tax Reporting Date
Column Name Description
IsOneTimeAccount Indicator: Is the account a one-time account? Show values
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
Debtor null
CustomerName Name of Customer TEXT80
Creditor null
SupplierName Name of Supplier TEXT80
BusinessPartnerUUID Business Partner GUID SYSUUID
VATRegistration null
VATRegistrationFromBSEG null
AuthorizationGroup Authorization Group BRGRU
TaxItemGroup Group Indicator for Tax Line Items NUM03
TaxCountry Tax Reporting Country/Region LAND1
ReportingCountry Country/Region Key LAND1
TaxReturnCountry Country/Region for Tax Report LAND1
IsEUTriangularDeal null
DelivOfGoodsDestCountry null
DelivOfGoodsOriginCountry null
ReferenceDocumentType Reference Document Type AWTYP
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_STRPTAXITMWITHEUTAXCLASS5.COMPANYCODE == T001.BUKRS
  • P_STRPTAXITMWITHEUTAXCLASS5.MANDT == T001.MANDT
Currency Key
  • Reporting Currency
  • Currency Key
  • Currency Key
  • Client
  • P_STRPTAXITMWITHEUTAXCLASS5.COUNTRYCURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS5.COMPANYCODECURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS5.DOCUMENTCURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS5.MANDT == TCURC.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • P_STRPTAXITMWITHEUTAXCLASS5.COUNTRY == T005.LAND1
  • P_STRPTAXITMWITHEUTAXCLASS5.MANDT == T005.MANDT
Reporting Currency
  • Reporting Currency
  • Currency Key
  • Currency Key
  • Client
  • P_STRPTAXITMWITHEUTAXCLASS5.COUNTRYCURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS5.COMPANYCODECURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS5.DOCUMENTCURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS5.MANDT == TCURC.MANDT
Currency Key
  • Reporting Currency
  • Currency Key
  • Currency Key
  • Client
  • P_STRPTAXITMWITHEUTAXCLASS5.COUNTRYCURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS5.COMPANYCODECURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS5.DOCUMENTCURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS5.MANDT == TCURC.MANDT
Taxes on Sales/Purchases Group
  • Taxes on Sales/Purchases Group
  • Client
  • P_STRPTAXITMWITHEUTAXCLASS5.TAXABLEENTITY == T007F.UMKRS
  • P_STRPTAXITMWITHEUTAXCLASS5.MANDT == T007F.MANDT
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • Client
  • P_STRPTAXITMWITHEUTAXCLASS5.[column in domain "KALSM_D"] == T007A.KALSM
  • P_STRPTAXITMWITHEUTAXCLASS5.TAXCODE == T007A.MWSKZ
  • P_STRPTAXITMWITHEUTAXCLASS5.MANDT == T007A.MANDT
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • Client
  • P_STRPTAXITMWITHEUTAXCLASS5.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • P_STRPTAXITMWITHEUTAXCLASS5.TAXJURISDICTION == TTXJ.TXJCD
  • P_STRPTAXITMWITHEUTAXCLASS5.MANDT == TTXJ.MANDT