FMIOI

Transparent Table Application Table
69 Fields 4 CDS Views

Commitment Documents Funds Management

FMIOI is an SAP database table in S/4HANA. Commitment Documents Funds Management. It contains 69 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
FM_tot_Fmioi view from FMIOI -> FMIT
I_FundsMgmtCmtmtEntryItemBasic view from BASIC Fnds Mgmt Commitments Entry Items Basic
P_FndsMgmtCmtmtOpnItmCurFsclYr view from BASIC
P_FundsMgmtCmtmtEntryItem view_entity from BASIC

Fields (69)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY refbn CO_REFBN Ref.document no
KEY refbt FM_REFBTYP Reference Doc. Cat.
KEY rforg AWORG Refer. Org.Unit
KEY rfpos CC_RFPOS Ref Item
KEY rfknt CC_RFKNT Acct Assnmt No.
KEY rfete CC_RFETE Schedule Line
KEY rcond RCOND Counter
KEY rftyp AWTYP Ref. procedure
KEY rfsys LOGSYSTEM Logical System
KEY btart FM_BTART Amount Type
KEY rldnr RLDNR Ledger
KEY gjahr GJAHR Fiscal Year
KEY stunr FM_STUNR Level Number
zhldt FM_ZHLDT FM Posting Date
gnjhr GNJHR YCE
perio CO_PERIO Period
cfstat FM_CFST FYC Status
cfstatsv FM_CFSTSV FYC Status
cfcnt FM_CFCNT CarryfwdPrevYr
objnrz J_OBJNR Object number
trbtr FM_TRBTR TC amount
fkbtr FM_FKBTR FMAC amount
fistl FISTL Funds Center
fonds BP_GEBER Fund
fipex FM_FIPEX Commitment Item
farea FM_FAREA Functional Area
measure FM_MEASURE Funded Program
grant_nbr GM_GRANT_NBR Grant
bus_area GSBER Business Area
prctr PRCTR Profit Center
wrttp FM_WRTTP Value Type
vrgng CO_VORGANG Bus.Transaction
bukrs BUKRS Company Code
stats FM_STATS Statisticl.Indicator
twaer TWAER Trans. Currency
cflev FM_CFLEV C/f Level
sgtxt SGTXT Text
tranr FM_TRANR Transaction No.
ctrnr FM_CTRNR Control Number
userdim FM_USERDIM Customer Field
dummy_incl_eew_cobl CFD_DUMMY Dummy
fmvor FMVOR FM Transcn
budget_pd FM_BUDGET_PERIOD Budget Period
hkont HKONT G/L Acct
erlkz ERLKZ Item Completed
loekz KBLLOEKZ Del. Ind.
fikrs FIKRS FM Area
budat BUDAT Posting Date
lifnr LIFNR Supplier
bl_doc_type FM_BL_DOC_TYPE BL document type
dp_with_po FM_DP_WITH_PO DP with PO
vrefbt FM_VREFBT Predecessor Doc.Cat.
vrefbn FM_VREFBN Predecessor Doc.No.
vrforg FM_VRFORG Predecessor Organiz.
vrfpos FM_VRFPOS Predecessor Doc.Item
vrfknt FM_VRFKNT Pred. Acct Assignmt.
vrftyp AWTYP Ref. procedure
vrfsys LOGSYSTEM Logical System
itcnact FM_ITCNACT CCN Line Active
cpudt CPUDT Entered On
cputm CPUTM Entered at
usnam USNAM User Name
tcode TCODE Transaction Code
bldocdate FM_BL_DOCDATE BL Doc Date
quant_open MENGE_D Quantity
quant_inv MENGE_D Quantity
meins MEINS Base Unit
kunnr KUNNR Customer

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 Documents Funds Management
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FMIOI (
    MANDT,                -- Client [MANDT]
    REFBN,                -- Ref.document no [CO_REFBN]
    REFBT,                -- Reference Doc. Cat. [FM_REFBTYP]
    RFORG,                -- Refer. Org.Unit [AWORG]
    RFPOS,                -- Ref Item [CC_RFPOS]
    RFKNT,                -- Acct Assnmt No. [CC_RFKNT]
    RFETE,                -- Schedule Line [CC_RFETE]
    RCOND,                -- Counter [RCOND]
    RFTYP,                -- Ref. procedure [AWTYP]
    RFSYS,                -- Logical System [LOGSYSTEM]
    BTART,                -- Amount Type [FM_BTART]
    RLDNR,                -- Ledger [RLDNR]
    GJAHR,                -- Fiscal Year [GJAHR]
    STUNR,                -- Level Number [FM_STUNR]
    ZHLDT,                -- FM Posting Date [FM_ZHLDT]
    GNJHR,                -- YCE [GNJHR]
    PERIO,                -- Period [CO_PERIO]
    CFSTAT,               -- FYC Status [FM_CFST]
    CFSTATSV,             -- FYC Status [FM_CFSTSV]
    CFCNT,                -- CarryfwdPrevYr [FM_CFCNT]
    OBJNRZ,               -- Object number [J_OBJNR]
    TRBTR,                -- TC amount [FM_TRBTR]
    FKBTR,                -- FMAC amount [FM_FKBTR]
    FISTL,                -- Funds Center [FISTL]
    FONDS,                -- Fund [BP_GEBER]
    FIPEX,                -- Commitment Item [FM_FIPEX]
    FAREA,                -- Functional Area [FM_FAREA]
    MEASURE,              -- Funded Program [FM_MEASURE]
    GRANT_NBR,            -- Grant [GM_GRANT_NBR]
    BUS_AREA,             -- Business Area [GSBER]
    PRCTR,                -- Profit Center [PRCTR]
    WRTTP,                -- Value Type [FM_WRTTP]
    VRGNG,                -- Bus.Transaction [CO_VORGANG]
    BUKRS,                -- Company Code [BUKRS]
    STATS,                -- Statisticl.Indicator [FM_STATS]
    TWAER,                -- Trans. Currency [TWAER]
    CFLEV,                -- C/f Level [FM_CFLEV]
    SGTXT,                -- Text [SGTXT]
    TRANR,                -- Transaction No. [FM_TRANR]
    CTRNR,                -- Control Number [FM_CTRNR]
    USERDIM,              -- Customer Field [FM_USERDIM]
    DUMMY_INCL_EEW_COBL,  -- Dummy [CFD_DUMMY]
    FMVOR,                -- FM Transcn [FMVOR]
    BUDGET_PD,            -- Budget Period [FM_BUDGET_PERIOD]
    HKONT,                -- G/L Acct [HKONT]
    ERLKZ,                -- Item Completed [ERLKZ]
    LOEKZ,                -- Del. Ind. [KBLLOEKZ]
    FIKRS,                -- FM Area [FIKRS]
    BUDAT,                -- Posting Date [BUDAT]
    LIFNR,                -- Supplier [LIFNR]
    BL_DOC_TYPE,          -- BL document type [FM_BL_DOC_TYPE]
    DP_WITH_PO,           -- DP with PO [FM_DP_WITH_PO]
    VREFBT,               -- Predecessor Doc.Cat. [FM_VREFBT]
    VREFBN,               -- Predecessor Doc.No. [FM_VREFBN]
    VRFORG,               -- Predecessor Organiz. [FM_VRFORG]
    VRFPOS,               -- Predecessor Doc.Item [FM_VRFPOS]
    VRFKNT,               -- Pred. Acct Assignmt. [FM_VRFKNT]
    VRFTYP,               -- Ref. procedure [AWTYP]
    VRFSYS,               -- Logical System [LOGSYSTEM]
    ITCNACT,              -- CCN Line Active [FM_ITCNACT]
    CPUDT,                -- Entered On [CPUDT]
    CPUTM,                -- Entered at [CPUTM]
    USNAM,                -- User Name [USNAM]
    TCODE,                -- Transaction Code [TCODE]
    BLDOCDATE,            -- BL Doc Date [FM_BL_DOCDATE]
    QUANT_OPEN,           -- Quantity [MENGE_D]
    QUANT_INV,            -- Quantity [MENGE_D]
    MEINS,                -- Base Unit [MEINS]
    KUNNR,                -- Customer [KUNNR]
    PRIMARY KEY (MANDT, REFBN, REFBT, RFORG, RFPOS, RFKNT, RFETE, RCOND, RFTYP, RFSYS, BTART, RLDNR, GJAHR, STUNR)
);

Learn More