I_DueDeferredTaxItemCube

View to display Due Deferred Tax Items | view: IDUEDEFTXITM | TRAN | Extraction: Not supported | Component: Financials Mexico
Tables used: BSECBKPFBSEGT001TKA02LFA1T007AT001T014
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.
TaxBoxStructureType Tax Box Structure Type (Adv. Tax Return)
AccountingDocumentType Document Type
TransactionTypeDetermination Transaction Key
StatryRptgEntity Reporting Entity
StatryRptCategory Report Category ID
StatryRptRunID Report Run ID
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Local Currency
TaxAmountInCoCodeCrcy Tax Amount In Company Code Currency
💲 Document Currency (DocumentCurrency):
TaxBaseAmountInTransCrcy Tax Base Amount In Transaction Currency
TaxAmount Tax Amount in Document Currency
💲 Reporting Currency (ReportingCurrency):
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
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
SupplierRecipientType Type for Third Party Show values
Column Name Description Domain name
DocumentReferenceID Reference Document Number XBLNR1
TaxRate TaxRate (Percentage)
GLAccount General Ledger Account SAKNR
TargetTaxCode Target Tax Code (for Deferred Tax) MWSKZ
TaxInvoiceNumber Journal Entry BELNR
InvoiceReferenceFiscalYear Fiscal Year GJAHR
FollowOnDocumentType Follow-On Document Type REBZT
BusinessPartnerCountry null
BusinessType null
TaxNumber1 null
BusinessPartnerName Name of Supplier TEXT80
TaxNumberResponsible Tax Number at Responsible Tax Authority CHAR18
Master Data Relations Join Conditions
Country/Region Key
  • Client
  • Country/Region Key
  • I_DUEDEFERREDTAXITEMCUBE.MANDT == T005.MANDT
  • I_DUEDEFERREDTAXITEMCUBE.COUNTRY == T005.LAND1
Supplier
  • Supplier
  • Client
  • I_DUEDEFERREDTAXITEMCUBE.CREDITOR == LFA1.LIFNR
  • I_DUEDEFERREDTAXITEMCUBE.MANDT == LFA1.MANDT