C_ZA_SuplrCharcsAndTaxItemQry

Analytical query South Africa BBBEE Supplier Classification | view: CZASUPCHARTXITMQ | Extraction: Not supported | Component: Localization Financials
Tables used: 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, CABN, AUSP, T005, KNA1, CVI_CUST_LINK, T685, T685A, LFA1, CVI_VEND_LINK, T007A, T001, T014, CLF_HDR, T007B
Column Name Description
CompanyCode Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxItem Number of Line Item Within Accounting Document
TaxCode Tax on sales/purchases code
TransactionTypeDetermination Transaction Key
Supplier FK Supplier
ClfnObjectID Key of Object to be Classified
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Document Currency
TaxAmountInCoCodeCrcy Tax Amount in Local Currency
RevenueAdjustmentAmount null
Column Name Description
Column Name Description
ReportingDate Reporting Date
ContractExpiryPredictedDate South Africa BBBEE Supplier Expiry date
Column Name Description
Column Name Description Domain name
SupplierVATRegistration null
ConversionFactor null
SupplierName Name of Supplier TEXT80
SupplierRecognitionLevel null
ZA_OrgIsEligibleToBBBEE050 null
ZA_OrgIsEligibleToBBBEE030 null
SupplierTurnoverLevel null
SupplierIsEmpowering null
SupplierIsEnterpriseDeveloped null
Master Data Relations Join Conditions
Reporting Entity
  • Client
  • Reporting Entity
  • C_ZA_SUPLRCHARCSANDTAXITEMQRY.MANDT == SRF_RPG_ENT.MANDT
  • C_ZA_SUPLRCHARCSANDTAXITEMQRY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Supplier
  • Client
  • C_ZA_SUPLRCHARCSANDTAXITEMQRY.SUPPLIER == LFA1.LIFNR
  • C_ZA_SUPLRCHARCSANDTAXITEMQRY.MANDT == LFA1.MANDT