Who is Participating?

SAP do not publish the Scheama. The reason being that they keep changing it. This is one of the major problems with direct DB access.

The accepted method of doing what you are doing is to drive it at the application level. SAP best practice is to never access the tables directly from outside of the application layer. I would be very surprised if a solution that did that would get SAP Certification, however these days you can never be sure.

You then use these to call Function Modules in SAP.
If the data you are looking for is standard kind of data you may find that there are pre-build RFCs called BAPIs which already fullfil your needs, if not you will need to write some in ABAP.

In the newer versions of SAP you can write WebSerivces to expose data from SAP in Java.

As for "I do know this much though, SAP runs on Oracle database" this is far from the truth.
SAP Can run on any of the major DBs from Oracle to ADABAS to DB2, to MySQL, SAP uses a level of abstraction from the DB to allow programs written in ABAP and Java in SAP to run on any of the supported databases. SAP even uses its own version of SQL "Open SQL" which the applicaiton layer convert to the native SQL of the installed DB.

The database is not fully normailised and the relationships are managed at the applicaiton level in the SAP Data Dictionary.

Basically we develop integration systems for our software, which allow us to basically connect to other applications for additional data/information.

Currently we make an automated script which re-structures SAP Data Dumps into what we want, but now we want to be able to go straight into SAP and get what we want.

If it at all helps, I only need the structure of the tables which are related to Device Management. I'm not sure what it's called in SAP, but the data we get given is information such as Hardware Devices installed/removed/changed, Port and Connectivity Configurations, etc.

We don't actually have a copy of the application in our office, and have been working blind developing these integration tools for SAP and our products. I do know this much though, SAP runs on Oracle database, and if it's anything like MS SQL (from what i've heard, it's better), you should be able to be able to make a database diagram of the Equipment/Device table, and all related tables which are JOIN'ed to it.

If someone could make something like that up for me, it would solve my question.