Follow us on LinkedIn for your next SAP project

SAP Table FMCI

Commitment items master data

FMCI (Commitment items master data) 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 FMCI to other SAP tables.

FMCI table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
MANDT T000
CLNT
3 0
FIKRS
Financial Management Area
FIKRS FM01
CHAR
4 0
GJAHR
Fiscal Year
GJAHR
NUMC
4 0
FIPEX
Commitment Item
FM_FIPEX
CHAR
24 0
KATEG
Attribute: Can be Posted To
FM_KATEG
NUMC
1 0
FIVOR
Financial transaction
FM_FIVOR
NUMC
2 0
POTYP
Commitment Item Category
FM_POTYP
NUMC
1 0
KRTYP
Commitment item criterion category
FM_KRTYP FMKRTP
CHAR
5 0
FPART
Commitment Item Type
FM_FPART
CHAR
3 0
FIPUP
Superior Commitment Item
FIPEX_UP
CHAR
24 0
POSIT
Item (Internal Commitment Item Number)
FM_POSIT
CHAR
8 0
FICTR
Funds Center (Default Value in a Commitment Item)
FM_DFICTR FMFCTR
CHAR
16 0
VPTYP
Carryforward item category for commitment item
FM_VPTYP FMVORTR0
CHAR
2 0
SNTYP
Collective budget adminstration category
FM_COLLTYP
CHAR
1 0
SNROL
Use type in collective budget administration
FM_COLLROL
CHAR
1 0
KRGRP
Criterion category group
FM_KRGRP FMKRG
CHAR
4 0
STATS
Statistical commitment item
FM_STATPOS
CHAR
1 0
NCBUD
No Budget for Future Years
FM_NCBUD
CHAR
1 0
AUGRP
Authorization Groups of the Commitment Item
FM_AUTHGRP
CHAR
10 0
STVAR
Standard variant
FM_STVAR
CHAR
1 0
HSART
Commitment Item Type
FM_HSART FMHSART
CHAR
1 0
GKFLG
Relevant to total costs
FM_GKFLG
CHAR
1 0
DRUCK
Not relevant for budget print
FM_DRUCK
CHAR
1 0
CFFLG
Able to carry forward at fiscal year change
FM_CFFLG
CHAR
1 0
CVFLG
(Negative) clearing item
FM_CVFLG
CHAR
1 0
NEGBUD
Negative Budget Permitted
FM_NEG_BUDGET_FLG
CHAR
1 0
BEZIRK
District
FM_BEZIRK
CHAR
4 0
BSAMT
Managed position / clearing lower section
FM_BSAMT FMFCTR
CHAR
16 0
UBFLG
Local authorities: Budget execution account
FM_UBFLG
CHAR
1 0
HSFLG
Budget balancing concept
FM_HSFLG
CHAR
1 0
NDAKZ
Indicator: NDA Budget
FM_NDAB
CHAR
1 0
AZPKZ
Indicator: Accrued Budget
FM_AZPB
CHAR
1 0
LOGSYSTEM
Logical System
LOGSYSTEM TBDLS
CHAR
10 0
FIPOS
Commitment Item
FIPOS
CHAR
14 0
BUTYP
Budget structure element type
BUTYP
CHAR
4 0
DATAB
FM: Valid from date
FM_DATAB
DATS
8 0
DATBIS
FM: Valid to date
FM_DATBIS
DATS
8 0
DATE_EXP
Expiration Date
FM_DATE_EXP
DATS
8 0
DUMMY_FMCIEXT
Single-Character Indicator
CHAR1
CHAR
1 0
DUMMY_FSTR
Single-Character Indicator
CHAR1
CHAR
1 0
STR_ID
Master Data Subdivision ID
FM_STR_ID FMMDSTRID
CHAR
10 0
CISUB1
Substring 1 of Commitment Item
FM_CISUB1 FMMDCISUB1
CHAR
10 0
CISUB2
Substring 2 of Commitment Item
FM_CISUB2 FMMDCISUB2
CHAR
10 0
CISUB3
Substring 3 of Commitment Item
FM_CISUB3 FMMDCISUB3
CHAR
10 0
CISUB4
Substring 4 of Commitment Item
FM_CISUB4 FMMDCISUB4
CHAR
10 0
CISUB5
Substring 5 of Commitment Item
FM_CISUB5 FMMDCISUB5
CHAR
10 0

