I_CZ_StRpTaxItem

VAT Tax Line Item CZ | view: ICZSRTAXITEM | TRAN | Extraction: Not supported | Component: Financials Czech Republic
Tables used: BKPF, BSEC, ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, ACDOCA, BKPF, BSEG, BSET, ADCP, ADRC, BUT000, T001, TKA02, T005, KNA1, CVI_CUST_LINK, FINSC_LEDGER, LFA1, CVI_VEND_LINK, T007A, T001, T014, KNAS, LFAS, T007B, IDFIVATT_CCTA, IDFIVATT_TAXAT, FINSC_ACTVE_APPL, FINSC_LEDGER_REP
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
DebitCreditCode Debit/Credit Code Show values
Column Name Description
💲 Reporting Currency (ReportingCurrency):
TaxBaseAmountInRptgCrcy null
TaxAmountInRptgCrcy null
TaxExpenseAmountInCoCodeCrcy null
TaxBaseAmtInAdditionalCrcy1 Tax Base Amount in Local Currency 2
TaxBaseAmtInAdditionalCrcy2 Tax Base Amount in Local Currency 3
TaxAmountInAdditionalCurrency1 Tax Amount in Local Currency 2
TaxAmountInAdditionalCurrency2 Tax Amount in Local Currency 3
💲 Currency Key (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
💲 Currency Key (DocumentCurrency):
TaxBaseAmountInTransCrcy null
TaxAmountInTransCrcy null
💲 Reporting Currency (CountryCurrency):
TaxBaseAmountInCountryCrcy null
TaxAmountInCountryCrcy null
Column Name Description
Column Name Description
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
TaxIsNotDeductible Indicator: Tax not deductible Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
TaxType Tax Type Show values
IsEuropeanUnionMember Indicator: European Union Member? Show values
SpecIdfgUsageIsActive Special Arrangements Show values
TaxGroupOperation Special Code Show values
TaxIsToBeCalculated Ratio Yes/No Show values
ProductIsClassified Read Material Settings Show values
Column Name Description Domain name
TaxRate null
TaxItemGroup Group Indicator for Tax Line Items NUM03
ReferenceDocumentType Reference Document Type AWTYP
DocumentReferenceID Document Reference ID XBLNR1
PaymentReference Payment Reference CHAR30
Reference1IDByBusinessPartner Business Partner Reference Key 1 CHAR12
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
VATRegistration Reporting Tax Number FICODIAN_TAX_NUMBER
BusinessPartner null
BusinessPartnerName null
CustomerSupplierAddress null
IsNaturalPerson null
CustomerCountry null
ReverseDocument Reverse Document BELNR
ReverseDocumentFiscalYear Reverse Document Fiscal Year GJAHR
CABillgDocIsReversed null
SDDocumentCategory null
SuplrBillgDocIsCanceled null
SupplierInvoiceOrigin null
FollowOnDocumentType Follow-On Document Type REBZT
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceItemReference Invoice Item Reference BUZEI
ProdIntlTradeClassification Classification Code for Material IDFIVAT_CLASS_CODE
TaxGroup Tax Group CHAR10
Product Material Number MATNR
Plant Plant WERKS
SystemMessageLongText Error text after posting CHAR250
StatryRptRunID Report Run ID SRF_REPORT_RUN_ID
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_CZ_STRPTAXITEM.MANDT == T003.MANDT
  • I_CZ_STRPTAXITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Client
  • Company Code
  • I_CZ_STRPTAXITEM.MANDT == T001.MANDT
  • I_CZ_STRPTAXITEM.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • I_CZ_STRPTAXITEM.MANDT == T005.MANDT
  • I_CZ_STRPTAXITEM.COMPANYCODECOUNTRY == T005.LAND1
Currency Key
  • Client
  • Currency Key
  • Reporting Currency
  • I_CZ_STRPTAXITEM.MANDT == TCURC.MANDT
  • I_CZ_STRPTAXITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • I_CZ_STRPTAXITEM.COUNTRYCURRENCY == TCURC.WAERS
Reporting Currency
  • Client
  • Currency Key
  • Reporting Currency
  • I_CZ_STRPTAXITEM.MANDT == TCURC.MANDT
  • I_CZ_STRPTAXITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • I_CZ_STRPTAXITEM.COUNTRYCURRENCY == TCURC.WAERS
General Ledger Account
  • General Ledger Account
  • Client
  • Company Code
  • I_CZ_STRPTAXITEM.GLACCOUNT == SKB1.SAKNR
  • I_CZ_STRPTAXITEM.MANDT == SKB1.MANDT
  • I_CZ_STRPTAXITEM.COMPANYCODE == SKB1.BUKRS
Reporting Entity
  • Client
  • Reporting Entity
  • I_CZ_STRPTAXITEM.MANDT == SRF_RPG_ENT.MANDT
  • I_CZ_STRPTAXITEM.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • ?
  • ?
  • I_CZ_STRPTAXITEM.TAXCALCULATIONPROCEDURE == T683.KALSM
  • I_CZ_STRPTAXITEM.MANDT == T683.MANDT
  • I_CZ_STRPTAXITEM.[column in domain "KVEWE"] == T683.KVEWE
  • I_CZ_STRPTAXITEM.[column in domain "KAPPL"] == T683.KAPPL
Tax on sales/purchases code
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • Tax on sales/purchases code
  • I_CZ_STRPTAXITEM.TAXCALCULATIONPROCEDURE == T007A.KALSM
  • I_CZ_STRPTAXITEM.MANDT == T007A.MANDT
  • I_CZ_STRPTAXITEM.TAXCODE == T007A.MWSKZ
Tax Jurisdiction
  • Tax Jurisdiction
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • I_CZ_STRPTAXITEM.TAXJURISDICTION == TTXJ.TXJCD
  • I_CZ_STRPTAXITEM.TAXCALCULATIONPROCEDURE == TTXJ.KALSM
  • I_CZ_STRPTAXITEM.MANDT == TTXJ.MANDT