We are in the process of providing content which will give some insight into those common business areas in SAP and ORACLE applications, for which data models are often required for Information Management projects.
The first one I have created is a data model of the SAP tables used in the BOM Explosion process. The model was created following some analysis in Safyr® and then exported. It’s available below in PowerDesigner and Erwin formats. I can make it available in other formats for anyone that doesn’t have these tools – just drop me a message via the comments box stating your desired format and I’ll see what I can do. In case you would like to see how I have achieved this, I’ve also put together a short video showing how the tables that make up the model were determined. Shown are the Bill of Materials Explosion tables from a standard SAP ECC6 system. These may not be identical to the set of tables implemented at a given customer site due to customisations. This model is shown at the Primary and Foreign key level. Full attribute information is available using the other model display levels. As we are providing something which is usable in some contexts… here is the legal bit. In no event will Silwood Technology Ltd be liable for any indirect, special or consequential loss arising out of or in any way relating to the use or performance or the use or misuse of the information presented in this model.
Here is the link to the download of the model in PowerDesigner format: https://www.silwoodtechnology.com/downloads/Experts%20Corner/bomexplosionpowerdesigner.zip
Here is the link to the download of the ERwin model: https://www.silwoodtechnology.com/downloads/Experts%20Corner/bomexplosionerwin.zip
Here is the link to the video showing how they were created: https://www.silwoodtechnology.com/downloads/Experts%20Corner/bomexplosionvideo.zip
I hope they are useful, please let me know what you think.
Want to know how Safyr could give you data models of your SAP system? Please click here