From time to time, we have to either clear out test data in the system or even worse, the results of a hasty data migration exercise. Below is a brief sequence for doing this at a client level, which was developed after a late night of trouble shooting, caffeine and project manager delivered pizza.

This is a very indiscriminate process and you should practice several times in a safe environment before getting a backup of where you are going to run it for real. Use at your own risk.

OBR1        Transactional data (FI)
OKC3        Transactional data (CO)
SAPF047        Customer and vendor lnks
OBR2        Customers
OBR2        Vendors
OABL        Assets
OBR2        General ledger codes
KA24        Cost elements
OBR2        Chart of accounts codes
KS14        Cost centres
0KE2        Profit centres
SAPF023        Bank accounts

Part 2, follows next time, which is about cleaning at company code level.