Hello everyone: the goal is to apply a recodification of the articles on the ITMMASTER table and all the zones to which it is linked

To access all the zones linked directly to our ITMMASTER I used the ATABZON tables zone, the SQL query used is:

Select * from ATABZON

Where LIEN_0 = ‘ITMMASTER’

Order by codfic_0

But there are elements missing to identify:

- Tables which are linked to ITMMASTER but not directly (there can be several intermediate levels).
- Tables which have generic areas (linked to no particular table) but which contain as given an article code.

Do you have any queries or ideas that can help me? Thank you in advance.