I_TW_FixedAssetTaxCube

Column Name Description
AccountingDocument Journal Entry
CompanyCode FK Company Code
FiscalYear Fiscal Year
TaxItemGroup Group Indicator for Tax Line Items
AccountingDocumentItem Journal Entry Posting View Item
TaxGroup FK Tax Group
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
TaxAmount Tax Amount in Local Currency
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
ReportingDate Reporting Date
TaxRateValidityStartDate Valid-From Date of the Tax Rate
Column Name Description
Column Name Description Domain name
TaiwaneseCalendarYear RSRSCAN1: Search String/Search Pattern SYCHAR20
FiscalPeriod null
DistrictTaxOffice null
SupplierTaxID1 null
SupplierTaxID2 null
DisplayDocumentDate null
DocumentReferenceID null
FixedAssetDescription Asset Description TEXT50
Quantity RSRSCAN1: Search String/Search Pattern SYCHAR20
AmountInCompanyCodeCurrency RSRSCAN1: Search String/Search Pattern SYCHAR20
TaxAmountInCoCodeCrcy RSRSCAN1: Search String/Search Pattern SYCHAR20
AssetAdditionalDescription Additional Asset Description TEXT50
BusinessPlace Business Place J_1BBRANCH
Supplier Account Number of Supplier LIFNR
Customer Customer Number KUNNR
CustomerCountry Country/Region Key LAND1
SupplierCountry Country/Region Key LAND1
AccountingDocumentClass ID of Reference 2 by Business Partner CHAR12
TaxCode Tax on sales/purchases code MWSKZ
TaxRate TaxRate (Percentage)
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_TW_FIXEDASSETTAXCUBE.COMPANYCODE == T001.BUKRS
  • I_TW_FIXEDASSETTAXCUBE.MANDT == T001.MANDT
Other Relations Join Conditions
Tax Group
  • ?
  • ?
  • ?
  • ?
  • ?
  • ?
  • ?
  • ?
  • ?
  • Tax Group
  • Client
  • I_TW_FIXEDASSETTAXCUBE.[column in domain "FOTFDATE"] == VGTAXGR.FDATE
  • I_TW_FIXEDASSETTAXCUBE.[column in domain "LAND1"] == VGTAXGR.LAND1
  • I_TW_FIXEDASSETTAXCUBE.[column in domain "TBSTYPE"] == VGTAXGR.TBSTYP
  • I_TW_FIXEDASSETTAXCUBE.[column in domain "BLART"] == VGTAXGR.BLART
  • I_TW_FIXEDASSETTAXCUBE.[column in domain "SHKZG_UMSV"] == VGTAXGR.SHKZG_UMSV
  • I_TW_FIXEDASSETTAXCUBE.[column in domain "KTOSL"] == VGTAXGR.KTOSL
  • I_TW_FIXEDASSETTAXCUBE.[column in domain "KTOKK"] == VGTAXGR.KTOKK
  • I_TW_FIXEDASSETTAXCUBE.[column in domain "MWSKZ"] == VGTAXGR.MWSKZ
  • I_TW_FIXEDASSETTAXCUBE.[column in domain "UMSKZ"] == VGTAXGR.UMSKZ
  • I_TW_FIXEDASSETTAXCUBE.TAXGROUP == VGTAXGR.ACR_TG
  • I_TW_FIXEDASSETTAXCUBE.MANDT == VGTAXGR.MANDT