FMIT

Transparent Table Application Table

Summentabelle für das Haushaltsmanagement

FMIT is an SAP database table in S/4HANA. Summentabelle für das Haushaltsmanagement. It contains 66 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
Fm_Fmit_Old view from FMIT

Fields (66)

KeyField Data ElementDescription DomainTypeLength
KEY rclnt mandt Client
KEY rldnr rldnr Ledger
KEY rrcty rrcty Record Type
KEY rvers rvers Version
KEY ryear gjahr Fiscal Year
KEY robjnr gobjnr_r Object number
KEY cobjnr gobjnr_c Trans.objct no.
KEY sobjnr gobjnr_s Partner obj.no.
KEY rtcur rtcur Currency
KEY rpmax rpmax Period
rbukrs bukrs Company Code
rfistl fistl Funds Center
rfonds bp_geber Fund
rfipex fm_fipex Commitment Item
rwrttp fm_wrttp Value Type
rbtart fm_btart Amount Type
rgnjhr gnjhr YCE
rhkont hkont G/L Acct
rstats fm_stats Statisticl.Indicator
rcflev fm_cflev C/f Level
robjnrz j_objnr Object number
rvrgng co_vorgang Bus.Transaction
ruserdim fm_userdim Customer Field
rfarea fm_farea Functional Area
rmeasure fm_measure Funded Program
logsys logsys Logical system
grant_nbr gm_grant_nbr Grant
rbusa gsber Business Area
budget_pd fm_budget_period Budget Period
tslvt tslvt9_cs Bal. c/f TC
tsl01 tslxx9_cs Total TC
tsl02 tslxx9_cs Total TC
tsl03 tslxx9_cs Total TC
tsl04 tslxx9_cs Total TC
tsl05 tslxx9_cs Total TC
tsl06 tslxx9_cs Total TC
tsl07 tslxx9_cs Total TC
tsl08 tslxx9_cs Total TC
tsl09 tslxx9_cs Total TC
tsl10 tslxx9_cs Total TC
tsl11 tslxx9_cs Total TC
tsl12 tslxx9_cs Total TC
tsl13 tslxx9_cs Total TC
tsl14 tslxx9_cs Total TC
tsl15 tslxx9_cs Total TC
tsl16 tslxx9_cs Total TC
hslvt hslvt9_cs Bal. c/f LC
hsl01 hslxx9_cs Total LC
hsl02 hslxx9_cs Total LC
hsl03 hslxx9_cs Total LC
hsl04 hslxx9_cs Total LC
hsl05 hslxx9_cs Total LC
hsl06 hslxx9_cs Total LC
hsl07 hslxx9_cs Total LC
hsl08 hslxx9_cs Total LC
hsl09 hslxx9_cs Total LC
hsl10 hslxx9_cs Total LC
hsl11 hslxx9_cs Total LC
hsl12 hslxx9_cs Total LC
hsl13 hslxx9_cs Total LC
hsl14 hslxx9_cs Total LC
hsl15 hslxx9_cs Total LC
hsl16 hslxx9_cs Total LC
cspred cspred Distr. key currency
fikrs fikrs FM Area
distkey fm_distkey Distrib. key

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.

-- Summentabelle für das Haushaltsmanagement
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FMIT (
    RCLNT,      -- Client [mandt]
    RLDNR,      -- Ledger [rldnr]
    RRCTY,      -- Record Type [rrcty]
    RVERS,      -- Version [rvers]
    RYEAR,      -- Fiscal Year [gjahr]
    ROBJNR,     -- Object number [gobjnr_r]
    COBJNR,     -- Trans.objct no. [gobjnr_c]
    SOBJNR,     -- Partner obj.no. [gobjnr_s]
    RTCUR,      -- Currency [rtcur]
    RPMAX,      -- Period [rpmax]
    RBUKRS,     -- Company Code [bukrs]
    RFISTL,     -- Funds Center [fistl]
    RFONDS,     -- Fund [bp_geber]
    RFIPEX,     -- Commitment Item [fm_fipex]
    RWRTTP,     -- Value Type [fm_wrttp]
    RBTART,     -- Amount Type [fm_btart]
    RGNJHR,     -- YCE [gnjhr]
    RHKONT,     -- G/L Acct [hkont]
    RSTATS,     -- Statisticl.Indicator [fm_stats]
    RCFLEV,     -- C/f Level [fm_cflev]
    ROBJNRZ,    -- Object number [j_objnr]
    RVRGNG,     -- Bus.Transaction [co_vorgang]
    RUSERDIM,   -- Customer Field [fm_userdim]
    RFAREA,     -- Functional Area [fm_farea]
    RMEASURE,   -- Funded Program [fm_measure]
    LOGSYS,     -- Logical system [logsys]
    GRANT_NBR,  -- Grant [gm_grant_nbr]
    RBUSA,      -- Business Area [gsber]
    BUDGET_PD,  -- Budget Period [fm_budget_period]
    TSLVT,      -- Bal. c/f TC [tslvt9_cs]
    TSL01,      -- Total TC [tslxx9_cs]
    TSL02,      -- Total TC [tslxx9_cs]
    TSL03,      -- Total TC [tslxx9_cs]
    TSL04,      -- Total TC [tslxx9_cs]
    TSL05,      -- Total TC [tslxx9_cs]
    TSL06,      -- Total TC [tslxx9_cs]
    TSL07,      -- Total TC [tslxx9_cs]
    TSL08,      -- Total TC [tslxx9_cs]
    TSL09,      -- Total TC [tslxx9_cs]
    TSL10,      -- Total TC [tslxx9_cs]
    TSL11,      -- Total TC [tslxx9_cs]
    TSL12,      -- Total TC [tslxx9_cs]
    TSL13,      -- Total TC [tslxx9_cs]
    TSL14,      -- Total TC [tslxx9_cs]
    TSL15,      -- Total TC [tslxx9_cs]
    TSL16,      -- Total TC [tslxx9_cs]
    HSLVT,      -- Bal. c/f LC [hslvt9_cs]
    HSL01,      -- Total LC [hslxx9_cs]
    HSL02,      -- Total LC [hslxx9_cs]
    HSL03,      -- Total LC [hslxx9_cs]
    HSL04,      -- Total LC [hslxx9_cs]
    HSL05,      -- Total LC [hslxx9_cs]
    HSL06,      -- Total LC [hslxx9_cs]
    HSL07,      -- Total LC [hslxx9_cs]
    HSL08,      -- Total LC [hslxx9_cs]
    HSL09,      -- Total LC [hslxx9_cs]
    HSL10,      -- Total LC [hslxx9_cs]
    HSL11,      -- Total LC [hslxx9_cs]
    HSL12,      -- Total LC [hslxx9_cs]
    HSL13,      -- Total LC [hslxx9_cs]
    HSL14,      -- Total LC [hslxx9_cs]
    HSL15,      -- Total LC [hslxx9_cs]
    HSL16,      -- Total LC [hslxx9_cs]
    CSPRED,     -- Distr. key currency [cspred]
    FIKRS,      -- FM Area [fikrs]
    DISTKEY,    -- Distrib. key [fm_distkey]
    PRIMARY KEY (RCLNT, RLDNR, RRCTY, RVERS, RYEAR, ROBJNR, COBJNR, SOBJNR, RTCUR, RPMAX)
);