SAP for Retail Discussions
Join conversations about personalization, omnichannel strategies, and operational excellence in retail using SAP for Retail software.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Database growing rapidly.. sap retail - solaris - oracle

Former Member

‎08-27-2015 10:22 PM

0 Kudos

Hi All,

Our Production database is growing rapidly we are adding 1 data file every week. I have found the larger growing tables..How can I identify the core issue..??

We make nearly 1000-2000 Purchase Orders on daily basis ( no attachments ).

Below is the largest table growth from EWA.

Regards..

Letz..

Preview file
99 KB
1 REPLY 1

eduardo_hinojosa
Active Contributor

‎09-07-2015 5:26 PM

0 Kudos

Hi

Surely around more than of 90% if these PO are STO. If you are working with a SAP IS-Retail you need to archive documents periodically. Run for instance tcode TAANA and check what kind of PO documents you have in your database.

Take in accound other tables with a fast growth could be MSEG, LIPS, BSIS and so on.

Check with your FI consultant if it's possible to do summarize documents in FI and CO-PCA.

So, begin to think in Archiving as your next task.

I hope this helps you

Regards

Eduardo