P_StRpTaxItmWithEUTaxClass7

EU Sales tax Item View for Statutory Reporting | view: PSRTIEUTAXCLS7 | Extraction: Not supported | Component: Localization Financials (generic parts)
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
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
StatryRptgEntity FK Reporting Entity
Column Name Description
💲 Reporting Currency (ReportingCurrency):
AmountInReportingCurrency Amount in Reporting Currency
💲 Company Code Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Local Currency
💲 Currency Key (DocumentCurrency):
TaxBaseAmountInTransCrcy Tax Base Amount in Document Currency
💲 Reporting Currency (CountryCurrency):
TaxBaseAmountInCountryCrcy Tax Base Amount in Country/Region Currency
AmountInCompanyCodeCurrSumForS Amount in Reporting Currency
AmountInCompanyCodeCurrSumForH Amount in Reporting Currency
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
IsEUTriangularDeal Indicator: Triangular Deal Within the EU Show values
EUTaxClassification EU Code/Code Show values
TaxType Tax Type Show values
TaxDebitCreditCode Debit/Credit Indicator Show values
Column Name Description Domain name
Debtor Customer KUNNR
CustomerName Name of Customer TEXT80
Creditor Supplier LIFNR
SupplierName Name of Supplier TEXT80
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerName Business Partner Name BP_NAME_CA
VATRegistration VAT Registration Number STCEG
VATRegistrationFromBSEG VAT Registration Number STCEG
VATRegistrationXI Tax Number 6 CHAR20
AuthorizationGroup Authorization Group BRGRU
TaxItemGroup Group Indicator for Tax Line Items NUM03
ReportingCountry Reporting Country/Region LAND1
TaxReturnCountry Country/Region for Tax Report LAND1
DelivOfGoodsDestCountry Country/Region of Destination for Delivery of Goods LAND1
DelivOfGoodsOriginCountry Supplying Country/Region for Delivery of Goods LAND1
ReferenceDocumentType Reference Document Type AWTYP
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_STRPTAXITMWITHEUTAXCLASS7.MANDT == T001.MANDT
  • P_STRPTAXITMWITHEUTAXCLASS7.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • Reporting Currency
  • Currency Key
  • P_STRPTAXITMWITHEUTAXCLASS7.MANDT == TCURC.MANDT
  • P_STRPTAXITMWITHEUTAXCLASS7.COMPANYCODECURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS7.COUNTRYCURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS7.DOCUMENTCURRENCY == TCURC.WAERS
Country/Region Key
  • Country/Region Key
  • Client
  • P_STRPTAXITMWITHEUTAXCLASS7.COUNTRY == T005.LAND1
  • P_STRPTAXITMWITHEUTAXCLASS7.MANDT == T005.MANDT
Reporting Currency
  • Client
  • Company Code Currency
  • Reporting Currency
  • Currency Key
  • P_STRPTAXITMWITHEUTAXCLASS7.MANDT == TCURC.MANDT
  • P_STRPTAXITMWITHEUTAXCLASS7.COMPANYCODECURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS7.COUNTRYCURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS7.DOCUMENTCURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Company Code Currency
  • Reporting Currency
  • Currency Key
  • P_STRPTAXITMWITHEUTAXCLASS7.MANDT == TCURC.MANDT
  • P_STRPTAXITMWITHEUTAXCLASS7.COMPANYCODECURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS7.COUNTRYCURRENCY == TCURC.WAERS
  • P_STRPTAXITMWITHEUTAXCLASS7.DOCUMENTCURRENCY == TCURC.WAERS
Reporting Entity
  • Client
  • Reporting Entity
  • P_STRPTAXITMWITHEUTAXCLASS7.MANDT == SRF_RPG_ENT.MANDT
  • P_STRPTAXITMWITHEUTAXCLASS7.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Taxes on Sales/Purchases Group
  • Client
  • Taxes on Sales/Purchases Group
  • P_STRPTAXITMWITHEUTAXCLASS7.MANDT == T007F.MANDT
  • P_STRPTAXITMWITHEUTAXCLASS7.TAXABLEENTITY == T007F.UMKRS
Tax on sales/purchases code
  • Client
  • Tax on sales/purchases code
  • ?
  • P_STRPTAXITMWITHEUTAXCLASS7.MANDT == T007A.MANDT
  • P_STRPTAXITMWITHEUTAXCLASS7.TAXCODE == T007A.MWSKZ
  • P_STRPTAXITMWITHEUTAXCLASS7.[column in domain "KALSM_D"] == T007A.KALSM
Tax Jurisdiction
  • Client
  • ?
  • Tax Jurisdiction
  • P_STRPTAXITMWITHEUTAXCLASS7.MANDT == TTXJ.MANDT
  • P_STRPTAXITMWITHEUTAXCLASS7.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • P_STRPTAXITMWITHEUTAXCLASS7.TAXJURISDICTION == TTXJ.TXJCD