SAP table GMGR (Grant Master)

SAP table GMGR has 2 primary key fields being CLIENT,GRANT_NBR.

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

GMGR foreign key relationships

Table Field Check Table Check Field
0 GMGR AUTHGR GMAUTHGRP Grants Management: Authority Groups CLIENT
0 GMGR AUTHGR GMAUTHGRP Grants Management: Authority Groups OBJECT
1 GMGR AWARD_TYPE GMAWARDTYPE User defined award types for sponsored program management CLIENT
0 GMGR BILLING_RULE GMBR Billing Rules CLIENT
1 GMGR CFDA GMCFDA CFDA Codes CLIENT
1 GMGR CFDA GMCFDA CFDA Codes CFDA
0 GMGR COMPANY_CODE T001 Company Codes BUKRS
1 GMGR COPY_SOURCE GMGR Grant Master GRANT_NBR
0 GMGR CS_RULE GMCSRULES Cost Sharing Rules CLIENT
1 GMGR DISTR_CHAN TVTW Organizational Unit: Distribution Channels MANDT
1 GMGR DISTR_CHAN TVTW Organizational Unit: Distribution Channels VTWEG
0 GMGR DIVISION TSPA Organizational Unit: Sales Divisions MANDT
0 GMGR DIVISION TSPA Organizational Unit: Sales Divisions SPART
1 GMGR EXCHANGE_RULE GMGRXCHNGCURR GM grant master exchange currency CLIENT
0 GMGR GRANT_CURRENCY TCURC Currency Codes MANDT
0 GMGR GRANT_CURRENCY TCURC Currency Codes WAERS
1 GMGR GRANT_FY_VARIANT T009 Fiscal Year Variants MANDT
1 GMGR GRANT_FY_VARIANT T009 Fiscal Year Variants PERIV
0 GMGR GRANT_TYPE GMGRTYPE Grant type GRANT_TYPE
1 GMGR IDC_RULE GMIDCRULES Indirect cost rules CLIENT
0 GMGR KOSTL CSKS Cost Center Master Record MANDT
0 GMGR KOSTL CSKS Cost Center Master Record KOKRS
0 GMGR KOSTL CSKS Cost Center Master Record KOSTL
0 GMGR KOSTL CSKS Cost Center Master Record DATBI
1 GMGR LETTER_OF_CREDIT GMLOC Letter of Credit Definition CLIENT
1 GMGR LETTER_OF_CREDIT GMLOC Letter of Credit Definition LETTER_OF_CREDIT
0 GMGR ORDERID AUFK Order master data AUFNR
1 GMGR PARTNER BUT000 BP: General data I PARTNER
0 GMGR PAYMENT_RULE GMPAYMENTRULE Payment Rule CLIENT
1 GMGR SALESORG TVKO Organizational Unit: Sales Organizations MANDT
1 GMGR SALESORG TVKO Organizational Unit: Sales Organizations VKORG
0 GMGR SPLITTING_RULE GMSPLITRULES Splitting Rules re Time Intervals Used in Sponsored Programs CLIENT
1 GMGR TASK_LIST TSCMA Schedule Manager: Task List Index PROFILE
0 GMGR WBS_ELEMENT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 GMGR WBS_ELEMENT PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR