SAP ABAP Table TAX_RFD_IF_TYPE (DMEE: Transaction Data for VAT Refund)

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	INTTAB	Structure
Structure	TAX_RFD_IF_TYPE	Table Relationship Diagram
Short Description	DMEE: Transaction Data for VAT Refund

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description
1	FOTRFDPARA	FOTRFDPARA		STRU	0	0
2	MANDT	MANDT	MANDT	CLNT	3	0	Client
3	REQID	FOT_RFDREQID	FOT_RFDREQID	CHAR	8	0	Identifies an VAT Refund Application
4	DECL_PARA	FOT_PARAM	FOT_PARAM	CHAR	30	0	Parameter(s) for Electronic Data Transmission to Authorities
5	DECL_PARV	FOT_PARVAL	FOT_PARVAL	CHAR	70	0	Parameter Value for Electr. Data Transmission to Authorities
6	DECL_AMT	FOT_DEC_SYS	WERTV8	CURR	15	2	Amount from System Electr. Data Transmission to Authorities
7	DECL_CURR	FOT_CURR	WAERS	CUKY	5	0	Reporting Currency
8	DECL_EXT_AMT	FOT_EXT_AMT	WERTV8	CURR	15	2	Ext. Amount for Electronic Data Transmission to Authorities
9	USERCHANGE	FOT_USRCHG	XUBNAME	CHAR	12	0	Changer of Rep. Data Electr. Communication with Authorities
10	CHANTSTMP	FOT_CHTSTMP	FOT_TSTMP	DEC	16	0	Change Time of Reporting Data
11	FOTRFDREQ	FOTRFDREQ		STRU	0	0
12	MANDT	MANDT	MANDT	CLNT	3	0	Client
13	REQID	FOT_RFDREQID	FOT_RFDREQID	CHAR	8	0	Identifies an VAT Refund Application
14	DECL_YEAR	FOT_DEYEAR	FOT_DEYEAR	NUMC	4	0	Reporting Year of Data Transmission to Authorities
15	DECL_PER_FROM	FOT_DCLPER_FROM	FOT_RFD_PER	NUMC	2	0	Reporting Period for VAT Refund Application
16	DECL_PER_TO	FOT_DCLPER_TO	FOT_RFD_PER	NUMC	2	0	Reporting Period for VAT Refund Application
17	RBASE_AMT	FOT_RBASE_AMT	WERTV8	CURR	15	2	Base Amount in Reporting Currency
18	RTX_AMT	FOT_RTAX_AMT	WERTV8	CURR	15	2	Tax Amount in Reporting Currency
19	RGROSS_AMT	FOT_RGROSS_AMT	WERTV8	CURR	15	2	Gross Amount in Reporting Currency
20	REP_CURR	FOT_CURR	WAERS	CUKY	5	0	Reporting Currency
21	DECL_LEGID	FOT_LEGAID	FOT_LEGAID	CHAR	32	0	ID of Reporting Data Electronic Data Transmission
22	DECL_SENID	FOT_SENDID	FOT_SENDID	NUMC	8	0	Identifies a Transfer of Reporting Data
23	SENDTSTMP	FOT_STSTMP	FOT_TSTMP	DEC	16	0	Transfer Time of Reporting Data
24	PROTTSTMP	FOT_PTSTMP	FOT_TSTMP	DEC	16	0	Time of Log Receipt
25	CREATSTMP	FOT_CTSTMP	FOT_TSTMP	DEC	16	0	Creation Time of Reporting Data
26	CHANTSTMP	FOT_CHTSTMP	FOT_TSTMP	DEC	16	0	Change Time of Reporting Data
27	USERCREATE	FOT_USRCRE	XUBNAME	CHAR	12	0	Creator of Return Data
28	USERSENT	FOT_USRSEN	XUBNAME	CHAR	12	0	Sender of Rep. Data Electr. Communication with Authorities
29	USERCHANGE	FOT_USRCHG	XUBNAME	CHAR	12	0	Changer of Rep. Data Electr. Communication with Authorities
30	DATEREPCONF	FOT_DATE_REP_CONF	DATUM	DATS	8	0	Receipt Date of VAT Rfd Application: Tax Reporting Country
31	DATERFDCONF	FOT_DATE_RFD_CONF	DATUM	DATS	8	0	Receipt Date - Tax Refund Country
32	DATETAXASSE	FOT_DATE_TAX_ASSE	DATUM	DATS	8	0	Date on which tax assessment was received
33	REQ_STATUS	FOT_RFDREQSTATUS	FOT_RFDREQSTATUS	CHAR	2	0	Status of VAT Refund Application
34	XIMESSKEY	FOT_XIMKEY	FOT_XIMKEY	CHAR	30	0	Key XI Message
35	FOT_TDATA	FOT_TDATA	FOT_TDATA	CHAR	1	0	Return Data for Test Purposes
36	FOTRFDPER	FOTRFDPER		STRU	0	0
37	.INCLUDE				0	0	Key Structure for VAT Refund Items
38	MANDT	MANDT	MANDT	CLNT	3	0	Client
39	.INCLUDE				0	0	Foreign Key for VAT Refund Items
40	DECL_TYPE	FOT_DCLTYP	FOT_DCLTYP	NUMC	4	0	Return Type for Authorities
41	TBUKRS	FOT_TBUKRS	BUKRS	CHAR	4	0	Dominant Enterprise/Company Code
42	DECL_CTRY	FOT_DCCTRY	LAND1	CHAR	3	0	Reporting Country
43	DECL_YEAR	FOT_DEYEAR	FOT_DEYEAR	NUMC	4	0	Reporting Year of Data Transmission to Authorities
44	DECL_PER	FOT_DCLPER	FOT_DCLPER	NUMC	2	0	Reporting Period Electronic Data Transmission
45	DECL_RUNID	FOT_RUNID	FOT_RUNID	NUMC	3	0	Counter of a Corrected Return
46	DECL_VERS	FOT_VERS	FOT_VERS	NUMC	3	0	New Version for Changed Return
47	RFD_CTRY	FOT_RFD_CTRY	LAND1	CHAR	3	0	Tax Refund Country
48	CREATSTMP	FOT_CTSTMP	FOT_TSTMP	DEC	16	0	Creation Time of Reporting Data
49	USERCREATE	FOT_USRCRE	XUBNAME	CHAR	12	0	Creator of Return Data
50	RBASE_AMT	FOT_RBASE_AMT	WERTV8	CURR	15	2	Base Amount in Reporting Currency
51	RTX_AMT	FOT_RTAX_AMT	WERTV8	CURR	15	2	Tax Amount in Reporting Currency
52	RGROSS_AMT	FOT_RGROSS_AMT	WERTV8	CURR	15	2	Gross Amount in Reporting Currency
53	REP_CURR	FOT_CURR	WAERS	CUKY	5	0	Reporting Currency
54	REQID	FOT_RFDREQID	FOT_RFDREQID	CHAR	8	0	Identifies an VAT Refund Application
55	FOTRFDITM_S	FOTRFDITM_S		STRU	0	0
56	.INCLUDE				0	0	VAT Refund Items
57	MANDT	MANDT	MANDT	CLNT	3	0	Client
58	RFD_ITEM_ID	FOT_RFD_ITEM_ID	FOT_RFD_ITEM_ID	CHAR	36	0	ID of VAT Refund-Related Line Items
59	.INCLUDE				0	0	Foreign Key for VAT Refund Items
60	DECL_TYPE	FOT_DCLTYP	FOT_DCLTYP	NUMC	4	0	Return Type for Authorities
61	TBUKRS	FOT_TBUKRS	BUKRS	CHAR	4	0	Dominant Enterprise/Company Code
62	DECL_CTRY	FOT_DCCTRY	LAND1	CHAR	3	0	Reporting Country
63	DECL_YEAR	FOT_DEYEAR	FOT_DEYEAR	NUMC	4	0	Reporting Year of Data Transmission to Authorities
64	DECL_PER	FOT_DCLPER	FOT_DCLPER	NUMC	2	0	Reporting Period Electronic Data Transmission
65	DECL_RUNID	FOT_RUNID	FOT_RUNID	NUMC	3	0	Counter of a Corrected Return
66	DECL_VERS	FOT_VERS	FOT_VERS	NUMC	3	0	New Version for Changed Return
67	RFD_CTRY	FOT_RFD_CTRY	LAND1	CHAR	3	0	Tax Refund Country
68	.INCLUDE				0	0	VAT Refund FI Items
69	DOC_POS	FOT_DOC_POS	FOT_DOC_POS	NUMC	3	0	Line Item Within a VAT Refund Application
70	BELNR	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
71	GJAHR	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
72	MONAT	MONAT	MONAT	NUMC	2	0	Fiscal period
73	BUDAT	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
74	XBLNR	XBLNR	XBLNR	CHAR	16	0	Reference Document Number
75	BLART	BLART	BLART	CHAR	2	0	Document type
76	LIFNR	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor
77	.INCLU-TV				0	0	VAT Refund TV Items
78	AWSYSTV	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System
79	PERNRTV	PERNR_D	PERNR	NUMC	8	0	Personnel Number
80	REINRTV	REINR	REINR	NUMC	10	0	Trip Number
81	PERIOTV	PTRV_PEROD	PTRV_PEROD	NUMC	3	0	Trip Period Number
82	PDVRSTV	FOT_PTRV_PDVRS	NUMC2	NUMC	2	0	Sequential Number of Period
83	BELNRTV	FOT_NRBEL	FOT_NRBEL	CHAR	3	0	Document Number
84	POSNRTV	FOT_PTRV_POSNR		NUMC	3	0	Item Number
85	REC_NOTV	FOT_PTRV_RECEIPT_NO		CHAR	16	0	Invoice Number of Original Document
86	REC_POS_NOTV	FOT_PTRV_RECEIPT_ITEM		NUMC	3	0	Number of Invoice Item
87	.INCLUDE				0	0	General Data for VAT Refund Items
88	RFD_SEQ_NO	FOT_RFD_SEQ_NO	FOT_SEQ_NO	CHAR	10	0	Sequential Number Within VAT Refund Application
89	RFD_ITM_CASE	FOT_RFD_ITM_CASE	FOT_RFD_ITM_CASE	CHAR	3	0	Type of VAT Refund Document
90	MWSKZ	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code
91	BLDAT	BLDAT	DATUM	DATS	8	0	Document Date in Document
92	RFD_ITEMSRC	FOT_RFD_ITEMORIG	FOT_RFD_ITEMORIG	CHAR	3	0	Origin of Line Item
93	RFD_CHAR	FOT_RFD_CHAR	FOT_RFD_CHAR	CHAR	3	0	Code for Goods and Services for VAT Refund Procedure
94	RFD_SUBCODE	FOT_TAX_RFD_SUB_CODE	TAX_RFD_SUB_CODE	CHAR	15	0	Subcode for VAT Refund
95	RFD_CH_SPARS	SPRAS	SPRAS	LANG	1	0	Language Key
96	RFD_CH_DESCR	FOT_RFD_CH_DESCR	CHAR100	CHAR	100	0	Additional Description of Nature of Goods and Services
97	BASE_AMT	FOT_BASE_AMT	WERTV8	CURR	15	2	Base Amount in Document Currency
98	TAX_AMT	FOT_TAX_AMT	WERTV8	CURR	15	2	Tax Amount in Document Currency
99	RFDTAX_AMT	FOT_RFDTAX_AMT	WERTV8	CURR	15	2	Deductible Input Tax Amount in Document Currency
100	ORIG_CURR	FOT_ORIG_CURR	WAERS	CUKY	5	0	Document Currency
101	RBASE_AMT	FOT_RBASE_AMT	WERTV8	CURR	15	2	Base Amount in Reporting Currency
102	RTX_AMT	FOT_RTAX_AMT	WERTV8	CURR	15	2	Tax Amount in Reporting Currency
103	RRFDTAX_AMT	FOT_RRFDTAX_AMT	WERTV8	CURR	15	2	Deductible Input Tax Amount in Reporting Currency
104	REP_CURR	FOT_CURR	WAERS	CUKY	5	0	Reporting Currency
105	NAME	AD_NAME1	TEXT40	CHAR	40	0	Name 1
106	CRED_CTRY	LAND1	LAND1	CHAR	3	0	Country Key
107	STREET	AD_STREET	TEXT60	CHAR	60	0	Street
108	HOUSE_NUM	AD_HSNM1	TEXT10	CHAR	10	0	House Number
109	POST_CODE	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
110	CITY	AD_CITY1	TEXT40	CHAR	40	0	City
111	STCEG	STCEG	STCEG	CHAR	20	0	VAT Registration Number
112	STCD1	STCD1	STCD1	CHAR	16	0	Tax Number 1
113	USERCHANGE	FOT_USRCHG	XUBNAME	CHAR	12	0	Changer of Rep. Data Electr. Communication with Authorities
114	CHANTSTMP	FOT_CHTSTMP	FOT_TSTMP	DEC	16	0	Change Time of Reporting Data
115	STATUS	FOT_ITEM_STATUS	FOT_ITEM_STATUS	CHAR	2	0	Status of Line Item for VAT Refund Procedure
116	CHANGED	FOT_CHANGED	XFELD	CHAR	1	0	Line Item Changed Manually
117	ORIG_REQ	FOT_ORIGREQ	XFELD	CHAR	1	0	Orig. Doc. Transferred to Tax Authority of Refund Country
118	RFD_CHAR_T	FOT_RFD_CHAR_T	TEXT180	CHAR	180	0	Short Text for VAT Refund Code
119	RFD_SUBCODE_T	FOT_TAX_RFD_SUB_C_T	TEXT180	CHAR	180	0	Text of Subcode
120	REQ_STATUS	FOT_RFDREQSTATUS	FOT_RFDREQSTATUS	CHAR	2	0	Status of VAT Refund Application
121	DATE_CHNGE	SYDATUM	SYDATS	DATS	8	0	System Date
122	TIME_CHNGE	SYUZEIT	SYTIME	TIMS	6	0	System Time
123	GROSS_AMT	FOT_GROSS_AMT	WERTV8	CURR	15	2	Gross Amount in Document Currency
124	RGROSS_AMT	FOT_RGROSS_AMT	WERTV8	CURR	15	2	Gross Amount in Reporting Currency
125	STATUS_T	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
126	ELEC_DOC_REQ	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
127	FI_BKPF_STBLG	STBLG	BELNR	CHAR	10	0	Reverse Document Number
128	FI_BKPF_STJAH	STJAH	GJAHR	NUMC	4	0	Reverse document fiscal year