GMGR - Grant Master

Grant Master information is stored in SAP table GMGR.
It is part of development package PSM_S4C_GM_MD in software component PSM-GM-GTE-MD. This development package consists of objects that can be grouped under "Public Sector S4C Grantee Management Master Data".

Fields for table GMGR

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6	T000
GRANT_NBR	Grant	X	GM_GRANT_NBR	CHAR	40
REVISION_NBR	Grant Revision Number		GM_GRANT_REVISION	CHAR	6
INT_REFERENCE	Alternate Grant Identifier		GM_INTERNAL_REF	CHAR	48
EXT_REFERENCE	Alternate Grant Identifier		GM_EXTERNAL_REF	CHAR	48
VALID_FROM	Valid-from Date		GM_FROM_DATE	DATS	16
VALID_TO	Valid-to Date		GM_TO_DATE	DATS	16
GRANT_TYPE	Grant Type		GM_GRANT_TYPE	CHAR	4	GMGRTYPE
COMPANY_CODE	Company Code		BUKRS	CHAR	8	T001
AWARD_TYPE	Award Type		GM_AWARD_TYPE	CHAR	6	GMAWARDTYPE
AWARD_START	Valid-from Date		GM_FROM_DATE	DATS	16
AWARD_END	Valid-to Date		GM_TO_DATE	DATS	16
FINAL_BILL_DATE	Final Bill Date		GM_FINAL_BILL_DATE	DATS	16
LETTER_OF_CREDIT	Letter of Credit		GM_LETTER_OF_CREDIT	CHAR	40	GMLOC
BLOCKING_IND	Blocking Indicator		GM_BLOCKING_INDICATOR	CHAR	2
SPLIT_OF_YEARS	Allow Year Split		GM_YEAR_SPLIT	CHAR	2
GRANT_FY_VARIANT	Fiscal year variant of grant		GM_GRANT_FYVARIANT	CHAR	4	T009
GRANT_CURRENCY	Grant currency		GM_GRANT_CURRENCY	CUKY	10	TCURC
GRANT_TOTAL	Total Grant Value in Sponsor Currency		GM_GRANT_TOTAL	CURR	7
EXCHANGE_RATE	Grant exchange rate		GM_EXCHANGE_RATE	DEC	5
EXCHANGE_DATE	Exchange Rate Date		GM_EXCHANGE_RATE_DATE	DATS	16
FROM_FACTOR	Ratio for the "from" currency units		FFACT_CURR	DEC	5
TO_FACTOR	Ratio for the "to" currency units		TFACT_CURR	DEC	5
CFDA	Number in Catalog of Federal Domestic Assistance		GM_CFDA_NBR	CHAR	20	GMCFDA
FUNDING_ORIGIN	Origin of Grant Funding		GM_FUNDING_ORIGIN	CHAR	60
PARTNER	Grant Sponsor		GM_SPONSOR	CHAR	20	BUT000
SALES_ORDER	Sales Document		VBELN_VA	CHAR	20
SALESORG	Sales Organization		VKORG	CHAR	8	TVKO
DISTR_CHAN	Distribution Channel		VTWEG	CHAR	4	TVTW
DIVISION	Division		SPART	CHAR	4	TSPA
WBS_ELEMENT	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	PRPS
BILLING_RULE	Rule Used as a Basis for Billing		GM_BILLING_RULE	NUMC	8	GMBR
PAYMENT_RULE	Payment Rule		GM_PAYMENT_RULE	NUMC	8	GMPAYMENTRULE
INSTALLMENT_AMT	Installment amount for periodic billing		GM_INSTALLMENT_AMOUNT	CURR	7
MILESTONE_TOTAL	Total Billing Amount (for milestone and periodic billing)		GM_MILESTONE_TOTAL	CURR	7
IDC_RULE	Rule for Determining Indirect Costs		GM_IDC_RULE	NUMC	8	GMIDCRULES
SPLITTING_RULE	Rule Used to Split Time Intervals Between Fiscal Years		GM_TIME_SPLITTING_RULE	NUMC	8	GMSPLITRULES
BUDGET_TRANSFER	Budget transfer restrictions		GM_BUDGET_TRANSFER	CHAR	2
IDC_CAP	Maximum IDC allowed		GM_IDC_CAP	CURR	7
IDC_ACCUMULATED	Total accumulated IDC per grant		GM_TOTAL_IDC_ACCUMULATED	CURR	7
CS_RULE	Rule for Determining Cost Sharing Requirements		GM_CS_RULE	NUMC	8	GMCSRULES
CS_RATE	Overall Cost Sharing Rate for Grant		GM_OVERALL_CS_RATE	DEC	4
OBJECT_NO	General Object Number		GM_OBJECT_NO	CHAR	44
LIFECYCLE_STATUS	Lifecycle Status		GM_LIFECYCLE_STATUS	CHAR	10	TJ02
USER_STATUS	User Status		J_ESTAT	CHAR	10
WORKFLOW_STATUS	Workflow status		GM_WORKFLOW_STATUS	CHAR	2
TASK_LIST	Task List for Schedule Manager		GM_TASK_LIST	CHAR	20	TSCMA
APPLICATION_LOG	Application Log: Log Handle		BALLOGHNDL	CHAR	44
CREATED_BY	Record Created by		GM_CREATED_BY	CHAR	24
CREATED_ON	Created on		GM_CREATED_ON	DATS	16
CREATED_AT	Created at		GM_CREATED_AT	TIMS	12
COPY_SOURCE	Source grant		GM_COPY_SOURCE	CHAR	40	GMGR
MODIFIED_BY	Last Modified by		GM_LAST_MODIFIED_BY	CHAR	24
MODIFIED_ON	Date last modified		GM_LAST_MODIFIED_DATE	DATS	16
MODIFIED_AT	Last Modified Time		GM_LAST_MODIFIED_TIME	TIMS	12
AUTHGR	Grants Management: Authorization Groups		GM_AUTHGR	CHAR	20	GMAUTHGRP
XDELE	Deletion Indicator		GM_DELETION_INDICATOR	CHAR	2
PRE_AWARD_COSTS	Pre-award cost control		GM_PRE_AWARD_COSTS	CHAR	2
WORKFLOW_BLOCK	GM Blocks grant editing pending approval		GM_WORKFLOW_BLOCK	CHAR	2
OUTGOING	Outgoing Grant Indicator		GM_OUTGOING	CHAR	2
ORDERID	Order Number		AUFNR	CHAR	24	AUFK
EXCHANGE_RULE	GM Exchange Rule for Revaluation		GM_EXCHANGE_RULE	CHAR	8	GMGRXCHNGCURR
KOKRS	Controlling Area		KOKRS	CHAR	8
KOSTL	Cost Center		KOSTL	CHAR	20	CSKS
.INCLUDE				GMRM_ADDON	0
OBJECTID	GUID		BAPIGUID	CHAR	64
DOCUMENT_CLASS	Storage Location of Document in SRM (Content Model)		BAPIDCLASS	CHAR	20	*
.INCLUDE				GMGR_INCL_EEW_PS	0
DUMMY_GMGR_INCL_EEW_PS	Custom Fields: Dummy for Use in Extension Includes		CFD_DUMMY	CHAR	2
.INCLUDE				CI_GMGR	0
IDC_RATE	Cloud Edition Only: Percentage for Indirect Costs		GM_PERCENTAGE_INDIRECT_COST_CE	DEC	4