SAP Master Data Tables
Are you looking for the right table related to SAP Master Data Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Master Data (PSM-GM-GTE-MD) module.
Top 10 tables in Master Data
| Table | Description |
|---|---|
| GMBRM | Rules for Manual Billing |
| GMFUNDRECOVER_O | Fund recovery for outgoing grants |
| GMFGC_USER | Field group criteria (Grants) system+user status |
| GMCCSETTINGS | Company code settings |
| GMSPPROGRAM_FMBA | Sponsored Program Master Data - Budget Allowed Object |
| GMSMVALUETYPE | Value type control by grant type and status |
| GMREPORT | GM Report Tracking |
| GMSCHEDULERULET | Description for the GM schedule rule |
| GMCSRULESTEXTS | Cost sharing rule texts |
| GMSPCLASSTEXTS | Sponsored Class Description texts |
List of tables in Master Data
| Table | Description |
|---|---|
| GMBRM | Rules for Manual Billing |
| GMFUNDRECOVER_O | Fund recovery for outgoing grants |
| GMFGC_USER | Field group criteria (Grants) system+user status |
| GMCCSETTINGS | Company code settings |
| GMSPPROGRAM_FMBA | Sponsored Program Master Data - Budget Allowed Object |
| GMSMVALUETYPE | Value type control by grant type and status |
| GMREPORT | GM Report Tracking |
| GMSCHEDULERULET | Description for the GM schedule rule |
| GMCSRULESTEXTS | Cost sharing rule texts |
| GMSPCLASSTEXTS | Sponsored Class Description texts |
| GMSPPROGRAM_FMBT | Sponsored Program Master Data - Budget Transfer Objects |
| GMINDIRECTCOST | IDC rates for directly sponsored grants [incoming grants] |
| GMRMBDGT_ACT | Budget Document Types- Records Management Interface |
| GMFGC | Obsolete - do not use. |
| GMBDGTVALIDITY | Grant budget validity |
| GMSPRESPONSIBLE | Objects responsible for the sponsored program |
| GMCFDA | CFDA Codes |
| GMGRCOSTSHARE | Cost sharing master data |
| GMSPONSORLOC | Sponsor Master: Letter of Credit References |
| GMGRVALUETYPE | Value type settings for posting control |
| GMGRTYPETEXTS | Grant type texts |
| GMASPCLASS | Sponsored Class - Sponsor Specific Data |
| GMRELATIONSHIP | GM Relationship definition between grants and other objects |
| GMRESPTYPE | Responsibility types - Sponsored programs management |
| GMRMELEMENTS | Parameters for Records Management Interface |
| GMSPPROGRAMTEXTS | Sponsored Program texts |
| GMGR | Grant Master |
| GMLOC | Letter of Credit Definition |
| GMBDGTLAYOUT | Grants Management Budget Layout |
| GMGRTEXTS | Texts for grant master |
| GMPRTEXTS | Payment Rule Text |
| GMASPPROG | Sponsored Program - Sponsor Specific Data |
| GMFGC_1 | Obsolete - do not use |
| GMREPCLASST | GM Reprot Class Text |
| GMGRXCHNGCURR | GM grant master exchange currency |
| GMINDIRECTCOST_O | Indirect costs for outgoing grants |
| GMCSRULES | Cost Sharing Rules |
| GMGRSPONSOREDOBJ | Grant sponsored objects |
| GMGSPCLASS | Grant specific sponsored class details |
| GMSPCLASS_FMBA | Sponsored Class Master Data - Budget Allowed Object |
| GMWFBUDGET | GM Workflow Grant Master |
| GMREPCLASS | GM Report Class |
| GMCFDAT | CFDA Codes |
| GMSTATNETHISTORY | Historical status information Sponsored Programs Mgmt |
| GMIDCRULETEXTS | Indirect cost rules |
| GMGAAPVT | GAAP Accruals VT customizing |
| GMWFACTIVITIEST | GM Workflow Activities Text |
| GMGRREPORT | Grant report tracking |
| GMGRFUNDRECOVER | Fund recovery |
| GMAWARDTYPETEXTS | Award type texts |
| GMASPREPORT | Reporting Records - - Sponsor Specific Data |
| GMGRIDCCAP2_O | Grant IDC Cap (Grant level) for outgoing grant |
| GMRMELEMENTSTEXT | Parameters for Records Management Interface |
| GMSPLITRULES | Splitting Rules re Time Intervals Used in Sponsored Programs |
| GMSPPROGRAM | Sponsored program master |
| GMRELATIONSHIPT | GM Relationship text |
| GMINDIRECTCOST_R | Indirect costs for recipient |
| GMAUTHGRPT | Grants Management: Authority Groups Descriptions |
| GMSMVALUETYPE_1 | Value type control by grant type and status |
| GMREPORTRULE | GM Report Rule |
| GMGRIDCCAP_O | Grant IDC Cap (Program + Class) for outgoing grant |
| GMAUTHGRP | Grants Management: Authority Groups |
| GMLOCTEXT | Letter of Credit Definition |
| GMPAYMENTRULE | Payment Rule |
| GMGRIDCCAP | Grant IDC Cap (Program + Class) |
| GMGRTYPEREPORT | GM Reports from Grant Type |
| GMRMGRTYPE_ACT | Grant Types - Records Management Interface |
| GMBR | Billing Rules |
| GMAWARDTYPE | User defined award types for sponsored program management |
| GMFGC_LIFE | Field group criteria (Grants) |
| GMLDCT | Legislative District Descriptions |
| GMSCHEDULERULE | GM Schedule Rule |
| GMIDCRULES | Indirect cost rules |
| GMCOA | Special GL accounts in chart of accounts for grants mgmt |
| GMGFUND | Grant specific fund details |
| GMWFAVC | GM Workflow AVC |
| GMSPRESPTYP | Responsibility Defaults for Sponsor |
| GMGRXCHNGCURRTXT | GM grant master exchange currency text |
| GMGBDGTLAYOUT | Grants Management Budget Layout |
| GMIDCRULES_ELE | Billing Rule Elements |
| GMSPAGT | Allowed Grant Types for Sponsor |
| GMLDC | Legislative District Codes |
| GMGRRESPONSIBLE | Objects responsible for the grant |
| GMSPONSOR | Sponsor Master |
| GMRESPEVENTS | Grant responsibility events |
| GMBRTEXTS | Billing Rules |
| GMGSPPROGRAM | Grant specific sponsored program details |
| GMBRE | Billing Rule Elements |
| GMOMD | Grants Management Object Mapper Table |
| GMREPORTRULET | Description of GM Report Rule |
| GMSPCLASS | Sponsored Class Master |
| GMSTATNET_INT | Grants Management Status Network |
| GMGRIDCCAP2 | Grant IDC Cap (Grant level) |
| GMSPCLASS_FMBT | Sponsored Class Master Data - Budget Transfer Object |
| GMRMBUPA | Business Partner - Records Management Interface |
| GMGTSPONSOR | Sponsor Master: Grant Type dependant attributes |
| GMGRTYPE | Grant type |
| GMWFGRANTM | GM Workflow Grant Master |
| GMRESPTYPET | Responsible type text |
| GMGRELATED | GM Grant relationships |
| GMGAAP | Special GL accounts in chart of accounts for GM GAAP |
| GMRMBUPA_ACT | Business Partner - Records Management Interface |
| GMSTATNET | Grants Management Status Network |
| GMRMGRTYPE | Grant Types - Records Managment Interface |
| GMGRANTNONE | Definition of Grant used as "Non-Relevant" |
| GMWFACTIVITIES | GM Workflow Activities |