CODEWITHSUNDEEP
sap-data-dictionary
sam
sam

Reputation: 69

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:

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?

Upvotes: 2

Views: 7415

Answers (5)

Dave Smith
Dave Smith

Reputation: 21

The foreign key check table for a table field you can get from SAP table DD03L. It is there in field CHECKTABLE. For table KNVK you will find all foreign key relations here.

You can also see this on some online web sites that have public documentation about it, e.g. from the SAP Tables documentation here.

However, not all relations can be discovered that way, as this is only useful for single key foreign key relations.

Another good way to see relations is to check, where a relevant data element is used. Data elements represent the data type of a field. You can e.g. see here,

Upvotes: 1

Suncatcher
Suncatcher

Reputation: 10621

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

enter image description here

Upvotes: 2

user1471512
user1471512

Reputation: 51

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

Upvotes: 0

Lars Hellwig
Lars Hellwig

Reputation: 9

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

Upvotes: 0

vwegert
vwegert

Reputation: 18483

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.

Upvotes: 4

Related Questions