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 (FIN-CS-MD) module.
Top 10 tables in Master Data
| Table | Description |
|---|---|
| FINCS_MDUPLD_ADM | Master Data Upload Administrative Information |
| FINCS_BUNIT_ATD | Consolidation Unit Attributes Time Dependent |
| FINCS_FSITEM_WA | Consolidation Financial Statement Item Upload Work Area |
| CONS_MASTER_CHAR | Consolidation Characteristics Master Data |
| FINCS_FSITGTASGN | Target Items: Assignment to FS Items |
| CONS_MDCHAR_ATTR | Attributes for Consolidation Master Data Characteristics |
| FINCS_GRPSTR_WA | Consolidation Group Structure Upload Work Area |
| FINCS_FSIMAPT | Financial Statement Item Mapping ID Text |
| FINCS_FSIMAPITM | Assignment of GL Account To FS Item Mapping Revision |
| FINCS_ADHITMT | Ad Hoc Item Text |
List of tables in Master Data
| Table | Description |
|---|---|
| FINCS_MDUPLD_ADM | Master Data Upload Administrative Information |
| FINCS_BUNIT_ATD | Consolidation Unit Attributes Time Dependent |
| FINCS_FSITEM_WA | Consolidation Financial Statement Item Upload Work Area |
| CONS_MASTER_CHAR | Consolidation Characteristics Master Data |
| FINCS_FSITGTASGN | Target Items: Assignment to FS Items |
| CONS_MDCHAR_ATTR | Attributes for Consolidation Master Data Characteristics |
| FINCS_GRPSTR_WA | Consolidation Group Structure Upload Work Area |
| FINCS_FSIMAPT | Financial Statement Item Mapping ID Text |
| FINCS_FSIMAPITM | Assignment of GL Account To FS Item Mapping Revision |
| FINCS_ADHITMT | Ad Hoc Item Text |
| FINCS_FSIMASSLOG | FS Item Mapping Assignment Log |
| FINCS_ADDLMD | Additional Master Data |
| FINCS_ADHSETT | Ad Hoc Set Text |
| FINCS_BUNIT_ATVD | Consolidation Unit Attributes Time and Version Dependent |
| FINCSFSITEM_D | I_CNSLDTNFINSTMNTITEMTP I_CNSLDTNFINSTMNTITEMTP |
| FINCS_ADDLCHARC | Additional Characteristics for Journal Entry |
| FINCS_TMP_FSITEM | Temporary FS Item Record |
| FINCS_FSIMAP | Financial Statement Item Mapping ID |
| FINCS_STREAM_TMP | Temp table for stream service |
| FINCSFSITEMT_D | I_CNSLDTNFINSTMNTITEMTP I_CNSLDTNFINSTMNTITEMTEXTTP |
| FINCS_ADDLMDT | Text of Additional Master Data |
| FINCS_FSIM_HDR_D | Draft Table for FS Iem Mapping - Header |
| FINCSADDLMD_D | I_CNSLDTNADDLCHARCSTP I_CNSLDTNADDLMDTP |
| FINCS_TMP_FSITXT | Temporary FS Item Text Record |
| FINCS_FTRE | Consolidation Feature |
| FINCS_FSITGTT | Descriptions of FS Item Target Attributes |
| FINCS_TMP_FSIMAP | Temporary FS Item Record |
| FINCS_ADDLMD_EXT | Additional Master Data |
| FINCS_ADDLCHARCT | Text of Additional Characteristics for Journal Entry |
| FINCS_FSIMAPASSG | Assignment of FS Item Mapping to Speical Mapping Version |
| FINCS_FSIMAPRV | Financial Statement Item Mapping Revision |
| FINCS_FSITEM | Financial Statement Item |
| FINCS_FSIMAPRVT | Financial Statement Item Mapping Revision Text |
| FINCS_FSITGT | FS Item Target Attributes |
| FINCSFLDCONF_D | I_CNSLDTNADDLCHARCSTP I_CNSLDTNADDLCHARCSTP |
| FINCS_DRAFT_ADM | Simplified Draft |
| FINCS_ADHSET | Ad Hoc Set |
| FINCS_GRPSTR | Consolidation Group Structure |
| FINCS_ADDLCHARCX | Char UUID - Additional Characteristics for Journal Entry |
| FINCS_BUNITT | Consolidation Unit |
| FINCS_ADHSETITM | Ad Hoc Set Item |
| FINCS_BUNIT_WA | Consolidation Unit Upload Work Area |
| FINCS_FSITEMT | FS Item Text |
| FINCS_BUNIT | Consolidation Unit |
| FINCS_TMP_MD | Temporary Master Data Record |
| FINCS_FSIM_ITM_D | Draft Table for FS Item Mapping - Detail |
| FINCS_FSIASSGMT | FS Item Assignments, Version- and Year-Period-Dependent |
| FINCS_ADHITM | Ad Hoc Item |
| FINCS_GRPSTR_D | I_CNSLDTNGROUPSTRUCTURETP I_CNSLDTNGROUPSTRUCTURETP |
| FINCS_BUNIT_WA_2 | Consolidation Unit Upload Work Area |
| FINCS_FSIMAPHDR | Obsolete |