C_ES_StRp193WhldgTaxItemCube

Spain Modelo-193 Wth Tax Itm View - Cube | view: CES193GWHLDG | 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
ES_TaxModel193IncomeNature null
EsIncTypeClassfctn null
ES_TaxReturnType null
FileName 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
TaxCountryName null
ProvincialTaxCode null
CustomerSupplierCityName null
TaxNumber1 Tax Number 1 STCD1
BPTaxNumber Business Partner Tax Number BPTAXNUM
BusinessPartnerBirthplaceName Birthplace of business partner TEXT40
VATRegistration VAT Registration Number STCEG
CompanyCodeName Character field of length 40 CHAR40
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_ES_STRP193WHLDGTAXITEMCUBE.COUNTRY == T005.LAND1
  • C_ES_STRP193WHLDGTAXITEMCUBE.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • C_ES_STRP193WHLDGTAXITEMCUBE.MANDT == T005.MANDT
Company Code
  • Client
  • Company Code
  • C_ES_STRP193WHLDGTAXITEMCUBE.MANDT == T001.MANDT
  • C_ES_STRP193WHLDGTAXITEMCUBE.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_ES_STRP193WHLDGTAXITEMCUBE.COUNTRY == T005.LAND1
  • C_ES_STRP193WHLDGTAXITEMCUBE.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • C_ES_STRP193WHLDGTAXITEMCUBE.MANDT == T005.MANDT
Supplier
  • Client
  • Supplier
  • Account Number of Supplier
  • C_ES_STRP193WHLDGTAXITEMCUBE.MANDT == LFA1.MANDT
  • C_ES_STRP193WHLDGTAXITEMCUBE.CREDITOR == LFA1.LIFNR
  • C_ES_STRP193WHLDGTAXITEMCUBE.SUPPLIER == LFA1.LIFNR
Customer Number
  • Client
  • Customer Number
  • C_ES_STRP193WHLDGTAXITEMCUBE.MANDT == KNA1.MANDT
  • C_ES_STRP193WHLDGTAXITEMCUBE.DEBTOR == KNA1.KUNNR
Account number of the master record with fiscal address
  • Account number of the master record with fiscal address
  • Client
  • C_ES_STRP193WHLDGTAXITEMCUBE.FISCALADDRESS == LFA1.LIFNR
  • C_ES_STRP193WHLDGTAXITEMCUBE.MANDT == LFA1.MANDT
Country/Region of Origin: Non-Resident Companies
  • Country/Region of Origin: Non-Resident Companies
  • Client
  • C_ES_STRP193WHLDGTAXITEMCUBE.NONRESIDENTCOMPANYORIGINCNTRY == T005.LAND1
  • C_ES_STRP193WHLDGTAXITEMCUBE.MANDT == T005.MANDT
Region code
  • ?
  • Client
  • Region (State, Province, County)
  • C_ES_STRP193WHLDGTAXITEMCUBE.[column in domain "LAND1"] == T005S.LAND1
  • C_ES_STRP193WHLDGTAXITEMCUBE.MANDT == T005S.MANDT
  • C_ES_STRP193WHLDGTAXITEMCUBE.REGION == T005S.BLAND
Reporting Entity
  • Reporting Entity
  • Client
  • C_ES_STRP193WHLDGTAXITEMCUBE.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • C_ES_STRP193WHLDGTAXITEMCUBE.MANDT == SRF_RPG_ENT.MANDT
Vendor account group
  • Vendor account group
  • Client
  • C_ES_STRP193WHLDGTAXITEMCUBE.SUPPLIERACCOUNTGROUP == T077K.KTOKK
  • C_ES_STRP193WHLDGTAXITEMCUBE.MANDT == T077K.MANDT
Type of Recipient
  • Type of Recipient
  • Country/Region Key
  • Country/Region Key
  • Client
  • Indicator for Withholding Tax Type
  • C_ES_STRP193WHLDGTAXITEMCUBE.SUPPLIERRECIPIENTTYPE == T059C.QSREC
  • C_ES_STRP193WHLDGTAXITEMCUBE.COUNTRY == T059C.LAND1
  • C_ES_STRP193WHLDGTAXITEMCUBE.BUSINESSPARTNERCOUNTRY == T059C.LAND1
  • C_ES_STRP193WHLDGTAXITEMCUBE.MANDT == T059C.MANDT
  • C_ES_STRP193WHLDGTAXITEMCUBE.WITHHOLDINGTAXTYPE == T059C.WITHT
Withholding Tax Key
  • Withholding Tax Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_ES_STRP193WHLDGTAXITEMCUBE.WHLDGTAXREFERENCETEXT == T059Z_WITHCD2.WITHCD2
  • C_ES_STRP193WHLDGTAXITEMCUBE.COUNTRY == T059Z_WITHCD2.LAND1
  • C_ES_STRP193WHLDGTAXITEMCUBE.BUSINESSPARTNERCOUNTRY == T059Z_WITHCD2.LAND1
  • C_ES_STRP193WHLDGTAXITEMCUBE.MANDT == T059Z_WITHCD2.MANDT
Withholding Tax Code
  • Withholding Tax Code
  • Country/Region Key
  • Country/Region Key
  • Client
  • Indicator for Withholding Tax Type
  • C_ES_STRP193WHLDGTAXITEMCUBE.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
  • C_ES_STRP193WHLDGTAXITEMCUBE.COUNTRY == T059Z.LAND1
  • C_ES_STRP193WHLDGTAXITEMCUBE.BUSINESSPARTNERCOUNTRY == T059Z.LAND1
  • C_ES_STRP193WHLDGTAXITEMCUBE.MANDT == T059Z.MANDT
  • C_ES_STRP193WHLDGTAXITEMCUBE.WITHHOLDINGTAXTYPE == T059Z.WITHT
Indicator for Withholding Tax Type
  • Country/Region Key
  • Country/Region Key
  • Client
  • Indicator for Withholding Tax Type
  • C_ES_STRP193WHLDGTAXITEMCUBE.COUNTRY == T059P.LAND1
  • C_ES_STRP193WHLDGTAXITEMCUBE.BUSINESSPARTNERCOUNTRY == T059P.LAND1
  • C_ES_STRP193WHLDGTAXITEMCUBE.MANDT == T059P.MANDT
  • C_ES_STRP193WHLDGTAXITEMCUBE.WITHHOLDINGTAXTYPE == T059P.WITHT