SAP Value Added Tax (VAT) Tables
Are you looking for the right table related to SAP Value Added Tax (VAT) Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Value Added Tax (VAT) (FI-GL-GL-F) module.
Top 10 tables in Value Added Tax (VAT)
| Table | Description |
|---|---|
| FOT_TXA_T030K | Tax Accounts Determination for TXA |
| FOTRFDPER | Period/Month in VAT Refund Application |
| FOT_ATR_TAX_BOX | Adv. Tax Return: Tax Box |
| FOTRFDPARA | Parameters for VAT Refund |
| FOTETAXUSMAPREG | Extenal Tax: Mapping Structure Registration |
| FOT_BTT_CODES_T | Texts for Business Transaction Type(BTT) Codes |
| FOT_ATR_TBS_TYPE | Adv. Tax Return: Tax Box Structure Types |
| FOT_TDT_PROD_ACT | Activation Product for TDT |
| FOT_TXA_STAT | Status for Tax Abroad |
| FOT_TIF_BTT_US | Relationship beteen Tax Interface and BTT Code |
List of tables in Value Added Tax (VAT)
| Table | Description |
|---|---|
| FOT_TXA_T030K | Tax Accounts Determination for TXA |
| FOTRFDPER | Period/Month in VAT Refund Application |
| FOT_ATR_TAX_BOX | Adv. Tax Return: Tax Box |
| FOTRFDPARA | Parameters for VAT Refund |
| FOTETAXUSMAPREG | Extenal Tax: Mapping Structure Registration |
| FOT_BTT_CODES_T | Texts for Business Transaction Type(BTT) Codes |
| FOT_ATR_TBS_TYPE | Adv. Tax Return: Tax Box Structure Types |
| FOT_TDT_PROD_ACT | Activation Product for TDT |
| FOT_TXA_STAT | Status for Tax Abroad |
| FOT_TIF_BTT_US | Relationship beteen Tax Interface and BTT Code |
| FOT_ETAX_OBS | External tax - Outbound service |
| FOTDECLTYC | Return Type Electronic Data Transmission to Authorities |
| FOT_ATR_TBS_TYPT | Adv. Tax Return: Tax Box Structure Types Texts |
| FOTDECLSTA | Status Information Rep Data Electronic Data Transmission |
| FOT_TDT_AUM_BSEG | BSEG lines created during verification of the tdt migration |
| FOTTDCL_MOSS | Items: Taxes on Sales/Purchases: Electronic Services |
| FOT_TDT_MIGNSTAT | TDT Migration Status for Country |
| FOT_TDT_NM_BSEG | BSEG-TXDAT lines not considered during tdt migration |
| FOTTDCLITM | Multinational ATR Items (TaxDeclarationNotificationItem) |
| FOTRFDITMCHG | Change Documents, VAT Refund Item |
| FOT_CTRY_EXR_TYP | Exch. Rate used for Conversion into Tax Amt in Country Curr |
| FOTTPRTXML | Country-Specific ATR Log Data (XML Format) |
| FOTTDCL_POST_DOC | Posting Documents for Tax Payable |
| FOTTDCL_POST_MOS | Tax Payable Posting Information for MOSS |
| FOTRFDREQ | VAT Refund Application |
| BSEG_CONV_TRG | BSEG, BSET & BSED Conversion Trigger |
| FOT_ETAX_UJCS | US Ext Tax: Unified Jurisdiction Code Structure Indicator |
| A4AV | Country/Tax Code |
| FOT_CTRY_SCOPE | Scope for countries |
| FOT_MIGRATORS | Migrators to be executed for tax applications |
| KONH_CONV_TRG | Trigger table for KONH |
| FOT_DISCLAIM | Disclaimer US tax calculation and reporting |
| FOT_ATR_TAX_GRP | Adv. Tax Return: Tax Groups |
| FOTETAXUSMAPPER | External Tax: Mapping Table |
| FOTDECLTYT | Name of Return Type Electronic Data Transmission |
| FOT_ETAX_US_TRAN | US External Tax: Transactions Registration |
| FOTETAXUSMAPCH | External Tax:Mapping Table Change Document |
| FOT_BTT_ASGNMNT | Assignment of BTT Code to Tax Properties |
| FOT_TDT_AUM_BSET | BSET lines created during verification of the tdt migration |
| FOT_TXA_REGISTN | Foreign Registrations for Company Code |
| FOTTDCLNOT | Multinational ATR Rep. Data (TaxDeclarationNotification) |
| FOT_E_CERTPAR | Tax partners certificated by SAP ICC |
| FOT_BTT_CODES | Business Transaction Type Codes |
| FOT_ATR_TBS | Adv. Tax Return: Tax Box Structure |
| FOT_ISO_CTRY_SCP | Scope for ISO Countries |
| FOTTBUKRS | Assignment of Company Codes to Dominant Enterprises |
| FOTETAXC | Settings Electronic Data Transmission to Authorities |
| FOT_ATR_COUNTRY | Countries which are using FOT_ATR* |
| FOT_ATR_TBS_MNTT | Adv. Tax Return: Maintenance Type for the TaxBoxStructure |
| FOTTDCLXML | Country-Specific ATR Reporting Data (XML Format) |
| FOT_ATR_TBTG_MAP | Adv. Tax Return: Mapping TaxBox to TaxGrp |
| FOTTDCLCON | Multinational ATR Confirmation (TaxDeclarationConfirmation) |
| FOT_ETAX_UNIFY | US External Tax: Unify Jurisdiction Code Structure Indicator |
| FOT_GL_TAXDATA | GL Account Tax Attributes |
| FOTPARAMC | Parameters Electronic Data Transmission |
| FOT_TDT_ACTVSTAT | Activation Status for TDT |
| FOT_ATR_TAX_BOXT | Adv. Tax Return: Tax Box Texts |
| FOTPARREFC | Assignment of Parameters Reporting Country Return Type |
| FOTETAXPC | Parameter Values Electronic Data Transmission to Authorities |
| FOT_TDT_NM_BSET | BSET-TXDAT lines not considered during tdt migration |
| KONV_CONV_TRG | KONV Conversion Trigger |
| ITAX_INDX_BLOB | INDX-Like Database Table with BLOB Column |
| FOTRFDITM | VAT Refund Items |
| REGUP_CONV_TRG | REGUP Conversion Trigger |