FOTRFDITM

VAT Refund Items | #transactional | #language | Component: Value Added Tax (VAT)
Column Name Description
MANDT FK Client
RFD_ITEM_ID ID of VAT Refund-Related Line Items
Column Name Description
💲 Document Currency (ORIG_CURR):
BASE_AMT Base Amount in Document Currency
TAX_AMT Tax Amount in Document Currency
RFDTAX_AMT Deductible Input Tax Amount in Document Currency
💲 Reporting Currency (REP_CURR):
RBASE_AMT Base Amount in Reporting Currency
RTX_AMT Tax Amount in Reporting Currency
RRFDTAX_AMT Deductible Input Tax Amount in Reporting Currency
Column Name Description
Column Name Description
BUDAT Posting Date in the Document
TXDAT Date for Determining Tax Rates
TXDAT_FROM Valid-From Date of the Tax Rate
BLDAT Document Date in Document
Column Name Description
DECL_TYPE Return Type for Authorities Show values
RFD_ITM_CASE Type of VAT Refund Document Show values
RFD_ITEMSRC Origin of Line Item Show values
STATUS Status of Line Item for VAT Refund Procedure Show values
CHANGED Line Item Changed Manually Show values
ORIG_REQ Orig. Doc. Transferred to Tax Authority of Refund Ctry/Reg. Show values
Column Name Description Domain name
DECL_YEAR Reporting Year of Data Transmission to Authorities FOT_DEYEAR
DECL_PER Reporting Period of Electronic Data Transmission FOT_DCLPER
DECL_RUNID Counter of a Corrected Return FOT_RUNID
DECL_VERS New Version for Changed Return FOT_VERS
DOC_POS Line Item Within a VAT Refund Application FOT_DOC_POS
BELNR Document Number of an Accounting Document BELNR
GJAHR Fiscal Year GJAHR
MONAT Fiscal period MONAT
XBLNR Reference Document Number XBLNR
AWSYSTV Logical System LOGSYS
PERNRTV Personnel Number PERNR
REINRTV Trip Number REINR
PERIOTV Trip Period Number PTRV_PEROD
PDVRSTV Sequential Number of Period NUMC2
BELNRTV Document Number FOT_NRBEL
POSNRTV Item Number
REC_NOTV Invoice Number of Original Document
REC_POS_NOTV Number of Invoice Item
RFD_SEQ_NO Sequential Number Within VAT Refund Application FOT_SEQ_NO
MWSKZ Tax on sales/purchases code MWSKZ
RFD_CHAR Code for Goods and Services for VAT Refund Procedure FOT_RFD_CHAR
RFD_CH_SPARS Language Key SPRAS
RFD_CH_DESCR Additional Description of Nature of Goods and Services CHAR100
NAME Name 1 TEXT40
CRED_CTRY Country/Region Key LAND1
STREET Street TEXT60
HOUSE_NUM House Number TEXT10
POST_CODE City postal code CHAR10
CITY City TEXT40
STCEG VAT Registration Number STCEG
STCD1 Tax Number 1 STCD1
USERCHANGE Changer of Rep. Data Electr. Communication with Authorities XUBNAME
CHANTSTMP Change Time of Reporting Data FOT_TSTMP
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • FOTRFDITM.BLART == T003.BLART
  • FOTRFDITM.MANDT == T003.MANDT
Foreign Key Relationship to Supplier
  • FOTRFDITM.MANDT == LFA1.MANDT
  • FOTRFDITM.LIFNR == LFA1.LIFNR
Client FOTRFDITM.MANDT == T000.MANDT
Document Currency
  • FOTRFDITM.MANDT == TCURC.MANDT
  • FOTRFDITM.ORIG_CURR == TCURC.WAERS
Reporting Currency
  • FOTRFDITM.MANDT == TCURC.MANDT
  • FOTRFDITM.REP_CURR == TCURC.WAERS