Application Platform (AP)
Basis Components (BC)
Business Mobile (MOB)
Business Network Solutions (BNS)
Controlling (CO)
Cross-Application Components (CA)
Cross-Application Components (CA)
Customer Relationship Management (CRM)
Enterprise Contract Management (CM)
Enterprise Controlling (EC)
Enterprise information management solutions (EIM)
Environment, Health, and Safety / Product Compliance (EHS)
Financial Accounting (FI)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Additional Functions (FI-AF)
- Asset Accounting (FI-AA)
- Bank Accounting (FI-BL)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Financial Supply Chain Management (FIN-FSCM)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Localization (FI-LOC)
  - ACR Activities (FI-LOC-VAT)
  - Audit Reporting (FI-LOC-AUR)
  - Cash Flow Localization (FI-LOC-CF)
  - Cash Management (FI-LOC-CM)
  - Contract Accounts Receivable and Payable (FI-LOC-CA)
  - Corporate Income Tax Framework (FI-LOC-CIT)
  - Globalization Service: Business Place (FI-LOC-BUP)
  - Golden Audit Interface (FI-LOC-GAI)
  - Localization Asset Accounting (FI-LOC-AA)
  - Localization E-Payment Integration (FI-LOC-EPI)
  - Localization Financials (FI-LOC-FI)
    - Financials Arabic Emirates (FI-LOC-FI-AE)
    - Financials Argentina (FI-LOC-FI-AR)
    - Financials Austria (FI-LOC-FI-AT)
    - Financials Belgium (FI-LOC-FI-BE)
    - Financials Brazil (FI-LOC-FI-BR)
    - Financials Chile (FI-LOC-FI-CL)
    - Financials China (FI-LOC-FI-CN)
    - Financials Colombia (FI-LOC-FI-CO)
    - Financials Czech Republic (FI-LOC-FI-CZ)
    - Financials Denmark (FI-LOC-FI-DK)
    - Financials Egypt (FI-LOC-FI-EG)
    - Financials France (FI-LOC-FI-FR)
    - Financials Germany (FI-LOC-FI-DE)
    - Financials Great Britain (FI-LOC-FI-GB)
    - Financials Hungary (FI-LOC-FI-HU)
    - Financials Indonesia (FI-LOC-FI-ID)
    - Financials Ireland (FI-LOC-FI-IE)
    - Financials Israel (FI-LOC-FI-IL)
    - Financials Italy (FI-LOC-FI-IT)
    - Financials Japan (FI-LOC-FI-JP)
    - Financials Kazakhastan (FI-LOC-FI-KZ)
    - Financials Luxembourg (FI-LOC-FI-LU)
    - Financials Malaysia (FI-LOC-FI-MY)
    - Financials Mexico (FI-LOC-FI-MX)
    - Financials Netherlands (FI-LOC-FI-NL)
    - Financials New Zealand (FI-LOC-FI-NZ)
    - Financials Norway (FI-LOC-FI-NO)
    - Financials Peru (FI-LOC-FI-PE)
    - Financials Philippines (FI-LOC-FI-PH)
    - Financials Poland (FI-LOC-FI-PL)
    - Financials Portugal (FI-LOC-FI-PT)
    - Financials Qatar (FI-LOC-FI-QA)
    - Financials Romania (FI-LOC-FI-RO)
    - Financials Russia (FI-LOC-FI-RU)
    - Financials Singapore (FI-LOC-FI-SG)
    - Financials Slovak republic (FI-LOC-FI-SK)
    - Financials Slovenia (FI-LOC-FI-SI)
    - Financials South Korea (FI-LOC-FI-KR)
    - Financials Spain (FI-LOC-FI-ES)
    - Financials Sweden (FI-LOC-FI-SE)
    - Financials Switzerland (FI-LOC-FI-CH)
    - Financials Taiwan (FI-LOC-FI-TW)
    - Financials Thailand (FI-LOC-FI-TH)
    - Financials Turkey (FI-LOC-FI-TR)
    - Financials USA (FI-LOC-FI-US)
    - Financials Ukraine (FI-LOC-FI-UA)
    - Financials Venezuela (FI-LOC-FI-VE)
  - Localization Financials (generic parts) (FI-LOC-GEN)
  - Localization Financials EC Sales List (FI-LOC-ECS)
  - Localization Financials Statements (FI-LOC-FS)
  - Localization Funds Management (FI-LOC-FM)
  - Localization Logistics (FI-LOC-LO)
  - Localization for Utilities Industry (FI-LOC-UT)
  - Payment Receipt (FI-LOC-PR)
  - SAF-T Reporting (Generic Part) (FI-LOC-SAF)
  - Statutory Reporting (FI-LOC-IS)
  - Statutory Reporting Framework (FI-LOC-SRF)
  - Tax Invoice Management (FI-LOC-TIM)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Tax Subledger (FI-TXL)
