SAP ABAP Table FOTRFDITMCHG (Change Documents, VAT Refund Item)

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	FOTRFDITMCHG	Table Relationship Diagram
Short Description	Change Documents, VAT Refund Item

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	CHANTSTMP	☑	FOT_CHTSTMP	FOT_TSTMP	DEC	16	0	Change Time of Reporting Data
4	DECL_CTRY	☐	FOT_DCCTRY	LAND1	CHAR	3	0	Reporting Country	*
5	RFD_CTRY	☐	FOT_RFD_CTRY	LAND1	CHAR	3	0	Tax Refund Country	*
6	USERCHANGE	☐	FOT_USRCHG	XUBNAME	CHAR	12	0	Changer of Rep. Data Electr. Communication with Authorities	*
7	XBLNR	☐	XBLNR	XBLNR	CHAR	16	0	Reference Document Number
8	RFD_CHAR	☐	FOT_RFD_CHAR	FOT_RFD_CHAR	CHAR	3	0	Code for Goods and Services for VAT Refund Procedure
9	RFD_SUBCODE	☐	FOT_TAX_RFD_SUB_CODE	TAX_RFD_SUB_CODE	CHAR	15	0	Subcode for VAT Refund
10	RFD_CH_SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
11	RFD_CH_DESCR	☐	FOT_RFD_CH_DESCR	CHAR100	CHAR	100	0	Additional Description of Nature of Goods and Services
12	BASE_AMT	☐	FOT_BASE_AMT	WERTV8	CURR	15	2	Base Amount in Document Currency
13	TAX_AMT	☐	FOT_TAX_AMT	WERTV8	CURR	15	2	Tax Amount in Document Currency
14	ORIG_CURR	☐	FOT_ORIG_CURR	WAERS	CUKY	5	0	Document Currency	TCURC
15	RBASE_AMT	☐	FOT_RBASE_AMT	WERTV8	CURR	15	2	Base Amount in Reporting Currency
16	RTX_AMT	☐	FOT_RTAX_AMT	WERTV8	CURR	15	2	Tax Amount in Reporting Currency
17	REP_CURR	☐	FOT_CURR	WAERS	CUKY	5	0	Reporting Currency	TCURC
18	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
19	NAME	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
20	CRED_CTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
21	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
22	HOUSE_NUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
23	POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
24	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
25	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
26	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
27	REC_NOTV	☐	FOT_PTRV_RECEIPT_NO		CHAR	16	0	Invoice Number of Original Document
28	REC_POS_NOTV	☐	FOT_PTRV_RECEIPT_ITEM		NUMC	3	0	Number of Invoice Item
29	STATUS	☐	FOT_ITEM_STATUS	FOT_ITEM_STATUS	CHAR	2	0	Status of Line Item for VAT Refund Procedure
30	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	FOTRFDITMCHG	MANDT	T000	MANDT	KEY	1	CN
2	FOTRFDITMCHG	ORIG_CURR	TCURC	WAERS
3	FOTRFDITMCHG	REP_CURR	TCURC	WAERS

History

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