FOTRFDREQ - VAT Refund Application

VAT Refund Application information is stored in SAP table FOTRFDREQ.
It is part of development package FOT_EDECLARATION in software component FI-GL-GL-F. This development package consists of objects that can be grouped under "Electronic Advance Return for Tax on Sales/Purchases".

Fields for table FOTRFDREQ

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	MANDT	CLNT	6
REQID	Identifies an VAT Refund Application	X	FOT_RFDREQID	CHAR	16
DECL_YEAR	Reporting Year of Data Transmission to Authorities		FOT_DEYEAR	NUMC	8
DECL_PER_FROM	Reporting Period for VAT Refund Application		FOT_DCLPER_FROM	NUMC	4
DECL_PER_TO	Reporting Period for VAT Refund Application		FOT_DCLPER_TO	NUMC	4
RBASE_AMT	Base Amount in Reporting Currency		FOT_RBASE_AMT	CURR	12
RTX_AMT	Tax Amount in Reporting Currency		FOT_RTAX_AMT	CURR	12
RGROSS_AMT	Gross Amount in Reporting Currency		FOT_RGROSS_AMT	CURR	12
REP_CURR	Reporting Currency		FOT_CURR	CUKY	10
DECL_LEGID	ID of Reporting Data Electronic Data Transmission		FOT_LEGAID	CHAR	64
DECL_SENID	Identifies a Transfer of Reporting Data		FOT_SENDID	NUMC	16
SENDTSTMP	Transfer Time of Reporting Data		FOT_STSTMP	DEC	9
PROTTSTMP	Time of Log Receipt		FOT_PTSTMP	DEC	9
CREATSTMP	Creation Time of Reporting Data		FOT_CTSTMP	DEC	9
CHANTSTMP	Change Time of Reporting Data		FOT_CHTSTMP	DEC	9
USERCREATE	Creator of Return Data		FOT_USRCRE	CHAR	24
USERSENT	Sender of Rep. Data Electr. Communication with Authorities		FOT_USRSEN	CHAR	24
USERCHANGE	Changer of Rep. Data Electr. Communication with Authorities		FOT_USRCHG	CHAR	24
DATEREPCONF	Receipt Date of VAT Rfd Application: Tax Reporting Ctry/Reg.		FOT_DATE_REP_CONF	DATS	16
DATERFDCONF	Receipt Date - Tax Refund Country/Region		FOT_DATE_RFD_CONF	DATS	16
DATETAXASSE	Date on Which Tax Assessment Was Received		FOT_DATE_TAX_ASSE	DATS	16
REQ_STATUS	Status of VAT Refund Application		FOT_RFDREQSTATUS	CHAR	4
XIMESSKEY	Key XI Message		FOT_XIMKEY	CHAR	60
FOT_TDATA	Return Data for Test Purposes		FOT_TDATA	CHAR	2