The GMIP table in SAP ERP or S/4HANA stores Plan line items table data. There are total 90 fields in GMIP table. The Plan line items 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 GMIP table. It is in Grants management (basis) (GMBASIS_E) ABAP package and is part of the Grantee Management (PSM-GM-GTE) module.
SAP GMIP Table Fields
Following is the list of fields that are available in SAP GMIP table. The primary key fields of the table are RCLNT (Client), GL_SIRID (Record number of the line item record).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| RCLNT | Client | MANDT | T000 | CLNT (3) |
| GL_SIRID | Record number of the line item record | GU_RECID | CHAR (18) | |
| RLDNR | Ledger | RLDNR | T881 | CHAR (2) |
| RRCTY | Record Type | RRCTY | CHAR (1) | |
| RVERS | Version | RVERS | T894 | CHAR (3) |
| RYEAR | Fiscal Year | GJAHR | NUMC (4) | |
| RTCUR | Currency Key | RTCUR | TCURC | CUKY (5) |
| RUNIT | Base Unit of Measure | MEINS | T006 | UNIT (3) |
| RPMAX | Period | RPMAX | NUMC (3) | |
| DOCCT | Document Category | DOCCT | CHAR (1) | |
| DOCNR | Accounting Document Number | BELNR_D | CHAR (10) | |
| DOCLN | Six-Character Posting Item for Ledger | DOCLN6 | CHAR (6) | |
| 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) | |
| SGTXT | Item Text | SGTXT | CHAR (50) | |
| DOCTY | FI-SL Document Type | DOCTY | T889 | CHAR (2) |
| ACTIV | Business Transaction | GLVOR | CHAR (4) | |
| BUDAT | Posting Date in the Document | BUDAT | DATS (8) | |
| WSDAT | Value Date for Currency Translation | WSDAT | DATS (8) | |
| REFDOCNR | Reference document number of an accounting document | REFBELNR | CHAR (10) | |
| REFRYEAR | Reference fiscal year | REFGJAHR | NUMC (4) | |
| REFDOCLN | Six-Digit Number of the Reference Posting Line | REFBUZEI6 | NUMC (6) | |
| REFDOCCT | Reference Document Category | REFDOCCT | CHAR (1) | |
| REFACTIV | FI-SL Business Reference Transaction | REFGLVOR | CHAR (4) | |
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS (8) | |
| CPUTM | Time of Entry | CPUTM | TIMS (6) | |
| USNAM | User Name | USNAM | CHAR (12) | |
| AWTYP | Reference procedure | AWTYP | TTYP | CHAR (5) |
| AWORG | Reference Organizational Units | AWORG | CHAR (10) |
