C_IL_StRpTaxItemLogQuery

IL:Tax Item For Statutory ReportingQuery | view: CILSTRPTAXITMQRY | TRAN | Extraction: Not supported | Component: Financials Israel
Tables used: VBRK, CFIN_AV_CI_PART, CFIN_AV_SO_PART, BSEC, VBPA3, BKPF, BSEG, VBPA, VBPA, ADCP, ADRC, CVI_CUST_CT_LINK, BUT000, CFIN_AV_CI_ROOT, T005, KNA1, CVI_CUST_LINK, T685, T685A, LFA1, CVI_VEND_LINK, T007A, T001, T014, T007B
Column Name Description
StatryRptgEntity Reporting Entity
StatryRptCategory Report Category ID
StatryRptRunID Report Run ID
CompanyCode Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxItem Number of Line Item Within Accounting Document
Column Name Description
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Document Currency
TaxBaseAmtInAdditionalCrcy1 Tax Base Amount in Local Currency 2
TaxBaseAmtInAdditionalCrcy2 Tax Base Amount in Local Currency 3
TaxAmountInCoCodeCrcy Tax Amount in Local Currency
TaxAmountInAdditionalCurrency1 Tax Amount in Local Currency 2
TaxAmountInAdditionalCurrency2 Tax Amount in Local Currency 3
Column Name Description
Column Name Description
PostingDate Posting Date in the Document
DocumentDate Journal Entry Date
Column Name Description
IL_VATRecordType Transaction record type for new vat file Show values
Column Name Description Domain name
SystemMessageTextLong null
TaxCode Tax on sales/purchases code MWSKZ
DocumentReferenceID Document Reference ID XBLNR1
TransactionTypeDetermination Transaction Key CHAR3
Master Data Relations Join Conditions
Customer Number
  • Customer Number
  • Client
  • C_IL_STRPTAXITEMLOGQUERY.CUSTOMER == KNA1.KUNNR
  • C_IL_STRPTAXITEMLOGQUERY.MANDT == KNA1.MANDT
Supplier
  • Client
  • Supplier
  • C_IL_STRPTAXITEMLOGQUERY.MANDT == LFA1.MANDT
  • C_IL_STRPTAXITEMLOGQUERY.SUPPLIER == LFA1.LIFNR