1. SAP Tutorial
  2. SAP PSM

GMGR SAP table for – Grant Master

Here we would like to draw your attention to GMGR table in SAP. As we know it is being mainly used with the SAP PSM-GM (Grants Management in PSM) component which is coming under PSM module (Public Sector Management). GMGR is a SAP standard transp table used for storing Grant Master related data in SAP. It comes under the package GMMASTERDATA_E.

SAP GMGR table

Table GMGR technical data

TableGMGR
Data storingGrant Master
ModulePSM
Sub ModulePSM-GM-GTE-MD
SAP PackageGMMASTERDATA_E
Delivery ClassA – Application table (master and transaction data)
ComponentEA-PS
Table CategoryTRANSP

SAP GMGR Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in GMGR table.

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GRANT_NBR : Grant
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • REVISION_NBR : Grant Revision Number
    Its data type is CHAR (Character String) with field length 3
  • INT_REFERENCE : Alternate Grant Identifier
    Its data type is CHAR (Character String) with field length 24
  • EXT_REFERENCE : Alternate Grant Identifier
    Its data type is CHAR (Character String) with field length 24
  • VALID_FROM : Valid-from Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALID_TO : Valid-to Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • GRANT_TYPE : Grant Type
    Its data type is CHAR (Character String) with field length 2
  • COMPANY_CODE : Company Code
    Its data type is CHAR (Character String) with field length 4
  • AWARD_TYPE : Award Type
    Its data type is CHAR (Character String) with field length 3
  • AWARD_START : Valid-from Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AWARD_END : Valid-to Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FINAL_BILL_DATE : Final Bill Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LETTER_OF_CREDIT : Letter of Credit
    Its data type is CHAR (Character String) with field length 20
  • BLOCKING_IND : Blocking Indicator
    Its data type is CHAR (Character String) with field length 1
  • SPLIT_OF_YEARS : Allow Year Split
    Its data type is CHAR (Character String) with field length 1
  • GRANT_FY_VARIANT : Fiscal year variant of grant
    Its data type is CHAR (Character String) with field length 2
  • GRANT_CURRENCY : Grant currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • GRANT_TOTAL : Total Grant Value in Sponsor Currency
    Its data type is CURR (Currency Field) with field length 13
  • EXCHANGE_RATE : Grant exchange rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • EXCHANGE_DATE : Exchange Rate Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FROM_FACTOR : Ratio for the “from” currency units
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • TO_FACTOR : Ratio for the “to” currency units
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • CFDA : Number in Catalog of Federal Domestic Assistance
    Its data type is CHAR (Character String) with field length 10
  • FUNDING_ORIGIN : Origin of Grant Funding
    Its data type is CHAR (Character String) with field length 30
  • PARTNER : Grant Sponsor
    Its data type is CHAR (Character String) with field length 10
  • SALES_ORDER : Sales Document
    Its data type is CHAR (Character String) with field length 10
  • SALESORG : Sales Organization
    Its data type is CHAR (Character String) with field length 4
  • DISTR_CHAN : Distribution Channel
    Its data type is CHAR (Character String) with field length 2
  • DIVISION : Division
    Its data type is CHAR (Character String) with field length 2
  • WBS_ELEMENT : Work Breakdown Structure Element (WBS Element)
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • BILLING_RULE : Rule Used as a Basis for Billing
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • PAYMENT_RULE : Payment Rule
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • INSTALLMENT_AMT : Installment amount for periodic billing
    Its data type is CURR (Currency Field) with field length 12
  • MILESTONE_TOTAL : Total Billing Amount (for milestone and periodic billing)
    Its data type is CURR (Currency Field) with field length 12
  • IDC_RULE : Rule for Determining Indirect Costs
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SPLITTING_RULE : Rule Used to Split Time Intervals Between Fiscal Years
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUDGET_TRANSFER : Budget transfer restrictions
    Its data type is CHAR (Character String) with field length 1
  • IDC_CAP : Maximum IDC allowed
    Its data type is CURR (Currency Field) with field length 12
  • IDC_ACCUMULATED : Total accumulated IDC per grant
    Its data type is CURR (Currency Field) with field length 12
  • CS_RULE : Rule for Determining Cost Sharing Requirements
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • CS_RATE : Overall cost sharing rate for grant
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • OBJECT_NO : General Object Number
    Its data type is CHAR (Character String) with field length 22
  • LIFECYCLE_STATUS : Lifecycle Status
    Its data type is CHAR (Character String) with field length 5
  • USER_STATUS : User Status
    Its data type is CHAR (Character String) with field length 5
  • WORKFLOW_STATUS : Workflow status
    Its data type is CHAR (Character String) with field length 1
  • TASK_LIST : Task List for Schedule Manager
    Its data type is CHAR (Character String) with field length 10
  • APPLICATION_LOG : Application Log: Log Handle
    Its data type is CHAR (Character String) with field length 22
  • CREATED_BY : Record Created by
    Its data type is CHAR (Character String) with field length 12
  • CREATED_ON : Created on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CREATED_AT : Created at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • COPY_SOURCE : Source grant
    Its data type is CHAR (Character String) with field length 20
  • MODIFIED_BY : Last Modified by
    Its data type is CHAR (Character String) with field length 12
  • MODIFIED_ON : Date last modified
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MODIFIED_AT : Last Modified Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AUTHGR : Grants Management: Authorization Groups
    Its data type is CHAR (Character String) with field length 10
  • XDELE : Deletion Indicator
    Its data type is CHAR (Character String) with field length 1
  • PRE_AWARD_COSTS : Pre-award cost control
    Its data type is CHAR (Character String) with field length 1
  • WORKFLOW_BLOCK : GM Blocks grant editing pending approval
    Its data type is CHAR (Character String) with field length 1
  • OUTGOING : Outgoing Grant Indicator
    Its data type is CHAR (Character String) with field length 1
  • ORDERID : Order Number
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Generic Add on for Records Management Interface with GM
  • OBJECTID : GUID
    Its data type is CHAR (Character String) with field length 32
  • DOCUMENT_CLASS : Storage Location of Document in SRM (Content Model)
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes

    • GMGR related tables

    • GMFGC_USER : Field group criteria (Grants) system+user status
    • GMAWARDTYPETEXTS : Award type texts
    • GMRESPTYPE : Responsibility types – Sponsored programs management
    • GMGRTEXTS : Texts for grant master
    • GMLDCT : Legislative District Descriptions
    • GMPAYMENTRULE : Payment Rule
    • GMRMBDGT_ACT : Budget Document Types- Records Management Interface
    • GMAUTHGRPT : Grants Management: Authority Groups Descriptions
    • GMSPPROGRAM : Sponsored program master
    • GMGSPCLASS : Grant specific sponsored class details
    • GMGRIDCCAP_O : Grant IDC Cap (Program + Class) for outgoing grant
    • GMREPORTRULET : Description of GM Report Rule
    • GMRMBUPA_ACT : Business Partner – Records Management Interface
    • GMREPORT : GM Report Tracking
    • GMGRTYPEREPORT : GM Reports from Grant Type
    • GMGAAP : Special GL accounts in chart of accounts for GM GAAP
    • GMRELATIONSHIP : GM Relationship definition between grants and other objects
    • GMWFACTIVITIEST : GM Workflow Activities Text
    • GMSMVALUETYPE_1 : Value type control by grant type and status
    • GMINDIRECTCOST : IDC rates for directly sponsored grants [incoming grants]

    GMGR related transaction codes under SAP package GMMASTERDATA_E

    • GM_LOC : GM: Define Letters of Credit
    • GM_OBJ_MAPPER : GM Object Mapper
    • GMS4 : GM BDT Sections
    • GM_AWARD_TYPE : Maintain award types
    • GMS17 : GM BDT External Applications
    • GMS15 : GM BDT Application Transactions
    • GMS11 : GM BDT Assign Scrn Flds to DB Fields
    • GMS101 : GM BDT field group per role category
    • GMCLAUTH : Class Authorization Groups
    • GMS9 : GM BDT GUI Addl Functions
    • GMS14 : GM BDT Role Groupings
    • GM_CFDA : GM: Define CFDA codes
    • GMS21 : GM BDT Activity Category
    • GMS102 : GM BDT Authorization Types
    • GMS108 : GM BDT Field Grouping ApplicationObj
    • GMS25 : GM BDT Where-used process to view
    • GMS5 : GM BDT Screens
    • GMPROGRAM : GM Sponsored Program Master Data
    • GMS3 : GM BDT Views
    • GMS1 : GM BDT Applications

    Related References

    Related Tutorials

    GMGRIDCCAP2_O SAP table for – Grant IDC Cap (Grant level) for outgoing grant

    GMGRIDCCAP2_O table in SAP PSM (Grants Management in PSM) module. This table is used for storing data of Grant IDC...

    GMGRIDCCAP_O SAP table for – Grant IDC Cap (Program + Class) for outgoing grant

    GMGRIDCCAP_O table in SAP PSM (Grants Management in PSM) module. This table is used for storing data of Grant IDC...

    GMGRIDCCAP2 SAP table for – Grant IDC Cap (Grant level)

    GMGRIDCCAP2 table in SAP PSM (Grants Management in PSM) module. This table is used for storing data of Grant IDC...

    GMGRTEXTS SAP table for – Texts for grant master

    GMGRTEXTS table in SAP PSM (Grants Management in PSM) module. This table is used for storing data of Texts for...

    GMWFBUDGET SAP table for – GM Workflow Grant Master

    GMWFBUDGET table in SAP PSM (Grants Management in PSM) module. This table is used for storing data of GM Workflow...

    GMGRIDCCAP SAP table for – Grant IDC Cap (Program + Class)

    GMGRIDCCAP table in SAP PSM (Grants Management in PSM) module. This table is used for storing data of Grant IDC...

    S_ALN_01000161 SAP tcode for – Master Data Index for Grant Sponsors

    S_ALN_01000161 tcode in SAP PSM (Grants Management in PSM) module. This transaction code is used for Master Data Index for...

    «
    »