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 | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||||||||||
| FIVOR | Financial transaction | FM_FIVOR | NUMC | 2 | 0 |
Possible values
|
||||||||||||||||
| POTYP | Commitment Item Category | FM_POTYP | NUMC | 1 | 0 |
Possible values
|
||||||||||||||||
| 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 |
Possible values
|
||||||||||||||||
| SNROL | Use type in collective budget administration | FM_COLLROL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| KRGRP | Criterion category group | FM_KRGRP | FMKRG | CHAR | 4 | 0 | ||||||||||||||||
| STATS | Statistical commitment item | FM_STATPOS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| NCBUD | No Budget for Future Years | FM_NCBUD | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| AUGRP | Authorization Groups of the Commitment Item | FM_AUTHGRP | CHAR | 10 | 0 | |||||||||||||||||
| STVAR | Standard variant | FM_STVAR | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| HSART | Commitment Item Type | FM_HSART | FMHSART | CHAR | 1 | 0 | ||||||||||||||||
| GKFLG | Relevant to total costs | FM_GKFLG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| DRUCK | Not relevant for budget print | FM_DRUCK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| CFFLG | Able to carry forward at fiscal year change | FM_CFFLG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| CVFLG | (Negative) clearing item | FM_CVFLG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| NEGBUD | Negative Budget Permitted | FM_NEG_BUDGET_FLG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| 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 |
Possible values
|
||||||||||||||||
| 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 | FIKRS | |
| FMCI | BSAMT | FMCI | BSAMT | FMFCTR | Funds Center Master Record | FICTR |
| FMCI | BSAMT | * | FMFCTR | Funds Center Master Record | DATBIS | |
| FMCI | BSAMT | * | FMFCTR | Funds Center Master Record | MANDT | |
| 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 | FMCI | CISUB3 | FMMDCISUB3 | Value of Substring 3 of Commitment Item | CISUB3 |
| 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 | 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 | CISUB4 | FMCI | CISUB4 | FMMDCISUB4 | Value of Substring 4 of Commitment Item | CISUB4 |
| FMCI | CISUB5 | FMCI | CISUB5 | FMMDCISUB5 | Value of Substring 5 of Commitment Item | CISUB5 |
| 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 | FICTR | FMCI | FICTR | FMFCTR | Funds Center Master Record | FICTR |
| FMCI | FICTR | * | FMFCTR | Funds Center Master Record | DATBIS | |
| FMCI | FICTR | * | FMFCTR | Funds Center Master Record | MANDT | |
| FMCI | FICTR | * | FMFCTR | Funds Center Master Record | FIKRS | |
| FMCI | FIKRS | FMCI | MANDT | FM01 | Financial Management Areas | MANDT |
| FMCI | FIKRS | FMCI | FIKRS | FM01 | Financial Management Areas | FIKRS |
| FMCI | HSART | * | FMHSART | FM: Budget Line Type | MANDT | |
| FMCI | HSART | FMCI | HSART | FMHSART | FM: Budget Line Type | HSART |
| 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 | SYST | MANDT | FMMDSTRID | Define Subdivision ID of FM Master Data | 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 | VPTYP | * | FMVORTR0 | Carryforward Item Categories of Totals Records | FIKRS | |
| FMCI | VPTYP | FMCI | VPTYP | FMVORTR0 | Carryforward Item Categories of Totals Records | VPTYP |
| FMCI | VPTYP | * | FMVORTR0 | Carryforward Item Categories of Totals Records | MANDT | |
