Follow us on LinkedIn for your next SAP project

← Back to Search

SAP Table FMIOI

Commitment Documents Funds Management

FMIOI (Commitment Documents Funds Management) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FMIOI to other SAP tables.

FMIOI table fields

Field

Data element

Checktable

Datatype

Length

Decimals

Possible values

MANDT

Client

MANDT

T000

CLNT

REFBN

Reference Document Number

CO_REFBN

CHAR

REFBT

Reference document category

FM_REFBTYP

NUMC

Value	Description
010	Purchase requisitions
020	Purchase orders
110	Earmarked Funds
910	FI documents
900	Parked documents
040	Trips
920	CO documents
050	Sales Order Predecessor Document
060	Sales Orders

RFORG

Reference Organizational Units

AWORG

CHAR

RFPOS

Item number of reference document

CC_RFPOS

NUMC

RFKNT

Account assignment number of reference document

CC_RFKNT

NUMC

RFETE

Reference document classification number

CC_RFETE

NUMC

RCOND

Counter Conditions and Level Number

RCOND

NUMC

RFTYP

Reference Transaction

AWTYP

CHAR

RFSYS

Logical System

LOGSYSTEM

CHAR

BTART

Amount type

FM_BTART

CHAR

Value	Description
0100	Original
0110	Approved in Workflow (Workflow ledger 9D only)
0120	Not approved in Workflow (Workflow ledger 9D only)
0150	Change
0200	Reduction
0210	Reduction Cheque Clearing
0220	Change by Revaluation
0250	Paid
0260	Paid Cheque Clearing
0300	Previous Year Carryforward (Commitments)
0350	Following year carryforward (commitments)
0351	Commitment Carryforward: Carryforward Consumed Amount
0352	Commitment Carryforward: Reduction of Consumed Amount
0360	Balance from Previous Years
0400	Block Entry
0500	Adjustment by Follow-on Document
0600	Reassignment Sender
0650	Reassignment Receiver
0700	Settlement of Retirements
0750	Settlement of Acquisitions

RLDNR

Ledger

RLDNR

T881

CHAR

GJAHR

Fiscal Year

GJAHR

NUMC

STUNR

Number that clearly identifies the line key in database

FM_STUNR

CHAR

ZHLDT

Funds Management - Update Date

FM_ZHLDT

DATS

GNJHR

Year of Cash Effectivity

GNJHR

NUMC

PERIO

Period

CO_PERIO

NUMC

CFSTAT

FM Commitment Carryforward: Status

FM_CFST

NUMC

Value	Description
00
31	Carried forward to following year
32	Carried forward from previous year
41	Selected for carryforward (Workflow)
42	Carryforward Approved (Workflow)
51	Carryforward reversed
99	No commitment cfwd

CFSTATSV

Year-End Closing: Status (Back Up)

FM_CFSTSV

NUMC

Value	Description
00
31	Carried forward to following year
32	Carried forward from previous year
41	Selected for carryforward (Workflow)
42	Carryforward Approved (Workflow)
51	Carryforward reversed
99	No commitment cfwd

CFCNT

Year-End Closing: Number of Transfers

FM_CFCNT

NUMC

OBJNRZ

Object number

J_OBJNR

ONR00

CHAR

TRBTR

Amount in transaction currency

FM_TRBTR

CURR

FKBTR

Amount in FM area currency

FM_FKBTR

CURR

FISTL

Funds Center

FISTL

FMFCTR

CHAR

FONDS

Fund

BP_GEBER

FMFINCODE

CHAR

FIPEX

Commitment Item

FM_FIPEX

CHAR

FAREA

Functional Area

FM_FAREA

TFKB

CHAR

MEASURE

Funded Program

FM_MEASURE

CHAR

GRANT_NBR

Grant

GM_GRANT_NBR

CHAR

BUS_AREA

Business Area

GSBER

CHAR

PRCTR

Profit Center

PRCTR

CHAR

WRTTP

Value Type

FM_WRTTP

CHAR

