FMIFIIT

FI Line Item Table in Funds Management | #transactional | Component: Funds Management
Column Name Description
MANDT FK Client
FMBELNR FK Document Number of FM Line Item
FIKRS FK Financial Management Area
FMBUZEI Number of a posting line in a TR-FM line item
BTART Amount Type Show values
RLDNR Ledger
GJAHR Fiscal Year
STUNR Number That Clearly Identifies the Line Key in Database
Column Name Description
💲 Transaction Currency (TWAER):
TRBTR Amount in transaction currency
💲 Financial Management Area Currency (FM01.WAERS):
FKBTR Amount in FM area currency
SKNTO Cash Discount Amount in Local Currency
RDIFF Exchange Rate Gain/Loss Realized
Column Name Description
MENGE Quantity
Column Name Description
ZHLDT Funds Management Update Date
PSOBT Posting Day
Column Name Description
BTART Amount Type Show values
CFSTAT FM Commitment Carryforward: Status Show values
CFSTATSV Year-End Closing: Status (Back Up) Show values
WRTTP Value Type Show values
STATS Funds Management Statistical Indicator Show values
CFLEV Carryforward Level Show values
FMVOR Classification of Document Lines Show values
PAYFLG Payment Status of FM Documents Show values
PUMETH Payment Update Procedure in FM Show values
VREFBT Predecessor Document Category Show values
Column Name Description Domain name
GNJHR Year of Cash Effectivity GJAHR
PERIO Period PERBL
CFCNT Year-End Closing: Number of Transfers FM_CFCNT
FIPEX Commitment Item FM_FIPEX
MEASURE Funded Program FM_MEASURE
GRANT_NBR Grant GM_GRANT_NBR
BUS_AREA Business Area GSBER
PRCTR Profit Center PRCTR
SGTXT Item Text TEXT50
TRANR Funds Management Transaction Number CHAR16
CTRNR Funds Management Control Number CHAR20
USERDIM Customer Field for FM Actual and Commitment Data FM_USERDIM
DUMMY_INCL_EEW_COBL Custom Fields: Dummy for Use in Extension Includes
BUDGET_PD Budget Period FM_BUDGET_PERIOD
HKONT General Ledger Account SAKNR
VOBUKRS Company code for payment document number BUKRS
VOGJAHR Fiscal year for payment document number GJAHR
VOBELNR Payment Document Number BELNR
VOBUZEI Item for Payment Document Number BUZEI
KNGJAHR Fiscal year for FI document number GJAHR
KNBELNR FI document number BELNR
KNBUZEI Document item for FI document number BUZEI
VBUND Company ID of Trading Partner RCOMP
XREF3 Reference key for line item CHAR20
VREFBN Predecessor Document Number BELNR
VRFORG Predecessor Document Organization AWORG
VRFPOS Predecessor Document Item NUMC05
VRFKNT Predecessor Account Assignment NUM05
VRFTYP Reference procedure AWTYP
VRFSYS Logical System LOGSYS
FMXDOCNR FM Reference Document Number BELNR
FMXYEAR FM Reference Year GJAHR
FMXDOCLN FM Reference Line Item NUMC6
FMXZEKKN FM Reference Sequence Account Assignment NUMC5
Master Data Relations Join Conditions
Company Code
  • FMIFIIT.MANDT == T001.MANDT
  • FMIFIIT.BUKRS == T001.BUKRS
Functional Area
  • FMIFIIT.MANDT == TFKB.MANDT
  • FMIFIIT.FAREA == TFKB.FKBER
Financial Management Area
  • FMIFIIT.MANDT == FM01.MANDT
  • FMIFIIT.FIKRS == FM01.FIKRS
Funds Center
  • Funds Center
  • Funds Management Update Date
  • Client
  • Financial Management Area
  • FMIFIIT.FISTL == FMFCTR.FICTR
  • FMIFIIT.ZHLDT == FMFCTR.DATBIS
  • FMIFIIT.MANDT == FMFCTR.MANDT
  • FMIFIIT.FIKRS == FMFCTR.FIKRS
Fund
  • Financial Management Area
  • Fund
  • Client
Client FMIFIIT.MANDT == T000.MANDT
Base Unit of Measure
  • FMIFIIT.MANDT == T006.MANDT
  • FMIFIIT.MEINS == T006.MSEHI
Transaction Currency
  • FMIFIIT.MANDT == TCURC.MANDT
  • FMIFIIT.TWAER == TCURC.WAERS