Vat return Table in SAP

• J_1SMWSBTR
  Table for IS-M/SD CH/F: VAT Amounts for VAT Deduction by Agreement
  Table Type : TRANSP
  Package : J1SC
  Module : IS-M
• J_1SMWSNWS
  Table for IS-M/SD CH/F: VAT Statement for VAT Deduction by Agreement
  Table Type : TRANSP
  Package : J1SC
  Module : IS-M
• TJL54
  Table for IS-M/SD: VAT Account - VAT Differences for Coll.Transfer
  Table Type : TRANSP
  Package : JSD
  Module : IS-M

• RFUMSV00_HIST
  Table for Maintain data for previous VAT return run
  Table Type : TRANSP
  Package : ID-FI-SK
  Module : FI-LOC
• MSR_C_REASON_REL
  Table for Assign Supplier Return Reasons to Customer Return Reasons
  Table Type : TRANSP
  Package : MSR_BASICS
  Module : LO-ARM
• P05TPRNL_LP_COLL
  Table for Pension Return: Collective Return - Legal Pers Level
  Table Type : TRANSP
  Package : P05T
  Module : PY-NL-RP
• P05T_AE_AANGIFTE
  Table for Wage Return: Administrative Unit - Collective Return
  Table Type : TRANSP
  Package : P05T
  Module : PY-NL-RP
• P05T_A_EXT
  Table for Wage Return: Collective Employer Data - Wage Return
  Table Type : TRANSP
  Package : P05T
  Module : PY-NL-RP
• P05T_IV_AANGIFTE
  Table for Wage Return: Income Relationship - Nominative Return
  Table Type : TRANSP
  Package : P05T
  Module : PY-NL-RP
• P05T_IV_DA
  Table for Wage Return: Income Relationship - Return Data
  Table Type : TRANSP
  Package : P05T
  Module : PY-NL-RP
• P05T_IV_DA_BSN
  Table for Wage Return: Other Cumulated Return Data
  Table Type : TRANSP
  Package : P05T
  Module : PY-NL-RP
• P05T_IV_DA_CUM
  Table for Wage Return: Other Cumulated Return Data
  Table Type : TRANSP
  Package : P05T
  Module : PY-NL-RP

• P05T_RESP2LA
  Table for Wage Return: Rel. between Response Message and Wage Return
  Table Type : TRANSP
  Package : P05T
  Module : PY-NL-RP
• A261
  Table for IS-M: VAT Country/RecLand/Cust.Tax Classification
  Table Type : TRANSP
  Package : JAS
  Module : IS-M
• A262
  Table for IS-M: VAT Country/RecCountry/CustTaxCl/TaxClass
  Table Type : TRANSP
  Package : JAS
  Module : IS-M
• CDBC_TAX_VATNO
  Table for Determining the VAT Registration Number
  Table Type : TRANSP
  Package : CDB
  Module : CRM-MSA
• CDBC_ZEROVAT
  Table for Localization: CDB Table for Reason for Zero VAT
  Table Type : TRANSP
  Package : CDB
  Module : CRM-MSA
• CDBC_ZEROVAT_T
  Table for Localization: CDB Table for Reason for Zero VAT
  Table Type : TRANSP
  Package : CDB
  Module : CRM-MSA
• CRMC_TAX_VATNO
  Table for Determining the VAT registration number
  Table Type : TRANSP
  Package : CRM_TAX
  Module : CRM-BF-TAX
• CRMC_ZEROVAT
  Table for Localization Reason for Zero VAT
  Table Type : TRANSP
  Package : CRM_LOC_ARGENTINA
  Module : CRM-LOC
• CRMC_ZEROVATT
  Table for Text Table: Localization Reason for Zero VAT
  Table Type : TRANSP
  Package : CRM_LOC_ARGENTINA
  Module : CRM-LOC
• CRM_LOC_GT_LIMIT
  Table for Maximum limit for VAT invoices
  Table Type : TRANSP
  Package : BEA_INTERNATIONAL
  Module : CRM-LOC
• CRM_LOC_GT_LIM_T
  Table for Text Table for Maximum limit for VAT invoices
  Table Type : TRANSP
  Package : BEA_INTERNATIONAL
  Module : CRM-LOC
• CRM_LOC_GT_TXCLG
  Table for Maintain Tax Catalog Code for VAT Rate
  Table Type : TRANSP
  Package : BEA_INTERNATIONAL
  Module : CRM-LOC

• DFKKITVATM
  Table for VAT monthly report for Italy: hystory table
  Table Type : TRANSP
  Package : FKK_ID_IT
  Module : FI-CA
• DFKKITVATQ
  Table for VAT quarterly report for Italy: hystory table
  Table Type : TRANSP
  Package : FKK_ID_IT
  Module : FI-CA
• DIAN_C_VAT_1001
  Table for Additional VAT Settings for Format 1001
  Table Type : TRANSP
  Package : ID-DIAN-CO
  Module : FI-LOC
