C_TH_WhldgTaxItemQ

Withholding Tax Items Query for all PND | view: CSRTHTAXITEMQ | Extraction: Not supported | Component: Withholding Tax Reporting
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
AccountingDocumentItem Number of Line Item Within Accounting Document
WithholdingTaxType FK Indicator for Withholding Tax Type
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
CalcdTxBaseAmtInCoCodeCrcy null
CalculatedTxAmtInCoCodeCrcy null
💲 Currency Key (DocumentCurrency):
WhldgTaxBaseAmtInTransacCrcy Withholding Tax Base Amount in Document Currency
WhldgTaxAmtInTransacCrcy Withholding Tax Amount in Document Currency
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ClearingDate Posting Date
Column Name Description
FinancialAccountType Account type Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
WithholdingTaxPostingRule Posting Indicator Show values
Column Name Description Domain name
WhldgTaxCodeName null
InvoiceReference Invoice Reference BELNR
DocumentReferenceID Reference Document Number XBLNR1
TH_WhldgRecipientType null
ItemIsReportingRelevant null
VATRegistration VAT Registration Number STCEG
BranchLongCode Business Place FITH_BUPLA
Customer Customer Number KUNNR
CustomerName Name of Customer TEXT80
CustomerFullName Customer Full Name TEXT220
BusinessPartner Customer Number KUNNR
TH_DefaultBranch Branch Code BCODE
Supplier Account Number of Supplier LIFNR
FormOfAddress Title TEXT15
TaxNumber1 Tax Number 1 STCD1
TaxNumber3 null
SupplierFullName Supplier Full Name TEXT220
BusinessPartnerName1 null
BusinessPartnerName2 null
BusinessPartnerName3 null
FirstName Name 1 TEXT40
LastName Name 2 TEXT40
Building Building (Number or Code) TEXT20
CityName City TEXT40
Country Country/Region Key LAND1
CountryName Country/Region Name TEXT50
Floor Floor in building TEXT10
FullName null
StreetName Street TEXT60
HouseNumber House Number TEXT10
District District TEXT40
PostalCode Postal Code PSTLZ
RoomNumber Room or Apartment Number TEXT10
AdditionalStreetPrefixName Street 3 TEXT40
StreetSuffixName Street 4 TEXT40
StreetPrefixName Street 2 TEXT40
HomeCityName City (different from postal city) TEXT40
PhoneNumber1 First telephone number TEXT16
Language null
CustomerSupplierAccount Vendor/Customer Account Number CHAR10
WithholdingTaxPercent Withholding Tax Rate PRZ22
WithholdingTaxCertificate Withholding Tax Certificate Number CHAR10
WhldgTaxDocumentType null
TH_FiscalYear null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_TH_WHLDGTAXITEMQ.COMPANYCODE == T001.BUKRS
  • C_TH_WHLDGTAXITEMQ.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • C_TH_WHLDGTAXITEMQ.MANDT == TCURC.MANDT
  • C_TH_WHLDGTAXITEMQ.DOCUMENTCURRENCY == TCURC.WAERS
  • C_TH_WHLDGTAXITEMQ.COMPANYCODECURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • C_TH_WHLDGTAXITEMQ.MANDT == TCURC.MANDT
  • C_TH_WHLDGTAXITEMQ.DOCUMENTCURRENCY == TCURC.WAERS
  • C_TH_WHLDGTAXITEMQ.COMPANYCODECURRENCY == TCURC.WAERS
Official Withholding Tax Key
  • ?
  • Client
  • Official Withholding Tax Key
  • C_TH_WHLDGTAXITEMQ.[column in domain "LAND1"] == T059O.LAND1
  • C_TH_WHLDGTAXITEMQ.MANDT == T059O.MANDT
  • C_TH_WHLDGTAXITEMQ.OFFICIALWHLDGTAXCODE == T059O.WT_QSCOD
Reporting Entity
  • Client
  • Reporting Entity
  • C_TH_WHLDGTAXITEMQ.MANDT == SRF_RPG_ENT.MANDT
  • C_TH_WHLDGTAXITEMQ.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Type of Recipient
  • Type of Recipient
  • Indicator for Withholding Tax Type
  • ?
  • Client
  • C_TH_WHLDGTAXITEMQ.SUPPLIERRECIPIENTTYPE == T059C.QSREC
  • C_TH_WHLDGTAXITEMQ.WITHHOLDINGTAXTYPE == T059C.WITHT
  • C_TH_WHLDGTAXITEMQ.[column in domain "LAND1"] == T059C.LAND1
  • C_TH_WHLDGTAXITEMQ.MANDT == T059C.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • C_TH_WHLDGTAXITEMQ.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_TH_WHLDGTAXITEMQ.MANDT == TCURC.MANDT
Withholding Tax Code
  • Indicator for Withholding Tax Type
  • ?
  • Withholding Tax Code
  • Client
  • C_TH_WHLDGTAXITEMQ.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • C_TH_WHLDGTAXITEMQ.[column in domain "LAND1"] == T059Z.LAND1
  • C_TH_WHLDGTAXITEMQ.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
  • C_TH_WHLDGTAXITEMQ.MANDT == T059Z.MANDT
Income Type
  • Income Type
  • ?
  • Client
  • C_TH_WHLDGTAXITEMQ.WITHHOLDINGTAXINCOMETYPE == T059E.QEKAR
  • C_TH_WHLDGTAXITEMQ.[column in domain "LAND1"] == T059E.LAND1
  • C_TH_WHLDGTAXITEMQ.MANDT == T059E.MANDT
Indicator for Withholding Tax Type
  • Indicator for Withholding Tax Type
  • ?
  • Client
  • C_TH_WHLDGTAXITEMQ.WITHHOLDINGTAXTYPE == T059P.WITHT
  • C_TH_WHLDGTAXITEMQ.[column in domain "LAND1"] == T059P.LAND1
  • C_TH_WHLDGTAXITEMQ.MANDT == T059P.MANDT