FMIFIIT SAP (FI Line Item Table in Funds Management) Table details

Dictionary Type: Table
Description: FI Line Item Table in Funds Management




ABAP Code to SELECT data from FMIFIIT
Related tables to FMIFIIT
Access table FMIFIIT




Table field list including key, data, relationships and ABAP select examples

FMIFIIT is a standard SAP Table which is used to store FI Line Item Table in Funds Management data and is available within R/3 SAP systems depending on the version and release level.

The FMIFIIT table consists of various fields, each holding specific information or linking keys about FI Line Item Table in Funds Management data available in SAP. These include FMBELNR (Document Number of FM Line Item), FIKRS (Financial Management Area), FMBUZEI (Number of a posting line in a TR-FM line item), BTART (Amount type).. 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 FMIFIIT 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
MANDTClient MANDTCLNT3T000MANDT
FMBELNRDocument Number of FM Line Item FM_BELNRCHAR10FMIFIHDALPHABELNR
FIKRSFinancial Management Area FIKRSCHAR4FM01FIKRSFIK
FMBUZEINumber of a posting line in a TR-FM line item FM_BUZEINUMC3NUMC03
BTARTAmount type FM_BTARTCHAR4FM_BTART
RLDNRLedger RLDNRCHAR2Assigned to domainALPHARLDNRGLNH_T881
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
STUNRNumber that clearly identifies the line key in database FM_STUNRCHAR16CHAR16
ZHLDTFunds Management - Update Date FM_ZHLDTDATS8DATUM
GNJHRYear of Cash Effectivity GNJHRNUMC4GJAHRGJAHRGNJHR
PERIOPeriod CO_PERIONUMC3PERBLVPE
CFSTATFM Commitment Carryforward: Status FM_CFSTNUMC2FM_CFST
CFSTATSVYear-End Closing: Status (Back Up) FM_CFSTSVNUMC2FM_CFST
CFCNTYear-End Closing: Number of Transfers FM_CFCNTNUMC2FM_CFCNT
OBJNRZObject number J_OBJNRCHAR22ONR00J_OBJNRONR
TRBTRAmount in transaction currency FM_TRBTRCURR13(2) WERTV7
FKBTRAmount in FM area currency FM_FKBTRCURR13(2) WERTV7
FISTLFunds Center FISTLCHAR16FMFCTRFISTLFIS
FONDSFund BP_GEBERCHAR10FMFINCODEBP_GEBERFIC
FIPEXCommitment Item FM_FIPEXCHAR24Assigned to domainFM_FIPEXFPS
FAREAFunctional Area FM_FAREACHAR16TFKBFKBERFBE
MEASUREFunded Program FM_MEASURECHAR24Assigned to domainFM_MEASUREFM_MEASURE
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
BUS_AREABusiness Area GSBERCHAR4Assigned to domainGSBERGSB
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
WRTTPValue Type FM_WRTTPCHAR2FM_WRTTP
VRGNGCO Business Transaction CO_VORGANGCHAR4TJ01J_VORGANG
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
STATSFunds Management Statistical Indicator FM_STATSCHAR1FM_STATS
TWAERTransaction Currency TWAERCUKY5TCURCWAERSFWS
CFLEVCarryforward level FM_CFLEVCHAR1FM_CFLEV
SGTXTItem Text SGTXTCHAR50TEXT50
TRANRFunds Management Transaction Number FM_TRANRCHAR16CHAR16
CTRNRFunds Management Control Number FM_CTRNRCHAR20CHAR20
USERDIMCustomer Field for FM Actual and Commitment Data FM_USERDIMCHAR10CHAR10
.INCLU--AP 0
FMVORClassification of Document Lines FMVORCHAR4FMVOR
.INCLU--AP 0
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
VOBUKRSCompany code for payment document number FM_VOBUKRSCHAR4Assigned to domainBUKRS
VOGJAHRFiscal year for payment document number FM_VOGJAHRNUMC4GJAHRGJAHRGJR
VOBELNRPayment Document Number FM_VOBELNRCHAR10ALPHABELNRBLN
VOBUZEIItem for payment document number FM_VOBUZEINUMC3BUZEI
KNGJAHRFiscal year for FI document number FM_KNGJAHRNUMC4GJAHRGJAHRGJR
KNBELNRFI document number FM_KNBELNRCHAR10ALPHABELNRBLN
KNBUZEIDocument item for FI document number FM_KNBUZEINUMC3BUZEI
SKNTOCash discount amount in local currency SKNTOCURR13(2) WERT7
RDIFFExchange Rate Gain/Loss Realized RDIFFCURR13(2) WRTV7
PAYFLGPayment Status of FM Documents FM_PAYFLGCHAR1FM_PAYFLG
PSOBTPosting Day PSOBTDATS8DATUM
MENGEQuantity MENGE_DQUAN13(3) MENG13
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
XREF3Reference key for line item XREF3CHAR20CHAR20
PUMETHPayment Update Procedure in FM PUMETHCHAR4PUMETH
VREFBTPredecessor document category FM_VREFBTNUMC3FM_REFBTYP
VREFBNPredecessor document number FM_VREFBNCHAR10ALPHABELNR
VRFORGPredecessor document organization FM_VRFORGCHAR10AWORG
VRFPOSPredecessor document item FM_VRFPOSNUMC5NUMC05
VRFKNTPredecessor account assignment FM_VRFKNTNUMC5NUM05
VRFTYPReference Transaction AWTYPCHAR5Assigned to domainAWTYP
VRFSYSLogical System LOGSYSTEMCHAR10Assigned to domainALPHALOGSYS
FMXDOCNRFM Reference Document Number FM_XDOCNRCHAR10ALPHABELNR
FMXYEARFM Reference Year FM_XYEARNUMC4GJAHRGJAHR
FMXDOCLNFM Reference Line Item FM_XDOCLNNUMC6NUMC6
FMXZEKKNFM Reference Sequence Account Assignment FM_XZEKKNNUMC5NUMC5

Key field Non-key field



How do I retrieve data from SAP table FMIFIIT using ABAP code

The following ABAP code Example will allow you to do a basic selection on FMIFIIT to SELECT all data from the table
DATA: WA_FMIFIIT TYPE FMIFIIT.

SELECT SINGLE *
FROM FMIFIIT
INTO CORRESPONDING FIELDS OF WA_FMIFIIT
WHERE...

How to access SAP table FMIFIIT

Within an ECC or HANA version of SAP you can also view further information about FMIFIIT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!