FMCI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FMCI BSAMT * FMFCTR
Funds Center Master Record
MANDT
FMCI BSAMT * FMFCTR
Funds Center Master Record
FIKRS
FMCI BSAMT FMCI BSAMT FMFCTR
Funds Center Master Record
FICTR
FMCI BSAMT * FMFCTR
Funds Center Master Record
DATBIS
FMCI CISUB1 SYST MANDT FMMDCISUB1
Value of Substring 1 of Commitment Item
MANDT
FMCI CISUB1 FMCI STR_ID FMMDCISUB1
Value of Substring 1 of Commitment Item
STR_ID
FMCI CISUB1 FMCI CISUB1 FMMDCISUB1
Value of Substring 1 of Commitment Item
CISUB1
FMCI CISUB2 SYST MANDT FMMDCISUB2
Value of Substring 2 of Commitment Item
MANDT
FMCI CISUB2 FMCI STR_ID FMMDCISUB2
Value of Substring 2 of Commitment Item
STR_ID
FMCI CISUB2 FMCI CISUB2 FMMDCISUB2
Value of Substring 2 of Commitment Item
CISUB2
FMCI CISUB3 SYST MANDT FMMDCISUB3
Value of Substring 3 of Commitment Item
MANDT
FMCI CISUB3 FMCI STR_ID FMMDCISUB3
Value of Substring 3 of Commitment Item
STR_ID
FMCI CISUB3 FMCI CISUB3 FMMDCISUB3
Value of Substring 3 of Commitment Item
CISUB3
FMCI CISUB4 FMCI CISUB4 FMMDCISUB4
Value of Substring 4 of Commitment Item
CISUB4
FMCI CISUB4 SYST MANDT FMMDCISUB4
Value of Substring 4 of Commitment Item
MANDT
FMCI CISUB4 FMCI STR_ID FMMDCISUB4
Value of Substring 4 of Commitment Item
STR_ID
FMCI CISUB5 SYST MANDT FMMDCISUB5
Value of Substring 5 of Commitment Item
MANDT
FMCI CISUB5 FMCI STR_ID FMMDCISUB5
Value of Substring 5 of Commitment Item
STR_ID
FMCI CISUB5 FMCI CISUB5 FMMDCISUB5
Value of Substring 5 of Commitment Item
CISUB5
FMCI FICTR * FMFCTR
Funds Center Master Record
MANDT
FMCI FICTR * FMFCTR
Funds Center Master Record
FIKRS
FMCI FICTR FMCI FICTR FMFCTR
Funds Center Master Record
FICTR
FMCI FICTR * FMFCTR
Funds Center Master Record
DATBIS
FMCI FIKRS FMCI MANDT FM01
Financial Management Areas
MANDT
FMCI FIKRS FMCI FIKRS FM01
Financial Management Areas
FIKRS
FMCI HSART FMCI HSART FMHSART
FM: Budget Line Type
HSART
FMCI HSART * FMHSART
FM: Budget Line Type
MANDT
FMCI KRGRP * FMKRG
Commitment Item Criterion Category Group
MANDT
FMCI KRGRP FMCI KRGRP FMKRG
Commitment Item Criterion Category Group
KRGRP
FMCI KRTYP * FMKRTP
Commitment item criterion category
MANDT
FMCI KRTYP FMCI KRTYP FMKRTP
Commitment item criterion category
KRTYP
FMCI LOGSYSTEM FMCI LOGSYSTEM TBDLS
Logical system
LOGSYS
FMCI MANDT FMCI MANDT T000
Clients
MANDT
FMCI STR_ID '1' FMMDSTRID
Define Subdivision ID of FM Master Data
MASDAT_ID
FMCI STR_ID FMCI STR_ID FMMDSTRID
Define Subdivision ID of FM Master Data
STR_ID
FMCI STR_ID SYST MANDT FMMDSTRID
Define Subdivision ID of FM Master Data
MANDT
FMCI VPTYP * FMVORTR0
Carryforward Item Categories of Totals Records
MANDT
FMCI VPTYP * FMVORTR0
Carryforward Item Categories of Totals Records
FIKRS
FMCI VPTYP FMCI VPTYP FMVORTR0
Carryforward Item Categories of Totals Records
VPTYP