Financial Services (FS)
Global Trade Services (SLL)
Investment Management (IM)
LOD Components (LOD)
Legal Content Management (LCM)
Logistics - General (LO)
Logistics Execution (LE)
Materials Management (MM)
Occasional Platform User (OPU)
Payroll (PY)
Personnel Management (PA)
Plant Maintenance (PM)
Portfolio and Project Management (PPM)
Product Lifecycle Management (PLM)
Production Planning and Control (PP)
Project System (PS)
Public Sector Management (PSM)
Purchasing SAP Cloud (PUR)
Quality Management (QM)
Real Estate Management (RE)
SAP Business Warehouse (BW)
SAP Supplier Lifecycle Management (SLC)
Sales and Distribution (SD)
Service (SV)
Supply Chain Management (SCM)
Sustainability management (SUS)
Transportation Management (TM)

I_US_StRp1099MiscWhldgTxItm

US 1099 MISC Reporting | view: IUS1099MSCWHLDG | 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, T001, TKA02, KNA1, CVI_CUST_LINK, T059Z, T005S, T000, LFA1, LFB1, CVI_VEND_LINK, T001, T014, SRF_RPG_PAR, T059P, T059L, WTREPDATE, SRF_RPG_CAT4

🔑 Keys (10)
💰 Amounts (19)
∑ Quantities
📅 Dates (4)
☰ Categorical (4)
Other (38)
🔗 Relations (9)

Column Name	Description
BusinessPartner	Business Partner Number
BPRgn	null
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
US_RentsWhldgTaxBaseAmt	Withholding Tax Base Amount in Company Code Currency
US_RoyaltiesWhldgTaxBaseAmt	Withholding Tax Base Amount in Company Code Currency
US_OtherIncomeWhldgTaxBaseAmt	Withholding Tax Base Amount in Company Code Currency
US_FishingBoatWhldgTaxBaseAmt	Withholding Tax Base Amount in Company Code Currency
US_MedicalWhldgTaxBaseAmt	Withholding Tax Base Amount in Company Code Currency
US_NonEmplCompnWhldgTaxBaseAmt	Withholding Tax Base Amount in Company Code Currency
US_DividendWhldgTaxBaseAmt	Withholding Tax Base Amount in Company Code Currency
US_DirectSaleWhldgTaxBaseAmt	Withholding Tax Base Amount in Company Code Currency
US_CropInsurWhldgTaxBaseAmt	Withholding Tax Base Amount in Company Code Currency
US_FishResaleWhldgTaxBaseAmt	Withholding Tax Base Amount in Company Code Currency
US_ExcessGldnWhldgTxBaseAmt	Withholding Tax Base Amount in Company Code Currency
US_AttrnyPaytWhldgTaxBaseAmt	Withholding Tax Base Amount in Company Code Currency
US_SctnDeferralWhldgTaxBaseAmt	Withholding Tax Base Amount in Company Code Currency
US_SctnIncomeWhldgTaxBaseAmt	Withholding Tax Base Amount in Company Code Currency
WhldgTxStateIncBaseAmtInCoCrcy	Withholding Tax Amount in Company Code Currency
US_FederalTaxAmtInCoCodeCrcy	Withholding Tax Amount in Company Code Currency

Column Name	Description

Column Name	Description
PostingDate	Posting Date
DocumentDate	Journal Entry Date
ReportingDate	Reporting Date
ClearingDate	Clearing Date

Column Name	Description
US_ReportingType	1099 Reporting Type	Show values
US_DirectSalesCode	US Direct Sales Indicator	Show values
US_SecondTINNoticeIsIssued	Second TIN Notice from IRS	Show values
US_FrgnAcctTaxFilingIsRequired	US FATCA Indicator	Show values

