C_MX_DueTaxAndWhldgTxItemLogC

Mexico specific Due Tax and Whldg Tax with Rptd Item Log Dta | view: CMXDTXNWGTXITLGC | TRAN | Extraction: Not supported | Component: Financials Mexico
Tables used: BKPF, BSEC, WITH_ITEM, BKPF, BSEG, T001, TKA02, T005T, T059Z, LFA1, T007A, T001, T014, MXTVO
Column Name Description
CompanyCode Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxCode Tax on sales/purchases code
TaxBox Tax Box (Adv. Tax Return)
TaxItem Number of Line Item Within Accounting Document
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
TaxItemGroupingVersion Grouping Version for Advance Return for Tax on Sales/Purch.
TaxBoxStructureType Tax Box Structure Type (Adv. Tax Return)
WithholdingTaxType Indicator for Withholding Tax Type
StatryRptgEntity Reporting Entity
StatryRptCategory Report Category ID
StatryRptRunID Report Run ID
ReportingDate Reporting Date
TaxBoxStrucValidityStartDate Valid From Date for Tax Box Structure
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
TaxAmountInCoCodeCrcy Tax Amount In Company Code Currency
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Local Currency
WhldgTaxAmtInCoCodeCrcy Withholding Tax Amount in Company Code Currency
💲 Reporting Currency (ReportingCurrency):
SupplierItemTaxAmount null
WhldgTaxAmtInReportingCrcy Withholding Tax Amount in Reporting Currency
TaxBaseAmountInRptgCrcy Tax Base Amount in Reporting Currency
TaxAmountInRptgCrcy Amount in Reporting Currency
Column Name Description
Column Name Description
ReportingDate Reporting Date
TaxBoxStrucValidityStartDate Valid From Date for Tax Box Structure
TaxBoxStrucValidityEndDate Valid To Date for Tax Box Structure
DocumentDate Journal Entry Date
PostingDate Posting 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
BusinessPartnerCountry null
BusinessPartnerName Name of Supplier TEXT80
BusinessType null
BusinessTransactionTypeName Short Text for Fixed Values DDTEXT
NationalityName Nationality TEXT15
DocumentReferenceID Reference Document Number XBLNR1
FollowOnDocumentType Follow-On Document Type REBZT
TaxInvoiceNumber Journal Entry BELNR
GLAccount General Ledger Account SAKNR
TaxNumber1 null
TaxNumberResponsible Tax Number at Responsible Tax Authority CHAR18
TaxRate TaxRate (Percentage)
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • C_MX_DUETAXANDWHLDGTXITEMLOGC.COUNTRY == T005.LAND1
  • C_MX_DUETAXANDWHLDGTXITEMLOGC.MANDT == T005.MANDT
Supplier
  • Supplier
  • Client
  • C_MX_DUETAXANDWHLDGTXITEMLOGC.CREDITOR == LFA1.LIFNR
  • C_MX_DUETAXANDWHLDGTXITEMLOGC.MANDT == LFA1.MANDT
Official Withholding Tax Key
  • Country/Region Key
  • Client
  • Official Withholding Tax Key
  • C_MX_DUETAXANDWHLDGTXITEMLOGC.COUNTRY == T059O.LAND1
  • C_MX_DUETAXANDWHLDGTXITEMLOGC.MANDT == T059O.MANDT
  • C_MX_DUETAXANDWHLDGTXITEMLOGC.OFFICIALWHLDGTAXCODE == T059O.WT_QSCOD