C_ES_StRpWhldgTaxItemQuery

Withholding Tax Item For Statutory Reporting Spain | view: CSRESWHLDGTXITMQ | Extraction: Not supported | Component: Withholding Tax Reporting
Column Name Description
CompanyCode FK Company Code
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
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
BusinessPartner Business Partner Number BU_PARTNER
WithholdingTaxPercent Withholding Tax Rate PRZ34
WithholdingTaxIncomeType Income Type QEKAR
EsIncTypeClassfctn null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_ES_STRPWHLDGTAXITEMQUERY.COMPANYCODE == T001.BUKRS
  • C_ES_STRPWHLDGTAXITEMQUERY.MANDT == T001.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • C_ES_STRPWHLDGTAXITEMQUERY.MANDT == T005.MANDT
  • C_ES_STRPWHLDGTAXITEMQUERY.COUNTRY == T005.LAND1
Supplier
  • Supplier
  • Client
  • C_ES_STRPWHLDGTAXITEMQUERY.CREDITOR == LFA1.LIFNR
  • C_ES_STRPWHLDGTAXITEMQUERY.MANDT == LFA1.MANDT
Customer Number
  • Customer Number
  • Client
  • C_ES_STRPWHLDGTAXITEMQUERY.DEBTOR == KNA1.KUNNR
  • C_ES_STRPWHLDGTAXITEMQUERY.MANDT == KNA1.MANDT
Reporting Entity
  • Client
  • Reporting Entity
  • C_ES_STRPWHLDGTAXITEMQUERY.MANDT == SRF_RPG_ENT.MANDT
  • C_ES_STRPWHLDGTAXITEMQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Type of Recipient
  • Type of Recipient
  • Indicator for Withholding Tax Type
  • Client
  • Country/Region Key
  • C_ES_STRPWHLDGTAXITEMQUERY.SUPPLIERRECIPIENTTYPE == T059C.QSREC
  • C_ES_STRPWHLDGTAXITEMQUERY.WITHHOLDINGTAXTYPE == T059C.WITHT
  • C_ES_STRPWHLDGTAXITEMQUERY.MANDT == T059C.MANDT
  • C_ES_STRPWHLDGTAXITEMQUERY.COUNTRY == T059C.LAND1
Withholding Tax Key
  • Withholding Tax Key
  • Client
  • Country/Region Key
Withholding Tax Code
  • Withholding Tax Code
  • Indicator for Withholding Tax Type
  • Client
  • Country/Region Key
  • C_ES_STRPWHLDGTAXITEMQUERY.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
  • C_ES_STRPWHLDGTAXITEMQUERY.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • C_ES_STRPWHLDGTAXITEMQUERY.MANDT == T059Z.MANDT
  • C_ES_STRPWHLDGTAXITEMQUERY.COUNTRY == T059Z.LAND1
Indicator for Withholding Tax Type
  • Indicator for Withholding Tax Type
  • Client
  • Country/Region Key
  • C_ES_STRPWHLDGTAXITEMQUERY.WITHHOLDINGTAXTYPE == T059P.WITHT
  • C_ES_STRPWHLDGTAXITEMQUERY.MANDT == T059P.MANDT
  • C_ES_STRPWHLDGTAXITEMQUERY.COUNTRY == T059P.LAND1