I_ZA_StRpTaxItemLogCube

South Africa Tax Items for VAT Rpg with Rptd Log info | view: ISRZATAXITEMLGC | TRAN | 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
TaxCode Tax on sales/purchases code
TaxItem Number of Line Item Within Accounting Document
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
TaxItemGroupingVersion Grouping Version for Advance Return for Tax on Sales/Purch.
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Document Currency
TaxAmountInCoCodeCrcy null
💲 Reporting Currency (ReportingCurrency):
TaxBaseAmountInRptgCrcy Tax Base Amount in Reporting Currency
TaxAmountInRptgCrcy null
TaxBox01AmtInReportingCurrency null
TaxBox02AmtInReportingCurrency null
TaxBox03AmtInReportingCurrency null
TaxBox04AmtInReportingCurrency null
TaxBox05AmtInReportingCurrency null
TaxBox06AmtInReportingCurrency null
TaxBox07AmtInReportingCurrency null
TaxBox08AmtInReportingCurrency null
TaxBox09AmtInReportingCurrency null
TaxBox10AmtInReportingCurrency null
TaxBox11AmtInReportingCurrency null
TaxBox12AmtInReportingCurrency null
TaxBox13AmtInReportingCurrency null
TaxBox14AmtInReportingCurrency null
TaxBox15AmtInReportingCurrency null
TaxBox16AmtInReportingCurrency null
TaxBox17AmtInReportingCurrency null
TaxBox18AmtInReportingCurrency null
TaxBox19AmtInReportingCurrency null
TaxBox20AmtInReportingCurrency null
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
CashDiscountIsDeductible Indicator: Tax not deductible Show values
Column Name Description Domain name
AccountingDocumentType Document Type BLART
LinkUUID null
VATRegistration VAT Registration Number STCEG
NumberOfDocuments null
CustomerSupplierVATRegn null
DocumentReferenceID Document Reference ID XBLNR1
TaxRate TaxRate (Percentage)
RecordType null
ReportingCountry Reporting Country/Region LAND1
ReferenceDocumentType Reference Document Type AWTYP
BusinessPartnerCountry Country/Region Key LAND1
AuthorizationGroup Authorization Group BRGRU
BusinessPartnerName Business Partner Name TEXT80
Reference1IDByBusinessPartner null
Reference2IDByBusinessPartner null
Reference3IDByBusinessPartner null
Customer Customer Number KUNNR
Supplier Account Number of Supplier LIFNR
StatryRptRunID Report Run ID SRF_REPORT_RUN_ID
Master Data Relations Join Conditions
Country/Region Key
  • Client
  • Country/Region Key
  • I_ZA_STRPTAXITEMLOGCUBE.MANDT == T005.MANDT
  • I_ZA_STRPTAXITEMLOGCUBE.COUNTRY == T005.LAND1
Reason for Reversal or Inverse Posting
  • Client
  • Reason for Reversal or Inverse Posting
  • I_ZA_STRPTAXITEMLOGCUBE.MANDT == T041C.MANDT
  • I_ZA_STRPTAXITEMLOGCUBE.REVERSALREASON == T041C.STGRD
Reporting Entity
  • Client
  • Reporting Entity
  • I_ZA_STRPTAXITEMLOGCUBE.MANDT == SRF_RPG_ENT.MANDT
  • I_ZA_STRPTAXITEMLOGCUBE.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Tax Box
  • ?
  • Client
  • Tax Box
  • ?
  • Country/Region Key
  • I_ZA_STRPTAXITEMLOGCUBE.[column in domain "FOTFDATE"] == VGTAXBOX.FDATE
  • I_ZA_STRPTAXITEMLOGCUBE.MANDT == VGTAXBOX.MANDT
  • I_ZA_STRPTAXITEMLOGCUBE.TAXBOX == VGTAXBOX.TAXBOX
  • I_ZA_STRPTAXITEMLOGCUBE.[column in domain "TBSTYPE"] == VGTAXBOX.TBSTYP
  • I_ZA_STRPTAXITEMLOGCUBE.COUNTRY == VGTAXBOX.LAND1
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • I_ZA_STRPTAXITEMLOGCUBE.[column in domain "KVEWE"] == T683.KVEWE
  • I_ZA_STRPTAXITEMLOGCUBE.[column in domain "KAPPL"] == T683.KAPPL
  • I_ZA_STRPTAXITEMLOGCUBE.TAXCALCULATIONPROCEDURE == T683.KALSM
  • I_ZA_STRPTAXITEMLOGCUBE.MANDT == T683.MANDT