I_DueTaxAndWithholdingTaxItemC

View to display Due Tax and Withholding Tax Items | view: IDUETXNWTHITM | TRAN | Extraction: Not supported | Component: Financials Mexico
Tables used: BKPFBSECWITH_ITEMBKPFBSEGT001TKA02T059ZLFA1T007AT001T014
Column Name Description
CompanyCode Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxCode Tax on sales/purchases code
TaxItem Number of Line Item Within Accounting Document
TaxBox Tax Box (Adv. Tax Return)
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
TaxItemGroupingVersion Grouping Version for Advance Return for Tax on Sales/Purch.
WithholdingTaxType FK Indicator for Withholding Tax Type
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Local Currency
TaxAmountInCoCodeCrcy Tax Amount In Company Code Currency
WhldgTaxAmtInCoCodeCrcy Withholding Tax Amount in Local Currency
💲 Reporting Currency (ReportingCurrency):
TaxBaseAmountInRptgCrcy Tax Base Amount in Reporting Currency
TaxAmountInRptgCrcy Amount in Reporting Currency
WhldgTaxBaseAmtInReportingCrcy Withholding Tax Base Amount in Reporting Currency
WhldgTaxAmtInReportingCrcy Withholding Tax Amount in Reporting Currency
SupplierItemTaxAmount null
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
ReportingDate Reporting Date
Column Name Description
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
SupplierRecipientType Type for Third Party Show values
Column Name Description Domain name
AccountingDocumentType Document Type BLART
DocumentReferenceID Reference Document Number XBLNR1
TaxRate TaxRate (Percentage)
GLAccount General Ledger Account SAKNR
TaxInvoiceNumber Journal Entry BELNR
BusinessPartnerCountry null
FollowOnDocumentType Follow-On Document Type REBZT
BusinessType null
BusinessPartnerName Name of Supplier TEXT80
TaxNumber1 null
TaxNumberResponsible Tax Number at Responsible Tax Authority CHAR18
Master Data Relations Join Conditions
Country/Region Key
  • Client
  • Country/Region Key
  • I_DUETAXANDWITHHOLDINGTAXITEMC.MANDT == T005.MANDT
  • I_DUETAXANDWITHHOLDINGTAXITEMC.COUNTRY == T005.LAND1
Supplier
  • Client
  • Supplier
  • I_DUETAXANDWITHHOLDINGTAXITEMC.MANDT == LFA1.MANDT
  • I_DUETAXANDWITHHOLDINGTAXITEMC.CREDITOR == LFA1.LIFNR
Official Withholding Tax Key
  • Official Withholding Tax Key
  • Client
  • Country/Region Key
  • I_DUETAXANDWITHHOLDINGTAXITEMC.OFFICIALWHLDGTAXCODE == T059O.WT_QSCOD
  • I_DUETAXANDWITHHOLDINGTAXITEMC.MANDT == T059O.MANDT
  • I_DUETAXANDWITHHOLDINGTAXITEMC.COUNTRY == T059O.LAND1
Indicator for Withholding Tax Type
  • Indicator for Withholding Tax Type
  • Client
  • Country/Region Key
  • I_DUETAXANDWITHHOLDINGTAXITEMC.WITHHOLDINGTAXTYPE == T059P.WITHT
  • I_DUETAXANDWITHHOLDINGTAXITEMC.MANDT == T059P.MANDT
  • I_DUETAXANDWITHHOLDINGTAXITEMC.COUNTRY == T059P.LAND1