I_Businesspartnerwhldgtax

Company code Whldg tax Core CDS | view: IBPWHLDGTAX | Extraction: Not supported | Component: Business Partners
Tables used: BUT000, LFBW, T001, TKA02, CVI_VEND_LINK
Column Name Description
BusinessPartner Business Partner Number
Supplier FK Account Number of Supplier
CompanyCode FK Company Code
WithholdingTaxType FK Indicator for Withholding Tax Type
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
BusinessPartnerUUID Business Partner GUID SYSUUID
WithholdingTaxNumber Withholding tax identification number STCD1
WithholdingTaxCertificate Exemption Certificate Number CHAR25
WithholdingTaxExmptPercent Exemption Rate PRZ32
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • I_BUSINESSPARTNERWHLDGTAX.MANDT == T001.MANDT
  • I_BUSINESSPARTNERWHLDGTAX.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Country/Region Key
  • Client
  • I_BUSINESSPARTNERWHLDGTAX.COUNTRYCODE == T005.LAND1
  • I_BUSINESSPARTNERWHLDGTAX.MANDT == T005.MANDT
Reason for Exemption
  • Country/Region Key
  • Reason for Exemption
  • Client
  • I_BUSINESSPARTNERWHLDGTAX.COUNTRYCODE == T059V.LAND1
  • I_BUSINESSPARTNERWHLDGTAX.EXEMPTIONREASON == T059V.WT_WTEXRS
  • I_BUSINESSPARTNERWHLDGTAX.MANDT == T059V.MANDT
Type of Recipient
  • Country/Region Key
  • Client
  • Indicator for Withholding Tax Type
  • Type of Recipient
  • I_BUSINESSPARTNERWHLDGTAX.COUNTRYCODE == T059C.LAND1
  • I_BUSINESSPARTNERWHLDGTAX.MANDT == T059C.MANDT
  • I_BUSINESSPARTNERWHLDGTAX.WITHHOLDINGTAXTYPE == T059C.WITHT
  • I_BUSINESSPARTNERWHLDGTAX.RECIPIENTTYPE == T059C.QSREC
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • I_BUSINESSPARTNERWHLDGTAX.SUPPLIER == LFA1.LIFNR
  • I_BUSINESSPARTNERWHLDGTAX.MANDT == LFA1.MANDT
Withholding Tax Code
  • Country/Region Key
  • Withholding Tax Code
  • Client
  • Indicator for Withholding Tax Type
  • I_BUSINESSPARTNERWHLDGTAX.COUNTRYCODE == T059Z.LAND1
  • I_BUSINESSPARTNERWHLDGTAX.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
  • I_BUSINESSPARTNERWHLDGTAX.MANDT == T059Z.MANDT
  • I_BUSINESSPARTNERWHLDGTAX.WITHHOLDINGTAXTYPE == T059Z.WITHT
Indicator for Withholding Tax Type
  • Country/Region Key
  • Client
  • Indicator for Withholding Tax Type
  • I_BUSINESSPARTNERWHLDGTAX.COUNTRYCODE == T059P.LAND1
  • I_BUSINESSPARTNERWHLDGTAX.MANDT == T059P.MANDT
  • I_BUSINESSPARTNERWHLDGTAX.WITHHOLDINGTAXTYPE == T059P.WITHT