SAP ABAP Table GMGR (Grant Master)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-GM-GTE-MD (Application Component) Master Data
     ⤷ GMMASTERDATA_E (Package) Grants management (master data)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	GMGR	Table Relationship Diagram
Short Description	Grant Master

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	GRANT_NBR	☑	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
3	REVISION_NBR	☐	GM_GRANT_REVISION	GM_GRANT_VERSION	CHAR	3	0	Grant Revision Number
4	INT_REFERENCE	☐	GM_INTERNAL_REF	GM_INTERNAL_REFERENCE	CHAR	24	0	Alternate Grant Identifier
5	EXT_REFERENCE	☐	GM_EXTERNAL_REF	GM_EXTERNAL_REFERENCE	CHAR	24	0	Alternate Grant Identifier
6	VALID_FROM	☐	GM_FROM_DATE	DATUM	DATS	8	0	Valid-from Date
7	VALID_TO	☐	GM_TO_DATE	DATUM	DATS	8	0	Valid-to Date
8	GRANT_TYPE	☐	GM_GRANT_TYPE	GM_GRANT_TYPE	CHAR	2	0	Grant Type	GMGRTYPE
9	COMPANY_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
10	AWARD_TYPE	☐	GM_AWARD_TYPE	GM_AWARD_TYPE	CHAR	3	0	Award Type	GMAWARDTYPE
11	AWARD_START	☐	GM_FROM_DATE	DATUM	DATS	8	0	Valid-from Date
12	AWARD_END	☐	GM_TO_DATE	DATUM	DATS	8	0	Valid-to Date
13	FINAL_BILL_DATE	☐	GM_FINAL_BILL_DATE	GM_FINAL_BILL_DATE	DATS	8	0	Final Bill Date
14	LETTER_OF_CREDIT	☐	GM_LETTER_OF_CREDIT		CHAR	20	0	Letter of Credit	GMLOC
15	BLOCKING_IND	☐	GM_BLOCKING_INDICATOR	XFIELD	CHAR	1	0	Blocking Indicator
16	SPLIT_OF_YEARS	☐	GM_YEAR_SPLIT	CMPFLAG	CHAR	1	0	Allow Year Split
17	GRANT_FY_VARIANT	☐	GM_GRANT_FYVARIANT	PERIV	CHAR	2	0	Fiscal year variant of grant	T009
18	GRANT_CURRENCY	☐	GM_GRANT_CURRENCY	WAERS	CUKY	5	0	Grant currency	TCURC
19	GRANT_TOTAL	☐	GM_GRANT_TOTAL	WERTV7	CURR	13	2	Total Grant Value in Sponsor Currency
20	EXCHANGE_RATE	☐	GM_EXCHANGE_RATE	KURSF	DEC	9	5	Grant exchange rate
21	EXCHANGE_DATE	☐	GM_EXCHANGE_RATE_DATE	DATUM	DATS	8	0	Exchange Rate Date
22	FROM_FACTOR	☐	FFACT_CURR	DEC9	DEC	9	0	Ratio for the "from" currency units
23	TO_FACTOR	☐	TFACT_CURR	DEC9	DEC	9	0	Ratio for the "to" currency units
24	CFDA	☐	GM_CFDA_NBR	GM_CFDA_NBR	CHAR	10	0	Number in Catalog of Federal Domestic Assistance	GMCFDA
25	FUNDING_ORIGIN	☐	GM_FUNDING_ORIGIN	GM_FUNDING_ORIGIN	CHAR	30	0	Origin of Grant Funding
26	PARTNER	☐	GM_SPONSOR	BU_PARTNER	CHAR	10	0	Grant Sponsor	BUT000
27	SALES_ORDER	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
28	SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
29	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
30	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	TSPA
31	WBS_ELEMENT	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
32	BILLING_RULE	☐	GM_BILLING_RULE	GM_BILLING_RULE	NUMC	4	0	Rule Used as a Basis for Billing	GMBR
33	PAYMENT_RULE	☐	GM_PAYMENT_RULE	GM_PAYMENT_RULE	NUMC	4	0	Payment Rule	GMPAYMENTRULE
34	INSTALLMENT_AMT	☐	GM_INSTALLMENT_AMOUNT	GM_INSTALLMENT_AMOUNT	CURR	12	2	Installment amount for periodic billing
35	MILESTONE_TOTAL	☐	GM_MILESTONE_TOTAL	GM_MILESTONE_TOTAL	CURR	12	2	Total Billing Amount (for milestone and periodic billing)
36	IDC_RULE	☐	GM_IDC_RULE	GM_IDC_RULE	NUMC	4	0	Rule for Determining Indirect Costs	GMIDCRULES
37	SPLITTING_RULE	☐	GM_TIME_SPLITTING_RULE	GM_TIME_SPLITTING_RULE	NUMC	4	0	Rule Used to Split Time Intervals Between Fiscal Years	GMSPLITRULES
38	BUDGET_TRANSFER	☐	GM_BUDGET_TRANSFER	GM_BUDGET_TRANSFER	CHAR	1	0	Budget transfer restrictions
39	IDC_CAP	☐	GM_IDC_CAP		CURR	12	2	Maximum IDC allowed
40	IDC_ACCUMULATED	☐	GM_TOTAL_IDC_ACCUMULATED	GM_MILESTONE_TOTAL	CURR	12	2	Total accumulated IDC per grant
41	CS_RULE	☐	GM_CS_RULE	GM_CS_RULE	NUMC	4	0	Rule for Determining Cost Sharing Requirements	GMCSRULES
42	CS_RATE	☐	GM_OVERALL_CS_RATE		DEC	7	3	Overall cost sharing rate for grant
43	OBJECT_NO	☐	GM_OBJECT_NO	J_OBJNR	CHAR	22	0	General Object Number	*
44	LIFECYCLE_STATUS	☐	GM_LIFECYCLE_STATUS	J_ISTAT	CHAR	5	0	Lifecycle Status	TJ02
45	USER_STATUS	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
46	WORKFLOW_STATUS	☐	GM_WORKFLOW_STATUS	GM_WORKFLOW_STATUS	CHAR	1	0	Workflow status
47	TASK_LIST	☐	GM_TASK_LIST	PEPPROFILE	CHAR	10	0	Task List for Schedule Manager	TSCMA
48	APPLICATION_LOG	☐	BALLOGHNDL	SYSUUID_22	CHAR	22	0	Application Log: Log Handle
49	CREATED_BY	☐	GM_CREATED_BY	USNAM	CHAR	12	0	Record Created by
50	CREATED_ON	☐	GM_CREATED_ON	GM_CREATED_ON	DATS	8	0	Created on
51	CREATED_AT	☐	GM_CREATED_AT	GM_CREATED_AT	TIMS	6	0	Created at
52	COPY_SOURCE	☐	GM_COPY_SOURCE	GM_GRANT_NBR	CHAR	20	0	Source grant	GMGR
53	MODIFIED_BY	☐	GM_LAST_MODIFIED_BY	USNAM	CHAR	12	0	Last Modified by
54	MODIFIED_ON	☐	GM_LAST_MODIFIED_DATE	DATS	DATS	8	0	Date last modified
55	MODIFIED_AT	☐	GM_LAST_MODIFIED_TIME	GM_CREATED_AT	TIMS	6	0	Last Modified Time
56	AUTHGR	☐	GM_AUTHGR	GM_AUTHGR	CHAR	10	0	Grants Management: Authorization Groups	GMAUTHGRP
57	XDELE	☐	GM_DELETION_INDICATOR	XFELD	CHAR	1	0	Deletion Indicator
58	PRE_AWARD_COSTS	☐	GM_PRE_AWARD_COSTS	XFELD	CHAR	1	0	Pre-award cost control
59	WORKFLOW_BLOCK	☐	GM_WORKFLOW_BLOCK	GM_WORKFLOW_BLOCK	CHAR	1	0	GM Blocks grant editing pending approval
60	OUTGOING	☐	GM_OUTGOING	GM_OUTGOING	CHAR	1	0	Outgoing Grant Indicator
61	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
62	.INCLUDE	☐				0	0	Generic Add on for Records Management Interface with GM
63	OBJECTID	☐	BAPIGUID	SDOK_DOCID	CHAR	32	0	GUID
64	DOCUMENT_CLASS	☐	BAPIDCLASS	SDOK_CLASS	CHAR	10	0	Storage Location of Document in SRM (Content Model)	*
65	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	GMGR	AUTHGR	GMAUTHGRP	AUTHGROUP
2	GMGR	AWARD_TYPE	GMAWARDTYPE	AWARD_TYPE	KEY	1	CN
3	GMGR	BILLING_RULE	GMBR	BILLING_RULE	KEY	1	CN
4	GMGR	CFDA	GMCFDA	CFDA	KEY	1	CN
5	GMGR	CLIENT	T000	MANDT	KEY	1	CN
6	GMGR	COMPANY_CODE	T001	BUKRS	KEY	1	CN
7	GMGR	COPY_SOURCE	GMGR	GRANT_NBR
8	GMGR	CS_RULE	GMCSRULES	CS_RULE	KEY	1	CN
9	GMGR	DISTR_CHAN	TVTW	VTWEG	KEY	1	CN
10	GMGR	DIVISION	TSPA	SPART	KEY	1	CN
11	GMGR	GRANT_CURRENCY	TCURC	WAERS	KEY	1	CN
12	GMGR	GRANT_FY_VARIANT	T009	PERIV	KEY	1	CN
13	GMGR	GRANT_TYPE	GMGRTYPE	GRANT_TYPE	KEY	1	CN
14	GMGR	IDC_RULE	GMIDCRULES	IDC_RULE	KEY	1	CN
15	GMGR	LETTER_OF_CREDIT	GMLOC	LETTER_OF_CREDIT	KEY	1	CN
16	GMGR	LIFECYCLE_STATUS	TJ02	ISTAT	KEY	1	CN
17	GMGR	ORDERID	AUFK	AUFNR	REF	C	CN
18	GMGR	PARTNER	BUT000	PARTNER	KEY	1	CN
19	GMGR	PAYMENT_RULE	GMPAYMENTRULE	PAYMENT_RULE	REF	1	CN
20	GMGR	SALESORG	TVKO	VKORG	KEY	1	CN
21	GMGR	SALES_ORDER	VBUK	VBELN
22	GMGR	SPLITTING_RULE	GMSPLITRULES	SPLITTING_RULE	KEY	1	CN
23	GMGR	TASK_LIST	TSCMA	PROFILE	KEY	1	CN
24	GMGR	WBS_ELEMENT	PRPS	PSPNR	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	462A