Finding SAP table relations?

I'm new to SAP. I have access to the SAP database, but not to the SAP GUI. I wanna know the tables relation i.e., how to join two tables.

Suppose, if I want to know all the relations VNVK has, where should I start? I can only view the primary keys and not the foreign keys for all the tables. I read some posts from this forum and got this information:

DD02L: SAP Tables
DD05S: Foreign key fields
DD09L: DD: Technical settings of tables
DD26S: Base tables and foreign key relationships

but the DD26S table doesn't give me these information either.

I even tried to get the table and column description and then try to join, but it's a tedious process.

I got a document with SAP table relations but it doesn't have all the modules in it.

Any holistic documentation about all of them?

Solution

If someone wants you to do the job, they have to give you the proper tools. You need frontend access (at least read-only) to do this. So take a pointed stick and poke whoever is responsible until you get the necessary permissions.

That being said, you should check out the IDES installation provided by consolut - they offer free (read only) access, and that might be enough for you. Read this for information about the dictionary structures and this for information on the tools.