Free tool
ERP Table and Field Explorer
Find the table behind a form or report, see its key, the fields that matter and how it joins to the rest of the schema, then get a JOIN query skeleton for SQL Server, Oracle or HANA. Built for report writers, ERP developers, consultants and IT managers.
Choose your ERP
Infor SyteLine (CloudSuite Industrial)
72 tables, 371 fields, 9 modules
item_mst, itemwhse_mst, itemloc_mst, location_mst, whse_mst, lot_mst
Open explorerInfor LN (and Baan)
74 tables, 666 fields, 9 modules
tcibd001, tcibd200, tdipu001, tiipd001, ticpr007, whwmd400
Open explorerInfor M3 (formerly Movex)
48 tables, 373 fields, 11 modules
MITMAS, MITFAC, MITAUN, MITPOP, MITWHL, MITBAL
Open explorerJD Edwards EnterpriseOne
62 tables, 490 fields, 11 modules
F0101, F0111, F0115, F01151, F0116, F0150
Open explorerSAP ECC (ERP Central Component)
95 tables, 1197 fields, 10 modules
MARA, MAKT, MARC, MBEW, MVKE, MARM
Open explorerSAP S/4HANA (on-premise and private cloud)
90 tables, 729 fields, 9 modules
MARA, MAKT, MARC, MARM, MVKE, MBEW
Open explorerOracle E-Business Suite
120 tables, 1179 fields, 13 modules
MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_TL, MTL_ITEM_CATEGORIES, MTL_CATEGORIES_B, MTL_ITEM_REVISIONS_B, MTL_UNITS_OF_MEASURE_TL
Open explorerOracle NetSuite
39 tables, 282 fields, 8 modules
transaction, transactionline, transactionaccountingline, nexttransactionlink, previoustransactionlinelink, transactionshipment
Open explorerEpicor Kinetic (formerly Epicor ERP 10)
55 tables, 502 fields, 9 modules
Part, Part_UD, PartRev, PartClass, ProdGrup, PartPlant
Open explorerSYSPRO ERP
34 tables, 224 fields, 11 modules
InvMaster, InvWarehouse, InvWhControl, InvMovements, InvPrice, SorMaster
Open explorerWhy a table explorer
ERP schemas are large and their names are terse: coitem_mst in SyteLine, tdsls401 in LN, OOLINE in M3, F4211 in JD Edwards, VBAP in SAP. The data dictionary that explains them often sits behind a login or a client install. This explorer keeps the most used tables of each ERP in one searchable place, with the conventions that trip people up: site and company columns, table name suffixes and right-justified keys.
Search by what you know. A field such as qty_ordered, a business word such as invoice, or a form name finds the table, and the detail panel shows the key and the joins so the query you write uses the index instead of scanning the table.
Questions
What does the ERP Table and Field Explorer do?
It is a searchable catalog of the tables report writers, developers and consultants use most in each ERP: items, BOM and routing, sales, purchasing, inventory, production, finance, customers and suppliers. For each table you get a description, the key, the important fields with their meaning and the documented join columns. Pick two to four tables and it writes a JOIN query skeleton in the right SQL dialect.
Where do the tables and fields come from?
From vendor documentation and well established public references, listed as sources on every ERP page. Anything we could not confirm is left out or marked verify in the table notes. Column sets change between releases, so treat the catalog as a map and confirm details in your own data dictionary.
Which SQL dialect does the query builder use?
The dialect of the database the ERP normally runs on: SQL Server for SyteLine, Epicor Kinetic and SYSPRO, Oracle for E-Business Suite, SuiteQL for NetSuite, and SQL Server or Oracle for JD Edwards and LN depending on your platform. On SAP pages you can switch the output to ABAP Open SQL or an ABAP CDS view skeleton, matched to the release: Open SQL compatible with 7.40 SP08 and 7.50 plus a DDIC-based CDS view for ECC, the FIELDS syntax and a CDS view entity for S/4HANA. For native SQL you can set the schema or owner, and on LN the company number suffix.
Is it safe to run the generated SQL?
The skeletons are read-only SELECT statements with a row limit and the site, client or company filter the ERP needs. Run them against a reporting copy or with read-only credentials, and never write to ERP tables with SQL: use the APIs, IDOs, BAPIs or interfaces the vendor supports.
Do I need an account?
No. Search, the query builder and every export work without a login. A free Netray account is optional and only saves your favorites and query so you can reopen them on another device.