P_US_StrpWhldgTaxItem

WIthholding Tax View for US | view: PSRUSWHLDGTXITM | Extraction: Not supported | Component: Financials USA
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, T005S, LFA1, LFB1, 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):
WhldgTaxBaseAmtInCoCodeCrcy Withholding Tax Base Amount in Company Code Currency
WhldgTaxAmtInCoCodeCrcy Withholding Tax Amount in Company Code Currency
WhldgTaxExmptAmtInCoCodeCrcy Amount Exempt from Withholding Tax in Local Currency
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ReportingDate Reporting Date
ClearingDate Clearing Date
Column Name Description
US_SecondTINNoticeIsIssued Second TIN Notice from IRS Show values
US_FrgnAcctTaxFilingIsRequired US FATCA Indicator Show values
US_ForeignSuplrHasPartnership Partnership Interest Indicator Show values
Column Name Description Domain name
WhldgTaxDocumentType null
WhldgTxCodeGrp 1 Byte Unsigned Integer INT1
BusinessPartner Business Partner Number /SCMB/DO_BU_PARTNER
WhldgTaxExmptCertificate Exemption Certificate Number CHAR25
StreetName Street TEXT60
HouseNumber House Number TEXT10
CompanyCodeName Name of Company Code or Company TEXT25
CompanyPostalCode City postal code CHAR10
POBoxDeviatingCityName PO Box city TEXT40
OrganizationBPName1 null
OrganizationBPName2 null
OrganizationBPName3 null
BusPartPOBox null
BPRgn null
CustomerSupplierPostalCode Business Partner Postal Code CHAR10
CustomerSupplierCityName Business partner City Name TEXT40
CustomerSupplierStreetName Business Partner Street Name TEXT60
CustomerSupplierHouseNumber null
BPHsNmbrSuplmntTxt Business Partner House Number Supplement Text TEXT10
BusinessPartnerCountry Business Partner Country/Region Key LAND1
BusPartPOBoxPostlCode Business Partner PO Box Postal Code
BPStPrefixName Street 2 TEXT40
PayeeCityName null
PayeeState Region for PO Box (Country/Region, State, Province, ...) REGIO
PayeeRegion Region for PO Box (Country/Region, State, Province, ...) REGIO
PayeeZipCode null
PayeePostalCode null
WithholdingTaxCountry Withholding Tax Country/Region Key QLAND
Language Language Key SPRAS
Name Business Partner Name TEXT80
FrgnBP Foreign Business Partner CHAR1
TaxNumber1 Tax Number 1 STCD1
TaxNumber2 Tax Number 2 STCD2
TaxNumber4 Tax Number 4 CHAR18
TaxNumber5 Tax Number 5 CHAR60
BPTaxNumber Business Partner Tax Number BPTAXNUM
ProvincialTaxCode Provincial Tax Code FPRCD
BusPartPOBoxDvtgCityName Business Partner PO Box Deviating City Name TEXT40
US_TaxNumberWhldgTxCodeGrp Tax Number + Withholding Tax Code Group CHAR50
US_RecipientForeignTaxID US Recipient Foreign Tax ID
US_ForeignSuplrLmtnOnBnftCode LOB Treaty Code
Master Data Relations Join Conditions
Region for PO Box (Country/Region, State, Province, ...)
  • Client
  • ?
  • Region for PO Box (Country/Region, State, Province, ...)
  • Region for PO Box (Country/Region, State, Province, ...)
  • P_US_STRPWHLDGTAXITEM.MANDT == T005S.MANDT
  • P_US_STRPWHLDGTAXITEM.[column in domain "LAND1"] == T005S.LAND1
  • P_US_STRPWHLDGTAXITEM.BUSPARTPOBOXRGN == T005S.BLAND
  • P_US_STRPWHLDGTAXITEM.POBOXDEVIATINGREGION == T005S.BLAND
City code for city/street file
  • Client
  • ?
  • City code for city/street file
  • P_US_STRPWHLDGTAXITEM.MANDT == ADRCITY.CLIENT
  • P_US_STRPWHLDGTAXITEM.[column in domain "LAND1"] == ADRCITY.COUNTRY
  • P_US_STRPWHLDGTAXITEM.CITYCODE == ADRCITY.CITY_CODE
Company Code
  • Client
  • Company Code
  • P_US_STRPWHLDGTAXITEM.MANDT == T001.MANDT
  • P_US_STRPWHLDGTAXITEM.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • P_US_STRPWHLDGTAXITEM.MANDT == T005.MANDT
  • P_US_STRPWHLDGTAXITEM.COUNTRY == T005.LAND1
Supplier
  • Client
  • Supplier
  • P_US_STRPWHLDGTAXITEM.MANDT == LFA1.MANDT
  • P_US_STRPWHLDGTAXITEM.CREDITOR == LFA1.LIFNR
Region for PO Box (Country/Region, State, Province, ...)
  • Client
  • ?
  • Region for PO Box (Country/Region, State, Province, ...)
  • Region for PO Box (Country/Region, State, Province, ...)
  • P_US_STRPWHLDGTAXITEM.MANDT == T005S.MANDT
  • P_US_STRPWHLDGTAXITEM.[column in domain "LAND1"] == T005S.LAND1
  • P_US_STRPWHLDGTAXITEM.BUSPARTPOBOXRGN == T005S.BLAND
  • P_US_STRPWHLDGTAXITEM.POBOXDEVIATINGREGION == T005S.BLAND
Reporting Entity
  • Client
  • Reporting Entity
  • P_US_STRPWHLDGTAXITEM.MANDT == SRF_RPG_ENT.MANDT
  • P_US_STRPWHLDGTAXITEM.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Foreign Key for Add. Withholding Tax Code
  • Client
  • Withholding Tax Key
  • Country/Region Key
Withholding Tax Code
  • Client
  • Indicator for Withholding Tax Type
  • Country/Region Key
  • Withholding Tax Code
  • P_US_STRPWHLDGTAXITEM.MANDT == T059Z.MANDT
  • P_US_STRPWHLDGTAXITEM.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • P_US_STRPWHLDGTAXITEM.COUNTRY == T059Z.LAND1
  • P_US_STRPWHLDGTAXITEM.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
Indicator for Withholding Tax Type
  • Client
  • Indicator for Withholding Tax Type
  • Country/Region Key
  • P_US_STRPWHLDGTAXITEM.MANDT == T059P.MANDT
  • P_US_STRPWHLDGTAXITEM.WITHHOLDINGTAXTYPE == T059P.WITHT
  • P_US_STRPWHLDGTAXITEM.COUNTRY == T059P.LAND1