Maintenance of EWM Database

[former_member209095]

Hello all,

 

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.

 

Best regards

Serhan Er

 

Don't forget the good old SARA transaction with business data archiving:

 

object	description
WME_DOOR	Door Activities
WME_EPD	Performance Document
WME_EWL	Executed Workload
WME_HU	Handling Units
WME_ILT	Indirect Labor Tasks
WME_MFS	Telegram Flows
WME_RSRC	Relevant Resource Data
WME_TO	Warehouse Tasks
WME_TU	TU Activities
WME_VAS	Value-Added Service Orders (VAS Orders)
WME_VEH	Shipping & Receiving: Vehicle Activities
WME_WAVE	Waves
WME_WO	Warehouse Orders

 

best regards,

Matthias