FOTRFDITM SAP (VAT Refund Items) Table details
Dictionary Type: Table
Description: VAT Refund Items
Description: VAT Refund Items
Table field list including key, data, relationships and ABAP select examples
FOTRFDITM is a standard SAP Table which is used to store VAT Refund Items data and is available within R/3 SAP systems depending on the version and release level.
The FOTRFDITM table consists of various fields, each holding specific information or linking keys about VAT Refund Items data available in SAP. These include RFD_ITEM_ID (ID of VAT Refund-Related Line Items), DECL_TYPE (Return Type for Authorities), TBUKRS (Dominant Enterprise/Company Code), DECL_CTRY (Reporting Country).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FOTRFDITM table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| RFD_ITEM_ID | ID of VAT Refund-Related Line Items | FOT_RFD_ITEM_ID | CHAR | 36 | FOT_RFD_ITEM_ID | ||||
| DECL_TYPE | Return Type for Authorities | FOT_DCLTYP | NUMC | 4 | FOT_DCLTYP | FOTTYP | |||
| TBUKRS | Dominant Enterprise/Company Code | FOT_TBUKRS | CHAR | 4 | Assigned to domain | BUKRS | FOTORG | ||
| DECL_CTRY | Reporting Country | FOT_DCCTRY | CHAR | 3 | Assigned to domain | LAND1 | FOTCTRY | ||
| DECL_YEAR | Reporting Year of Data Transmission to Authorities | FOT_DEYEAR | NUMC | 4 | FOT_DEYEAR | FOTYEAR | |||
| DECL_PER | Reporting Period Electronic Data Transmission | FOT_DCLPER | NUMC | 2 | FOT_DCLPER | ||||
| DECL_RUNID | Counter of a Corrected Return | FOT_RUNID | NUMC | 3 | FOT_RUNID | ||||
| DECL_VERS | New Version for Changed Return | FOT_VERS | NUMC | 3 | FOT_VERS | ||||
| RFD_CTRY | Tax Refund Country | FOT_RFD_CTRY | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
| DOC_POS | Line Item Within a VAT Refund Application | FOT_DOC_POS | NUMC | 3 | FOT_DOC_POS | ||||
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
| MONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
| XBLNR | Reference Document Number | XBLNR | CHAR | 16 | XBLNR | ||||
| BLART | Document Type | BLART | CHAR | 2 | T003 | BLART | BAR | ||
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
| .INCLU-TV | 0 | ||||||||
| AWSYSTV | Logical System | LOGSYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
| PERNRTV | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
| REINRTV | Trip Number | REINR | NUMC | 10 | REINR | ||||
| PERIOTV | Trip Period Number | PTRV_PEROD | NUMC | 3 | PTRV_PEROD | ||||
| PDVRSTV | Sequential Number of Period | FOT_PTRV_PDVRS | NUMC | 2 | NUMC2 | ||||
| BELNRTV | Document Number | FOT_NRBEL | CHAR | 3 | FOT_NRBEL | ||||
| POSNRTV | Item Number | FOT_PTRV_POSNR | NUMC | 3 | |||||
| REC_NOTV | Invoice Number of Original Document | FOT_PTRV_RECEIPT_NO | CHAR | 16 | |||||
| REC_POS_NOTV | Number of Invoice Item | FOT_PTRV_RECEIPT_ITEM | NUMC | 3 | |||||
| RFD_SEQ_NO | Sequential Number Within VAT Refund Application | FOT_RFD_SEQ_NO | CHAR | 10 | ALPHA | FOT_SEQ_NO | |||
| RFD_ITM_CASE | Type of VAT Refund Document | FOT_RFD_ITM_CASE | CHAR | 3 | FOT_RFD_ITM_CASE | ||||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
| BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
| RFD_ITEMSRC | Origin of Line Item | FOT_RFD_ITEMORIG | CHAR | 3 | FOT_RFD_ITEMORIG | ||||
| RFD_CHAR | Code for Goods and Services for VAT Refund Procedure | FOT_RFD_CHAR | CHAR | 3 | ALPHA | FOT_RFD_CHAR | |||
| RFD_SUBCODE | Subcode for VAT Refund | FOT_TAX_RFD_SUB_CODE | CHAR | 15 | Assigned to domain | TAX_RFD_SUB_CODE | |||
| RFD_CH_SPARS | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
| RFD_CH_DESCR | Additional Description of Nature of Goods and Services | FOT_RFD_CH_DESCR | CHAR | 100 | CHAR100 | ||||
| BASE_AMT | Base Amount in Document Currency | FOT_BASE_AMT | CURR | 15(2) | WERTV8 | ||||
| TAX_AMT | Tax Amount in Document Currency | FOT_TAX_AMT | CURR | 15(2) | WERTV8 | ||||
| RFDTAX_AMT | Deductible Input Tax Amount in Document Currency | FOT_RFDTAX_AMT | CURR | 15(2) | WERTV8 | ||||
| ORIG_CURR | Document Currency | FOT_ORIG_CURR | CUKY | 5 | TCURC | WAERS | |||
| RBASE_AMT | Base Amount in Reporting Currency | FOT_RBASE_AMT | CURR | 15(2) | WERTV8 | ||||
| RTX_AMT | Tax Amount in Reporting Currency | FOT_RTAX_AMT | CURR | 15(2) | WERTV8 | ||||
| RRFDTAX_AMT | Deductible Input Tax Amount in Reporting Currency | FOT_RRFDTAX_AMT | CURR | 15(2) | WERTV8 | ||||
| REP_CURR | Reporting Currency | FOT_CURR | CUKY | 5 | TCURC | WAERS | |||
| NAME | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
| CRED_CTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
| STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
| HOUSE_NUM | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
| POST_CODE | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
| CITY | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
| STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
| STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
| USERCHANGE | Changer of Rep. Data Electr. Communication with Authorities | FOT_USRCHG | CHAR | 12 | Assigned to domain | XUBNAME | |||
| CHANTSTMP | Change Time of Reporting Data | FOT_CHTSTMP | DEC | 16 | FOT_TSTMP | ||||
| STATUS | Status of Line Item for VAT Refund Procedure | FOT_ITEM_STATUS | CHAR | 2 | FOT_ITEM_STATUS | ||||
| CHANGED | Line Item Changed Manually | FOT_CHANGED | CHAR | 1 | XFELD | ||||
| ORIG_REQ | Orig. Doc. Transferred to Tax Authority of Refund Country | FOT_ORIGREQ | CHAR | 1 | XFELD |
| Key field | Non-key field |
How do I retrieve data from SAP table FOTRFDITM using ABAP code
The following ABAP code Example will allow you to do a basic selection on FOTRFDITM to SELECT all data from the tableDATA: WA_FOTRFDITM TYPE FOTRFDITM.
SELECT SINGLE *
FROM FOTRFDITM
INTO CORRESPONDING FIELDS OF WA_FOTRFDITM
WHERE...
How to access SAP table FOTRFDITM
Within an ECC or HANA version of SAP you can also view further information about FOTRFDITM and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects