I am not a baan user, but a report developer using Crystal Reports. I have been asked to create some reports on baan data and have found that there are thousands of tables. I am looking for a document that defines the tables, or some sort of data dictionary or schema that would help narrow down the information I am looking for. Any help would be greatly appreciated.

a better way is to ask your user to give specs with screenshots of baan forms containing the data. you need to logon to baan and look at the sessions/tables themselves. you can print table definitions with fields.

Can you give me a little more information on that process? How would a user print table definitions with fields? Are you meaning out of Baan itself? I thought I had read something about a crtl-shift-4 function that would list the sql. Is this what you are referring to?

when you logon to baan there is a session print table definitions and a choice to print the fields, detailed report, etc. also look at session help, it will tell you which table field it's using.

You can use the field help, showing you the tecnical field name behind the form field, e.g. tiitm001.item (table.field ... on sql level you have to add a "t" in the beginning and the 3 digits of the company numer e.g. 100 and the technical separator ($ or _), so tiitm001.item is ttiitm001100.t$item on database level.

Which version are you using? From 5.0 there is a facility within the enterprise modeller to generate entity relationship diagrams from the tables. Then in the editor you can look at the diagram for each table, from where you can explore the fields, indices and links to other tables.

The splash screen indicates B40c.104