P_US_StRp1099WhldgTxItm

US 1099 With Item | view: PUS1099WHLDGTX | 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
BusinessPartner Business Partner Number
BPRgn null
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
ClearingDate Clearing Date
ReportingDate Reporting Date
Column Name Description
US_SecondTINNoticeIsIssued Second TIN Notice from IRS Show values
US_FrgnAcctTaxFilingIsRequired US FATCA Indicator Show values
Column Name Description Domain name
WhldgTaxDocumentType null
WhldgTxCodeGrp 1 Byte Unsigned Integer INT1
CompanyCodeName Name of Company Code or Company TEXT25
CompanyPostalCode City postal code CHAR10
POBoxDeviatingCityName PO Box city TEXT40
Language Language Key SPRAS
Name Business Partner Name TEXT80
BusinessPartnerName1 null
BusinessPartnerName2 null
BusinessPartnerName3 null
CustomerSupplierCityName Business partner City Name TEXT40
PhoneNumber First telephone no.: dialling code+number CHAR30
BPStPrefixName Street 2 TEXT40
CustomerSupplierStreetName Business Partner Street Name TEXT60
CustomerSupplierHouseNumber null
BusPartPOBox null
SupplierFullName Supplier Full Name TEXT220
US_PayeeAddressIsInFrgnCntry null
BusinessPartnerCountry Business Partner Country/Region Key LAND1
PayeeCompleteAddress null
PayeeCityName null
PayeeRegion Region for PO Box (Country/Region, State, Province, ...) REGIO
PayeeState Region for PO Box (Country/Region, State, Province, ...) REGIO
PayeeZipCode null
PayeePostalCode null
PayeeAdress null
US_PayeeMailingAddress Character field of length 40 CHAR40
FrgnBP Foreign Business Partner CHAR1
CustomerSupplierPostalCode Business Partner Postal Code CHAR10
BusPartPOBoxDvtgCityName Business Partner PO Box Deviating City Name TEXT40
BPHsNmbrSuplmntTxt Business Partner House Number Supplement Text TEXT10
TaxNumber5 Tax Number 5 CHAR60
BusPartPOBoxPostlCode Business Partner PO Box Postal Code
WithholdingTaxCountry Withholding Tax Country/Region Key QLAND
WithholdingTaxPercent Withholding Tax Rate PRZ34
ProvincialTaxCode Provincial Tax Code FPRCD
US_TaxNumberWhldgTxCodeGrp Tax Number + Withholding Tax Code Group CHAR50
SupplierRegion null
US_MinCombinedAmountIsRqd Character Field of Length 1 CHAR1
US_RegionRecordIsRqd Character Field of Length 1 CHAR1
US_PyeTypeOfTin Character Field with Length 10 CHAR10
TaxNumber1 Tax Number 1 STCD1
TaxNumber2 Tax Number 2 STCD2
AlternativePayeeAccountNumber Account Number of the Alternative Payee LIFNR
Master Data Relations Join Conditions
Region for PO Box (Country/Region, State, Province, ...)
  • Region for PO Box (Country/Region, State, Province, ...)
  • ?
  • Client
  • P_US_STRP1099WHLDGTXITM.BUSPARTPOBOXRGN == T005S.BLAND
  • P_US_STRP1099WHLDGTXITM.[column in domain "LAND1"] == T005S.LAND1
  • P_US_STRP1099WHLDGTXITM.MANDT == T005S.MANDT
City code for city/street file
  • City code for city/street file
  • Client
  • ?
  • P_US_STRP1099WHLDGTXITM.CITYCODE == ADRCITY.CITY_CODE
  • P_US_STRP1099WHLDGTXITM.MANDT == ADRCITY.CLIENT
  • P_US_STRP1099WHLDGTXITM.[column in domain "LAND1"] == ADRCITY.COUNTRY
Company Code
  • Company Code
  • Client
  • P_US_STRP1099WHLDGTXITM.COMPANYCODE == T001.BUKRS
  • P_US_STRP1099WHLDGTXITM.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • P_US_STRP1099WHLDGTXITM.COUNTRY == T005.LAND1
  • P_US_STRP1099WHLDGTXITM.MANDT == T005.MANDT
Supplier
  • Supplier
  • Client
  • P_US_STRP1099WHLDGTXITM.CREDITOR == LFA1.LIFNR
  • P_US_STRP1099WHLDGTXITM.MANDT == LFA1.MANDT
Official Withholding Tax Key
  • Official Withholding Tax Key
  • Country/Region Key
  • Client
  • P_US_STRP1099WHLDGTXITM.OFFICIALWHLDGTAXCODE == T059O.WT_QSCOD
  • P_US_STRP1099WHLDGTXITM.COUNTRY == T059O.LAND1
  • P_US_STRP1099WHLDGTXITM.MANDT == T059O.MANDT
Reporting Entity
  • Client
  • Reporting Entity
  • P_US_STRP1099WHLDGTXITM.MANDT == SRF_RPG_ENT.MANDT
  • P_US_STRP1099WHLDGTXITM.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Foreign Key for Add. Withholding Tax Code
  • Withholding Tax Key
  • Country/Region Key
  • Client
Withholding Tax Code
  • Withholding Tax Code
  • Country/Region Key
  • Client
  • Indicator for Withholding Tax Type
  • P_US_STRP1099WHLDGTXITM.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
  • P_US_STRP1099WHLDGTXITM.COUNTRY == T059Z.LAND1
  • P_US_STRP1099WHLDGTXITM.MANDT == T059Z.MANDT
  • P_US_STRP1099WHLDGTXITM.WITHHOLDINGTAXTYPE == T059Z.WITHT
Indicator for Withholding Tax Type
  • Country/Region Key
  • Client
  • Indicator for Withholding Tax Type
  • P_US_STRP1099WHLDGTXITM.COUNTRY == T059P.LAND1
  • P_US_STRP1099WHLDGTXITM.MANDT == T059P.MANDT
  • P_US_STRP1099WHLDGTXITM.WITHHOLDINGTAXTYPE == T059P.WITHT