P_StRpWhldgTaxItem

Withholding Tax Item | view: PSRTIWHLDGTX | 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
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
PostingDate Posting Date
DocumentDate Journal Entry Date
WithholdingTaxReportingDate Withholding Tax Reporting Date
ReportingDate Posting 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
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
BusinessPartnerNumber Business Partner Number BU_PARTNER
SqntlNmbrOfWhldgTaxType Sequential Number of a Withholding Tax Type WT_TPNR
DependencyNmbrOfWhldgTaxType Withholding Tax Type Number on Which This W/Tax Type Depends WT_TPNR
SenderCompanyCode Company Code in Sender System CHAR4
SenderAccountingDocument Sender Journal Entry BELNR
SenderFiscalYear Fiscal Year of an Accounting Document in the Sender System GJAHR
SenderLogicalSystem Sender Logical System LOGSYS
TransactionTypeDetermination null
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_STRPWHLDGTAXITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_STRPWHLDGTAXITEM.MANDT == T003.MANDT
Business Area
  • Business Area
  • Client
  • P_STRPWHLDGTAXITEM.BUSINESSAREA == TGSB.GSBER
  • P_STRPWHLDGTAXITEM.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_STRPWHLDGTAXITEM.CHARTOFACCOUNTS == T004.KTOPL
  • P_STRPWHLDGTAXITEM.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_STRPWHLDGTAXITEM.COMPANYCODE == T001.BUKRS
  • P_STRPWHLDGTAXITEM.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • P_STRPWHLDGTAXITEM.COUNTRY == T005.LAND1
  • P_STRPWHLDGTAXITEM.MANDT == T005.MANDT
Supplier
  • Supplier
  • Client
  • P_STRPWHLDGTAXITEM.CREDITOR == LFA1.LIFNR
  • P_STRPWHLDGTAXITEM.MANDT == LFA1.MANDT
Customer Number
  • Customer Number
  • Client
  • P_STRPWHLDGTAXITEM.DEBTOR == KNA1.KUNNR
  • P_STRPWHLDGTAXITEM.MANDT == KNA1.MANDT
General Ledger Account
  • General Ledger Account
  • Chart of Accounts
  • Client
  • P_STRPWHLDGTAXITEM.GLACCOUNT == SKA1.SAKNR
  • P_STRPWHLDGTAXITEM.CHARTOFACCOUNTS == SKA1.KTOPL
  • P_STRPWHLDGTAXITEM.MANDT == SKA1.MANDT
Official Withholding Tax Key
  • Country/Region Key
  • Official Withholding Tax Key
  • Client
  • P_STRPWHLDGTAXITEM.COUNTRY == T059O.LAND1
  • P_STRPWHLDGTAXITEM.OFFICIALWHLDGTAXCODE == T059O.WT_QSCOD
  • P_STRPWHLDGTAXITEM.MANDT == T059O.MANDT
Posting Key
  • Posting Key
  • Client
  • P_STRPWHLDGTAXITEM.POSTINGKEY == TBSL.BSCHL
  • P_STRPWHLDGTAXITEM.MANDT == TBSL.MANDT
Special G/L Indicator
  • ?
  • Client
  • Special G/L Indicator
  • P_STRPWHLDGTAXITEM.[column in domain "KOART"] == T074U.KOART
  • P_STRPWHLDGTAXITEM.MANDT == T074U.MANDT
  • P_STRPWHLDGTAXITEM.SPECIALGLCODE == T074U.UMSKZ
Type of Recipient
  • Country/Region Key
  • Type of Recipient
  • Indicator for Withholding Tax Type
  • Client
  • P_STRPWHLDGTAXITEM.COUNTRY == T059C.LAND1
  • P_STRPWHLDGTAXITEM.SUPPLIERRECIPIENTTYPE == T059C.QSREC
  • P_STRPWHLDGTAXITEM.WITHHOLDINGTAXTYPE == T059C.WITHT
  • P_STRPWHLDGTAXITEM.MANDT == T059C.MANDT
Tax Section
  • Tax Section
  • Company Code
  • Client
  • P_STRPWHLDGTAXITEM.TAXSECTION == SECCODE.SECCODE
  • P_STRPWHLDGTAXITEM.COMPANYCODE == SECCODE.BUKRS
  • P_STRPWHLDGTAXITEM.MANDT == SECCODE.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • P_STRPWHLDGTAXITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_STRPWHLDGTAXITEM.MANDT == TCURC.MANDT
Withholding Tax Code
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Client
  • Withholding Tax Code
  • P_STRPWHLDGTAXITEM.COUNTRY == T059Z.LAND1
  • P_STRPWHLDGTAXITEM.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • P_STRPWHLDGTAXITEM.MANDT == T059Z.MANDT
  • P_STRPWHLDGTAXITEM.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
Income Type
  • Country/Region Key
  • Income Type
  • Client
  • P_STRPWHLDGTAXITEM.COUNTRY == T059E.LAND1
  • P_STRPWHLDGTAXITEM.WITHHOLDINGTAXINCOMETYPE == T059E.QEKAR
  • P_STRPWHLDGTAXITEM.MANDT == T059E.MANDT
Indicator for Withholding Tax Type
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Client
  • P_STRPWHLDGTAXITEM.COUNTRY == T059P.LAND1
  • P_STRPWHLDGTAXITEM.WITHHOLDINGTAXTYPE == T059P.WITHT
  • P_STRPWHLDGTAXITEM.MANDT == T059P.MANDT