I_US_StRpFrgnVndrWhldgTxItm

Cube View For 1042s Reporting | view: IUSWHLDGTX1042S | TRAN | 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, DFKKBPTAXNUM, LFBW, T001, TKA02, T005T, KNA1, CVI_CUST_LINK, T059Z, T005S, T005U, LFA1, LFB1, CVI_VEND_LINK, CVI_VEND_LINK, T001, T014, T059P, WTREPDATE, T059FB
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 null
WhldgTaxAmtInCoCodeCrcy null
WhldgTaxExmptAmtInCoCodeCrcy Amount Exempt from Withholding Tax in Local Currency
US_NetAmtInCoCodeCrcy null
US_WhldgTaxCrdtAmtInCoCodeCrcy null
US_FederalTaxAmtInCoCodeCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ReportingDate Reporting Date
ClearingDate Clearing Date
BirthDate Date of Birth of the Person Subject to Withholding Tax
Column Name Description
US_ForeignSuplrHasPartnership Partnership Interest Indicator Show values
Column Name Description Domain name
BusinessPartner Business Partner Number /SCMB/DO_BU_PARTNER
PayerName1 Name 1 TEXT40
PayerName2 Name 2 TEXT40
PayerName3 Name 3 TEXT40
CityName City TEXT25
PhoneNumber First telephone no.: dialling code+number CHAR30
StreetPrefixName Street 2 TEXT40
StreetName Street TEXT60
HouseNumber House Number TEXT10
CompanyCodeName Name of Company Code or Company TEXT25
CompanyPostalCode null
Language Language Key SPRAS
SupplierFullName Supplier Full Name TEXT220
BusinessPartnerCountry Business Partner Country/Region Key LAND1
BusinessPartnerCountryName Country/Region Name TEXT50
CustomerSupplierCityName Business partner City Name TEXT40
CustomerSupplierStreetName Business Partner Street Name TEXT60
OrganizationBPName1 null
OrganizationBPName2 null
BPStPrefixName Street 2 TEXT40
BPRgn null
RegionName Description TEXT20
BusPartPOBoxDvtgCityName Business Partner PO Box Deviating City Name TEXT40
CustomerSupplierHouseNumber null
US_PayeeMailingAddress Character field of length 40 CHAR40
BPTaxNumber Business Partner Tax Number BPTAXNUM
TaxNumber1 Business Partner Tax Number BPTAXNUM
TaxNumber2 Business Partner Tax Number BPTAXNUM
TaxNumber4 null
TaxNumber5 Business Partner Tax Number BPTAXNUM
CustomerSupplierPostalCode null
BusPartPOBox null
WithholdingTaxCountry Withholding Tax Country/Region Key QLAND
SupplierRegion null
US_TaxState null
WithholdingTaxExmptPercent null
PayerRegion null
PayerCountryName null
US_FrgnSuplrHasWhldgAllowance null
US_FrgnAcctTxCmplncIdentifier null
WithholdingTaxPercent Withholding Tax Rate PRZ34
RecipientType Type of Recipient WT_QSREC
ExemptionReason Reason for Exemption WT_WTEXRS
US_PyeTypeOfTin Character Field with Length 10 CHAR10
TaxRate Withholding Tax Rate PRZ34
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, ...)
  • Region for PO Box (Country/Region, State, Province, ...)
  • Client
  • ?
  • I_US_STRPFRGNVNDRWHLDGTXITM.BUSPARTPOBOXRGN == T005S.BLAND
  • I_US_STRPFRGNVNDRWHLDGTXITM.MANDT == T005S.MANDT
  • I_US_STRPFRGNVNDRWHLDGTXITM.[column in domain "LAND1"] == T005S.LAND1
City code for city/street file
  • Client
  • City code for city/street file
  • ?
  • I_US_STRPFRGNVNDRWHLDGTXITM.MANDT == ADRCITY.CLIENT
  • I_US_STRPFRGNVNDRWHLDGTXITM.CITYCODE == ADRCITY.CITY_CODE
  • I_US_STRPFRGNVNDRWHLDGTXITM.[column in domain "LAND1"] == ADRCITY.COUNTRY
Company Code
  • Client
  • Company Code
  • I_US_STRPFRGNVNDRWHLDGTXITM.MANDT == T001.MANDT
  • I_US_STRPFRGNVNDRWHLDGTXITM.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Country/Region Key
  • Client
  • I_US_STRPFRGNVNDRWHLDGTXITM.COUNTRY == T005.LAND1
  • I_US_STRPFRGNVNDRWHLDGTXITM.MANDT == T005.MANDT
Official Withholding Tax Key
  • Country/Region Key
  • Official Withholding Tax Key
  • Client
  • I_US_STRPFRGNVNDRWHLDGTXITM.COUNTRY == T059O.LAND1
  • I_US_STRPFRGNVNDRWHLDGTXITM.OFFICIALWHLDGTAXCODE == T059O.WT_QSCOD
  • I_US_STRPFRGNVNDRWHLDGTXITM.MANDT == T059O.MANDT
Region code
  • Region (State, Province, County)
  • Client
  • ?
  • I_US_STRPFRGNVNDRWHLDGTXITM.REGION == T005S.BLAND
  • I_US_STRPFRGNVNDRWHLDGTXITM.MANDT == T005S.MANDT
  • I_US_STRPFRGNVNDRWHLDGTXITM.[column in domain "LAND1"] == T005S.LAND1
Reporting Entity
  • Reporting Entity
  • Client
  • I_US_STRPFRGNVNDRWHLDGTXITM.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • I_US_STRPFRGNVNDRWHLDGTXITM.MANDT == SRF_RPG_ENT.MANDT
Foreign Key for Add. Withholding Tax Code
  • Country/Region Key
  • Withholding Tax Key
  • Client
Withholding Tax Code
  • Country/Region Key
  • Client
  • Indicator for Withholding Tax Type
  • Withholding Tax Code
  • I_US_STRPFRGNVNDRWHLDGTXITM.COUNTRY == T059Z.LAND1
  • I_US_STRPFRGNVNDRWHLDGTXITM.MANDT == T059Z.MANDT
  • I_US_STRPFRGNVNDRWHLDGTXITM.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • I_US_STRPFRGNVNDRWHLDGTXITM.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
Indicator for Withholding Tax Type
  • Country/Region Key
  • Client
  • Indicator for Withholding Tax Type
  • I_US_STRPFRGNVNDRWHLDGTXITM.COUNTRY == T059P.LAND1
  • I_US_STRPFRGNVNDRWHLDGTXITM.MANDT == T059P.MANDT
  • I_US_STRPFRGNVNDRWHLDGTXITM.WITHHOLDINGTAXTYPE == T059P.WITHT