Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

GMRGRL SAP (Grants Management report structure for grant list) Structure details

Dictionary Type: Structure
Description: Grants Management report structure for grant list

ABAP Code to SELECT data from GMRGRL
Related tables to GMRGRL
Access table GMRGRL

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

Structure field list including key, data, relationships and ABAP select examples

GMRGRL is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Grants Management report structure for grant list" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_GMRGRL TYPE GMRGRL.

The GMRGRL table consists of various fields, each holding specific information or linking keys about Grants Management report structure for grant list data available in SAP. These include CLIENT (Client), GRANT_NBR (Grant), REVISION_NBR (Grant Revision Number), INT_REFERENCE (Alternate Grant Identifier).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP GMRGRL structure fields - Full list of fields found in SAP data dictionary

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
CLIENT	Client	MANDT	CLNT	3	T000		MANDT
GRANT_NBR	Grant	GM_GRANT_NBR	CHAR	20		ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
REVISION_NBR	Grant Revision Number	GM_GRANT_REVISION	CHAR	3			GM_GRANT_VERSION
INT_REFERENCE	Alternate Grant Identifier	GM_INTERNAL_REF	CHAR	24			GM_INTERNAL_REFERENCE
EXT_REFERENCE	Alternate Grant Identifier	GM_EXTERNAL_REF	CHAR	24			GM_EXTERNAL_REFERENCE
VALID_FROM	Valid-from Date	GM_FROM_DATE	DATS	8			DATUM
VALID_TO	Valid-to Date	GM_TO_DATE	DATS	8			DATUM
GRANT_TYPE	Grant Type	GM_GRANT_TYPE	CHAR	2	GMGRTYPE		GM_GRANT_TYPE	GM_GRANT_TYPE	GMGRANTTYPES
COMPANY_CODE	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
AWARD_TYPE	Award Type	GM_AWARD_TYPE	CHAR	3	GMAWARDTYPE		GM_AWARD_TYPE
AWARD_START	Valid-from Date	GM_FROM_DATE	DATS	8			DATUM
AWARD_END	Valid-to Date	GM_TO_DATE	DATS	8			DATUM
FINAL_BILL_DATE	Final Bill Date	GM_FINAL_BILL_DATE	DATS	8			GM_FINAL_BILL_DATE
LETTER_OF_CREDIT	Letter of Credit	GM_LETTER_OF_CREDIT	CHAR	20	GMLOC
BLOCKING_IND	Blocking Indicator	GM_BLOCKING_INDICATOR	CHAR	1			XFIELD
SPLIT_OF_YEARS	Allow Year Split	GM_YEAR_SPLIT	CHAR	1			CMPFLAG
GRANT_FY_VARIANT	Fiscal year variant of grant	GM_GRANT_FYVARIANT	CHAR	2	T009		PERIV
GRANT_CURRENCY	Grant currency	GM_GRANT_CURRENCY	CUKY	5	TCURC		WAERS
GRANT_TOTAL	Total Grant Value in Sponsor Currency	GM_GRANT_TOTAL	CURR	13(2)			WERTV7
EXCHANGE_RATE	Grant exchange rate	GM_EXCHANGE_RATE	DEC	9(5)		EXCRT	KURSF
EXCHANGE_DATE	Exchange Rate Date	GM_EXCHANGE_RATE_DATE	DATS	8			DATUM
FROM_FACTOR	Ratio for the 'From' Currency Units	FFACT_CURR	DEC	9			DEC9
TO_FACTOR	Ratio for the 'To' Currency Units	TFACT_CURR	DEC	9			DEC9
CFDA	Number in Catalog of Federal Domestic Assistance	GM_CFDA_NBR	CHAR	10	GMCFDA		GM_CFDA_NBR
FUNDING_ORIGIN	Origin of Grant Funding	GM_FUNDING_ORIGIN	CHAR	30			GM_FUNDING_ORIGIN
PARTNER	Grant Sponsor	GM_SPONSOR	CHAR	10	BUT000	ALPHA	BU_PARTNER	BPA	BUPA
SALES_ORDER	Sales Document	VBELN_VA	CHAR	10	VBUK	ALPHA	VBELN	AUN
SALESORG	Sales Organization	VKORG	CHAR	4	TVKO		VKORG	VKO	C_VKORG
DISTR_CHAN	Distribution Channel	VTWEG	CHAR	2	TVTW		VTWEG	VTW	C_VTWEG
DIVISION	Division	SPART	CHAR	2	TSPA		SPART	SPA	C_SPART
WBS_ELEMENT	Work Breakdown Structure Element (WBS Element)	PS_PSP_PNR	NUMC	8	PRPS	KONPR	PS_POSNR
BILLING_RULE	Rule Used as a Basis for Billing	GM_BILLING_RULE	NUMC	4	GMBR		GM_BILLING_RULE		GM_BILLING_RULE
PAYMENT_RULE	Payment Rule	GM_PAYMENT_RULE	NUMC	4	GMPAYMENTRULE		GM_PAYMENT_RULE
INSTALLMENT_AMT	Installment amount for periodic billing	GM_INSTALLMENT_AMOUNT	CURR	12(2)			GM_INSTALLMENT_AMOUNT
MILESTONE_TOTAL	Total Billing Amount (for milestone and periodic billing)	GM_MILESTONE_TOTAL	CURR	12(2)			GM_MILESTONE_TOTAL
IDC_RULE	Rule for Determining Indirect Costs	GM_IDC_RULE	NUMC	4	GMIDCRULES		GM_IDC_RULE		GMIDCRULE
SPLITTING_RULE	Rule Used to Split Time Intervals Between Fiscal Years	GM_TIME_SPLITTING_RULE	NUMC	4	GMSPLITRULES		GM_TIME_SPLITTING_RULE		GMSPLITRULES
BUDGET_TRANSFER	Budget transfer restrictions	GM_BUDGET_TRANSFER	CHAR	1			GM_BUDGET_TRANSFER
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)			GM_MILESTONE_TOTAL
CS_RULE	Rule for Determining Cost Sharing Requirements	GM_CS_RULE	NUMC	4	GMCSRULES		GM_CS_RULE		GMCSRULE
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	Assigned to domain		J_OBJNR
LIFECYCLE_STATUS	Lifecycle Status	GM_LIFECYCLE_STATUS	CHAR	5	TJ02		J_ISTAT		GMLIFECYCLE_STATUS
USER_STATUS	User Status	J_ESTAT	CHAR	5	Assigned to domain		J_ESTAT
WORKFLOW_STATUS	Workflow status	GM_WORKFLOW_STATUS	CHAR	1			GM_WORKFLOW_STATUS
TASK_LIST	Task List for Schedule Manager	GM_TASK_LIST	CHAR	10	TSCMA		PEPPROFILE
APPLICATION_LOG	Application Log: Log Handle	BALLOGHNDL	CHAR	22			SYSUUID_22
CREATED_BY	Record Created by	GM_CREATED_BY	CHAR	12			USNAM
CREATED_ON	Created on	GM_CREATED_ON	DATS	8			GM_CREATED_ON
CREATED_AT	Created at	GM_CREATED_AT	TIMS	6			GM_CREATED_AT
COPY_SOURCE	Source grant	GM_COPY_SOURCE	CHAR	20	GMGR	ALPHA	GM_GRANT_NBR		GRANTS_GENERIC
MODIFIED_BY	Last Modified by	GM_LAST_MODIFIED_BY	CHAR	12			USNAM
MODIFIED_ON	Date last modified	GM_LAST_MODIFIED_DATE	DATS	8			DATS
MODIFIED_AT	Last Modified Time	GM_LAST_MODIFIED_TIME	TIMS	6			GM_CREATED_AT
AUTHGR	Grants Management: Authorization Groups	GM_AUTHGR	CHAR	10	GMAUTHGRP		GM_AUTHGR		GMAUTHGRP
XDELE	Deletion Indicator	GM_DELETION_INDICATOR	CHAR	1			XFELD
PRE_AWARD_COSTS	Pre-award cost control	GM_PRE_AWARD_COSTS	CHAR	1			XFELD
WORKFLOW_BLOCK	GM Blocks grant editing pending approval	GM_WORKFLOW_BLOCK	CHAR	1			GM_WORKFLOW_BLOCK
OUTGOING	Outgoing Grant Indicator	GM_OUTGOING	CHAR	1			GM_OUTGOING
ORDERID	Order Number	AUFNR	CHAR	12	AUFK	ALPHA	AUFNR	ANR
EXCHANGE_RULE	GM Exchange Rule for Revaluation	GM_EXCHANGE_RULE	CHAR	4	GMGRXCHNGCURR		GM_EXCHANGE_RULE
OBJECTID	GUID	BAPIGUID	CHAR	32			SDOK_DOCID
DOCUMENT_CLASS	Storage Location of Document in SRM (Content Model)	BAPIDCLASS	CHAR	10	Assigned to domain		SDOK_CLASS
GRANT_SHORT_DESC	Name of Grant	GM_GRANT_SHORT_DESC	CHAR	20			CHAR20
SPONSOR_DESCRIPTION	Sponsor Description	GM_SPONSOR_DESCRIPTION	CHAR	80			TEXT80
TYPE_DESCRIPTION	Grant Type Description	GM_GRANT_TYPE_DESCRIPTION	CHAR	30			GM_TYPE_DESCRIPTION
COMPANY_CODE_TXT	Name of Company Code or Company	BUTXT	CHAR	25			TEXT25
AWARD_DESCRIPTION	Award Description	GM_AWARD_DESCRIPTION	CHAR	80			TEXT80
FY_VARIANT_DESCRIPTION	Fiscal Year Variant Description	GM_FY_VARIANT_DESCRIPTION	CHAR	30			TEXT30
BILLING_RULE_TXT	Billing Rule Description	GM_BILLING_RULE_TXT	CHAR	30			TEXT30
IDC_RULE_TXT	Indirect Cost Rule Text	GM_IDC_RULE_TXT	CHAR	30
SPLIT_RULE_TXT	Splitting rule Description	GM_SPLIT_RULE_TXT	CHAR	60			GM_SPLIT_RULE_DESC
CS_RULE_TXT	Cost Sharing Rule Description	GM_CS_RULE_TXT	CHAR	50
AUTH_GRP_DESCRIPTION	Grants Management: Authority Group Description	GM_AUTH_GRP_DESCRIPTION	CHAR	20			GM_AUTH_GRP_DESCRIPTION
OBJECT_ID	HR Planning Object ID of Resource	GM_USER_ID	CHAR	70			TEXT70
OBJECT_ID_DESCRIPTION	Descripton of HR Planning Object ID of Resource	GM_USER_ID_DESCRIPTION	CHAR	80			TEXT80
LIFECYCLE_STATUS_DESC	GM Lifecycle Status Description	GM_LIFECYCLE_STATUS_DESC	CHAR	30			TXT30
USER_STATUS_DESC	GM user status description	GM_USER_STATUS_DESC	CHAR	30			TXT30

Key field

Non-key field

How do I retrieve data from SAP structure GMRGRL using ABAP code?

As GMRGRL is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on GMRGRL as there is no data to select.

How to access SAP table GMRGRL

Within an ECC or HANA version of SAP you can also view further information about GMRGRL and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Search for further information about these or an SAP related objects

Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!