SAP ABAP Table FOTRFDITM (VAT Refund Items)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI (Application Component) Financial Accounting
     ⤷ FOT_EDECLARATION (Package) Electronic Advance Return for Tax on Sales/Purchases

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FOTRFDITM	Table Relationship Diagram
Short Description	VAT Refund Items

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	RFD_ITEM_ID	☑	FOT_RFD_ITEM_ID	FOT_RFD_ITEM_ID	CHAR	36	0	ID of VAT Refund-Related Line Items
3	.INCLUDE	☐				0	0	Foreign Key for VAT Refund Items
4	DECL_TYPE	☐	FOT_DCLTYP	FOT_DCLTYP	NUMC	4	0	Return Type for Authorities
5	TBUKRS	☐	FOT_TBUKRS	BUKRS	CHAR	4	0	Dominant Enterprise/Company Code	*
6	DECL_CTRY	☐	FOT_DCCTRY	LAND1	CHAR	3	0	Reporting Country	*
7	DECL_YEAR	☐	FOT_DEYEAR	FOT_DEYEAR	NUMC	4	0	Reporting Year of Data Transmission to Authorities
8	DECL_PER	☐	FOT_DCLPER	FOT_DCLPER	NUMC	2	0	Reporting Period Electronic Data Transmission
9	DECL_RUNID	☐	FOT_RUNID	FOT_RUNID	NUMC	3	0	Counter of a Corrected Return
10	DECL_VERS	☐	FOT_VERS	FOT_VERS	NUMC	3	0	New Version for Changed Return
11	RFD_CTRY	☐	FOT_RFD_CTRY	LAND1	CHAR	3	0	Tax Refund Country	*
12	.INCLUDE	☐				0	0	VAT Refund FI Items
13	DOC_POS	☐	FOT_DOC_POS	FOT_DOC_POS	NUMC	3	0	Line Item Within a VAT Refund Application
14	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
15	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
16	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
17	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
18	XBLNR	☐	XBLNR	XBLNR	CHAR	16	0	Reference Document Number
19	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
20	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
21	.INCLU-TV	☐				0	0	VAT Refund TV Items
22	AWSYSTV	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
23	PERNRTV	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
24	REINRTV	☐	REINR	REINR	NUMC	10	0	Trip Number
25	PERIOTV	☐	PTRV_PEROD	PTRV_PEROD	NUMC	3	0	Trip Period Number
26	PDVRSTV	☐	FOT_PTRV_PDVRS	NUMC2	NUMC	2	0	Sequential Number of Period
27	BELNRTV	☐	FOT_NRBEL	FOT_NRBEL	CHAR	3	0	Document Number
28	POSNRTV	☐	FOT_PTRV_POSNR		NUMC	3	0	Item Number
29	REC_NOTV	☐	FOT_PTRV_RECEIPT_NO		CHAR	16	0	Invoice Number of Original Document
30	REC_POS_NOTV	☐	FOT_PTRV_RECEIPT_ITEM		NUMC	3	0	Number of Invoice Item
31	.INCLUDE	☐				0	0	General Data for VAT Refund Items
32	RFD_SEQ_NO	☐	FOT_RFD_SEQ_NO	FOT_SEQ_NO	CHAR	10	0	Sequential Number Within VAT Refund Application
33	RFD_ITM_CASE	☐	FOT_RFD_ITM_CASE	FOT_RFD_ITM_CASE	CHAR	3	0	Type of VAT Refund Document
34	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
35	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
36	RFD_ITEMSRC	☐	FOT_RFD_ITEMORIG	FOT_RFD_ITEMORIG	CHAR	3	0	Origin of Line Item
37	RFD_CHAR	☐	FOT_RFD_CHAR	FOT_RFD_CHAR	CHAR	3	0	Code for Goods and Services for VAT Refund Procedure
38	RFD_SUBCODE	☐	FOT_TAX_RFD_SUB_CODE	TAX_RFD_SUB_CODE	CHAR	15	0	Subcode for VAT Refund	*
39	RFD_CH_SPARS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
40	RFD_CH_DESCR	☐	FOT_RFD_CH_DESCR	CHAR100	CHAR	100	0	Additional Description of Nature of Goods and Services
41	BASE_AMT	☐	FOT_BASE_AMT	WERTV8	CURR	15	2	Base Amount in Document Currency
42	TAX_AMT	☐	FOT_TAX_AMT	WERTV8	CURR	15	2	Tax Amount in Document Currency
43	RFDTAX_AMT	☐	FOT_RFDTAX_AMT	WERTV8	CURR	15	2	Deductible Input Tax Amount in Document Currency
44	ORIG_CURR	☐	FOT_ORIG_CURR	WAERS	CUKY	5	0	Document Currency	TCURC
45	RBASE_AMT	☐	FOT_RBASE_AMT	WERTV8	CURR	15	2	Base Amount in Reporting Currency
46	RTX_AMT	☐	FOT_RTAX_AMT	WERTV8	CURR	15	2	Tax Amount in Reporting Currency
47	RRFDTAX_AMT	☐	FOT_RRFDTAX_AMT	WERTV8	CURR	15	2	Deductible Input Tax Amount in Reporting Currency
48	REP_CURR	☐	FOT_CURR	WAERS	CUKY	5	0	Reporting Currency	TCURC
49	NAME	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
50	CRED_CTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
51	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
52	HOUSE_NUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
53	POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
54	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
55	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
56	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
57	USERCHANGE	☐	FOT_USRCHG	XUBNAME	CHAR	12	0	Changer of Rep. Data Electr. Communication with Authorities	*
58	CHANTSTMP	☐	FOT_CHTSTMP	FOT_TSTMP	DEC	16	0	Change Time of Reporting Data
59	STATUS	☐	FOT_ITEM_STATUS	FOT_ITEM_STATUS	CHAR	2	0	Status of Line Item for VAT Refund Procedure
60	CHANGED	☐	FOT_CHANGED	XFELD	CHAR	1	0	Line Item Changed Manually
61	ORIG_REQ	☐	FOT_ORIGREQ	XFELD	CHAR	1	0	Orig. Doc. Transferred to Tax Authority of Refund Country

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FOTRFDITM	BLART	T003	BLART	REF	1	CN
2	FOTRFDITM	LIFNR	LFA1	LIFNR	REF	C	CN
3	FOTRFDITM	MANDT	T000	MANDT	KEY	1	CN
4	FOTRFDITM	ORIG_CURR	TCURC	WAERS	REF	1	CN
5	FOTRFDITM	REP_CURR	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	605