Hello to everybody,

I have a question.
First:

Because I need different informations from different baan sessions I wanted to write my own job. Beause I don't have access to this and I dont't have knowledge about this I'm writing queries with the module EasySQL, prininting this Queries in EXCEL and connect the different Queries with PowerQuery to get the informations needed.

To get the right tables I need a "MasterTable" in which I can see the name (i.e. tisfc001) and the description (i.e. "Head Prodution oder").

Is there a table in BaaN which includes all tables used in BaaN.


Thanks in advance.

ttadv420 should have the tables - you'll have to do something to make sure you're selecting for the PVRC you're in. Descriptions should be in the labels table - ttadv140. Different versions link those two tables differently.

From your point of view start with
1) assume session code to have the main table as well: ppmmmaxbcm000 has maintable ppmmmabc
2) when that fails, just run the session and press Ctrl-Shift-8 and go to the Query tab, there you will see the query used to populate the screen
3) In other cases (silent process sessions) you can always set up logging of the bshell to find out what the session is doing, but you will get lost in the logfile.

Hey, Thanks for your fast replies. The solution with the table ttaadv420 doesnt't work for me. I get an error message 506. The table doens't exist. I will try it with the idea from ome luuk.

Infor LN is technically a RDBMS where not only the application data is stored in companies but the structure of the data itself is also stored in "system" tables. These are - however - located in the "tools company 000" so to query those tables you will need to "switch company" to 000.