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-FM-MD) module.
Top 10 tables in Master Data
| Table | Description |
|---|---|
| FMFUSE | FIFM: Application of Funds from Secondary Sources |
| FMC_D_FUNCAR_DFT | I_FNDSMGMTFUNCTIONALAREACORETPI_FNDSMGMTFUNCTIONALAREACORETP |
| FMFINT | FIFM: Fund texts |
| FMMDFCSUB3T | Text of Substring 3 of Funds Center |
| FMFUNDEDPR_DRAFT | I_FUNDEDPROGRAMTP I_FUNDEDPROGRAMTP |
| FMFCTR_RFC | RFC Destination for Funds Center Replication |
| FMED01 | Special Character for Preparing Commitment Items |
| FMFUNDBPD | FM: Assignments of Funds to Budget Periods |
| FMFCTR_MAP | Funds Center: Mapping to Global Unique ID |
| FMVORTR0 | Carryforward Item Categories of Totals Records |
List of tables in Master Data
| Table | Description |
|---|---|
| FMFUSE | FIFM: Application of Funds from Secondary Sources |
| FMC_D_FUNCAR_DFT | I_FNDSMGMTFUNCTIONALAREACORETPI_FNDSMGMTFUNCTIONALAREACORETP |
| FMFINT | FIFM: Fund texts |
| FMMDFCSUB3T | Text of Substring 3 of Funds Center |
| FMFUNDEDPR_DRAFT | I_FUNDEDPROGRAMTP I_FUNDEDPROGRAMTP |
| FMFCTR_RFC | RFC Destination for Funds Center Replication |
| FMED01 | Special Character for Preparing Commitment Items |
| FMFUNDBPD | FM: Assignments of Funds to Budget Periods |
| FMFCTR_MAP | Funds Center: Mapping to Global Unique ID |
| FMVORTR0 | Carryforward Item Categories of Totals Records |
| FMMDCISUB1T | Text of Substring 1 of Commitment Item |
| FMMDFCSUB3 | Value of Substring 3 of Funds Center |
| FMPP | Commitment Item in Chart of Commitment Items |
| FMMDFDSUB2T | Text of Substring 2 of Fund |
| FMFUSET | FIFM: Application of Funds from Secondary Sources |
| FMBUDGETPD | FM: Budget Period Master Data |
| FMCIVARNTT | Variant for commitment item hierarchy: Entities texts |
| FMHIPG | Hierarchy Table of Commitment Items in Fiscal Year |
| FMKRTP | Commitment item criterion category |
| FMMDCISUB3 | Value of Substring 3 of Commitment Item |
| FMHISV | Hierarchy table of funds centers in Hivariant |
| FMMDFNSUB1 | Value of Substring 1 of Functional Area |
| FMMDFNSUB3T | Text of Substring 3 of Functional Area |
| FMPPLAN | Chart of Commitment Items: Entities |
| FMFCTR | Funds Center Master Record |
| FMFCTRT | Funds Center Text |
| FMVORTR | Cmmt items for carryover item category of totals records |
| FMCIVARNT | Variant for commitment item hierarchy: Entities texts |
| FMMEASURE | FM Funded Program Master Data |
| FMBDGTPERD_DRAFT | I_BUDGETPERIODTP I_BUDGETPERIODTP |
| FMC_D_BDGTPD_DFT | I_BUDGETPERIODCORETP I_BUDGETPERIODCORETP |
| FMKR | Commitment Item Criterion |
| FMPOSIT | Commitment Item Assignment to Internal Number (FIPEX-POSIT) |
| GMGRNT_FU_DFT | I_GRANTFUNDSLINKTP I_GRANTFUNDSLINKTP |
| FMMDCISUB1 | Value of Substring 1 of Commitment Item |
| FMKRTPT | Text: Commitment Item Criterion Category |
| FMMDST | Field selection string |
| FM01BSP | FM Area - Fund Center for the Budget |
| FMKRG | Commitment Item Criterion Category Group |
| FMPG | Commitment Items in FM Area/Fiscal Year |
| FMMDCISUB2T | Text of Substring 2 of Commitment Item |
| FMHICI | Commitment items hierarchy |
| FMAPPLOFFD_DRAFT | I_APPLICATIONOFFUNDTP I_APPLICATIONOFFUNDTP |
| FMMDFNSUB3 | Value of Substring 3 of Functional Area |
| FCTRREPLSTATLOG | Funds Center Replication Status Log |
| FMMDCISUB4 | Value of Substring 4 of Commitment Item |
| FMFXPO | Commitment item, internal and external number (conversion) |
| GMSPLITRULEST | Splitting Rules Text |
| FMCI | Commitment items master data |
| FMMDACTIV | Activate Subdivision of FM Master Data |
| FMCIT | Commitment items texts |
| FMKRGTP | Assignment Table: Criterion Category to Crit.Cat.Group |
| FMHSARTT | FM: Budget Line Type |
| FMFUNDBP_DRAFT | I_FUNDTP I_FUNDTOBUDGETPERIODTP |
| FMFUNDSCTR_DRAFT | I_FUNDSCENTERTP I_FUNDSCENTERTP |
| FMFUNCAREA_DRAFT | I_FUNDSMGMTFUNCTIONALAREATP I_FUNDSMGMTFUNCTIONALAREATP |
| FMPPLANT | Chart of Commitment Items: Entity Texts |
| FMMDCISUB3T | Text of Substring 3 of Commitment Item |
| FM01S | Additional master data for budgeting tools |
| FMC_D_AUTHGRP | Authorization Groups |
| FMMEASURE_FGC | Field group criteria (Funded Program) using FM Area |
| FMMDSTF | Field Selection String and Fields |
| FMZUBSP | Assign Budget Structure Elements |
| FMFINCODE | FIFM: Financing code |
| FMHIVARNTT | Funds Center Hierarchy Variant: Entities |
| FMCOMMITEM_DRAFT | I_COMMITMENTITEMTP I_COMMITMENTITEMTP |
| FMHSART | FM: Budget Line Type |
| FMMDFCSUB2 | Value of Substring 2 of Funds Center |
| FMINDEX_FIELDS | Application-Dependent Indices: Fields |
| FMC_D_FUNC_AREA | Funds Management Functional Area (Extensions) |
| FMC_D_AUTHGRPT | Authorization Groups Texts |
| FMC_D_FUND_DRAFT | I_FUNDCORETP I_FUNDCORETP |
| FMMDFCSUB1 | Value of Substring 1 of Funds Center |
| FMED00 | Preparation of Commitment Items |
| FMMDCISUB4T | Text of Substring 4 of Commitment Item |
| FMALE_SETNUM | FM Document Numbers to be Converted FI Line Item Table FM |
| FMVARNT | Chart of Commitment Items Variant: Entity Texts |
| FMMDFNSUB2T | Text of Substring 2 of Functional Area |
| PSM_D_PRDICITYT | Text Table for Periodicity |
| FMKRT | Text: Commitment Item Criteria |
| FMMDCISUB5 | Value of Substring 5 of Commitment Item |
| GMC_D_GRANT_DFT | I_GRANTCORETP I_GRANTCORETP |
| FM01P | Year-Dependent Assignment of Master Data to FM Area |
| FMHIVARNT | Funds Center Hierarchy Variant: Entities |
| FMBUDGETPDT | FM: Budget Period texts |
| FMVARNTT | Chart of Commitment Items Variant: Entity Texts |
| FMPPT | Commitment Item in Chart of Commitment Items: Texts |
| FMMDFDSUB1 | Value of Substring 1 of Fund |
| PSM_D_PRDICITY | Periodicity Type |
| FMFUND_DRAFT | I_FUNDTP I_FUNDTP |
| FMMDFCSUB2T | Text of Substring 2 of Funds Center |
| FM01H | Year-Independent Assignment of Hierarchy Variants to FM Area |
| FMHIPP | Hierarchy Table of Commitment Items in Chart of Cmmt Items |
| FM01_ST | Assign Field Selection String -> FM Area |
| FMINDEX_HEADER | Application-Dependent Indices: Header |
| GMGRNT_SP_DFT | I_GRANTSPONSOREDPROGRAMSLINKTPI_GRANTSPONSOREDPROGRAMSLINKTP |
| FMMEASURET | FM Funded Program Text Table |
| FMMDFNSUB1T | Text of Substring 1 of Functional Area |
| FMMDFDSUB2 | Value of Substring 2 of Fund |
| FMMDSTRID | Define Subdivision ID of FM Master Data |
| FMMDCISUB5T | Text of Substring 5 of Commitment Item |
| FMMDFNSUB2 | Value of Substring 2 of Functional Area |
| FMMDSUBDIV | Define Substrings of FM Master Data |
| FMMDFDSUB1T | Text of Substring 1 of Fund |
| T017 | is being deleted |
| FMMDFCSUB1T | Text of Substring 1 of Funds Center |
| FMMDSTT | Text for Field Selection String |
| FMMDCISUB2 | Value of Substring 2 of Commitment Item |
| GMGRNT_SC_DFT | I_GRANTSPONSOREDCLASSESLINKTP I_GRANTSPONSOREDCLASSESLINKTP |
| FMSTATUS | FIFM: Status for FIFM Account Assignment Objects |
| FMMDSUBDIVT | Define Substrings of FM Master Data |
| FMTTXID | Help Table for Maintenance View: Long Texts |
| FMKRGT | Text: Commitment Item Criterion Category Group |