The GMGR table in SAP ERP or S/4HANA stores Grant Master data. There are total 61 fields in GMGR table. The Grant Master 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 GMGR table. It is in Public Sector S4C Grantee Management Master Data (PSM_S4C_GM_MD) ABAP package and is part of the Master Data (PSM-GM-GTE-MD) module.
SAP GMGR Table Fields
Following is the list of fields that are available in SAP GMGR table. The primary key fields of the table are CLIENT (Client), GRANT_NBR (Grant).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR (20) | |
| REVISION_NBR | Grant Revision Number | GM_GRANT_REVISION | CHAR (3) | |
| INT_REFERENCE | Alternate Grant Identifier | GM_INTERNAL_REF | CHAR (24) | |
| EXT_REFERENCE | Alternate Grant Identifier | GM_EXTERNAL_REF | CHAR (24) | |
| VALID_FROM | Valid-from Date | GM_FROM_DATE | DATS (8) | |
| VALID_TO | Valid-to Date | GM_TO_DATE | DATS (8) | |
| GRANT_TYPE | Grant Type | GM_GRANT_TYPE | GMGRTYPE | CHAR (2) |
| COMPANY_CODE | Company Code | BUKRS | T001 | CHAR (4) |
| AWARD_TYPE | Award Type | GM_AWARD_TYPE | GMAWARDTYPE | CHAR (3) |
| AWARD_START | Valid-from Date | GM_FROM_DATE | DATS (8) | |
| AWARD_END | Valid-to Date | GM_TO_DATE | DATS (8) | |
| FINAL_BILL_DATE | Final Bill Date | GM_FINAL_BILL_DATE | DATS (8) | |
| BLOCKING_IND | Blocking Indicator | GM_BLOCKING_INDICATOR | CHAR (1) | |
| SPLIT_OF_YEARS | Allow Year Split | GM_YEAR_SPLIT | CHAR (1) | |
| GRANT_FY_VARIANT | Fiscal year variant of grant | GM_GRANT_FYVARIANT | T009 | CHAR (2) |
| GRANT_CURRENCY | Grant currency | GM_GRANT_CURRENCY | TCURC | CUKY (5) |
| GRANT_TOTAL | Total Grant Value in Sponsor Currency | GM_GRANT_TOTAL | CURR (13) | |
| EXCHANGE_RATE | Grant exchange rate | GM_EXCHANGE_RATE | DEC (9) | |
| EXCHANGE_DATE | Exchange Rate Date | GM_EXCHANGE_RATE_DATE | DATS (8) | |
| FROM_FACTOR | Ratio for the “from” currency units | FFACT_CURR | DEC (9) | |
| TO_FACTOR | Ratio for the “to” currency units | TFACT_CURR | DEC (9) | |
| CFDA | Number in Catalog of Federal Domestic Assistance | GM_CFDA_NBR | GMCFDA | CHAR (10) |
| FUNDING_ORIGIN | Origin of Grant Funding | GM_FUNDING_ORIGIN | CHAR (30) | |
| PARTNER | Grant Sponsor | GM_SPONSOR | BUT000 | CHAR (10) |
| SALES_ORDER | Sales Document | VBELN_VA | CHAR (10) | |
| SALESORG | Sales Organization | VKORG | TVKO | CHAR (4) |
| DISTR_CHAN | Distribution Channel | VTWEG | TVTW | CHAR (2) |
| DIVISION | Division | SPART | TSPA | CHAR (2) |
| WBS_ELEMENT | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC (8) |
| BILLING_RULE | Rule Used as a Basis for Billing | GM_BILLING_RULE | GMBR | NUMC (4) |
| PAYMENT_RULE | Payment Rule | GM_PAYMENT_RULE | GMPAYMENTRULE | NUMC (4) |
| INSTALLMENT_AMT | Installment amount for periodic billing | GM_INSTALLMENT_AMOUNT | CURR (12) | |
| MILESTONE_TOTAL | Total Billing Amount (for milestone and periodic billing) | GM_MILESTONE_TOTAL | CURR (12) | |
| IDC_RULE | Rule for Determining Indirect Costs | GM_IDC_RULE | GMIDCRULES | NUMC (4) |
| SPLITTING_RULE | Rule Used to Split Time Intervals Between Fiscal Years | GM_TIME_SPLITTING_RULE | GMSPLITRULES | NUMC (4) |
| BUDGET_TRANSFER | Budget transfer restrictions | GM_BUDGET_TRANSFER | CHAR (1) | |
| IDC_ACCUMULATED | Total accumulated IDC per grant | GM_TOTAL_IDC_ACCUMULATED | CURR (12) | |
| CS_RULE | Rule for Determining Cost Sharing Requirements | GM_CS_RULE | GMCSRULES | NUMC (4) |
| OBJECT_NO | General Object Number | GM_OBJECT_NO | CHAR (22) | |
| LIFECYCLE_STATUS | Lifecycle Status | GM_LIFECYCLE_STATUS | TJ02 | CHAR (5) |
| USER_STATUS | User Status | J_ESTAT | CHAR (5) | |
| WORKFLOW_STATUS | Workflow status | GM_WORKFLOW_STATUS | CHAR (1) | |
| TASK_LIST | Task List for Schedule Manager | GM_TASK_LIST | TSCMA | CHAR (10) |
| APPLICATION_LOG | Application Log: Log Handle | BALLOGHNDL | CHAR (22) | |
| CREATED_BY | Record Created by | GM_CREATED_BY | CHAR (12) | |
| CREATED_ON | Created on | GM_CREATED_ON | DATS (8) | |
| CREATED_AT | Created at | GM_CREATED_AT | TIMS (6) | |
| COPY_SOURCE | Source grant | GM_COPY_SOURCE | GMGR | CHAR (20) |
| MODIFIED_BY | Last Modified by | GM_LAST_MODIFIED_BY | CHAR (12) | |
| MODIFIED_ON | Date last modified | GM_LAST_MODIFIED_DATE | DATS (8) | |
| MODIFIED_AT | Last Modified Time | GM_LAST_MODIFIED_TIME | TIMS (6) | |
| AUTHGR | Grants Management: Authorization Groups | GM_AUTHGR | GMAUTHGRP | CHAR (10) |
| XDELE | Deletion Indicator | GM_DELETION_INDICATOR | CHAR (1) | |
| PRE_AWARD_COSTS | Pre-award cost control | GM_PRE_AWARD_COSTS | CHAR (1) | |
| WORKFLOW_BLOCK | GM Blocks grant editing pending approval | GM_WORKFLOW_BLOCK | CHAR (1) | |
| OUTGOING | Outgoing Grant Indicator | GM_OUTGOING | CHAR (1) | |
| ORDERID | Order Number | AUFNR | AUFK | CHAR (12) |
| EXCHANGE_RULE | GM Exchange Rule for Revaluation | GM_EXCHANGE_RULE | GMGRXCHNGCURR | CHAR (4) |
| OBJECTID | GUID | BAPIGUID | CHAR (32) | |
| DOCUMENT_CLASS | Storage Location of Document in SRM (Content Model) | BAPIDCLASS | * | CHAR (10) |
