FMCI SAP table for – Commitment items master data

Here we would like to draw your attention to FMCI table in SAP. As we know it is being mainly used with the SAP FI-FM (Funds Management in FI) component which is coming under FI module (Financial Accounting). FMCI is a SAP standard transp table used for storing Commitment items master data related data in SAP. It comes under the package FMMD_CORE.

SAP FMCI table

Table FMCI technical data

TableFMCI
Data storingCommitment items master data
ModuleFI
Sub ModuleFI-FM
SAP PackageFMMD_CORE
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP FMCI Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FMCI table.

  • .INCLUDE : Key Fields Commitment Items (Table FMCI)
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • FIKRS : Financial Management Area
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • FIPEX : Commitment item
    Its a key field. Its data type is CHAR (Character String) with field length 24
  • .INCLUDE : Structure of Commitment Item Master Data
  • KATEG : Attribute: Can be Posted To
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • FIVOR : Financial transaction
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • POTYP : Commitment Item Category
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • KRTYP : Commitment item criterion category
    Its data type is CHAR (Character String) with field length 5
  • FPART : Commitment Item Type
    Its data type is CHAR (Character String) with field length 3
  • FIPUP : Superior Commitment Item
    Its data type is CHAR (Character String) with field length 24
  • POSIT : Item (Internal Commitment Item Number)
    Its data type is CHAR (Character String) with field length 8
  • FICTR : Funds Center (Default Value in a Commitment Item)
    Its data type is CHAR (Character String) with field length 16
  • VPTYP : Carryforward item category for commitment item
    Its data type is CHAR (Character String) with field length 2
  • SNTYP : Collective budget adminstration category
    Its data type is CHAR (Character String) with field length 1
  • SNROL : Use type in collective budget administration
    Its data type is CHAR (Character String) with field length 1
  • KRGRP : Criterion category group
    Its data type is CHAR (Character String) with field length 4
  • STATS : Statistical commitment item
    Its data type is CHAR (Character String) with field length 1
  • NCBUD : No Budget for Future Years
    Its data type is CHAR (Character String) with field length 1
  • AUGRP : Authorization Groups of the Commitment Item
    Its data type is CHAR (Character String) with field length 10
  • STVAR : Standard variant
    Its data type is CHAR (Character String) with field length 1
  • HSART : Commitment Item Type
    Its data type is CHAR (Character String) with field length 1
  • GKFLG : Relevant to total costs
    Its data type is CHAR (Character String) with field length 1
  • DRUCK : Not relevant for budget print
    Its data type is CHAR (Character String) with field length 1
  • CFFLG : Able to carry forward at fiscal year change
    Its data type is CHAR (Character String) with field length 1
  • CVFLG : (Negative) clearing item
    Its data type is CHAR (Character String) with field length 1
  • NEGBUD : Negative Budget Permitted
    Its data type is CHAR (Character String) with field length 1
  • BEZIRK : District
    Its data type is CHAR (Character String) with field length 4
  • BSAMT : Managed position / clearing lower section
    Its data type is CHAR (Character String) with field length 16
  • UBFLG : Local authorities: Budget execution account
    Its data type is CHAR (Character String) with field length 1
  • HSFLG : Budget balancing concept
    Its data type is CHAR (Character String) with field length 1
  • NDAKZ : Indicator: NDA Budget
    Its data type is CHAR (Character String) with field length 1
  • AZPKZ : Indicator: Accrued Budget
    Its data type is CHAR (Character String) with field length 1
  • LOGSYSTEM : Logical System
    Its data type is CHAR (Character String) with field length 10
  • FIPOS : Commitment Item
    Its data type is CHAR (Character String) with field length 14
  • BUTYP : Budget structure element type
    Its data type is CHAR (Character String) with field length 4
  • DATAB : FM: Valid from date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATBIS : FM: Valid to date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATE_EXP : Expiration Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Country-Specific Enhancement for Commitment Item
  • DUMMY_FMCIEXT : Single-Character Flag
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Subfields Commitment Item
  • DUMMY_FSTR : Single-Character Flag
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Structure of Substrings of Commitment Item
  • STR_ID : Master Data Subdivision ID
    Its data type is CHAR (Character String) with field length 10
  • CISUB1 : Substring 1 of Commitment Item
    Its data type is CHAR (Character String) with field length 10
  • CISUB2 : Substring 2 of Commitment Item
    Its data type is CHAR (Character String) with field length 10
  • CISUB3 : Substring 3 of Commitment Item
    Its data type is CHAR (Character String) with field length 10
  • CISUB4 : Substring 4 of Commitment Item
    Its data type is CHAR (Character String) with field length 10
  • CISUB5 : Substring 5 of Commitment Item
    Its data type is CHAR (Character String) with field length 10