Column Name	Description	Domain name
WhldgTxCodeGrp	1 Byte Unsigned Integer	INT1
US_1099HasRegionRecord	null
ProvincialTaxCode	Provincial Tax Code	FPRCD
BusinessPartnerName1	null
BusinessPartnerName2	null
BusinessPartnerName3	null
CompanyCodeName	Name of Company Code or Company	TEXT25
CompanyPostalCode	City postal code	CHAR10
CustomerSupplierCityName	Business partner City Name	TEXT40
PhoneNumber	First telephone no.: dialling code+number	CHAR30
US_PayeeAddressIsInFrgnCntry	null
FrgnBP	Foreign Business Partner	CHAR1
SupplierFullName	Supplier Full Name	TEXT220
BusinessPartnerCountry	Business Partner Country/Region Key	LAND1
CustomerSupplierPostalCode	Business Partner Postal Code	CHAR10
CustomerSupplierStreetName	Business Partner Street Name	TEXT60
Language	Language Key	SPRAS
BPStPrefixName	Street 2	TEXT40
BusPartPOBoxDvtgCityName	Business Partner PO Box Deviating City Name	TEXT40
CustomerSupplierHouseNumber	null
BPHsNmbrSuplmntTxt	Business Partner House Number Supplement Text	TEXT10
TaxNumber1	Tax Number 1	STCD1
TaxNumber2	Tax Number 2	STCD2
TaxNumber5	Tax Number 5	CHAR60
BusPartPOBoxPostlCode	Business Partner PO Box Postal Code
BusPartPOBox	null
BPTaxNumber	Tax Number 1	STCD1
WithholdingTaxCountry	Withholding Tax Country/Region Key	QLAND
SupplierRegion	null
AlternativePayeeAccountNumber	Account Number of the Alternative Payee	LIFNR
US_PayeeMailingAddress	Character field of length 40	CHAR40
PayeeCityName	null
PayeeRegion	Region for PO Box (Country/Region, State, Province, ...)	REGIO
PayeePostalCode	null
CustomerSupplierAddress	null
US_PyeTypeOfTin	Character Field with Length 10	CHAR10
US_MinCombinedAmountIsRqd	Character Field of Length 1	CHAR1
US_1099IsBusinessPartnerValid	null

Master Data Relations	Join Conditions
Region for PO Box (Country/Region, State, Province, ...) Client ? Region for PO Box (Country/Region, State, Province, ...)	`I_US_STRP1099MISCWHLDGTXITM.MANDT == T005S.MANDT` `I_US_STRP1099MISCWHLDGTXITM.[column in domain "LAND1"] == T005S.LAND1` `I_US_STRP1099MISCWHLDGTXITM.BUSPARTPOBOXRGN == T005S.BLAND`
City code for city/street file Client City code for city/street file ?	`I_US_STRP1099MISCWHLDGTXITM.MANDT == ADRCITY.CLIENT` `I_US_STRP1099MISCWHLDGTXITM.CITYCODE == ADRCITY.CITY_CODE` `I_US_STRP1099MISCWHLDGTXITM.[column in domain "LAND1"] == ADRCITY.COUNTRY`
Company Code Company Code Client	`I_US_STRP1099MISCWHLDGTXITM.COMPANYCODE == T001.BUKRS` `I_US_STRP1099MISCWHLDGTXITM.MANDT == T001.MANDT`
Country/Region Key Country/Region Key Client	`I_US_STRP1099MISCWHLDGTXITM.COUNTRY == T005.LAND1` `I_US_STRP1099MISCWHLDGTXITM.MANDT == T005.MANDT`
Official Withholding Tax Key Country/Region Key Official Withholding Tax Key Client	`I_US_STRP1099MISCWHLDGTXITM.COUNTRY == T059O.LAND1` `I_US_STRP1099MISCWHLDGTXITM.OFFICIALWHLDGTAXCODE == T059O.WT_QSCOD` `I_US_STRP1099MISCWHLDGTXITM.MANDT == T059O.MANDT`
Reporting Entity Reporting Entity Client	`I_US_STRP1099MISCWHLDGTXITM.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY` `I_US_STRP1099MISCWHLDGTXITM.MANDT == SRF_RPG_ENT.MANDT`
Foreign Key for Add. Withholding Tax Code Country/Region Key Client Withholding Tax Key	`I_US_STRP1099MISCWHLDGTXITM.COUNTRY == T059Z_WITHCD2.LAND1` `I_US_STRP1099MISCWHLDGTXITM.MANDT == T059Z_WITHCD2.MANDT` `I_US_STRP1099MISCWHLDGTXITM.WHLDGTAXREFERENCETEXT == T059Z_WITHCD2.WITHCD2`
Withholding Tax Code Withholding Tax Code Country/Region Key Indicator for Withholding Tax Type Client	`I_US_STRP1099MISCWHLDGTXITM.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD` `I_US_STRP1099MISCWHLDGTXITM.COUNTRY == T059Z.LAND1` `I_US_STRP1099MISCWHLDGTXITM.WITHHOLDINGTAXTYPE == T059Z.WITHT` `I_US_STRP1099MISCWHLDGTXITM.MANDT == T059Z.MANDT`
Indicator for Withholding Tax Type Country/Region Key Indicator for Withholding Tax Type Client	`I_US_STRP1099MISCWHLDGTXITM.COUNTRY == T059P.LAND1` `I_US_STRP1099MISCWHLDGTXITM.WITHHOLDINGTAXTYPE == T059P.WITHT` `I_US_STRP1099MISCWHLDGTXITM.MANDT == T059P.MANDT`