C_ES_StRp190WhldgTaxItemCube

Spain Modelo-190 Wth Tax Itm View - Cube | view: CES190GWHLDG | TRAN | 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
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
Column Name Description Domain name
ItemIsReportingRelevant null
WhldgTaxDocumentType null
BusinessPartner Business Partner Number BU_PARTNER
WithholdingTaxPercent Withholding Tax Rate PRZ34
WithholdingTaxIncomeType Income Type QEKAR
ES_IncomeNature null
EsIncTypeClassfctn null
FileName null
ES_TaxReturnType null
ES_SrvcIsDlvrdInAutonomousCity null
AuthorizationGroup Authorization Group BRGRU
IsNaturalPerson null
SupplierFullName Supplier Full Name
SupplierName Name of Supplier TEXT80
AddressText Withholdee's address for Modelo 296 CHAR50
SupplierAddress Third-party Supplier Address Information FIPH_TEXT
RegionName Description TEXT20
CustomerSupplierPostalCode Component of the Version Number CHAR2
TaxCountryName null
ProvincialTaxCode null
CustomerSupplierCityName null
TaxNumber1 Field of length 16 CHAR16
BPTaxNumber Business Partner Tax Number BPTAXNUM
BusinessPartnerBirthplaceName Birthplace of business partner TEXT40
VATRegistration Character field of 9 digits CHAR9
CompanyCodeName Character field of length 40 CHAR40
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_ES_STRP190WHLDGTAXITEMCUBE.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • C_ES_STRP190WHLDGTAXITEMCUBE.COUNTRY == T005.LAND1
  • C_ES_STRP190WHLDGTAXITEMCUBE.MANDT == T005.MANDT
Company Code
  • Company Code
  • Client
  • C_ES_STRP190WHLDGTAXITEMCUBE.COMPANYCODE == T001.BUKRS
  • C_ES_STRP190WHLDGTAXITEMCUBE.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_ES_STRP190WHLDGTAXITEMCUBE.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • C_ES_STRP190WHLDGTAXITEMCUBE.COUNTRY == T005.LAND1
  • C_ES_STRP190WHLDGTAXITEMCUBE.MANDT == T005.MANDT
Supplier
  • Account Number of Supplier
  • Supplier
  • Client
  • C_ES_STRP190WHLDGTAXITEMCUBE.SUPPLIER == LFA1.LIFNR
  • C_ES_STRP190WHLDGTAXITEMCUBE.CREDITOR == LFA1.LIFNR
  • C_ES_STRP190WHLDGTAXITEMCUBE.MANDT == LFA1.MANDT
Customer Number
  • Customer Number
  • Client
  • C_ES_STRP190WHLDGTAXITEMCUBE.DEBTOR == KNA1.KUNNR
  • C_ES_STRP190WHLDGTAXITEMCUBE.MANDT == KNA1.MANDT
Account number of the master record with fiscal address
  • Account number of the master record with fiscal address
  • Client
  • C_ES_STRP190WHLDGTAXITEMCUBE.FISCALADDRESS == LFA1.LIFNR
  • C_ES_STRP190WHLDGTAXITEMCUBE.MANDT == LFA1.MANDT
Country/Region of Origin: Non-Resident Companies
  • Country/Region of Origin: Non-Resident Companies
  • Client
  • C_ES_STRP190WHLDGTAXITEMCUBE.NONRESIDENTCOMPANYORIGINCNTRY == T005.LAND1
  • C_ES_STRP190WHLDGTAXITEMCUBE.MANDT == T005.MANDT
Region code
  • ?
  • Region (State, Province, County)
  • Client
  • C_ES_STRP190WHLDGTAXITEMCUBE.[column in domain "LAND1"] == T005S.LAND1
  • C_ES_STRP190WHLDGTAXITEMCUBE.REGION == T005S.BLAND
  • C_ES_STRP190WHLDGTAXITEMCUBE.MANDT == T005S.MANDT
Reporting Entity
  • Reporting Entity
  • Client
  • C_ES_STRP190WHLDGTAXITEMCUBE.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • C_ES_STRP190WHLDGTAXITEMCUBE.MANDT == SRF_RPG_ENT.MANDT
Vendor account group
  • Client
  • Vendor account group
  • C_ES_STRP190WHLDGTAXITEMCUBE.MANDT == T077K.MANDT
  • C_ES_STRP190WHLDGTAXITEMCUBE.SUPPLIERACCOUNTGROUP == T077K.KTOKK
Type of Recipient
  • Country/Region Key
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Client
  • Type of Recipient
  • C_ES_STRP190WHLDGTAXITEMCUBE.BUSINESSPARTNERCOUNTRY == T059C.LAND1
  • C_ES_STRP190WHLDGTAXITEMCUBE.COUNTRY == T059C.LAND1
  • C_ES_STRP190WHLDGTAXITEMCUBE.WITHHOLDINGTAXTYPE == T059C.WITHT
  • C_ES_STRP190WHLDGTAXITEMCUBE.MANDT == T059C.MANDT
  • C_ES_STRP190WHLDGTAXITEMCUBE.SUPPLIERRECIPIENTTYPE == T059C.QSREC
Withholding Tax Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • Withholding Tax Key
  • C_ES_STRP190WHLDGTAXITEMCUBE.BUSINESSPARTNERCOUNTRY == T059Z_WITHCD2.LAND1
  • C_ES_STRP190WHLDGTAXITEMCUBE.COUNTRY == T059Z_WITHCD2.LAND1
  • C_ES_STRP190WHLDGTAXITEMCUBE.MANDT == T059Z_WITHCD2.MANDT
  • C_ES_STRP190WHLDGTAXITEMCUBE.WHLDGTAXREFERENCETEXT == T059Z_WITHCD2.WITHCD2
Withholding Tax Code
  • Country/Region Key
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Client
  • Withholding Tax Code
  • C_ES_STRP190WHLDGTAXITEMCUBE.BUSINESSPARTNERCOUNTRY == T059Z.LAND1
  • C_ES_STRP190WHLDGTAXITEMCUBE.COUNTRY == T059Z.LAND1
  • C_ES_STRP190WHLDGTAXITEMCUBE.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • C_ES_STRP190WHLDGTAXITEMCUBE.MANDT == T059Z.MANDT
  • C_ES_STRP190WHLDGTAXITEMCUBE.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
Indicator for Withholding Tax Type
  • Country/Region Key
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Client
  • C_ES_STRP190WHLDGTAXITEMCUBE.BUSINESSPARTNERCOUNTRY == T059P.LAND1
  • C_ES_STRP190WHLDGTAXITEMCUBE.COUNTRY == T059P.LAND1
  • C_ES_STRP190WHLDGTAXITEMCUBE.WITHHOLDINGTAXTYPE == T059P.WITHT
  • C_ES_STRP190WHLDGTAXITEMCUBE.MANDT == T059P.MANDT