Finding SAP table relations?

I'm new to SAP. I only have开发者_StackOverflow中文版 SAP tables and i don't have access to the frontend.. 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 foreigh 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?

---

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.

---

On STechno you can find a list of SAP tables: http://www.stechno.net/sap-tables.html

where table relations for any SAP table can be seen by via field references. Another way this resource provides is graphical visualization of the table relations. For example, MARA connections look like this

---

I'm from consolut, you can also program Abap but not in our IDES. For programming try our Mini-SAP system.

---

There are are several vendors out there that offer SAP systems for short or long term use as sandboxes, one of them is also Bettisworth associates. Simply google them