Hello,

we are going to delete one of our test companies.

Therefore I´m looking for a detailed documentation how to manage this procedure.

Who is able to help me?

Thanks in advance.

Regards,
Thomas

Thomas,

Here's what you should do from a 'tools' perspective:

1. Run Delete tables (ttaad4231m000) for your company

2. Remove the company from Maintain Companies (ttaad1100m000) and Convert to Runtime

...but take care about linked tables before deletion

I would do the following (company XXX to be deleted):

0. Make a backup, you never know!

1. Check with ttaad4520m000 (display logical tables) if any company YYY is using tables from XXX.
- IF so, you need to remove the links from YYY to XXX, export those tables from XXX and import them into YYY, or export YYY, then remove links and re-import it.

2. Delete data with ttaa4231m000 (delete tables) for company XXX.

3. Delete company with ttaad1100m000 (delete company).

4. Check entries for company XXX on $BSE/lib/DB/DB_storage (eg., DB=ora for oracle database) and take notice of tablespaces used, remove entries for company XXX.

5. Drop (including contents) the tablespaces (taken from step 4) from the database, remove the files at OS level if not done automatically by the database 'drop'.