FAC_AUDIT_Z3_CUSTOMER_WITHTAX

Customer Withholding Tax Data | view: FAC_DZCUSTWTAX | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: T059ZTT059UBUT000KNBWT001TKA02CVI_CUST_LINK
Column Name Description
CompanyCode FK Company Code
Customer FK Customer Number
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
ObligationDateBegin Obligated to Withhold Tax From
ObligationDateEnd Obligated to Withhold Tax Until
Column Name Description
WithholdingTaxAgent Indicator: Withholding Tax Agent? Show values
Column Name Description Domain name
SystemClient Client
WithholdingTaxCertificate Exemption Certificate Number CHAR25
WithholdingTaxNumber Withholding tax identification number STCD1
WithholdingTaxExmptPercent Exemption Rate PRZ32
ExemptionReason Reason for Exemption WT_WTEXRS
WhldgTaxCodeName Text, 40 Characters Long
WithholdingTaxTypeName Text, 40 Characters Long
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • FAC_AUDIT_Z3_CUSTOMER_WITHTAX.COMPANYCODE == T001.BUKRS
  • FAC_AUDIT_Z3_CUSTOMER_WITHTAX.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • FAC_AUDIT_Z3_CUSTOMER_WITHTAX.COUNTRYCODE == T005.LAND1
  • FAC_AUDIT_Z3_CUSTOMER_WITHTAX.MANDT == T005.MANDT
Customer Number
  • Customer Number
  • Client
  • FAC_AUDIT_Z3_CUSTOMER_WITHTAX.CUSTOMER == KNA1.KUNNR
  • FAC_AUDIT_Z3_CUSTOMER_WITHTAX.MANDT == KNA1.MANDT
Withholding Tax Code
  • Indicator for Withholding Tax Type
  • Withholding Tax Code
  • Country/Region Key
  • Client
  • FAC_AUDIT_Z3_CUSTOMER_WITHTAX.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • FAC_AUDIT_Z3_CUSTOMER_WITHTAX.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
  • FAC_AUDIT_Z3_CUSTOMER_WITHTAX.COUNTRYCODE == T059Z.LAND1
  • FAC_AUDIT_Z3_CUSTOMER_WITHTAX.MANDT == T059Z.MANDT
Indicator for Withholding Tax Type
  • Indicator for Withholding Tax Type
  • Country/Region Key
  • Client
  • FAC_AUDIT_Z3_CUSTOMER_WITHTAX.WITHHOLDINGTAXTYPE == T059P.WITHT
  • FAC_AUDIT_Z3_CUSTOMER_WITHTAX.COUNTRYCODE == T059P.LAND1
  • FAC_AUDIT_Z3_CUSTOMER_WITHTAX.MANDT == T059P.MANDT