C_TW_TaxItemQuery

Column Name Description
CompanyCode Company Code
BusinessPlace Business Place
AccountingDocumentClass Format Code
AccountingDocument Document Number of an Accounting Document
TaxCode Tax on sales/purchases code
TaiwaneseCalendarYear Minguo Calendar Year
DebitCreditCode Debit/Credit Indicator
TaxGroup FK Tax Group
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy Tax Base Amount
GrossTaxAmount Gross Tax Amount
Column Name Description
Column Name Description
ReportingDate Reporting Date
DocumentDate Journal Entry Date
PostingDate Posting Date in the Document
TaxRateValidityStartDate Valid-From Date of the Tax Rate
Column Name Description
TaxCategory TW VAT Tax Type Show values
DeductionType TW VAT Deduction Type Show values
IndustrialTaxRateCategory TW VAT Special GUI Remark Show values
GoodsAreCleared Customs Approach Show values
Column Name Description Domain name
ReferenceDocumentType Reference Document Type AWTYP
TaxItem Number of Line Item Within Accounting Document
AssignmentReference Assignment Reference
JrnlEntryCntrySpecificRef1 ID of Reference 1 by Business Partner
JrnlEntryCntrySpecificRef2 ID of Reference 2 by Business Partner
JrnlEntryCntrySpecificRef3 ID of Reference 3 by Business Partner
SourceReferenceDocument Original GUI Number CHAR16
Supplier Account Number of Supplier LIFNR
SupplierCountry Country/Region Key
Customer Customer Number KUNNR
CustomerCountry Country/Region Key
FiscalYear Fiscal Year GJAHR
BusinessPartner Business Partner Number BU_PARTNER
DocumentReferenceID Reference Document
SupplierTaxID2 Tax Number 2
SequenceNumber Sequence Number
FiscalPeriod Month
CustomerTaxID1 Buyer GUID
SupplierTaxID1 Seller GUI
TaxInvoiceNumber Government Uniform Invoice Number
TaxRate TaxRate (Percentage)
TaxType Tax Type
ControllingObjectType Official Document Numbering Control
NmbrOfPages Number of Invoices
MultipleInvoiceType Remark
IsMarkedForDeletion Mark as Deleted
SalesAmtInCompanyCodeCurrency CHAR30 for SYST
TaxAmount CHAR30 for SYST
Master Data Relations Join Conditions
Official document class
  • Official document class
  • Client
  • ?
  • C_TW_TAXITEMQUERY.LOGICALDOCUMENTCLASS == DOCCLSS.DOCCLS
  • C_TW_TAXITEMQUERY.MANDT == DOCCLSS.MANDT
  • C_TW_TAXITEMQUERY.[column in domain "LAND1"] == DOCCLSS.LAND1
Other Relations Join Conditions
Tax Group
  • Tax Group
  • ?
  • ?
  • Client
  • ?
  • ?
  • ?
  • ?
  • ?
  • ?
  • ?
  • C_TW_TAXITEMQUERY.TAXGROUP == VGTAXGR.ACR_TG
  • C_TW_TAXITEMQUERY.[column in domain "FOTFDATE"] == VGTAXGR.FDATE
  • C_TW_TAXITEMQUERY.[column in domain "TBSTYPE"] == VGTAXGR.TBSTYP
  • C_TW_TAXITEMQUERY.MANDT == VGTAXGR.MANDT
  • C_TW_TAXITEMQUERY.[column in domain "BLART"] == VGTAXGR.BLART
  • C_TW_TAXITEMQUERY.[column in domain "SHKZG_UMSV"] == VGTAXGR.SHKZG_UMSV
  • C_TW_TAXITEMQUERY.[column in domain "KTOSL"] == VGTAXGR.KTOSL
  • C_TW_TAXITEMQUERY.[column in domain "KTOKK"] == VGTAXGR.KTOKK
  • C_TW_TAXITEMQUERY.[column in domain "MWSKZ"] == VGTAXGR.MWSKZ
  • C_TW_TAXITEMQUERY.[column in domain "UMSKZ"] == VGTAXGR.UMSKZ
  • C_TW_TAXITEMQUERY.[column in domain "LAND1"] == VGTAXGR.LAND1