I_ES_StRpWhldgTaxItem

Spain Withholding Tax Reporting | view: ISRESWHLDGTXITM | TRAN | Extraction: Not supported | Component: Withholding Tax Reporting
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, T005U, LFA1, CVI_VEND_LINK, T001, T014, T059P, FIWTES_WHTKEY, 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
ES_WhldgReportType Report Type Show values
Column Name Description
💲 Company Code Currency (ReportingCurrency):
WhldgTaxExmptAmtInCoCodeCrcy Amount Exempt from Withholding Tax in Local Currency
WhldgTaxExmptAmtInTransacCrcy Amount Exempt from Withholding Tax in Document Currency
WhldgTaxBaseAmtInCoCodeCrcy null
WhldgTaxAmtInCoCodeCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ReportingDate Reporting Date
BirthDate Date of Birth of the Person Subject to Withholding Tax
Column Name Description
ES_WhldgReportType Report Type Show values
FinancialAccountType Account type Show values
IsReversed Indicator: Item is Reversed Show values
IsReversal Indicator: Item is Reversing Another Item Show values
BusinessPartnerCategory Business Partner Category Show values
Column Name Description Domain name
WithholdingTaxIncomeType Income Type
ES_IncomeNature null
EsIncTypeClassfctn null
WithholdingTaxPercent Withholding Tax Rate PRZ34
ItemIsReportingRelevant null
WhldgTaxDocumentType null
AuthorizationGroup Authorization Group BRGRU
Supplier Account Number of Supplier LIFNR
BusinessPartner Business Partner Number BU_PARTNER
IsNaturalPerson null
SupplierFullName Supplier Full Name
SupplierName Name of Supplier TEXT80
SupplierAddress Third-party Supplier Address Information FIPH_TEXT
AddressText Withholdee's address for Modelo 296 CHAR50
CustomerSupplierCityName null
RegionName Description TEXT20
CustomerSupplierPostalCode Component of the Version Number
PostalCode null
TaxNumber1 Tax Number 1
TaxNumber2 null
TaxNumber3 null
TaxNumber4 null
TaxNumber5 null
BusinessPartnerBirthplaceName Birthplace of business partner TEXT40
Language Language Key SPRAS
VATRegistration VAT Registration Number
CompanyCodeName null
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • I_ES_STRPWHLDGTAXITEM.COUNTRY == T005.LAND1
  • I_ES_STRPWHLDGTAXITEM.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • I_ES_STRPWHLDGTAXITEM.MANDT == T005.MANDT
Company Code
  • Company Code
  • Client
  • I_ES_STRPWHLDGTAXITEM.COMPANYCODE == T001.BUKRS
  • I_ES_STRPWHLDGTAXITEM.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • I_ES_STRPWHLDGTAXITEM.COUNTRY == T005.LAND1
  • I_ES_STRPWHLDGTAXITEM.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • I_ES_STRPWHLDGTAXITEM.MANDT == T005.MANDT
Supplier
  • Account Number of Supplier
  • Supplier
  • Client
  • I_ES_STRPWHLDGTAXITEM.SUPPLIER == LFA1.LIFNR
  • I_ES_STRPWHLDGTAXITEM.CREDITOR == LFA1.LIFNR
  • I_ES_STRPWHLDGTAXITEM.MANDT == LFA1.MANDT
Customer Number
  • Customer Number
  • Client
  • I_ES_STRPWHLDGTAXITEM.DEBTOR == KNA1.KUNNR
  • I_ES_STRPWHLDGTAXITEM.MANDT == KNA1.MANDT
Account number of the master record with fiscal address
  • Account number of the master record with fiscal address
  • Client
  • I_ES_STRPWHLDGTAXITEM.FISCALADDRESS == LFA1.LIFNR
  • I_ES_STRPWHLDGTAXITEM.MANDT == LFA1.MANDT
Country/Region of Origin: Non-Resident Companies
  • Client
  • Country/Region of Origin: Non-Resident Companies
  • I_ES_STRPWHLDGTAXITEM.MANDT == T005.MANDT
  • I_ES_STRPWHLDGTAXITEM.NONRESIDENTCOMPANYORIGINCNTRY == T005.LAND1
Provincial Tax Code
  • Country/Region Key
  • Country/Region Key
  • Provincial Tax Code
  • Client
  • ?
  • I_ES_STRPWHLDGTAXITEM.COUNTRY == T005P.LAND1
  • I_ES_STRPWHLDGTAXITEM.BUSINESSPARTNERCOUNTRY == T005P.LAND1
  • I_ES_STRPWHLDGTAXITEM.PROVINCIALTAXCODE == T005P.FPRCD
  • I_ES_STRPWHLDGTAXITEM.MANDT == T005P.MANDT
  • I_ES_STRPWHLDGTAXITEM.[column in domain "REGIO"] == T005P.BLAND
Region code
  • Region (State, Province, County)
  • Client
  • ?
  • I_ES_STRPWHLDGTAXITEM.REGION == T005S.BLAND
  • I_ES_STRPWHLDGTAXITEM.MANDT == T005S.MANDT
  • I_ES_STRPWHLDGTAXITEM.[column in domain "LAND1"] == T005S.LAND1
Reporting Entity
  • Reporting Entity
  • Client
  • I_ES_STRPWHLDGTAXITEM.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • I_ES_STRPWHLDGTAXITEM.MANDT == SRF_RPG_ENT.MANDT
Vendor account group
  • Client
  • Vendor account group
  • I_ES_STRPWHLDGTAXITEM.MANDT == T077K.MANDT
  • I_ES_STRPWHLDGTAXITEM.SUPPLIERACCOUNTGROUP == T077K.KTOKK
Type of Recipient
  • Country/Region Key
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Client
  • Type of Recipient
  • I_ES_STRPWHLDGTAXITEM.COUNTRY == T059C.LAND1
  • I_ES_STRPWHLDGTAXITEM.BUSINESSPARTNERCOUNTRY == T059C.LAND1
  • I_ES_STRPWHLDGTAXITEM.WITHHOLDINGTAXTYPE == T059C.WITHT
  • I_ES_STRPWHLDGTAXITEM.MANDT == T059C.MANDT
  • I_ES_STRPWHLDGTAXITEM.SUPPLIERRECIPIENTTYPE == T059C.QSREC
Withholding Tax Key
  • Country/Region Key
  • Country/Region Key
  • Withholding Tax Key
  • Client
Withholding Tax Code
  • Country/Region Key
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Client
  • Withholding Tax Code
  • I_ES_STRPWHLDGTAXITEM.COUNTRY == T059Z.LAND1
  • I_ES_STRPWHLDGTAXITEM.BUSINESSPARTNERCOUNTRY == T059Z.LAND1
  • I_ES_STRPWHLDGTAXITEM.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • I_ES_STRPWHLDGTAXITEM.MANDT == T059Z.MANDT
  • I_ES_STRPWHLDGTAXITEM.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
Indicator for Withholding Tax Type
  • Country/Region Key
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Client
  • I_ES_STRPWHLDGTAXITEM.COUNTRY == T059P.LAND1
  • I_ES_STRPWHLDGTAXITEM.BUSINESSPARTNERCOUNTRY == T059P.LAND1
  • I_ES_STRPWHLDGTAXITEM.WITHHOLDINGTAXTYPE == T059P.WITHT
  • I_ES_STRPWHLDGTAXITEM.MANDT == T059P.MANDT