SAP table FMCI (Commitment items master data)

SAP table FMCI has 4 primary key fields being MANDT,FIKRS,GJAHR,FIPEX.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
FIKRS Financial Management Area CHAR 4 0 FM01 FIKRS
GJAHR Fiscal Year NUMC 4 0 GJAHR
FIPEX Commitment Item CHAR 24 0 FM_FIPEX
KATEG Postable NUMC 1 0 FM_KATEG
2 Postable
4 Not Postable
FIVOR Financial transaction NUMC 2 0 FM_FIVOR
30 Post revenue, expenditure, asset, inventory stocks...
40 Post goods receipt, goods issue
50 Clearing
60 Post rcvbls and pybls from goods + services
70 Post customer clearing
80 Post bank clearing, bill of exchange
90 Post cash holdings
POTYP Commitment Item Category NUMC 1 0 FM_POTYP
1 Balance
2 Revenues
3 Expenditures
4 Balances
5 Clarification Worklist
KRTYP Commitment Item Criterion Category CHAR 5 0 FMKRTP FM_KRTYP
FPART Commitment Item Type CHAR 3 0 FM_FPART
FIPUP Superior Commitment Item CHAR 24 0 FIPEX_UP
POSIT Internal Commitment Item Number CHAR 8 0 FM_POSIT
FICTR Funds Center Default Value CHAR 16 0 FMFCTR FM_DFICTR
VPTYP Carryforward Item Category for Commitment Item CHAR 2 0 FMVORTR0 FM_VPTYP
SNTYP Collective budget adminstration category CHAR 1 0 FM_COLLTYP
1 Collective Expenditure within Funds Center
2 Collective Expenditure across Funds Centers
SNROL Use type in collective budget administration CHAR 1 0 FM_COLLROL
KRGRP Criterion Category Group CHAR 4 0 FMKRG FM_KRGRP
STATS Statistical commitment item CHAR 1 0 FM_STATPOS
NCBUD No Budget for Future Years CHAR 1 0 FM_NCBUD
AUGRP Authorization Group for Commitment Item CHAR 10 0 FM_AUTHGRP
STVAR Standard Variant CHAR 1 0 FM_STVAR
HSART Commitment Item Type CHAR 1 0 FMHSART FM_HSART
GKFLG Relevant to Total Costs CHAR 1 0 FM_GKFLG
DRUCK Not Relevant for Budget Print CHAR 1 0 FM_DRUCK
CFFLG Able to Carry Forward at Fiscal Year Change CHAR 1 0 FM_CFFLG
CVFLG (Negative) Clearing Item CHAR 1 0 FM_CVFLG
NEGBUD Negative Budget Permitted CHAR 1 0 FM_NEG_BUDGET_FLG
BEZIRK District CHAR 4 0 FM_BEZIRK
BSAMT Managed Position/Clearing Lower Section CHAR 16 0 FMFCTR FM_BSAMT
UBFLG Local Authorities: Budget Execution Account CHAR 1 0 FM_UBFLG
HSFLG Budget Balancing Concept CHAR 1 0 FM_HSFLG
NDAKZ Indicator: NDA Budget CHAR 1 0 FM_NDAB
AZPKZ Indicator: Accrued Budget CHAR 1 0 FM_AZPB
LOGSYSTEM Logical System CHAR 10 0 TBDLS LOGSYSTEM
FIPOS Commitment Item CHAR 14 0 * FIPOS
BUTYP Budget structure element type CHAR 4 0 * BUTYP
DATAB FM: Valid-From Date DATS 8 0 FM_DATAB
DATBIS FM: Valid-To Date DATS 8 0 FM_DATBIS
DATE_EXP Expiration Date DATS 8 0 FM_DATE_EXP
DUMMY_FMCIEXT Single-Character Flag CHAR 1 0 CHAR1
CLASSIFICATION Commitment Item Classification CHAR 2 0 GENFM_CI_CLASSIFICATION
BUDGET_RULE Commitment Item Budget Rule CHAR 2 0 GENFMC_CI_BRULE GENFM_CI_BUDGET_RULE
ALT_FIPEX Alternative Commitment Item CHAR 24 0 GENFM_ALT_FIPEX
TIPO Budget classification type NUMC 2 0 PFM_12TIPO
01 Current
02 Capital
03 Extra-budgetary
04 Dummy
13 Own Revenue
23 State Revenue
33 Treasury Operation
43 Manage balance previously delivered
CIVA Wage type for deductible VAT posting? CHAR 1 0 PFM_12CIVA
CDF Commitment item classification CHAR 1 0 PFM_12CDF
DUMMY_FSTR Single-Character Flag CHAR 1 0 CHAR1
STR_ID Master Data Subdivision ID CHAR 10 0 FMMDSTRID FM_STR_ID
CISUB1 Substring 1 of Commitment Item CHAR 10 0 FMMDCISUB1 FM_CISUB1
CISUB2 Substring 2 of Commitment Item CHAR 10 0 FMMDCISUB2 FM_CISUB2
CISUB3 Substring 3 of Commitment Item CHAR 10 0 FMMDCISUB3 FM_CISUB3
CISUB4 Substring 4 of Commitment Item CHAR 10 0 FMMDCISUB4 FM_CISUB4
CISUB5 Substring 5 of Commitment Item CHAR 10 0 FMMDCISUB5 FM_CISUB5
DUMMY_FMCI_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY

FMCI foreign key relationships

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