C_ZA_StRpTaxItemLogQuery

Analytical Qry for South Africa Tax Item with Rptd Log Data | view: CSRZATAXITEMLGQ | Extraction: Not supported | Component: Localization Financials
Tables used: BKPF, VBRK, CFIN_AV_CI_PART, CFIN_AV_SO_PART, BSEC, VBPA3, ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, BKPF, BSEG, VBPA, VBPA, ADCP, ADRC, CVI_CUST_CT_LINK, BUT000, CFIN_AV_CI_ROOT, T001, TKA02, T005, KNA1, CVI_CUST_LINK, T685, T685A, LFA1, CVI_VEND_LINK, VGTAXBOX, VGTAXBOXT, VGTBS, VGTBST, T007A, T001, T014, KNAS, LFAS, T007B, VGTBS, T007L_LU, T007K_LU, T007L_MY, T007K_MY, T007L, T007K, VGTAXGR, VGTGTB, T007Z
Column Name Description
CompanyCode Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TransactionTypeDetermination Transaction Key
TaxItem Number of Line Item Within Accounting Document
TaxItemGroupingVersion Grouping Version for Advance Return for Tax on Sales/Purch.
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
Column Name Description
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date in the Document
ReportingDate Reporting Date
Column Name Description
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
FinancialAccountType Account Type Show values
TaxType Tax Type Show values
Column Name Description Domain name
TaxCode Tax on sales/purchases code MWSKZ
VATRegistration VAT Registration Number STCEG
LinkUUID null
TaxRate TaxRate (Percentage)
NumberOfDocuments null
DocumentReferenceID Document Reference ID XBLNR1
TaxBaseAmountInCoCodeCrcy Target length DEC(23,2) Output 31 w/ Sign AFLED15D2O21S_TO_23D2O31S
TaxAmountInCoCodeCrcy Target length DEC(23,2) Output 30 AFLED13D2O17N_TO_23D2O30N
TaxBaseAmountInRptgCrcy Target length DEC(23,2) Output 31 w/ Sign AFLED15D2O21S_TO_23D2O31S
TaxAmountInRptgCrcy Target length DEC(23,2) Output 30 AFLED13D2O17N_TO_23D2O30N
TaxBox01AmtInReportingCurrency Consideration Amount at std rate excl goods and services
TaxBox02AmtInReportingCurrency Consideration Amount at std rate only goods and/or services
TaxBox03AmtInReportingCurrency Consideration Amount at zero rate excl goods and services
TaxBox04AmtInReportingCurrency Consideration Amount at zero rate only exported goods
TaxBox05AmtInReportingCurrency Consideration Amount for Exempt and Non-Supplies
TaxBox06AmtInReportingCurrency Consideration amount for Accommodation exceeding 28 days
TaxBox07AmtInReportingCurrency Consideration amount for Accommodation not exceeding 28 days
TaxBox08AmtInReportingCurrency VAT amt for change goods and export of secondhand goods
TaxBox09AmtInReportingCurrency VAT amt for Other Adjustments and Imported Services
TaxBox10AmtInReportingCurrency VAT amt for Capital goods and services fully claimable
TaxBox11AmtInReportingCurrency VAT amt for Capital goods and services part claimable
TaxBox12AmtInReportingCurrency VAT amt for Capital goods imported full claimable
TaxBox13AmtInReportingCurrency VAT amt for Capital goods imported part claimable
TaxBox14AmtInReportingCurrency VAT amt for Other goods and/or services full claimable
TaxBox15AmtInReportingCurrency VAT amt for Other goods and/or services part claimable
TaxBox16AmtInReportingCurrency VAT amt for Other goods imported full claimable
TaxBox17AmtInReportingCurrency VAT amt for Other goods imported part claimable
TaxBox18AmtInReportingCurrency VAT amt for adjustments to the change in use of goods
TaxBox19AmtInReportingCurrency VAT amt for adjustments attributed to bad debt
TaxBox20AmtInReportingCurrency VAT amt for adjustments attributed to other transactions
CustomerSupplierVATRegn null
BusinessPartnerName Business Partner Name TEXT80
Reference1IDByBusinessPartner null
Reference2IDByBusinessPartner null
Reference3IDByBusinessPartner null
ReportingCountry Reporting Country/Region LAND1
RecordType null
Customer Customer Number KUNNR
Supplier Account Number of Supplier LIFNR
Master Data Relations Join Conditions
Reporting Entity
  • Client
  • Reporting Entity
  • C_ZA_STRPTAXITEMLOGQUERY.MANDT == SRF_RPG_ENT.MANDT
  • C_ZA_STRPTAXITEMLOGQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Tax Box
  • ?
  • Client
  • ?
  • ?
  • Tax Box
  • C_ZA_STRPTAXITEMLOGQUERY.[column in domain "LAND1"] == VGTAXBOX.LAND1
  • C_ZA_STRPTAXITEMLOGQUERY.MANDT == VGTAXBOX.MANDT
  • C_ZA_STRPTAXITEMLOGQUERY.[column in domain "TBSTYPE"] == VGTAXBOX.TBSTYP
  • C_ZA_STRPTAXITEMLOGQUERY.[column in domain "FOTFDATE"] == VGTAXBOX.FDATE
  • C_ZA_STRPTAXITEMLOGQUERY.TAXBOX == VGTAXBOX.TAXBOX