EWM creates large amount of data for each process and stores these at complicated tables. You need to create periodic background jobs to clean these tables to improve database access and performance. I will give you some basic jobs for common use, feel free to add if you want to share more.
|/LIME/BACKGROUND_DELETE_EXEC||Deletes DB entries for zero stock quantities, index entries without stock|
|/LIME/COLLECTION_DELETE||Deletes the dispatch message log for goods movements between EWM and ERP older than X days|
|/SCMB/ALEN_ALERT_DELETE||Deletes alerts older than X days|
|SBAL_DELETE||Deletes Application logs(BALDAT & BALHDR Tables)|
It is clear from my explanations, but you can learn more from definition of SAP.
Don’t forget the good old SARA transaction with business data archiving:
|WME_ILT||Indirect Labor Tasks|
|WME_RSRC||Relevant Resource Data|
|WME_VAS||Value-Added Service Orders (VAS Orders)|
|WME_VEH||Shipping & Receiving: Vehicle Activities|