C_StRpWithholdingTaxItemQuery

Withholding Tax Item Query | view: CSRWHLDGTXITMQ | Extraction: Not supported | Component: Withholding Tax Reporting
Tables used: BKPF, BSEC, ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, WITH_ITEM, BKPF, BSEG, ADCP, ADRC, ADR6, BUT000, T001, TKA02, KNA1, CVI_CUST_LINK, T059Z, LFA1, CVI_VEND_LINK, T001, T014, T059P, WTREPDATE
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
💲 Company Code Currency (ReportingCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
TaxAmountInCoCodeCrcy Signed Tax Amount in Company Code Currency
WhldgTaxBaseAmtInCoCodeCrcy null
WhldgTaxAmtInCoCodeCrcy null
WhldgTaxDeductedNetAmount null
WhldgTaxExmptAmtInCoCodeCrcy Amount Exempt from Withholding Tax in Local Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
TaxAmount Tax Amount in Transaction Currency
WhldgTaxBaseAmtInTransacCrcy null
WhldgTaxAmtInTransacCrcy null
WhldgTaxExmptAmtInTransacCrcy Amount Exempt from Withholding Tax in Document Currency
💲 Additional Currency 1 (AdditionalCurrency1):
AmountInAdditionalCurrency1 Amount in Additional Currency 1
TaxAmountInAdditionalCurrency1 Tax Amount in Additional Currency1
WhldgTaxBaseAmtInAddlCrcy2 null
WhldgTaxAmtInAddlCrcy2 null
WhldgTaxExmptAmtInAddlCrcy2 Amount Exempt from Withholding Tax in 2nd Local Currency
💲 Additional Currency 2 (AdditionalCurrency2):
AmountInAdditionalCurrency2 Amount in Additional Currency 2
TaxAmountInAdditionalCurrency2 Tax Amount in Additional Currency2
WhldgTaxBaseAmtInAddlCrcy3 null
WhldgTaxAmtInAddlCrcy3 null
WhldgTaxExmptAmtInAddlCrcy3 Amount Exempt from Withholding Tax in 3rd Local Currency
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ReportingDate Reporting Date
WithholdingTaxReportingDate Withholding Tax Reporting Date
ClearingDate Clearing Date
WhldgTaxCertDate Issue or Print Date of Withholding Tax Certificate
Column Name Description
FinancialAccountType Account type Show values
IsReversed Indicator: Item is Reversed Show values
IsReversal Indicator: Item is Reversing Another Item Show values
WhldgTaxBaseIsEnteredManually Indicator: Withholding Tax Base Amount Entered Manually Show values
WhldgTaxIsEnteredManually Indicator: Withholding Tax Amount Entered Manually Show values
WhldgTaxItemStatus Line Item Status Show values
IsSelfWhldgTax Indicator: Entry Posted as Self-Withholding Tax Show values
IsGrossingUp Indicator: Entry Posted as "Grossing Up" Show values
IsNaturalPerson Natural Person Show values
Column Name Description Domain name
CustomerName Name of Customer TEXT80
BusinessPartner Customer Number KUNNR
FiscalPeriod Fiscal Period POPER
ClearingAccountingDocument Clearing Journal Entry BELNR
DocumentReferenceID Reference Document Number XBLNR1
SpecialGLTransactionType Special G/L Transaction Type UMSKS
ReverseDocument Reverse Document BELNR
WhldgTaxExmptCertificate Exemption Certificate Number CHAR25
WithholdingTaxExmptPercent Exemption Rate PRZ32
WithholdingTaxPercent Withholding Tax Rate PRZ34
WithholdingTaxCertificate Withholding Tax Certificate Number CHAR10
WhldgTaxDocumentType null
Name null
TaxNumber1 null
TaxNumber2 null
TaxNumber3 null
TaxNumber4 null
TaxNumber5 null
VATRegistration VAT Registration Number STCEG
TaxNumberType Tax Number Type TEXT2
PostalCode null
CityName null
StreetName null
HouseNumber null
HouseNumberSupplementText null
OrganizationBPName1 null
OrganizationBPName2 null
SearchTerm1 null
OrganizationFoundationDate null
POBoxPostalCode null
POBox null
Region null
BusinessPartnerCountry null
PaymentIsNotified null
DocumentItemText Item Text TEXT50
Language Language Key SPRAS
EmailAddress E-Mail Address AD_SMTPADR
ItemIsReportingRelevant null
TaxItemIsZeroRated null
BusinessPartnerNumber Business Partner Number BU_PARTNER
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_STRPWITHHOLDINGTAXITEMQUERY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_STRPWITHHOLDINGTAXITEMQUERY.MANDT == T003.MANDT
Business Area
  • Business Area
  • Client
  • C_STRPWITHHOLDINGTAXITEMQUERY.BUSINESSAREA == TGSB.GSBER
  • C_STRPWITHHOLDINGTAXITEMQUERY.MANDT == TGSB.MANDT
Company Code
  • Client
  • Company Code
  • C_STRPWITHHOLDINGTAXITEMQUERY.MANDT == T001.MANDT
  • C_STRPWITHHOLDINGTAXITEMQUERY.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • C_STRPWITHHOLDINGTAXITEMQUERY.MANDT == T005.MANDT
  • C_STRPWITHHOLDINGTAXITEMQUERY.COUNTRY == T005.LAND1
Supplier
  • Client
  • Supplier
  • C_STRPWITHHOLDINGTAXITEMQUERY.MANDT == LFA1.MANDT
  • C_STRPWITHHOLDINGTAXITEMQUERY.CREDITOR == LFA1.LIFNR
Customer Number
  • Customer Number
  • Client
  • C_STRPWITHHOLDINGTAXITEMQUERY.DEBTOR == KNA1.KUNNR
  • C_STRPWITHHOLDINGTAXITEMQUERY.MANDT == KNA1.MANDT
General Ledger Account
  • ?
  • Client
  • General Ledger Account
  • C_STRPWITHHOLDINGTAXITEMQUERY.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_STRPWITHHOLDINGTAXITEMQUERY.MANDT == SKA1.MANDT
  • C_STRPWITHHOLDINGTAXITEMQUERY.GLACCOUNT == SKA1.SAKNR
Official Withholding Tax Key
  • Client
  • Official Withholding Tax Key
  • Country/Region Key
  • C_STRPWITHHOLDINGTAXITEMQUERY.MANDT == T059O.MANDT
  • C_STRPWITHHOLDINGTAXITEMQUERY.OFFICIALWHLDGTAXCODE == T059O.WT_QSCOD
  • C_STRPWITHHOLDINGTAXITEMQUERY.COUNTRY == T059O.LAND1
Posting Key
  • Client
  • Posting Key
  • C_STRPWITHHOLDINGTAXITEMQUERY.MANDT == TBSL.MANDT
  • C_STRPWITHHOLDINGTAXITEMQUERY.POSTINGKEY == TBSL.BSCHL
Special G/L Indicator
  • Client
  • ?
  • Special G/L Indicator
  • C_STRPWITHHOLDINGTAXITEMQUERY.MANDT == T074U.MANDT
  • C_STRPWITHHOLDINGTAXITEMQUERY.[column in domain "KOART"] == T074U.KOART
  • C_STRPWITHHOLDINGTAXITEMQUERY.SPECIALGLCODE == T074U.UMSKZ
Reporting Entity
  • Client
  • Reporting Entity
  • C_STRPWITHHOLDINGTAXITEMQUERY.MANDT == SRF_RPG_ENT.MANDT
  • C_STRPWITHHOLDINGTAXITEMQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Type of Recipient
  • Client
  • Type of Recipient
  • Indicator for Withholding Tax Type
  • Country/Region Key
  • C_STRPWITHHOLDINGTAXITEMQUERY.MANDT == T059C.MANDT
  • C_STRPWITHHOLDINGTAXITEMQUERY.SUPPLIERRECIPIENTTYPE == T059C.QSREC
  • C_STRPWITHHOLDINGTAXITEMQUERY.WITHHOLDINGTAXTYPE == T059C.WITHT
  • C_STRPWITHHOLDINGTAXITEMQUERY.COUNTRY == T059C.LAND1
Tax Section
  • Client
  • Tax Section
  • Company Code
  • C_STRPWITHHOLDINGTAXITEMQUERY.MANDT == SECCODE.MANDT
  • C_STRPWITHHOLDINGTAXITEMQUERY.TAXSECTION == SECCODE.SECCODE
  • C_STRPWITHHOLDINGTAXITEMQUERY.COMPANYCODE == SECCODE.BUKRS
Transaction Currency
  • Transaction Currency
  • Client
  • C_STRPWITHHOLDINGTAXITEMQUERY.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_STRPWITHHOLDINGTAXITEMQUERY.MANDT == TCURC.MANDT
Withholding Tax Code
  • Client
  • Indicator for Withholding Tax Type
  • Country/Region Key
  • Withholding Tax Code
  • C_STRPWITHHOLDINGTAXITEMQUERY.MANDT == T059Z.MANDT
  • C_STRPWITHHOLDINGTAXITEMQUERY.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • C_STRPWITHHOLDINGTAXITEMQUERY.COUNTRY == T059Z.LAND1
  • C_STRPWITHHOLDINGTAXITEMQUERY.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
Income Type
  • Client
  • Income Type
  • Country/Region Key
  • C_STRPWITHHOLDINGTAXITEMQUERY.MANDT == T059E.MANDT
  • C_STRPWITHHOLDINGTAXITEMQUERY.WITHHOLDINGTAXINCOMETYPE == T059E.QEKAR
  • C_STRPWITHHOLDINGTAXITEMQUERY.COUNTRY == T059E.LAND1
Indicator for Withholding Tax Type
  • Client
  • Indicator for Withholding Tax Type
  • Country/Region Key
  • C_STRPWITHHOLDINGTAXITEMQUERY.MANDT == T059P.MANDT
  • C_STRPWITHHOLDINGTAXITEMQUERY.WITHHOLDINGTAXTYPE == T059P.WITHT
  • C_STRPWITHHOLDINGTAXITEMQUERY.COUNTRY == T059P.LAND1