C_ES_StRp190WhldgTaxItemQuery

Spain Modelo-190 Wth Tax Itm View-Query | view: CES190GWHLDGQ | Extraction: Not supported | Component: Withholding Tax Reporting
Tables used: BKPF, BSEC, SRF_RPG_ACT, ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, SRF_RPG_PHASE, SRF_REP_RUN, SRF_REPORTING, ACCT_SRF_RPIT_WI, WITH_ITEM, BKPF, BSEG, ADCP, ADRC, ADR6, BUT000, DFKKBPTAXNUM, 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
Supplier Account Number of Supplier
WhldgTaxReferenceText FK Withholding Tax Key
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
WithholdingTaxCode FK Withholding Tax Code
PostingDate Posting Date
AccountingDocument Document Number of an Accounting Document
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
WhldgTaxAmtInCoCodeCrcy null
WhldgTaxBaseAmtInCoCodeCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ReportingDate Reporting Date
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
Column Name Description Domain name
ItemIsReportingRelevant null
WhldgTaxDocumentType null
ProvincialTaxCode null
BusinessPartner Business Partner Number BU_PARTNER
WithholdingTaxPercent Withholding Tax Rate PRZ34
WithholdingTaxIncomeType Income Type QEKAR
ES_IncomeNature null
EsIncTypeClassfctn null
ES_TaxModel190NumberOfIncomes null
FileName null
ES_TaxReturnType null
ES_SrvcIsDlvrdInAutonomousCity 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
RegionName Description TEXT20
CustomerSupplierPostalCode Component of the Version Number CHAR2
BPTaxNumber Business Partner Tax Number BPTAXNUM
VATRegistration Character field of 9 digits
CompanyCodeName Character field of length 40
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_ES_STRP190WHLDGTAXITEMQUERY.COUNTRY == T005.LAND1
  • C_ES_STRP190WHLDGTAXITEMQUERY.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • C_ES_STRP190WHLDGTAXITEMQUERY.MANDT == T005.MANDT
Company Code
  • Company Code
  • Client
  • C_ES_STRP190WHLDGTAXITEMQUERY.COMPANYCODE == T001.BUKRS
  • C_ES_STRP190WHLDGTAXITEMQUERY.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_ES_STRP190WHLDGTAXITEMQUERY.COUNTRY == T005.LAND1
  • C_ES_STRP190WHLDGTAXITEMQUERY.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • C_ES_STRP190WHLDGTAXITEMQUERY.MANDT == T005.MANDT
Supplier
  • Client
  • Supplier
  • Account Number of Supplier
  • C_ES_STRP190WHLDGTAXITEMQUERY.MANDT == LFA1.MANDT
  • C_ES_STRP190WHLDGTAXITEMQUERY.CREDITOR == LFA1.LIFNR
  • C_ES_STRP190WHLDGTAXITEMQUERY.SUPPLIER == LFA1.LIFNR
Customer Number
  • Customer Number
  • Client
  • C_ES_STRP190WHLDGTAXITEMQUERY.DEBTOR == KNA1.KUNNR
  • C_ES_STRP190WHLDGTAXITEMQUERY.MANDT == KNA1.MANDT
Account number of the master record with fiscal address
  • Client
  • Account number of the master record with fiscal address
  • C_ES_STRP190WHLDGTAXITEMQUERY.MANDT == LFA1.MANDT
  • C_ES_STRP190WHLDGTAXITEMQUERY.FISCALADDRESS == LFA1.LIFNR
Region code
  • ?
  • Client
  • Region (State, Province, County)
  • C_ES_STRP190WHLDGTAXITEMQUERY.[column in domain "LAND1"] == T005S.LAND1
  • C_ES_STRP190WHLDGTAXITEMQUERY.MANDT == T005S.MANDT
  • C_ES_STRP190WHLDGTAXITEMQUERY.REGION == T005S.BLAND
Reporting Entity
  • Client
  • Reporting Entity
  • C_ES_STRP190WHLDGTAXITEMQUERY.MANDT == SRF_RPG_ENT.MANDT
  • C_ES_STRP190WHLDGTAXITEMQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Type of Recipient
  • Country/Region Key
  • Country/Region Key
  • Client
  • Type of Recipient
  • Indicator for Withholding Tax Type
  • C_ES_STRP190WHLDGTAXITEMQUERY.COUNTRY == T059C.LAND1
  • C_ES_STRP190WHLDGTAXITEMQUERY.BUSINESSPARTNERCOUNTRY == T059C.LAND1
  • C_ES_STRP190WHLDGTAXITEMQUERY.MANDT == T059C.MANDT
  • C_ES_STRP190WHLDGTAXITEMQUERY.SUPPLIERRECIPIENTTYPE == T059C.QSREC
  • C_ES_STRP190WHLDGTAXITEMQUERY.WITHHOLDINGTAXTYPE == T059C.WITHT
Withholding Tax Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • Withholding Tax Key
  • C_ES_STRP190WHLDGTAXITEMQUERY.COUNTRY == T059Z_WITHCD2.LAND1
  • C_ES_STRP190WHLDGTAXITEMQUERY.BUSINESSPARTNERCOUNTRY == T059Z_WITHCD2.LAND1
  • C_ES_STRP190WHLDGTAXITEMQUERY.MANDT == T059Z_WITHCD2.MANDT
  • C_ES_STRP190WHLDGTAXITEMQUERY.WHLDGTAXREFERENCETEXT == T059Z_WITHCD2.WITHCD2
Withholding Tax Code
  • Country/Region Key
  • Country/Region Key
  • Client
  • Withholding Tax Code
  • Indicator for Withholding Tax Type
  • C_ES_STRP190WHLDGTAXITEMQUERY.COUNTRY == T059Z.LAND1
  • C_ES_STRP190WHLDGTAXITEMQUERY.BUSINESSPARTNERCOUNTRY == T059Z.LAND1
  • C_ES_STRP190WHLDGTAXITEMQUERY.MANDT == T059Z.MANDT
  • C_ES_STRP190WHLDGTAXITEMQUERY.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
  • C_ES_STRP190WHLDGTAXITEMQUERY.WITHHOLDINGTAXTYPE == T059Z.WITHT
Indicator for Withholding Tax Type
  • Country/Region Key
  • Country/Region Key
  • Client
  • Indicator for Withholding Tax Type
  • C_ES_STRP190WHLDGTAXITEMQUERY.COUNTRY == T059P.LAND1
  • C_ES_STRP190WHLDGTAXITEMQUERY.BUSINESSPARTNERCOUNTRY == T059P.LAND1
  • C_ES_STRP190WHLDGTAXITEMQUERY.MANDT == T059P.MANDT
  • C_ES_STRP190WHLDGTAXITEMQUERY.WITHHOLDINGTAXTYPE == T059P.WITHT