3 ms·

I came to the same conclusion when I read that a basic SAP installation comes with over 20k tables. (see: https://retool.com/blog/erp-for-engineers/ https://ret

• 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 ago
    How 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 ago
      Sure it is. We can perform DB joins with any column as long as the data type and the data value is matched.
  • AdrianB1 7y ago
    It 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.