FMIFIIT

Transparent Table Application Table
66 Fields 2 CDS Views

FI Line Item Table in Funds Management

FMIFIIT is an SAP database table in S/4HANA. FI Line Item Table in Funds Management. It contains 66 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FM_tot_Fmifiit view from FMIFIIT -> FMIT
I_FundsManagementDocItemBasic view from BASIC FM Document Item Basic

Fields (66)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY fmbelnr FM_BELNR FM Doc. No.
KEY fikrs FIKRS FM Area
KEY fmbuzei FM_BUZEI Item
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
vobukrs FM_VOBUKRS Company code
vogjahr FM_VOGJAHR Fiscal year
vobelnr FM_VOBELNR Payment Document No.
vobuzei FM_VOBUZEI Item
kngjahr FM_KNGJAHR Fiscal year
knbelnr FM_KNBELNR FI document no.
knbuzei FM_KNBUZEI Item
sknto SKNTO_CS Discount Amt
rdiff RDIFF_CS Diff. Realized
payflg FM_PAYFLG Payment Status
psobt PSOBT Posting Day
menge MENGE_D Quantity
meins MEINS Base Unit
vbund RASSC Trading Partner
xref3 XREF3 Reference Key 3
pumeth PUMETH Procedures
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
fmxdocnr FM_XDOCNR FM Ref. Doc. Nr.
fmxyear FM_XYEAR FM Ref. Year
fmxdocln FM_XDOCLN FM Ref. Item
fmxzekkn FM_XZEKKN FM Ref. AA.

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.

-- FI Line Item Table in Funds Management
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FMIFIIT (
    MANDT,                -- Client [MANDT]
    FMBELNR,              -- FM Doc. No. [FM_BELNR]
    FIKRS,                -- FM Area [FIKRS]
    FMBUZEI,              -- Item [FM_BUZEI]
    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]
    VOBUKRS,              -- Company code [FM_VOBUKRS]
    VOGJAHR,              -- Fiscal year [FM_VOGJAHR]
    VOBELNR,              -- Payment Document No. [FM_VOBELNR]
    VOBUZEI,              -- Item [FM_VOBUZEI]
    KNGJAHR,              -- Fiscal year [FM_KNGJAHR]
    KNBELNR,              -- FI document no. [FM_KNBELNR]
    KNBUZEI,              -- Item [FM_KNBUZEI]
    SKNTO,                -- Discount Amt [SKNTO_CS]
    RDIFF,                -- Diff. Realized [RDIFF_CS]
    PAYFLG,               -- Payment Status [FM_PAYFLG]
    PSOBT,                -- Posting Day [PSOBT]
    MENGE,                -- Quantity [MENGE_D]
    MEINS,                -- Base Unit [MEINS]
    VBUND,                -- Trading Partner [RASSC]
    XREF3,                -- Reference Key 3 [XREF3]
    PUMETH,               -- Procedures [PUMETH]
    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]
    FMXDOCNR,             -- FM Ref. Doc. Nr. [FM_XDOCNR]
    FMXYEAR,              -- FM Ref. Year [FM_XYEAR]
    FMXDOCLN,             -- FM Ref. Item [FM_XDOCLN]
    FMXZEKKN,             -- FM Ref. AA. [FM_XZEKKN]
    PRIMARY KEY (MANDT, FMBELNR, FIKRS, FMBUZEI, BTART, RLDNR, GJAHR, STUNR)
);

Learn More