I_StRpTaxReturnBoxCube

Cube View to Return Tax Details with TaxBox configuration | view: ISRTAXRETURNBOXC | TRAN | Extraction: Not supported | Component: Localization Financials
Tables used: BKPF, T007A
Column Name Description
CompanyCode Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxItem Number of Line Item Within Accounting Document
TransactionTypeDetermination Transaction Key
DebitCreditCode Debit/Credit Code Show values
AccountingDocumentType Document Type
SupplierAccountGroup Supplier Account Group
TaxBox Tax Box (Adv. Tax Return)
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
TaxBoxStrucValidityStartDate Valid From Date for Tax Box Structure
UnifiedTaxBoxStructureType Adv. Tax Return: Unified Tax Box Structure Type
TaxGroup Tax Group
TaxItemGrpgDebitCreditCode Indicator: Total Balance, Debit Balance or Credit Balance? Show values
TaxItemGrpgAcctgDocumentType Tax Item Group Document Type
TaxItemGrpgSupplierAcctGroup Tax Item Grouping of Supplier Account Group
TaxItemGrpgSpecialGLCode Special G/L Indicator
StatryRptgEntity Reporting Entity
StatryRptCategory Report Category ID
StatryRptRunID Report Run ID
Column Name Description
💲 Reporting Currency (ReportingCurrency):
TaxBaseAmountInRptgCrcy Tax Base Amount in Reporting Currency
TaxAmountInRptgCrcy Amount in Reporting Currency
AmountInReportingCurrency Amount in Reporting Currency
TotalGrossAmount Total Amount in Reporting Currency
NonDeductibleInputTaxAmount Non Deductible Input Tax Amount
DcblVATIncrdCostInRptgCrcy Deductible Input Tax Amount
💲 Company Code Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Local Currency
TaxAmountInCoCodeCrcy Tax Amount In Company Code Currency
DifferenceTaxAmtInCoCodeCrcy Difference Amount in Company Code currency
DiffTaxBaseAmountInCoCodeCrcy Difference Amount in Company Code currency
TotalGrossAmountInCoCodeCrcy Total Gross Amount In Company Code Currency
CalculatedTxAmtInCoCodeCrcy Calculated Tax Amount In Company Code Currency
AmountInCompanyCodeCurrency Amount in Company Code Currency
CalcdTxBaseAmtInCoCodeCrcy Tax Base Amount in Local Currency
BalanceAmountInTransacCurrency Difference Amount in Company Code currency
💲 Document Currency (DocumentCurrency):
TaxBaseAmountInTransCrcy Tax Base Amount In Transaction Currency
TaxAmount Tax Amount in Document Currency
TotalGrossAmountInTransCrcy Total Gross Amount In Transaction Currency
CalculatedTaxAmountInTransCrcy Calculated Tax Amount In Transaction Currency
CalculatedTxBaseAmtInTransCrcy Calculated TaxBase Amount In Transaction Currency
AmountInTransactionCurrency Amount in Transaction Currency
💲 Country/Region Currency (CountryCurrency):
TaxBaseAmountInCountryCrcy Tax Base in Reporting Currency
TaxAmountInCountryCrcy Tax Amount in Reporting Currency
💲 Additional Currency 1 (AdditionalCurrency1):
TaxBaseAmtInAdditionalCrcy1 Tax Base Amount in Local Currency 2
TaxAmountInAdditionalCurrency1 Tax Amount in Local Currency 2
AmountInAdditionalCurrency1 Amount in Additional Currency1
💲 Additional Currency 2 (AdditionalCurrency2):
TaxBaseAmtInAdditionalCrcy2 Tax Base Amount in Local Currency 3
TaxAmountInAdditionalCurrency2 Tax Amount in Local Currency 3
AmountInAdditionalCurrency2 Amount in Additional Currency2
Column Name Description
Column Name Description
TaxBoxStrucValidityStartDate Valid From Date for Tax Box Structure
ValidFrom Valid From Date for Tax Box Structure
ValidTo Valid To Date for Tax Box Structure
TaxBoxStrucValidityEndDate Valid To Date for Tax Box Structure
TaxRateValidityStartDate Valid-From Date of the Tax Rate
PostingDate Posting Date
DocumentDate Journal Entry Date
TaxReportingDate Tax Reporting Date
ReportingDate Reporting Date
TaxReportingDocumentDate Reporting Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
TaxItemGrpgDebitCreditCode Indicator: Total Balance, Debit Balance or Credit Balance? Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
TaxType Tax Type Show values
TaxIsNotDeductible Indicator: Tax not deductible Show values
IsNegativePosting Indicator: Negative Posting Show values
Column Name Description Domain name
StatryRptRun Report Run SRF_REPORT_RUN
Country Reporting Country/Region LAND1
TaxCode Tax on sales/purchases code MWSKZ
TaxItemGroupingVersion Grouping Version for Advance Return for Tax on Sales/Purch. CHAR4
TaxBoxStructureType Tax Box Structure Type (Adv. Tax Return) FOT_ATR_TAX_BOX_STRUCT_TYPE
TaxCalculationProcedure Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
TaxRate TaxRate (Percentage)
IPITaxRate TaxRate (Percentage) CHAR16
TaxCodeRatePointer TaxGroup Rate which represents the TaxCode Rate
Customer Customer Number KUNNR
GLAccount General Ledger Account SAKNR
TaxItemGroup Group Indicator for Tax Line Items NUM03
BusinessPlace Business Place J_1BBRANCH
TaxJurisdiction Tax Jurisdiction TXJCD
LowestLevelTaxJurisdiction Tax Jurisdiction Code - Jurisdiction for Lowest Level Tax TXJCD
ReferenceDocumentType Reference Document Type AWTYP
AlternativeReferenceDocument Alternate Reference Doc Number
ReverseDocument Reverse Document Number BELNR
ReverseDocumentFiscalYear Fiscal Year of Reversal Document GJAHR
ConditionRecord Number of the Condition Record KNUMH
RoundingDecimalPlaces Count parameters NUMC4
DocumentReferenceID Reference Document Number XBLNR1
Ledger Ledger FINS_LEDGER
LedgerGroup Ledger Group FAGL_LDGRP
FiscalPeriod Fiscal Period POPER
ExchangeRate Exchange Rate UKURS
AccountingDocumentHeaderText Document Header Text TEXT25
CompanyCodeCountry Company Code Country/Region LAND1
ReportingCountry Tax Country/Region or Company Code Country/Region LAND1
TaxReturnCountry Tax Return Country/Region LAND1
BPTaxNumber Business Partner Tax Number BPTAXNUM
ReportingVATRegistration VAT number under which the partner is reported STCEG
TaxNumber1 Tax Number 1 STCD1
ShippingPointCountry Country/Region Key LAND1
TargetTaxCode Target Tax Code (for Deferred Tax) MWSKZ
TaxNumber2 Tax Number 2 STCD2
ActiveTaxType Generic VAT Derived Tax Type CHAR2
TaxNumber3 Tax Number 3 CHAR18
TaxIsDeferredRelevant null
TaxIsMossRelevant null
BusinessPartner Business Partner Number BU_PARTNER
CAReconciliationKey Reconciliation Key for General Ledger FIKEY_KK
BusinessPartnerName Business Partner Name TEXT80
BusinessPartnerCountry Business Partner Country/Region LAND1
TaxTypeName Tax Type Name Description CHAR20
CustomerSupplierAddress Business Partner Address
SenderCompanyCode Company Code in Sender System CHAR4
SenderAccountingDocument Sender Journal Entry BELNR
SenderFiscalYear Fiscal Year of an Accounting Document in the Sender System GJAHR
TaxBoxStructure Tax Box Structure (Adv. Tax Return) FOT_ATR_TAX_BOX_STRUCTURE
TaxBoxStructureName Tax Box Structure Name TXT50
TaxBoxName Tax Box Desciption FOT_ATR_TAX_BOX_TEXT
TaxBoxCondition Tax Box Condition (Adv. Tax Return )
TaxBoxAggregationOperation Operation for linking attribute values OPERATION
TaxGroupOperation Function character of step CHAR2
ConditionType Condition Type KSCHL
IsVATRelevant null
TaxCountry Tax Origin Country/Region LAND1
TaxCntryOrCompanyCodeCntry Tax Reporting Country/Region LAND1
TaxGroupFreeClassification Free Classification Code CHAR8