Value	Description
50	Purchase Requisitions
51	Purchase Orders
52	Business Trip Commitments
54	Invoices
57	Payments
58	Down Payment Requests
60	Parked Documents
6B	Clarification Worklist FI-CA
61	Down Payments
64	Funds Transfers
65	Funds Commitment
66	Transfer Postings
80	Funds Block
81	Funds Reservation
82	Funds Precommitment
83	Forecast of Revenue
84	Payment Reservation (Not for General Use)
95	Secondary Cost Postings (CO)

VRGNG

CO Business Transaction

CO_VORGANG

TJ01

CHAR

BUKRS

Company Code

BUKRS

T001

CHAR

STATS

Funds Management Statistical Indicator

FM_STATS

CHAR

Value	Description
NULL	Real (Budget Relevant)
X	Statistical (not budget-relevant, no FYC)
Y	Statistical (not budget relevant, relevant for FYC)

TWAER

Transaction Currency

TWAER

TCURC

CUKY

CFLEV

Carryforward level

FM_CFLEV

CHAR

Value	Description
NULL	Document and Predecessor not Carried Forward
X	X Document or Predecessor Carried Forward
U	U Customer Flag: Document or Predecessor Carried Forward
NULL	Customer Specification: Number of Carryforwards

SGTXT

Item Text

SGTXT

CHAR

TRANR

Funds Management Transaction Number

FM_TRANR

CHAR

CTRNR

Funds Management Control Number

FM_CTRNR

CHAR

USERDIM

Customer Field for FM Actual and Commitment Data

FM_USERDIM

CHAR

FMVOR

Classification of Document Lines

FMVOR

CHAR

Value	Description
ADUP	Commitment Increase
ADDN	Commitment Decrease
PAMG	Purchase Account Processing
PD01	Price Difference, General
PD02	Price Difference, Relevant with Quantity
SC01	Subcontracting, Clearing
SC02	Subcontracting, Material Offsetting Posting

BUDGET_PD

FM: Budget Period

FM_BUDGET_PERIOD

CHAR

HKONT

General Ledger Account

HKONT

CHAR

ERLKZ

Completed Indicator for Open Items

ERLKZ

CHAR

Value	Description
NULL	Open
F	Reduced
X	Completed

LOEKZ

Deletion Indicator

KBLLOEKZ

CHAR

Value	Description
NULL	Not Selected
X	Selected

FIKRS

Financial Management Area

FIKRS

FM01

CHAR

BUDAT

Posting Date in the Document

BUDAT

DATS

LIFNR

Account Number of Vendor or Creditor

LIFNR

LFA1

CHAR

BL_DOC_TYPE

FM budgetary ledger document type

FM_BL_DOC_TYPE

CHAR

DP_WITH_PO

FM Down payment with reference to purchase order for BL

FM_DP_WITH_PO

CHAR

Value	Description
NULL	Down payment without reference to a purchase order
X	Down payment with reference to a purchase order

VREFBT

Predecessor document category

FM_VREFBT

NUMC

Value	Description
010	Purchase requisitions
020	Purchase orders
110	Earmarked Funds
910	FI documents
900	Parked documents
040	Trips
920	CO documents
050	Sales Order Predecessor Document
060	Sales Orders

VREFBN

Predecessor document number

FM_VREFBN

CHAR

VRFORG

Predecessor document organization

FM_VRFORG

CHAR

VRFPOS

Predecessor document item

FM_VRFPOS

NUMC

VRFKNT

Predecessor account assignment

FM_VRFKNT

NUMC

VRFTYP

Reference Transaction

AWTYP

CHAR

VRFSYS

Logical System

LOGSYSTEM

CHAR

ITCNACT

FM: Change with active CCN functionality

FM_ITCNACT

CHAR

Value	Description
X	Yes
NULL	No

CPUDT

Day On Which Accounting Document Was Entered

CPUDT

DATS

CPUTM

Time of Entry

CPUTM

TIMS

USNAM

User name

USNAM

CHAR

TCODE

Transaction Code

TCODE

CHAR

BLDOCDATE

