FMIT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| Fm_Fmit_Old | view | from | FMIT |
Fields (66)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA