0GM_GRANT_ATTR

Grant Number | #ATTR | Extraction method: F1 | Delta: AIE | Component: Master Data Grants Management
Tables used: GMGR, GMSTATNETHISTORY, GMBDGTVALIDITY, GMSPCLASS, GMSPPROGRAM ... +15 more
Column Name Description
GRANT_NBR Grant
GRANT_TYPE FK Grant Type
LIFECYCLE_STATUS FK Lifecycle Status
USER_STATUS User-Defined State
Column Name Description
💲 Grant currency (GRANT_CURRENCY):
GRANT_TOTAL Total Grant Value in Sponsor Currency
INSTALLMENT_AMT Installment amount for periodic billing
MILESTONE_TOTAL Total Billing Amount (for milestone and periodic billing)
Column Name Description
Column Name Description
UPDATES Dates of Last Change
AWARD_START Valid-from Date
AWARD_END Valid-to Date
EXCHANGE_DATE Exchange Rate Date
VALID_FROM Valid-from Date
VALID_TO Valid-to Date
FINAL_BILL_DATE Final Bill Date
CREATED_ON Created on
CREATED_AT Created at
MODIFIED_ON Date last modified
MODIFIED_AT Last Modified Time
Column Name Description
BLOCKING_IND Blocking Indicator Show values
XDELE Deletion Indicator Show values
PRE_AWARD_COSTS Pre-award cost control Show values
Column Name Description Domain name
EXCHANGE_RATE Grant exchange rate KURSF
OBJECT_NO General Object Number J_OBJNR
REVISION_NBR Grant Revision Number GM_GRANT_VERSION
INTERNAL_REF Alternate Grant Identifier GM_INTERNAL_REFERENCE
EXTERNAL_REF Alternate Grant Identifier GM_EXTERNAL_REFERENCE
FUNDING_ORIGIN Origin of Grant Funding GM_FUNDING_ORIGIN
CREATED_BY Record Created by USNAM
MODIFIED_BY Last Modified by USNAM
Master Data Relations Join Conditions
Award Type
  • Client
  • Award Type
Rule Used as a Basis for Billing
  • Client
  • Rule Used as a Basis for Billing
  • 0GM_GRANT_ATTR.MANDT == GMBR.CLIENT
  • 0GM_GRANT_ATTR.BILLING_RULE == GMBR.BILLING_RULE
Number in Catalog of Federal Domestic Assistance
  • Client
  • Number in Catalog of Federal Domestic Assistance
  • 0GM_GRANT_ATTR.MANDT == GMCFDA.CLIENT
  • 0GM_GRANT_ATTR.CFDA == GMCFDA.CFDA
Company Code
  • Client
  • Company Code
  • 0GM_GRANT_ATTR.MANDT == T001.MANDT
  • 0GM_GRANT_ATTR.COMPANY_CODE == T001.BUKRS
Source grant
  • Client
  • Source grant
  • 0GM_GRANT_ATTR.MANDT == GMGR.CLIENT
  • 0GM_GRANT_ATTR.COPY_SOURCE == GMGR.GRANT_NBR
Grant currency
  • Client
  • Grant currency
  • 0GM_GRANT_ATTR.MANDT == TCURC.MANDT
  • 0GM_GRANT_ATTR.GRANT_CURRENCY == TCURC.WAERS
Fiscal year variant of grant
  • Client
  • Fiscal year variant of grant
  • 0GM_GRANT_ATTR.MANDT == T009.MANDT
  • 0GM_GRANT_ATTR.GRANT_FY_VARIANT == T009.PERIV
Grant type
  • Client
  • Grant Type
  • 0GM_GRANT_ATTR.MANDT == GMGRTYPE.CLIENT
  • 0GM_GRANT_ATTR.GRANT_TYPE == GMGRTYPE.GRANT_TYPE
Letter of Credit
  • Client
  • Letter of Credit
  • 0GM_GRANT_ATTR.MANDT == GMLOC.CLIENT
  • 0GM_GRANT_ATTR.LETTER_OF_CREDIT == GMLOC.LETTER_OF_CREDIT
Lifecycle Status 0GM_GRANT_ATTR.LIFECYCLE_STATUS == TJ02.ISTAT
Order Number
  • Client
  • Order Number
  • 0GM_GRANT_ATTR.MANDT == AUFK.MANDT
  • 0GM_GRANT_ATTR.ORDERID == AUFK.AUFNR
Grant Sponsor
  • Client
  • Grant Sponsor
  • 0GM_GRANT_ATTR.MANDT == BUT000.CLIENT
  • 0GM_GRANT_ATTR.SPONSOR == BUT000.PARTNER