FMCI

Transparent Table Application Table
53 Fields 6 CDS Views

Commitment items master data

FMCI is an SAP database table in S/4HANA. Commitment items master data. It contains 53 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
E_CommitmentItem view from EXTENSION Commitment Item Extension
I_CommitmentItemBasic view from BASIC Commitment Item Basic
I_CommitmentItemBasicFiscYear view_entity from BASIC Commitment Item Basic FYear
I_USFedObjectClass view from BASIC US Federal Object Class
I_USFEDOBJECTCLASSVH view from BASIC US Federal Object Class
P_CommitmentItemMinMaxYears view from BASIC

Fields (53)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY fikrs FIKRS FM Area
KEY gjahr GJAHR Fiscal Year
KEY fipex FM_FIPEX Commitment Item
kateg FM_KATEG Directly Postable
fivor FM_FIVOR Financial Trans
potyp FM_POTYP Commitment Item Cat.
krtyp FM_KRTYP Criterion Type
fpart FM_FPART Commitment Item Type
fipup FIPEX_UP Commitment item
posit FM_POSIT Item
fictr FM_DFICTR Funds Center
vptyp FM_VPTYP Carryfwd Item Cat.
sntyp FM_COLLTYP CBA type
snrol FM_COLLROL CBA role
krgrp FM_KRGRP Crit. Cat Group
stats FM_STATPOS Stat. Commitm. Item
ncbud FM_NCBUD No Bdgt f. FY
augrp FM_AUTHGRP Authoriz. Group
stvar FM_STVAR Stand.Variant
hsart FM_HSART Cmmt Item Type
gkflg FM_GKFLG Total Costs
druck FM_DRUCK No Budget Print
cfflg FM_CFFLG CanBeCFrwd
cvflg FM_CVFLG Clearing Item
negbud FM_NEG_BUDGET_FLG Neg. Budget
bezirk FM_BEZIRK District
bsamt FM_BSAMT MngPos/ClrLowSc
ubflg FM_UBFLG Bdgt Exec. Acct
hsflg FM_HSFLG Bdgt Bal. Con.
ndakz FM_NDAB NDA Budget
azpkz FM_AZPB Accrued Budget
logsystem LOGSYSTEM Logical System
fipos FIPOS Commitment item
butyp BUTYP BS el.type
datab FM_DATAB Valid From
datbis FM_DATBIS Valid To
date_exp FM_DATE_EXP Expiration Date
dummy_fmciext CHAR1 Single-Character Flag
classification GENFM_CI_CLASSIFICATION CI Class
budget_rule GENFM_CI_BUDGET_RULE CI BudRule
alt_fipex GENFM_ALT_FIPEX Alt.Comit.Item
tipo PFM_12TIPO Budg.classif.type
civa PFM_12CIVA VAT posting
cdf PFM_12CDF CommitmIt.class.
dummy_fstr CHAR1 Single-Character Flag
str_id FM_STR_ID Subdivision ID
cisub1 FM_CISUB1 CI Substring 1
cisub2 FM_CISUB2 CI Substring 2
cisub3 FM_CISUB3 CI Substring 3
cisub4 FM_CISUB4 CI Substring 4
cisub5 FM_CISUB5 CI Substring 5
dummy_fmci_incl_eew_ps CFD_DUMMY Dummy

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Commitment items master data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FMCI (
    MANDT,                   -- Client [MANDT]
    FIKRS,                   -- FM Area [FIKRS]
    GJAHR,                   -- Fiscal Year [GJAHR]
    FIPEX,                   -- Commitment Item [FM_FIPEX]
    KATEG,                   -- Directly Postable [FM_KATEG]
    FIVOR,                   -- Financial Trans [FM_FIVOR]
    POTYP,                   -- Commitment Item Cat. [FM_POTYP]
    KRTYP,                   -- Criterion Type [FM_KRTYP]
    FPART,                   -- Commitment Item Type [FM_FPART]
    FIPUP,                   -- Commitment item [FIPEX_UP]
    POSIT,                   -- Item [FM_POSIT]
    FICTR,                   -- Funds Center [FM_DFICTR]
    VPTYP,                   -- Carryfwd Item Cat. [FM_VPTYP]
    SNTYP,                   -- CBA type [FM_COLLTYP]
    SNROL,                   -- CBA role [FM_COLLROL]
    KRGRP,                   -- Crit. Cat Group [FM_KRGRP]
    STATS,                   -- Stat. Commitm. Item [FM_STATPOS]
    NCBUD,                   -- No Bdgt f. FY [FM_NCBUD]
    AUGRP,                   -- Authoriz. Group [FM_AUTHGRP]
    STVAR,                   -- Stand.Variant [FM_STVAR]
    HSART,                   -- Cmmt Item Type [FM_HSART]
    GKFLG,                   -- Total Costs [FM_GKFLG]
    DRUCK,                   -- No Budget Print [FM_DRUCK]
    CFFLG,                   -- CanBeCFrwd [FM_CFFLG]
    CVFLG,                   -- Clearing Item [FM_CVFLG]
    NEGBUD,                  -- Neg. Budget [FM_NEG_BUDGET_FLG]
    BEZIRK,                  -- District [FM_BEZIRK]
    BSAMT,                   -- MngPos/ClrLowSc [FM_BSAMT]
    UBFLG,                   -- Bdgt Exec. Acct [FM_UBFLG]
    HSFLG,                   -- Bdgt Bal. Con. [FM_HSFLG]
    NDAKZ,                   -- NDA Budget [FM_NDAB]
    AZPKZ,                   -- Accrued Budget [FM_AZPB]
    LOGSYSTEM,               -- Logical System [LOGSYSTEM]
    FIPOS,                   -- Commitment item [FIPOS]
    BUTYP,                   -- BS el.type [BUTYP]
    DATAB,                   -- Valid From [FM_DATAB]
    DATBIS,                  -- Valid To [FM_DATBIS]
    DATE_EXP,                -- Expiration Date [FM_DATE_EXP]
    DUMMY_FMCIEXT,           -- Single-Character Flag [CHAR1]
    CLASSIFICATION,          -- CI Class [GENFM_CI_CLASSIFICATION]
    BUDGET_RULE,             -- CI BudRule [GENFM_CI_BUDGET_RULE]
    ALT_FIPEX,               -- Alt.Comit.Item [GENFM_ALT_FIPEX]
    TIPO,                    -- Budg.classif.type [PFM_12TIPO]
    CIVA,                    -- VAT posting [PFM_12CIVA]
    CDF,                     -- CommitmIt.class. [PFM_12CDF]
    DUMMY_FSTR,              -- Single-Character Flag [CHAR1]
    STR_ID,                  -- Subdivision ID [FM_STR_ID]
    CISUB1,                  -- CI Substring 1 [FM_CISUB1]
    CISUB2,                  -- CI Substring 2 [FM_CISUB2]
    CISUB3,                  -- CI Substring 3 [FM_CISUB3]
    CISUB4,                  -- CI Substring 4 [FM_CISUB4]
    CISUB5,                  -- CI Substring 5 [FM_CISUB5]
    DUMMY_FMCI_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, FIKRS, GJAHR, FIPEX)
);

Learn More