SAP ABAP Table GMRGRL (Grants Management report structure for grant list)

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	INTTAB	Structure
Structure	GMRGRL	Table Relationship Diagram
Short Description	Grants Management report structure for grant list

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in	110