Tables related to Item

vishal.vgarg

Hi
I need to export some item and import it back at diff place.For this I need to know what all tables are related to Item so that I can export and import without any problem(like itemgroup not found )and even the tables that are related to the table that is related to item and goo till the end .I like to know a way which can programitically tell what all tables are related to item.What I figured out is that I browse through the item master table and check every field if there is a relationship in the ext data type then it has the main table and i can include that in my list.But I am unable to figure out how to do this. Any help is appreciated.

Thanks

kine

1) If you want to export whole chain of the related tables, you can do backup and restore of whole DB, because nearly all tables are related to each other. For example - On item you can have Vendor No. - it means export all Vendors. You have sales prices - export Customers with all connected tables etc... the result is that you will transfer all tables without transaction tables...