SAP R3 Database Schema
Hi guys,
Any chance that someone can provide me with the SAP R3 Database Schema?
Cheers!
Any chance that someone can provide me with the SAP R3 Database Schema?
Cheers!
ASKER
Hi,
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,
Cheers!
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,
Cheers!
Hmm....
Its a bit complex request. Frankly i am not aware of any such resource/book which describes the entire DB Structure of SAP.
Regards,
cryptosid
Its a bit complex request. Frankly i am not aware of any such resource/book which describes the entire DB Structure of SAP.
Regards,
cryptosid
ASKER
Hi,
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.
Cheers!
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.
Cheers!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You may want to have a look here.
For most companies SAP Certification is essential for any product that integrates with SAP. Without it companies are putting their support agreements at risk.
http://www.sdn.sap.com/irj/sdn/sdnservices/icc
For most companies SAP Certification is essential for any product that integrates with SAP. Without it companies are putting their support agreements at risk.
http://www.sdn.sap.com/irj/sdn/sdnservices/icc
ASKER
Hi,
Lucky for us, the people we are making the solution for have the maintenance rights to SAP, and since the solution is for them, creating it will be legal.
But from what you've told me, it looks like I need to look into the .NET connectors, and go from there.
Thanks for the very detailed reply, it was highly appreciated!
Cheers!
Lucky for us, the people we are making the solution for have the maintenance rights to SAP, and since the solution is for them, creating it will be legal.
But from what you've told me, it looks like I need to look into the .NET connectors, and go from there.
Thanks for the very detailed reply, it was highly appreciated!
Cheers!
Not sure what your purpose is, however let me tell you, SAP R/3 Database has 13,000+ tables that come along with the installation.
do you want to know about the Architecture of SAP ?