FISVD_EXTERNALTAX_ITEM_INFO

Final External Tax Document Line Item Info | view: FISCDSEXTAXINFO | TRAN | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: ETXDCF, ETXDCH, ETXDCI, ETXDCJ, ETXJCD, T001, TKA02, SKB1, T005S, T005U, SKAT, T004
Column Name Description
UniqueKey Unique Key
TaxItem FK Tax Item Num
JurisdictionLevel Jurisdiction Level
Column Name Description
💲 Document Currency (TaxCurrency):
TaxAmount Tax Amount in Document Currency
TaxBaseAmount JurLevelTaxBaseAmt
ExemptAmount Jur Exempt Amount
TaxItemBaseAmount ItemLevelTaxBaseAmt
TaxItemBaseAmountGross Gross Tax Base Amt
FreightAmount Freight Amount
InternalExemptAmount Exempt Amount
TotalTaxAmount Total Tax Amt
BilledAmount Billed amount (in currency format)
💲 Local Currency (GLCurrency):
GLTaxAmount JurTaxAmtInLoclCurr
GLTaxBaseAmount JurTaxBaseInLoclCurr
GLExtTaxAmount Tax Amt in Locl Curr
Column Name Description
MaterialQuantity Material Quantity
Column Name Description
TaxDate Tax Date
PostingDate Tax Reporting Date
DocumentDate Document Date in Document
ReferencePostingDate Posting Date in the Document
ServiceRenderDate Service Render Date
TaxDateExpired Expired Tax Date
Column Name Description
DebitCreditIndicator Deb/Credit Indicator Show values
TaxDefaultReason Tax Default Reason Show values
SDDocumentCategory Sales Document Category Show values
TaxSourcing Tax Sourcing Show values
Column Name Description Domain name
DocumentNumber Reference Document Number AWREF
CompanyCode Company Code BUKRS
CompanyCodeName Name of Company Code or Company TEXT25
TaxRate Tax Rate (%)
ExemptReasonCode Jur ExemptReasonCode CHAR2
GLTaxRate G/LTaxRateByJur
DebitCreditCodeName Debit/Credit Code Name DDTEXT
GLAccount G/L Account SAKNR
GLAccountName G/L Account Name CHAR30
TaxInfoDesc RSRSCAN1: Search String/Search Pattern SYCHAR20
TaxJurisdiction Tax Jurisdiction TXJCD
ShipToTaxJurisdiction Ship-to Jurisdiction TXJCD
ShipFromTaxJurisdiction Ship-from Jurisdict TXJCD
OrderAccTaxJurisdiction POA Jurisdiction TXJCD
OrderOriginTaxJurisdiction POO Jurisdiction TXJCD
ExtDocItem Tax Base Item Num NUM6
TaxDocItem Item Num in Ref Doc NUM6
SalesPurchasesCode Tax Code MWSKZ
MMTaxDocItem Item Num in Ref Doc NUM6
Groupingcode Grouping Code CHAR18
TaxDepartureCountry Departure Country/Region LAND1
BusinessAreaDivisionCode Business Area CHAR4
MaterialNumber Material Number CHAR18
InternalProductCode S4H Product Code CHAR10
GroupProductCode Group Product Code CHAR10
PricingReferenceMaterial Pricing Ref Material MATNR
IndicatorForAPAR I/O Tax Indicator CHAR1
TaxType Tax Type/Category CHAR1
IsTaxExemptTaxable Tax Exempt Flag CHAR1
VendorCustomerAccountNumber Suplr/Cust Acct Num KTO16
ClassificationOfAccount Suplr/Cust AcctClass CHAR10
CostObject Cost Object CHAR18
PointOfTitlePassage Passage of Title Ind CHAR1
CustomerTaxExemptionnumber S4H Exmp Cert Num CHAR25
TaxExemptionReasonCode Exempt Reason Code CHAR2
UserSpecificField User-Specific Data TXT50
StoreCode Store Code CHAR10
UserSpecificReportData User Reporting Data TEXT50
JurisdictionCodeFforTaxCal TaxCalcJurisCode Ind CHAR1
TotalTaxRate Total Tax Rate (%)
CodeForMaterialTaxExemption Matl Exmp Rsn Code CHAR2
CodeForCustomerTaxExemption Cust Exmp Rsn Code
CustomerExemptCertificate Ext Exmp Cert CHAR25
TaxExtExemptionReasonCode Ext Exmp Rsn Code CHAR2
GLExtTaxRate G/L Tax Rate
IndicatorTaxCredit Tax Credit Flag CHAR1
SoldToParty Sold-To Party KUNNR
ShipToParty Ship-To Party KUNNR
BillToParty Bill-To Party KUNNR
ReferenceGLAccount G/L Account Number, Significant Length CHAR10
CostCenter Cost Center KOSTL
PurchasingDocument Purchasing Document Number EBELN
SDDocument Sales Document Number VBELN
TotalContractValue Total Contract Value CHAR25
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSNR
BusTransTypeCode Business Transaction Type(Do not use! Will be overwrited) FOT_TDT_TXDAT_DET_BTT_CODE
ExtensionField001 Extension Field 001 TEXT100
ExtensionField002 Extension Field 002 TEXT100
ExtensionField003 Extension Field 003 TEXT100
ExtensionField004 Extension Field 004 TEXT100
ExtensionField005 Extension Field 005 TEXT100
ExtensionField006 Extension Field 006 TEXT100
ExtensionField007 Extension Field 007 TEXT100
ExtensionField008 Extension Field 008 TEXT100
ExtensionField009 Extension Field 009 TEXT100
ExtensionField010 Extension Field 010 TEXT100
ExtensionField011 Extension Field 011 TEXT100
ExtensionField012 Extension Field 012 TEXT100
ExtensionField013 Extension Field 013 TEXT100
ExtensionField014 Extension Field 014 TEXT100
ExtensionField015 Extension Field 015 TEXT100
ExtensionField016 Extension Field 016 TEXT100
ExtensionField017 Extension Field 017 TEXT100
ExtensionField018 Extension Field 018 TEXT100
ExtensionField019 Extension Field 019 TEXT100
ExtensionField020 Extension Field 020 TEXT100
ExtensionField021 Extension Field 021 TEXT100
ExtensionField022 Extension Field 022 TEXT100
ExtensionField023 Extension Field 023 TEXT100
ExtensionField024 Extension Field 024 TEXT100
ExtensionField025 Extension Field 025 TEXT100
ExtensionField026 Extension Field 026 TEXT100
ExtensionField027 Extension Field 027 TEXT100
ExtensionField028 Extension Field 028 TEXT100
ExtensionField029 Extension Field 029 TEXT100
ExtensionField030 Extension Field 030 TEXT100
ExtensionField031 Extension Field 031 TEXT100
ExtensionField032 Extension Field 032 TEXT100
ExtensionField033 Extension Field 033 TEXT100
ExtensionField034 Extension Field 034 TEXT100
ExtensionField035 Extension Field 035 TEXT100
ExtensionField036 Extension Field 036 TEXT100
ExtensionField037 Extension Field 037 TEXT100
ExtensionField038 Extension Field 038 TEXT100
ExtensionField039 Extension Field 039 TEXT100
ExtensionField040 Extension Field 040 TEXT100
ExtensionField041 Extension Field 041 TEXT100
ExtensionField042 Extension Field 042 TEXT100
ExtensionField043 Extension Field 043 TEXT100
ExtensionField044 Extension Field 044 TEXT100
ExtensionField045 Extension Field 045 TEXT100
ExtensionField046 Extension Field 046 TEXT100
ExtensionField047 Extension Field 047 TEXT100
ExtensionField048 Extension Field 048 TEXT100
ExtensionField049 Extension Field 049 TEXT100
ExtensionField050 Extension Field 050 TEXT100
FiscalYear Fiscal Year GJAHR
JurisdictionArea Tax Jurisdiction Code Description CHAR200
TaxStateDescription US state Description CHAR20
TaxState Tax State
Master Data Relations Join Conditions
Chart of Accounts
  • Chart of Accounts
  • Client
  • FISVD_EXTERNALTAX_ITEM_INFO.CHARTOFACCOUNTS == T004.KTOPL
  • FISVD_EXTERNALTAX_ITEM_INFO.MANDT == T004.MANDT