Budgetary Ledger Document Date

FM_BL_DOCDATE

DATS

QUANT_OPEN

Quantity

MENGE_D

QUAN

QUANT_INV

Quantity

MENGE_D

QUAN

MEINS

Base Unit of Measure

MEINS

T006

UNIT

KUNNR

Customer Number

KUNNR

CHAR

FMIOI foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table	Check field
FMIOI	BUKRS	FMIOI	MANDT	T001 Company Codes	MANDT
FMIOI	BUKRS	FMIOI	BUKRS	T001 Company Codes	BUKRS
FMIOI	FAREA	SY	MANDT	TFKB Functional areas	MANDT
FMIOI	FAREA	FMIOI	FAREA	TFKB Functional areas	FKBER
FMIOI	FIKRS	FMIOI	MANDT	FM01 Financial Management Areas	MANDT
FMIOI	FIKRS	FMIOI	FIKRS	FM01 Financial Management Areas	FIKRS
FMIOI	FISTL	FMIOI	MANDT	FMFCTR Funds Center Master Record	MANDT
FMIOI	FISTL	FMIOI	FIKRS	FMFCTR Funds Center Master Record	FIKRS
FMIOI	FISTL	FMIOI	FISTL	FMFCTR Funds Center Master Record	FICTR
FMIOI	FISTL	FMIOI	BUDAT	FMFCTR Funds Center Master Record	DATBIS
FMIOI	FONDS	SY	MANDT	FMFINCODE FIFM: Financing code	MANDT
FMIOI	FONDS	FM01	FIKRS	FMFINCODE FIFM: Financing code	FIKRS
FMIOI	FONDS	FMIOI	FONDS	FMFINCODE FIFM: Financing code	FINCODE
FMIOI	LIFNR	FMIOI	MANDT	LFA1 Vendor Master (General Section)	MANDT
FMIOI	LIFNR	FMIOI	LIFNR	LFA1 Vendor Master (General Section)	LIFNR
FMIOI	MANDT	FMIOI	MANDT	T000 Clients	MANDT
FMIOI	MEINS	*		T006 Units of Measurement	MANDT
FMIOI	MEINS	FMIOI	MEINS	T006 Units of Measurement	MSEHI
FMIOI	OBJNRZ	FMIOI	MANDT	ONR00 General Object Number	MANDT
FMIOI	OBJNRZ	FMIOI	OBJNRZ	ONR00 General Object Number	OBJNR
FMIOI	RLDNR	FMIOI	RLDNR	T881 Ledger Master	RLDNR
FMIOI	RLDNR	FMIOI	MANDT	T881 Ledger Master	MANDT
FMIOI	TWAER	FMIOI	MANDT	TCURC Currency Codes	MANDT
FMIOI	TWAER	FMIOI	TWAER	TCURC Currency Codes	WAERS
FMIOI	VRGNG	FMIOI	VRGNG	TJ01 Business Transactions	VRGNG
FMIOI	ZZREGION	SYST	MANDT	ZREG User Defined Regions	MANDT
FMIOI	ZZREGION	FMIOI	ZZREGION	ZREG User Defined Regions	ZZREGION
FMIOI	ZZSPREG	SYST	MANDT	ZZSPREG Check table for ZZSPREG = Special Region	MANDT
FMIOI	ZZSPREG	FMIOI	ZZSPREG	ZZSPREG Check table for ZZSPREG = Special Region	ZZSPREG
FMIOI	ZZSTATE	SYST	MANDT	T005S Taxes: Region (Province) Key	MANDT
FMIOI	ZZSTATE	*		T005S Taxes: Region (Province) Key	LAND1
FMIOI	ZZSTATE	FMIOI	ZZSTATE	T005S Taxes: Region (Province) Key	BLAND
FMIOI	ZZUSERFLD1	SYST	MANDT	ZFU1 Check Table for User Field 1	MANDT
FMIOI	ZZUSERFLD1	FMIOI	ZZUSERFLD1	ZFU1 Check Table for User Field 1	ZZUSERFLD1