The GMIT table in SAP ERP or S/4HANA stores Summary table data. There are total 76 fields in GMIT table. The Summary table table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of GMIT table. It is in Grants management (basis) (GMBASIS_E) ABAP package and is part of the Grantee Management (PSM-GM-GTE) module.
SAP GMIT Table Fields
Following is the list of fields that are available in SAP GMIT table. The primary key fields of the table are RCLNT (Client), RLDNR (Ledger), RRCTY (Record Type), RVERS (Version), RYEAR (Fiscal Year), ROBJNR (Object number for objects (account assignment elements)), COBJNR (Object number for transaction attributes), SOBJNR (Object number for partner objects (accnt assignmnt elements)), RTCUR (Currency Key), RUNIT (Base Unit of Measure), RPMAX (Period).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| RCLNT | Client | MANDT | T000 | CLNT (3) |
| RLDNR | Ledger | RLDNR | T881 | CHAR (2) |
| RRCTY | Record Type | RRCTY | CHAR (1) | |
| RVERS | Version | RVERS | T894 | CHAR (3) |
| RYEAR | Fiscal Year | GJAHR | NUMC (4) | |
| ROBJNR | Object number for objects (account assignment elements) | GOBJNR_R | CHAR (18) | |
| COBJNR | Object number for transaction attributes | GOBJNR_C | CHAR (18) | |
| SOBJNR | Object number for partner objects (accnt assignmnt elements) | GOBJNR_S | CHAR (18) | |
| RTCUR | Currency Key | RTCUR | TCURC | CUKY (5) |
| RUNIT | Base Unit of Measure | MEINS | T006 | UNIT (3) |
| RPMAX | Period | RPMAX | NUMC (3) | |
| RBUKRS | Company Code | BUKRS | T001 | CHAR (4) |
| RGRANT_NBR | Grant | GM_GRANT_NBR | CHAR (20) | |
| RSPONSORED_PROG | Sponsored Program | GM_SPONSORED_PROG | CHAR (20) | |
| RSPONSORED_CLASS | Sponsored Class | GM_SPONSORED_CLASS | CHAR (20) | |
| RBDGT_VLDTY_NBR | Budget Validity Number | GM_BDGT_VLDTY_NBR | CHAR (3) | |
| RFUND | Fund | BP_GEBER | CHAR (10) | |
| RVALUETYPE_9 | GM Value Type | GM_VALUETYPE | CHAR (2) | |
| RTRANS | Business Transaction | J_VORGANG | CHAR (4) | |
| RSTATS_IND | Statistical Indicator | GM_STATS | CHAR (1) | |
| RGRANTEE_FY_9 | Fiscal Year for Grantee Organization | GM_GRANTEE_FY | NUMC (4) | |
| LOGSYS | Logical system | LOGSYS | TBDLS | CHAR (10) |
| BDGT_STATE | Workflow State of a Record in the Budget Totals Table | GM_BDGT_STATE | CHAR (1) | |
| TSLVT | Balance carried forward in transaction currency | TSLVT9_CS | CURR (17) | |
| TSL01 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL02 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL03 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL04 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL05 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL06 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL07 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL08 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL09 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL10 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL11 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL12 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL13 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL14 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL15 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL16 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| HSLVT | Balance carried forward in local currency | HSLVT9_CS | CURR (17) | |
| HSL01 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL02 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL03 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL04 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL05 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL06 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL07 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL08 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL09 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL10 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL11 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL12 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL13 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL14 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL15 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL16 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| MSLVT | Balance carried forward of quantity | MSLVT | QUAN (15) | |
| MSL01 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL02 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL03 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL04 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL05 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL06 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL07 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL08 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL09 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL10 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL11 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL12 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL13 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL14 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL15 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL16 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| CSPRED | Distribution key for currency amounts | CSPRED | T821S | CHAR (4) |
| QSPRED | Distribution key for quantities | QSPRED | T821S | CHAR (4) |
