SAP Table GMGR
Grant Master
GMGR (Grant Master) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link GMGR to other SAP tables.
GMGR table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | 0 | |||||||||
| REVISION_NBR | Grant Revision Number | GM_GRANT_REVISION | CHAR | 3 | 0 | |||||||||
| INT_REFERENCE | Alternate Grant Identifier | GM_INTERNAL_REF | CHAR | 24 | 0 | |||||||||
| EXT_REFERENCE | Alternate Grant Identifier | GM_EXTERNAL_REF | CHAR | 24 | 0 | |||||||||
| VALID_FROM | Valid-from Date | GM_FROM_DATE | DATS | 8 | 0 | |||||||||
| VALID_TO | Valid-to Date | GM_TO_DATE | DATS | 8 | 0 | |||||||||
| GRANT_TYPE | Grant Type | GM_GRANT_TYPE | GMGRTYPE | CHAR | 2 | 0 | ||||||||
| COMPANY_CODE | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||
| AWARD_TYPE | Award Type | GM_AWARD_TYPE | GMAWARDTYPE | CHAR | 3 | 0 | ||||||||
| AWARD_START | Valid-from Date | GM_FROM_DATE | DATS | 8 | 0 | |||||||||
| AWARD_END | Valid-to Date | GM_TO_DATE | DATS | 8 | 0 | |||||||||
| FINAL_BILL_DATE | Final Bill Date | GM_FINAL_BILL_DATE | DATS | 8 | 0 | |||||||||
| LETTER_OF_CREDIT | Letter of Credit | GM_LETTER_OF_CREDIT | GMLOC | CHAR | 20 | 0 | ||||||||
| BLOCKING_IND | Blocking Indicator | GM_BLOCKING_INDICATOR | CHAR | 1 | 0 |
Possible values
|
||||||||
| SPLIT_OF_YEARS | Allow Year Split | GM_YEAR_SPLIT | CHAR | 1 | 0 |
Possible values
|
||||||||
| GRANT_FY_VARIANT | Fiscal year variant of grant | GM_GRANT_FYVARIANT | T009 | CHAR | 2 | 0 | ||||||||
| GRANT_CURRENCY | Grant currency | GM_GRANT_CURRENCY | TCURC | CUKY | 5 | 0 | ||||||||
| GRANT_TOTAL | Total Grant Value in Sponsor Currency | GM_GRANT_TOTAL | CURR | 13 | 2 | |||||||||
| EXCHANGE_RATE | Grant exchange rate | GM_EXCHANGE_RATE | DEC | 9 | 5 | |||||||||
| EXCHANGE_DATE | Exchange Rate Date | GM_EXCHANGE_RATE_DATE | DATS | 8 | 0 | |||||||||
| FROM_FACTOR | Ratio for the "From" Currency Units | FFACT_CURR | DEC | 9 | 0 | |||||||||
| TO_FACTOR | Ratio for the "To" Currency Units | TFACT_CURR | DEC | 9 | 0 | |||||||||
| CFDA | Number in Catalog of Federal Domestic Assistance | GM_CFDA_NBR | GMCFDA | CHAR | 10 | 0 | ||||||||
| FUNDING_ORIGIN | Origin of Grant Funding | GM_FUNDING_ORIGIN | CHAR | 30 | 0 | |||||||||
| PARTNER | Grant Sponsor | GM_SPONSOR | BUT000 | CHAR | 10 | 0 | ||||||||
| SALES_ORDER | Sales Document | VBELN_VA | VBUK | CHAR | 10 | 0 | ||||||||
| SALESORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||||
| DISTR_CHAN | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||||||||
| DIVISION | Division | SPART | TSPA | CHAR | 2 | 0 | ||||||||
| WBS_ELEMENT | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC | 8 | 0 | ||||||||
| BILLING_RULE | Rule Used as a Basis for Billing | GM_BILLING_RULE | GMBR | NUMC | 4 | 0 | ||||||||
| PAYMENT_RULE | Payment Rule | GM_PAYMENT_RULE | GMPAYMENTRULE | NUMC | 4 | 0 | ||||||||
| INSTALLMENT_AMT | Installment amount for periodic billing | GM_INSTALLMENT_AMOUNT | CURR | 12 | 2 | |||||||||
| MILESTONE_TOTAL | Total Billing Amount (for milestone and periodic billing) | GM_MILESTONE_TOTAL | CURR | 12 | 2 | |||||||||
| IDC_RULE | Rule for Determining Indirect Costs | GM_IDC_RULE | GMIDCRULES | NUMC | 4 | 0 | ||||||||
| SPLITTING_RULE | Rule Used to Split Time Intervals Between Fiscal Years | GM_TIME_SPLITTING_RULE | GMSPLITRULES | NUMC | 4 | 0 | ||||||||
| BUDGET_TRANSFER | Budget transfer restrictions | GM_BUDGET_TRANSFER | CHAR | 1 | 0 |
Possible values
|
||||||||
| IDC_CAP | Maximum IDC allowed | GM_IDC_CAP | CURR | 12 | 2 | |||||||||
| IDC_ACCUMULATED | Total accumulated IDC per grant | GM_TOTAL_IDC_ACCUMULATED | CURR | 12 | 2 | |||||||||
| CS_RULE | Rule for Determining Cost Sharing Requirements | GM_CS_RULE | GMCSRULES | NUMC | 4 | 0 | ||||||||
| CS_RATE | Overall Cost Sharing Rate for Grant | GM_OVERALL_CS_RATE | DEC | 7 | 3 | |||||||||
| OBJECT_NO | General Object Number | GM_OBJECT_NO | CHAR | 22 | 0 | |||||||||
| LIFECYCLE_STATUS | Lifecycle Status | GM_LIFECYCLE_STATUS | TJ02 | CHAR | 5 | 0 | ||||||||
| USER_STATUS | User Status | J_ESTAT | CHAR | 5 | 0 | |||||||||
| WORKFLOW_STATUS | Workflow status | GM_WORKFLOW_STATUS | CHAR | 1 | 0 |
Possible values
|
||||||||
| TASK_LIST | Task List for Schedule Manager | GM_TASK_LIST | TSCMA | CHAR | 10 | 0 | ||||||||
| APPLICATION_LOG | Application Log: Log Handle | BALLOGHNDL | CHAR | 22 | 0 | |||||||||
| CREATED_BY | Record Created by | GM_CREATED_BY | CHAR | 12 | 0 | |||||||||
| CREATED_ON | Created on | GM_CREATED_ON | DATS | 8 | 0 | |||||||||
| CREATED_AT | Created at | GM_CREATED_AT | TIMS | 6 | 0 | |||||||||
| COPY_SOURCE | Source grant | GM_COPY_SOURCE | GMGR | CHAR | 20 | 0 | ||||||||
| MODIFIED_BY | Last Modified by | GM_LAST_MODIFIED_BY | CHAR | 12 | 0 | |||||||||
| MODIFIED_ON | Date last modified | GM_LAST_MODIFIED_DATE | DATS | 8 | 0 | |||||||||
| MODIFIED_AT | Last Modified Time | GM_LAST_MODIFIED_TIME | TIMS | 6 | 0 | |||||||||
| AUTHGR | Grants Management: Authorization Groups | GM_AUTHGR | GMAUTHGRP | CHAR | 10 | 0 | ||||||||
| XDELE | Deletion Indicator | GM_DELETION_INDICATOR | CHAR | 1 | 0 |
Possible values
|
||||||||
| PRE_AWARD_COSTS | Pre-award cost control | GM_PRE_AWARD_COSTS | CHAR | 1 | 0 |
Possible values
|
||||||||
| WORKFLOW_BLOCK | GM Blocks grant editing pending approval | GM_WORKFLOW_BLOCK | CHAR | 1 | 0 |
Possible values
|
||||||||
| OUTGOING | Outgoing Grant Indicator | GM_OUTGOING | CHAR | 1 | 0 |
Possible values
|
||||||||
| ORDERID | Order Number | AUFNR | AUFK | CHAR | 12 | 0 | ||||||||
| EXCHANGE_RULE | GM Exchange Rule for Revaluation | GM_EXCHANGE_RULE | GMGRXCHNGCURR | CHAR | 4 | 0 | ||||||||
| OBJECTID | GUID | BAPIGUID | CHAR | 32 | 0 | |||||||||
| DOCUMENT_CLASS | Storage Location of Document in SRM (Content Model) | BAPIDCLASS | CHAR | 10 | 0 | |||||||||
GMGR foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| GMGR | AUTHGR | GMGR | AUTHGR | GMAUTHGRP | Grants Management: Authority Groups | AUTHGROUP |
| GMGR | AUTHGR | GMGR | CLIENT | GMAUTHGRP | Grants Management: Authority Groups | CLIENT |
| GMGR | AUTHGR | 'G' | GMAUTHGRP | Grants Management: Authority Groups | OBJECT | |
| GMGR | AWARD_TYPE | GMGR | CLIENT | GMAWARDTYPE | User defined award types for sponsored program management | CLIENT |
| GMGR | AWARD_TYPE | GMGR | AWARD_TYPE | GMAWARDTYPE | User defined award types for sponsored program management | AWARD_TYPE |
| GMGR | BILLING_RULE | GMGR | CLIENT | GMBR | Billing Rules | CLIENT |
| GMGR | BILLING_RULE | GMGR | BILLING_RULE | GMBR | Billing Rules | BILLING_RULE |
| GMGR | CFDA | GMGR | CLIENT | GMCFDA | CFDA Codes | CLIENT |
| GMGR | CFDA | GMGR | CFDA | GMCFDA | CFDA Codes | CFDA |
| GMGR | CLIENT | GMGR | CLIENT | T000 | Clients | MANDT |
| GMGR | COMPANY_CODE | GMGR | CLIENT | T001 | Company Codes | MANDT |
| GMGR | COMPANY_CODE | GMGR | COMPANY_CODE | T001 | Company Codes | BUKRS |
| GMGR | COPY_SOURCE | GMGR | COPY_SOURCE | GMGR | Grant Master | GRANT_NBR |
| GMGR | COPY_SOURCE | GMGR | CLIENT | GMGR | Grant Master | CLIENT |
| GMGR | CS_RULE | GMGR | CLIENT | GMCSRULES | Cost Sharing Rules | CLIENT |
| GMGR | CS_RULE | GMGR | CS_RULE | GMCSRULES | Cost Sharing Rules | CS_RULE |
| GMGR | DISTR_CHAN | GMGR | CLIENT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| GMGR | DISTR_CHAN | GMGR | DISTR_CHAN | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| GMGR | DIVISION | GMGR | CLIENT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| GMGR | DIVISION | GMGR | DIVISION | TSPA | Organizational Unit: Sales Divisions | SPART |
| GMGR | EXCHANGE_RULE | GMGR | CLIENT | GMGRXCHNGCURR | GM grant master exchange currency | CLIENT |
| GMGR | EXCHANGE_RULE | GMGR | EXCHANGE_RULE | GMGRXCHNGCURR | GM grant master exchange currency | EXCHANGE_RULE |
| GMGR | GRANT_CURRENCY | GMGR | CLIENT | TCURC | Currency Codes | MANDT |
| GMGR | GRANT_CURRENCY | GMGR | GRANT_CURRENCY | TCURC | Currency Codes | WAERS |
| GMGR | GRANT_FY_VARIANT | GMGR | CLIENT | T009 | Fiscal Year Variants | MANDT |
| GMGR | GRANT_FY_VARIANT | GMGR | GRANT_FY_VARIANT | T009 | Fiscal Year Variants | PERIV |
| GMGR | GRANT_TYPE | GMGR | CLIENT | GMGRTYPE | Grant type | CLIENT |
| GMGR | GRANT_TYPE | GMGR | GRANT_TYPE | GMGRTYPE | Grant type | GRANT_TYPE |
| GMGR | IDC_RULE | GMGR | IDC_RULE | GMIDCRULES | Indirect cost rules | IDC_RULE |
| GMGR | IDC_RULE | GMGR | CLIENT | GMIDCRULES | Indirect cost rules | CLIENT |
| GMGR | LETTER_OF_CREDIT | GMGR | CLIENT | GMLOC | Letter of Credit Definition | CLIENT |
| GMGR | LETTER_OF_CREDIT | GMGR | LETTER_OF_CREDIT | GMLOC | Letter of Credit Definition | LETTER_OF_CREDIT |
| GMGR | LIFECYCLE_STATUS | GMGR | LIFECYCLE_STATUS | TJ02 | System status | ISTAT |
| GMGR | ORDERID | GMGR | CLIENT | AUFK | Order master data | MANDT |
| GMGR | ORDERID | GMGR | ORDERID | AUFK | Order master data | AUFNR |
| GMGR | PARTNER | GMGR | CLIENT | BUT000 | BP: General data I | CLIENT |
| GMGR | PARTNER | GMGR | PARTNER | BUT000 | BP: General data I | PARTNER |
| GMGR | PAYMENT_RULE | GMGR | CLIENT | GMPAYMENTRULE | Payment Rule | CLIENT |
| GMGR | PAYMENT_RULE | GMGR | PAYMENT_RULE | GMPAYMENTRULE | Payment Rule | PAYMENT_RULE |
| GMGR | SALESORG | GMGR | CLIENT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| GMGR | SALESORG | GMGR | SALESORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| GMGR | SALES_ORDER | GMGR | SALES_ORDER | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| GMGR | SALES_ORDER | GMGR | CLIENT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| GMGR | SPLITTING_RULE | GMGR | CLIENT | GMSPLITRULES | Splitting Rules re Time Intervals Used in Sponsored Programs | CLIENT |
| GMGR | SPLITTING_RULE | GMGR | SPLITTING_RULE | GMSPLITRULES | Splitting Rules re Time Intervals Used in Sponsored Programs | SPLITTING_RULE |
| GMGR | TASK_LIST | GMGR | CLIENT | TSCMA | Schedule Manager: Task List Index | MANDT |
| GMGR | TASK_LIST | GMGR | TASK_LIST | TSCMA | Schedule Manager: Task List Index | PROFILE |
| GMGR | WBS_ELEMENT | GMGR | CLIENT | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
| GMGR | WBS_ELEMENT | GMGR | WBS_ELEMENT | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
