SAP ABAP Table FOTRFDITM_S (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	INTTAB	Structure
Structure	FOTRFDITM_S	Table Relationship Diagram
Short Description	VAT Refund Items

Delivery and Maintenance

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

Foreign Keys

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

History

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