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.
| 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 | |||||||||||||||||
| 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 |