• DIAN_C_VAT_CONST
  Table for VAT Concept Settings
  Table Type : TRANSP
  Package : ID-DIAN-CO
  Module : FI-LOC
• DIAN_C_VAT_FORST
  Table for DIAN VAT Format Settings
  Table Type : TRANSP
  Package : ID-DIAN-CO
  Module : FI-LOC
• FIEUA_VOC_IDF
  Table for Identifying VAT on Cash Information for Business Partner
  Table Type : TRANSP
  Package : ID-FI-PT
  Module : FI-LOC
• FOTRFDITM
  Table for VAT Refund Items
  Table Type : TRANSP
  Package : FOT_EDECLARATION
  Module : FI
• FOTRFDITMCHG
  Table for Change Documents, VAT Refund Item
  Table Type : TRANSP
  Package : FOT_EDECLARATION
  Module : FI
• FOTRFDPARA
  Table for Parameters for VAT Refund
  Table Type : TRANSP
  Package : FOT_EDECLARATION
  Module : FI
• FOTRFDPER
  Table for Period/Month in VAT Refund Application
  Table Type : TRANSP
  Package : FOT_EDECLARATION
  Module : FI
• FOTRFDREQ
  Table for VAT Refund Application
  Table Type : TRANSP
  Package : FOT_EDECLARATION
  Module : FI
• IDEU_VAT
  Table for EU VAT Posting
  Table Type : TRANSP
  Package : ID-FI
  Module : CA-GTF-CSC
• IDGT_CUSTTYPE
  Table for VAT Invoice Type
  Table Type : TRANSP
  Package : ID-SD-CN-GT
  Module : FI-LOC
• IDGT_VATH
  Table for VAT Invoice Header
  Table Type : TRANSP
  Package : ID-SD-CN-GT-01
  Module : FI-LOC
• IDGT_VATI
  Table for VAT Invoice Item
  Table Type : TRANSP
  Package : ID-SD-CN-GT-01
  Module : FI-LOC
• IDGT_VATM
  Table for Mapping of GT Document and VAT Invoice
  Table Type : TRANSP
  Package : ID-SD-CN-GT-01
  Module : FI-LOC
• IDHU_DOWNP_LOG
  Table for Log Table for Down Payment Recalculation VAT Amount
  Table Type : TRANSP
  Package : ID-FI-HU
  Module : FI-LOC
• IDKR_CUSTVAT
  Table for VAT registration number against customer on a time basis
  Table Type : TRANSP
  Package : ID-FI-KR
  Module : CA-GTF-CSC
• IDKR_VENVAT
  Table for VAT registration number against vendor on a time basis
  Table Type : TRANSP
  Package : ID-FI-KR
  Module : CA-GTF-CSC
• IDMX_VAT
  Table for Mexico : Identifiable and Non-Identifiable VAT conditions
  Table Type : TRANSP
  Package : ID-FI-SA
  Module : FI-LOC
• IDTW_VAT
  Table for VAT (Taiwan): Current Values
  Table Type : TRANSP
  Package : ID-FI
  Module : CA-GTF-CSC
• JFTX
  Table for IS-M/SD: Period Grid for VAT Accrual
  Table Type : TRANSP
  Package : JSD
  Module : IS-M
• J_1ADRVER
  Table for Versions of VAT daily report
  Table Type : TRANSP
  Package : J1AF
  Module : CRM-BF-TAX
• J_1ADRVERT
  Table for Texts for versions of VAT daily report
  Table Type : TRANSP
  Package : J1AF
  Module : CRM-BF-TAX
• J_1ARFZ
  Table for Definition of reasons for zero VAT
  Table Type : TRANSP
  Package : J1AT
  Module : CRM-BF-TAX
• J_1ARFZT
  Table for Texts for reasons for zero VAT
  Table Type : TRANSP
  Package : J1AT
  Module : CRM-BF-TAX
• J_1ARZTX
  Table for Reason for zero VAT per tax code
  Table Type : TRANSP
  Package : J1AT
  Module : CRM-BF-TAX
• DEFMXACC
  Table Data element for VAT Return Line
• J_3R_OPERATION_CODE
  Table Data element for Operation Code for VAT Return (Russia), Section 2
• RC_CALC
  Table Data element for Return Value (Return Code)
• FL_NRET
  Table Data element for Return flight: no return needed
• GB_PERIOD_END_DATE
  Table Data element for New CIS Return - End date for a return Period
• GB_NIL_RETURN_INDICATOR
  Table Data element for Specifies if the current return is a Nil Return or n
• REM_NACHLF
  Table Data element for Return Follow-Up Time in Days for Alternative Return Start
• XMAXREMMG
  Table Data element for Expected return quantity is maximum return quantity
• RUECKGEB
  Table Data element for IS-M: Return Charge for Bank Return
• P05_PRNL_STATUS
  Table Data element for Pension Return: Return Status
• P05T_SRTAANG
  Table Data element for Wage Return: Type of Return
• P05T_STATUS
  Table Data element for Wage Return: Return Status

Vat return related terms

Definitions

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.