FOTRFDITM - VAT Refund Items

VAT Refund Items information is stored in SAP table FOTRFDITM.
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 FOTRFDITM

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
RFD_ITEM_ID	ID of VAT Refund-Related Line Items	X	FOT_RFD_ITEM_ID	CHAR	72
.INCLUDE	KEY			FOT_S_RFDFKEY	0
DECL_TYPE	Return Type for Authorities		FOT_DCLTYP	NUMC	8
TBUKRS	Dominant Enterprise/Company Code		FOT_TBUKRS	CHAR	8	*
DECL_CTRY	Reporting Country/Region		FOT_DCCTRY	CHAR	6	*
DECL_YEAR	Reporting Year of Data Transmission to Authorities		FOT_DEYEAR	NUMC	8
DECL_PER	Reporting Period of Electronic Data Transmission		FOT_DCLPER	NUMC	4
DECL_RUNID	Counter of a Corrected Return		FOT_RUNID	NUMC	6
DECL_VERS	New Version for Changed Return		FOT_VERS	NUMC	6
RFD_CTRY	Tax Refund Country/Region		FOT_RFD_CTRY	CHAR	6	*
.INCLUDE	RFDFIITM			FOT_S_RFDFIITM	0
DOC_POS	Line Item Within a VAT Refund Application		FOT_DOC_POS	NUMC	6
BELNR	Document Number of an Accounting Document		BELNR_D	CHAR	20
GJAHR	Fiscal Year		GJAHR	NUMC	8
MONAT	Fiscal period		MONAT	NUMC	4
BUDAT	Posting Date in the Document		BUDAT	DATS	16
XBLNR	Reference Document Number		XBLNR	CHAR	32
BLART	Document Type		BLART	CHAR	4	T003
LIFNR	Account Number of Supplier		LIFNR	CHAR	20	LFA1
.INCLU-TV	RFDTVITM			FOT_S_RFDTVITM	0
AWSYSTV	Logical System		LOGSYSTEM	CHAR	20	*
PERNRTV	Personnel Number		PERNR_D	NUMC	16
REINRTV	Trip Number		REINR	NUMC	20
PERIOTV	Trip Period Number		PTRV_PEROD	NUMC	6
PDVRSTV	Sequential Number of Period		FOT_PTRV_PDVRS	NUMC	4
BELNRTV	Document Number		FOT_NRBEL	CHAR	6
POSNRTV	Item Number		FOT_PTRV_POSNR	NUMC	6
REC_NOTV	Invoice Number of Original Document		FOT_PTRV_RECEIPT_NO	CHAR	32
REC_POS_NOTV	Number of Invoice Item		FOT_PTRV_RECEIPT_ITEM	NUMC	6
.INCLUDE				FOT_S_RFDGEN	0
RFD_SEQ_NO	Sequential Number Within VAT Refund Application		FOT_RFD_SEQ_NO	CHAR	20
RFD_ITM_CASE	Type of VAT Refund Document		FOT_RFD_ITM_CASE	CHAR	6
MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4	*
TXDAT	Date for Determining Tax Rates		TXDAT	DATS	16
TXDAT_FROM	Valid-From Date of the Tax Rate		FOT_TXDAT_FROM	DATS	16
BLDAT	Document Date in Document		BLDAT	DATS	16
RFD_ITEMSRC	Origin of Line Item		FOT_RFD_ITEMORIG	CHAR	6
RFD_CHAR	Code for Goods and Services for VAT Refund Procedure		FOT_RFD_CHAR	CHAR	6
RFD_SUBCODE	Subcode for VAT Refund		FOT_TAX_RFD_SUB_CODE	CHAR	30	*
RFD_CH_SPARS	Language Key		SPRAS	LANG	2
RFD_CH_DESCR	Additional Description of Nature of Goods and Services		FOT_RFD_CH_DESCR	CHAR	200
BASE_AMT	Base Amount in Document Currency		FOT_BASE_AMT	CURR	12
TAX_AMT	Tax Amount in Document Currency		FOT_TAX_AMT	CURR	12
RFDTAX_AMT	Deductible Input Tax Amount in Document Currency		FOT_RFDTAX_AMT	CURR	12
ORIG_CURR	Document Currency		FOT_ORIG_CURR	CUKY	10	TCURC
RBASE_AMT	Base Amount in Reporting Currency		FOT_RBASE_AMT	CURR	12
RTX_AMT	Tax Amount in Reporting Currency		FOT_RTAX_AMT	CURR	12
RRFDTAX_AMT	Deductible Input Tax Amount in Reporting Currency		FOT_RRFDTAX_AMT	CURR	12
REP_CURR	Reporting Currency		FOT_CURR	CUKY	10	TCURC
NAME	Name 1		AD_NAME1	CHAR	80
CRED_CTRY	Country/Region Key		LAND1	CHAR	6	*
STREET	Street		AD_STREET	CHAR	120
HOUSE_NUM	House Number		AD_HSNM1	CHAR	20
POST_CODE	City postal code		AD_PSTCD1	CHAR	20
CITY	City		AD_CITY1	CHAR	80
STCEG	VAT Registration Number		STCEG	CHAR	40
STCD1	Tax Number 1		STCD1	CHAR	32
USERCHANGE	Changer of Rep. Data Electr. Communication with Authorities		FOT_USRCHG	CHAR	24	*
CHANTSTMP	Change Time of Reporting Data		FOT_CHTSTMP	DEC	9
STATUS	Status of Line Item for VAT Refund Procedure		FOT_ITEM_STATUS	CHAR	4
CHANGED	Line Item Changed Manually		FOT_CHANGED	CHAR	2
ORIG_REQ	Orig. Doc. Transferred to Tax Authority of Refund Ctry/Reg.		FOT_ORIGREQ	CHAR	2