FAC_AUDIT_Z3_VENODR_WITHTAX

Vendor Withholding Tax Data | view: FAC_DZVENDWTAX | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: T059ZTT059UBUT000LFBWT001TKA02CVI_VEND_LINK
Column Name Description
CompanyCode FK Company Code
Supplier FK Account Number of Supplier
WithholdingTaxType FK Indicator for Withholding Tax Type
BusinessPartner Business Partner Number
Column Name Description
Column Name Description
Column Name Description
ExemptionDateBegin Date on Which Exemption Begins
ExemptionDateEnd Date on Which Exemption Ends
Column Name Description
IsWithholdingTaxSubject Indicator: Subject to Withholding Tax? Show values
Column Name Description Domain name
SystemClient Client
WithholdingTaxCertificate Exemption Certificate Number CHAR25
WithholdingTaxNumber Withholding tax identification number STCD1
WithholdingTaxExmptPercent Exemption Rate PRZ32
WhldgTaxCodeName Text, 40 Characters Long
WithholdingTaxTypeName Text, 40 Characters Long
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • FAC_AUDIT_Z3_VENODR_WITHTAX.COMPANYCODE == T001.BUKRS
  • FAC_AUDIT_Z3_VENODR_WITHTAX.MANDT == T001.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • FAC_AUDIT_Z3_VENODR_WITHTAX.MANDT == T005.MANDT
  • FAC_AUDIT_Z3_VENODR_WITHTAX.COUNTRYCODE == T005.LAND1
Reason for Exemption
  • Reason for Exemption
  • Client
  • Country/Region Key
  • FAC_AUDIT_Z3_VENODR_WITHTAX.EXEMPTIONREASON == T059V.WT_WTEXRS
  • FAC_AUDIT_Z3_VENODR_WITHTAX.MANDT == T059V.MANDT
  • FAC_AUDIT_Z3_VENODR_WITHTAX.COUNTRYCODE == T059V.LAND1
Type of Recipient
  • Type of Recipient
  • Indicator for Withholding Tax Type
  • Client
  • Country/Region Key
  • FAC_AUDIT_Z3_VENODR_WITHTAX.RECIPIENTTYPE == T059C.QSREC
  • FAC_AUDIT_Z3_VENODR_WITHTAX.WITHHOLDINGTAXTYPE == T059C.WITHT
  • FAC_AUDIT_Z3_VENODR_WITHTAX.MANDT == T059C.MANDT
  • FAC_AUDIT_Z3_VENODR_WITHTAX.COUNTRYCODE == T059C.LAND1
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • FAC_AUDIT_Z3_VENODR_WITHTAX.SUPPLIER == LFA1.LIFNR
  • FAC_AUDIT_Z3_VENODR_WITHTAX.MANDT == LFA1.MANDT
Withholding Tax Code
  • Indicator for Withholding Tax Type
  • Withholding Tax Code
  • Client
  • Country/Region Key
  • FAC_AUDIT_Z3_VENODR_WITHTAX.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • FAC_AUDIT_Z3_VENODR_WITHTAX.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
  • FAC_AUDIT_Z3_VENODR_WITHTAX.MANDT == T059Z.MANDT
  • FAC_AUDIT_Z3_VENODR_WITHTAX.COUNTRYCODE == T059Z.LAND1
Indicator for Withholding Tax Type
  • Indicator for Withholding Tax Type
  • Client
  • Country/Region Key
  • FAC_AUDIT_Z3_VENODR_WITHTAX.WITHHOLDINGTAXTYPE == T059P.WITHT
  • FAC_AUDIT_Z3_VENODR_WITHTAX.MANDT == T059P.MANDT
  • FAC_AUDIT_Z3_VENODR_WITHTAX.COUNTRYCODE == T059P.LAND1