I_StRpWhldgTaxItem

Withholding Tax Item View For Statutory Reporting | view: ISRTIWHLDGTX | TRAN | 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
WhldgTaxExmptAmtInCoCodeCrcy Amount Exempt from Withholding Tax in Local Currency
WhldgTaxDeductedNetAmount null
💲 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
WhldgTxDdctdNetAmtInTransCrcy null
💲 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
WithholdingTaxReportingDate Withholding Tax Reporting Date
PostingDate Posting Date
DocumentDate Journal Entry Date
ReportingDate Reporting Date
ClearingDate Clearing Date
WhldgTaxCertDate Issue or Print Date of Withholding Tax Certificate
Column Name Description
FinancialAccountType Account type Show values
WhldgTaxRptgDateIsActive Activate Withholding Tax Reporting Date Indicator Show values
DefaultWhldgTxRptgDateIsActive Default Withholding Tax Reporting Date Indicator 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
WhldgTaxBaseIsInherited Indicator: Base Amount Equals Amount of Other Type 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
SpecialGLTransactionType Special G/L Transaction Type UMSKS
Reference3IDByBusinessPartner ID of Reference 3 by Business Partner CHAR20
InvoiceReference Invoice Reference BELNR
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
ItemIsReportingRelevant null
Name null
TaxNumber1 null
TaxNumber2 null
TaxNumber3 null
TaxNumber4 null
TaxNumber5 null
VATRegistration VAT Registration Number STCEG
PostalCode null
CityName null
StreetName null
HouseNumber null
HouseNumberSupplementText null
OrganizationBPName1 null
SearchTerm1 null
OrganizationFoundationDate null
OrganizationBPName2 null
POBoxPostalCode null
POBox null
Region null
BusinessPartnerCountry null
TaxNumberType Tax Number Type TEXT2
PaymentIsNotified null
Language Language Key SPRAS
TaxItemIsZeroRated null
DocumentReferenceID Reference Document Number XBLNR1
TransactionCode Transaction Code TCODE
AccountingDocumentHeaderText Document Header Text TEXT25
DocumentItemText Item Text TEXT50
EmailAddress E-Mail Address AD_SMTPADR
SqntlNmbrOfWhldgTaxType Sequential Number of a Withholding Tax Type WT_TPNR
DependencyNmbrOfWhldgTaxType Withholding Tax Type Number on Which This W/Tax Type Depends WT_TPNR
BusinessPartnerNumber Business Partner Number BU_PARTNER
Supplier Account Number of Supplier LIFNR
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_STRPWHLDGTAXITEM.MANDT == T003.MANDT
  • I_STRPWHLDGTAXITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Business Area
  • Client
  • Business Area
  • I_STRPWHLDGTAXITEM.MANDT == TGSB.MANDT
  • I_STRPWHLDGTAXITEM.BUSINESSAREA == TGSB.GSBER
Company Code
  • Company Code
  • Client
  • I_STRPWHLDGTAXITEM.COMPANYCODE == T001.BUKRS
  • I_STRPWHLDGTAXITEM.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • I_STRPWHLDGTAXITEM.COUNTRY == T005.LAND1
  • I_STRPWHLDGTAXITEM.MANDT == T005.MANDT
Supplier
  • Client
  • Supplier
  • Account Number of Supplier
  • I_STRPWHLDGTAXITEM.MANDT == LFA1.MANDT
  • I_STRPWHLDGTAXITEM.CREDITOR == LFA1.LIFNR
  • I_STRPWHLDGTAXITEM.SUPPLIER == LFA1.LIFNR
Customer Number
  • Customer Number
  • Client
  • I_STRPWHLDGTAXITEM.DEBTOR == KNA1.KUNNR
  • I_STRPWHLDGTAXITEM.MANDT == KNA1.MANDT
General Ledger Account
  • ?
  • General Ledger Account
  • Client
  • I_STRPWHLDGTAXITEM.[column in domain "KTOPL"] == SKA1.KTOPL
  • I_STRPWHLDGTAXITEM.GLACCOUNT == SKA1.SAKNR
  • I_STRPWHLDGTAXITEM.MANDT == SKA1.MANDT
Official Withholding Tax Key
  • Country/Region Key
  • Client
  • Official Withholding Tax Key
  • I_STRPWHLDGTAXITEM.COUNTRY == T059O.LAND1
  • I_STRPWHLDGTAXITEM.MANDT == T059O.MANDT
  • I_STRPWHLDGTAXITEM.OFFICIALWHLDGTAXCODE == T059O.WT_QSCOD
Posting Key
  • Posting Key
  • Client
  • I_STRPWHLDGTAXITEM.POSTINGKEY == TBSL.BSCHL
  • I_STRPWHLDGTAXITEM.MANDT == TBSL.MANDT
Special G/L Indicator
  • ?
  • Special G/L Indicator
  • Client
  • I_STRPWHLDGTAXITEM.[column in domain "KOART"] == T074U.KOART
  • I_STRPWHLDGTAXITEM.SPECIALGLCODE == T074U.UMSKZ
  • I_STRPWHLDGTAXITEM.MANDT == T074U.MANDT
Reporting Entity
  • Reporting Entity
  • Client
  • I_STRPWHLDGTAXITEM.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • I_STRPWHLDGTAXITEM.MANDT == SRF_RPG_ENT.MANDT
Type of Recipient
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Type of Recipient
  • Client
  • I_STRPWHLDGTAXITEM.COUNTRY == T059C.LAND1
  • I_STRPWHLDGTAXITEM.WITHHOLDINGTAXTYPE == T059C.WITHT
  • I_STRPWHLDGTAXITEM.SUPPLIERRECIPIENTTYPE == T059C.QSREC
  • I_STRPWHLDGTAXITEM.MANDT == T059C.MANDT
Tax Section
  • Company Code
  • Tax Section
  • Client
  • I_STRPWHLDGTAXITEM.COMPANYCODE == SECCODE.BUKRS
  • I_STRPWHLDGTAXITEM.TAXSECTION == SECCODE.SECCODE
  • I_STRPWHLDGTAXITEM.MANDT == SECCODE.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • I_STRPWHLDGTAXITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_STRPWHLDGTAXITEM.MANDT == TCURC.MANDT
Withholding Tax Code
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Client
  • Withholding Tax Code
  • I_STRPWHLDGTAXITEM.COUNTRY == T059Z.LAND1
  • I_STRPWHLDGTAXITEM.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • I_STRPWHLDGTAXITEM.MANDT == T059Z.MANDT
  • I_STRPWHLDGTAXITEM.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
Income Type
  • Country/Region Key
  • Client
  • Income Type
  • I_STRPWHLDGTAXITEM.COUNTRY == T059E.LAND1
  • I_STRPWHLDGTAXITEM.MANDT == T059E.MANDT
  • I_STRPWHLDGTAXITEM.WITHHOLDINGTAXINCOMETYPE == T059E.QEKAR
Indicator for Withholding Tax Type
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Client
  • I_STRPWHLDGTAXITEM.COUNTRY == T059P.LAND1
  • I_STRPWHLDGTAXITEM.WITHHOLDINGTAXTYPE == T059P.WITHT
  • I_STRPWHLDGTAXITEM.MANDT == T059P.MANDT