Hi Dear Friends, sometimes I changes value of Baan Tables' fields by using SQL plus. But I don't know tables that depends on which related tables.Which tables use same fields ? and same value like that ?. For example when user do inventory operations, some values are inserted into some tables like tdinv100. But I don't know all of these tables. Only I guess the structure in my knowledge and then I do some operations. At that point , I wonder dependence of tables. When I change value of field Which tables I must check ? does anyone know all structure and relations of main DB tables of BAAN.

Thank you ALL !

Hi Suleyman,

I have a trick to know the table of any specific field. I dont know either it is useful in you case or not but just telling you. What you have to do just click on the help tool and drag it or click over the specific field (which you want to know) a new help window will apear, On the title bar of that window a table name with field will be displayed like tgbrg840.tusr.


Viplov

I know it . but I wonder whole structure of all main BAAN tables with relations and dependencies. I mean that the picture of BAAN DB

As far as I know, this is not possible

I do not recommended to change the values like this if you don't know the relations and dependencies. What I do is I use AFS to change the value of a field. I go to the maintain session of it and add/modify it there. Then I am sure all the DB will be updated

You can still use AFS from VB, but I don't know how this will help!

- George

do you mean picture like this?

George ! Everybody knows that you said. But sometimes if you are baan administrator,
you couldn't solve someproblems that were made by mistake. Then you have to use DB operations. Anyway I mean that mrandy's picture but for whole baan DB.

Thank you !!!

Pic I submitted above is generated. No problem
to generate this one for whole DB, but it is completely useless: it
is huge graph about 3k nodes and 10k edges

How can I get it ? or did you use any program to get that shema like by using TOAD, MS VISIO how did you get it ?

program is http://www.graphviz.org/Gallery.php

use command line :
"C:\Program Files\ATT\Graphviz\bin\dot.exe" source.txt -Tpng -oresult.png

where source.txt is like this:

digraph G {
tigrt008 -> tigrt002
tigrt002 -> tigrt003
tigrt002 -> tigrt001
tigrt008 -> tigrt006
tigrt008 -> tigrt003
tigrt008 -> tigrt001
}

you have to generate it from ttadv422 by yourself
enjoy

Does it connect BAAN DB ? or Should I create digraph of DB by using tables and view the structure on it ?

What i think is that this is not possible for whole DB. If created then very difficult to understand the graph.

I think that your solution is a manuel so I have to construct DB table structure as graph. It is very diffucult way and so far to my case. I wonder that is there a any automatic way to get graph of DB. May be there is a documentation about tables process on Baan. In fact I search process on whole tables. In the other words, I want to source of table process according to term on ERP like inventory or purchase operations.
Thank you for your considerations and time