4 ms·
A SAP partner once told me (the company I was working at was considering using SAP) that the deployment would have ~180K tables - I don't know if they got the f
by arethuza 7y ago
A SAP partner once told me (the company I was working at was considering using SAP) that the deployment would have ~180K tables - I don't know if they got the figure wrong, I have misremembered (I did check when they said it) or maybe that's for a "fully loaded" instance.
Edit: Not SAP, but certain other ERP products have an alarming habit of not using foreign keys - which makes working out the structure of the database quite interesting...
- gberger 7y agoHow do you perform joins without foreign keys? Do you just have a column that is effectively a foreign key but is not marked as such?
- dizaime 7y agoSure it is. We can perform DB joins with any column as long as the data type and the data value is matched.
- AdrianB1 7y agoIt depends on the version and how many modules you have installed. In my company it was ~ 50k tables for R/3, so the order of magnitude is right.