P_CZ_StRpTaxItem

Czech VAT Tax Items | view: PCZSRTAXITEM | Extraction: Not supported | Component: Financials Czech Republic
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
AccountingDocumentItem null
TaxItem Number of Tax Line Item
TaxCode FK Tax on sales/purchases code
TransactionTypeDetermination Transaction Key
Column Name Description
TaxRate Tax Rate
💲 Reporting Currency (ReportingCurrency):
TaxBaseAmountInRptgCrcy null
TaxAmountInRptgCrcy null
💲 Currency Key (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
💲 Currency Key (DocumentCurrency):
TaxBaseAmountInTransCrcy null
TaxAmountInTransCrcy null
💲 Reporting Currency (CountryCurrency):
TaxBaseAmountInCountryCrcy null
TaxBaseAmtInAdditionalCrcy1 Tax Base Amount in Local Currency 2
TaxAmountInAdditionalCurrency1 Tax Amount in Local Currency 2
TaxBaseAmtInAdditionalCrcy2 Tax Base Amount in Local Currency 3
TaxAmountInAdditionalCurrency2 Tax Amount in Local Currency 3
TaxAmountInCountryCrcy null
Column Name Description
Column Name Description
TaxRateValidityStartDate Valid-From Date of the Tax Rate
PostingDate Posting Date
DocumentDate Journal Entry Date
TaxReportingDate Tax Reporting Date
InvoiceReceiptDate Invoice Receipt Date
ReportingDate Posting Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
FinancialAccountType Account Type Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
TaxIsNotDeductible Indicator: Tax not deductible Show values
TaxType Tax Type Show values
EUTaxClassification EU Code/Code Show values
Column Name Description Domain name
PaymentReference Payment Reference CHAR30
Reference1IDByBusinessPartner Business Partner Reference Key 1 CHAR12
OriginalReferenceDocument Original Reference Document AWKEY
TaxItemGroup Group Indicator for Tax Line Items NUM03
ReferenceDocumentType Reference Document Type AWTYP
DocumentReferenceID Document Reference ID XBLNR1
FiscalPeriod Fiscal Period POPER
ExchangeRate Exchange Rate UKURS
AccountingDocumentHeaderText Document Header Text TEXT25
ReportingCountry Reporting Country/Region LAND1
TaxReturnCountry Country/Region for Tax Report LAND1
Supplier null
Customer null
BPVATRegistration VAT Registration Number STCEG
CountryVATRegistration VAT Registration Number STCEG
VATRegistration null
TaxNumber1 null
TaxNumber2 null
TaxNumber3 null
BusinessPartner null
BusinessPartnerName null
CustomerSupplierAddress null
IsNaturalPerson null
CustomerCountry null
ReverseDocumentFiscalYear Reverse Document Fiscal Year GJAHR
ReverseDocument Reverse Document BELNR
CABillgDocIsReversed null
SDDocumentCategory null
SupplierInvoiceOrigin null
SuplrBillgDocIsCanceled null
FollowOnDocumentType Follow-On Document Type REBZT
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceItemReference Invoice Item Reference BUZEI
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_CZ_STRPTAXITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_CZ_STRPTAXITEM.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • P_CZ_STRPTAXITEM.COMPANYCODE == T001.BUKRS
  • P_CZ_STRPTAXITEM.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • P_CZ_STRPTAXITEM.COMPANYCODECOUNTRY == T005.LAND1
  • P_CZ_STRPTAXITEM.MANDT == T005.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Reporting Currency
  • Client
  • P_CZ_STRPTAXITEM.DOCUMENTCURRENCY == TCURC.WAERS
  • P_CZ_STRPTAXITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • P_CZ_STRPTAXITEM.COUNTRYCURRENCY == TCURC.WAERS
  • P_CZ_STRPTAXITEM.MANDT == TCURC.MANDT
Reporting Currency
  • Currency Key
  • Currency Key
  • Reporting Currency
  • Client
  • P_CZ_STRPTAXITEM.DOCUMENTCURRENCY == TCURC.WAERS
  • P_CZ_STRPTAXITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • P_CZ_STRPTAXITEM.COUNTRYCURRENCY == TCURC.WAERS
  • P_CZ_STRPTAXITEM.MANDT == TCURC.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Reporting Currency
  • Client
  • P_CZ_STRPTAXITEM.DOCUMENTCURRENCY == TCURC.WAERS
  • P_CZ_STRPTAXITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • P_CZ_STRPTAXITEM.COUNTRYCURRENCY == TCURC.WAERS
  • P_CZ_STRPTAXITEM.MANDT == TCURC.MANDT
General Ledger Account
  • Company Code
  • General Ledger Account
  • Client
  • P_CZ_STRPTAXITEM.COMPANYCODE == SKB1.BUKRS
  • P_CZ_STRPTAXITEM.GLACCOUNT == SKB1.SAKNR
  • P_CZ_STRPTAXITEM.MANDT == SKB1.MANDT
Tax Code
  • Target Tax Code (for Deferred Tax)
  • ?
  • Client
  • P_CZ_STRPTAXITEM.TARGETTAXCODE == T007A.MWSKZ
  • P_CZ_STRPTAXITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • P_CZ_STRPTAXITEM.MANDT == T007A.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • P_CZ_STRPTAXITEM.[column in domain "KVEWE"] == T683.KVEWE
  • P_CZ_STRPTAXITEM.[column in domain "KAPPL"] == T683.KAPPL
  • P_CZ_STRPTAXITEM.TAXCALCULATIONPROCEDURE == T683.KALSM
  • P_CZ_STRPTAXITEM.MANDT == T683.MANDT
Tax on sales/purchases code
  • Tax on sales/purchases code
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • P_CZ_STRPTAXITEM.TAXCODE == T007A.MWSKZ
  • P_CZ_STRPTAXITEM.TAXCALCULATIONPROCEDURE == T007A.KALSM
  • P_CZ_STRPTAXITEM.MANDT == T007A.MANDT
Tax Jurisdiction
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • Tax Jurisdiction
  • P_CZ_STRPTAXITEM.TAXCALCULATIONPROCEDURE == TTXJ.KALSM
  • P_CZ_STRPTAXITEM.MANDT == TTXJ.MANDT
  • P_CZ_STRPTAXITEM.TAXJURISDICTION == TTXJ.TXJCD