|
Written by Administrator
|
|
Tuesday, 24 March 2009 14:58 |
SAP database contains thousands of tables.
For example SAP ERP database contains more than 30,000 tables.
Some lighter products like SAP NetWeaver Process Integration (PI) contains less than 10,000 tables.
In SAP about 10% of the tables contains 90% of the data.
That means few tables grow in size while other remains relatively constant.
The tables that grow in size are most transactional tables. Transactional tables contains transactions like Invoices, Journal etc.
The table that remain unchanged are mostly master tables. Master tables contain master data like list of currencies, list of states within USA etc.
Master data does not change as often as transactional data.
|
