C_BusinessPartnerWhldgTax

Consumption View for Withholding Tax | view: CBUPAWHLDGTAX | Extraction: Not supported | Component: Business Partners
Tables used: T059U, BUT000, T047, LFBW, T001, TKA02, LFB1, CVI_VEND_LINK
Column Name Description
CompanyCode FK Company Code
BusinessPartner Business Partner Number
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
ExtendedWhldgTaxIsActive Indicator: Extended Withholding Tax Active Show values
Column Name Description Domain name
WithholdingTaxTypeName Text, 40 Characters Long TEXT40
BusinessPartnerForEdit Business Partner Number BU_PARTNER
BusinessPartnerUUID Business Partner GUID SYSUUID
WithholdingTaxNumber Withholding tax identification number STCD1
WithholdingTaxExmptPercent Exemption Rate PRZ32
WithholdingTaxCertificate Exemption Certificate Number CHAR25
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • Company Code
  • C_BUSINESSPARTNERWHLDGTAX.MANDT == T001.MANDT
  • C_BUSINESSPARTNERWHLDGTAX.COMPANYCODEFOREDIT == T001.BUKRS
  • C_BUSINESSPARTNERWHLDGTAX.COMPANYCODE == T001.BUKRS
Company Code
  • Client
  • Company Code
  • Company Code
  • C_BUSINESSPARTNERWHLDGTAX.MANDT == T001.MANDT
  • C_BUSINESSPARTNERWHLDGTAX.COMPANYCODEFOREDIT == T001.BUKRS
  • C_BUSINESSPARTNERWHLDGTAX.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • C_BUSINESSPARTNERWHLDGTAX.MANDT == T005.MANDT
  • C_BUSINESSPARTNERWHLDGTAX.COUNTRY == T005.LAND1
  • C_BUSINESSPARTNERWHLDGTAX.COUNTRYCODE == T005.LAND1
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • C_BUSINESSPARTNERWHLDGTAX.MANDT == T005.MANDT
  • C_BUSINESSPARTNERWHLDGTAX.COUNTRY == T005.LAND1
  • C_BUSINESSPARTNERWHLDGTAX.COUNTRYCODE == T005.LAND1
Reason for Exemption
  • Client
  • Country/Region Key
  • Country/Region Key
  • Reason for Exemption
  • C_BUSINESSPARTNERWHLDGTAX.MANDT == T059V.MANDT
  • C_BUSINESSPARTNERWHLDGTAX.COUNTRY == T059V.LAND1
  • C_BUSINESSPARTNERWHLDGTAX.COUNTRYCODE == T059V.LAND1
  • C_BUSINESSPARTNERWHLDGTAX.EXEMPTIONREASON == T059V.WT_WTEXRS
Type of Recipient
  • Client
  • Type of Recipient
  • Country/Region Key
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Indicator for Withholding Tax Type
  • C_BUSINESSPARTNERWHLDGTAX.MANDT == T059C.MANDT
  • C_BUSINESSPARTNERWHLDGTAX.RECIPIENTTYPE == T059C.QSREC
  • C_BUSINESSPARTNERWHLDGTAX.COUNTRY == T059C.LAND1
  • C_BUSINESSPARTNERWHLDGTAX.COUNTRYCODE == T059C.LAND1
  • C_BUSINESSPARTNERWHLDGTAX.WITHHOLDINGTAXTYPE == T059C.WITHT
  • C_BUSINESSPARTNERWHLDGTAX.WITHHOLDINGTAXTYPEFOREDIT == T059C.WITHT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • C_BUSINESSPARTNERWHLDGTAX.SUPPLIER == LFA1.LIFNR
  • C_BUSINESSPARTNERWHLDGTAX.MANDT == LFA1.MANDT
Withholding Tax Code
  • Client
  • Country/Region Key
  • Country/Region Key
  • Withholding Tax Code
  • Indicator for Withholding Tax Type
  • Indicator for Withholding Tax Type
  • C_BUSINESSPARTNERWHLDGTAX.MANDT == T059Z.MANDT
  • C_BUSINESSPARTNERWHLDGTAX.COUNTRY == T059Z.LAND1
  • C_BUSINESSPARTNERWHLDGTAX.COUNTRYCODE == T059Z.LAND1
  • C_BUSINESSPARTNERWHLDGTAX.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
  • C_BUSINESSPARTNERWHLDGTAX.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • C_BUSINESSPARTNERWHLDGTAX.WITHHOLDINGTAXTYPEFOREDIT == T059Z.WITHT
Indicator for Withholding Tax Type
  • Client
  • Country/Region Key
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Indicator for Withholding Tax Type
  • C_BUSINESSPARTNERWHLDGTAX.MANDT == T059P.MANDT
  • C_BUSINESSPARTNERWHLDGTAX.COUNTRY == T059P.LAND1
  • C_BUSINESSPARTNERWHLDGTAX.COUNTRYCODE == T059P.LAND1
  • C_BUSINESSPARTNERWHLDGTAX.WITHHOLDINGTAXTYPE == T059P.WITHT
  • C_BUSINESSPARTNERWHLDGTAX.WITHHOLDINGTAXTYPEFOREDIT == T059P.WITHT
Indicator for Withholding Tax Type
  • Client
  • Country/Region Key
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Indicator for Withholding Tax Type
  • C_BUSINESSPARTNERWHLDGTAX.MANDT == T059P.MANDT
  • C_BUSINESSPARTNERWHLDGTAX.COUNTRY == T059P.LAND1
  • C_BUSINESSPARTNERWHLDGTAX.COUNTRYCODE == T059P.LAND1
  • C_BUSINESSPARTNERWHLDGTAX.WITHHOLDINGTAXTYPE == T059P.WITHT
  • C_BUSINESSPARTNERWHLDGTAX.WITHHOLDINGTAXTYPEFOREDIT == T059P.WITHT