Child pages
  • Report SAP_DROP_TMPTABLES
Skip to end of metadata
Go to start of metadata

Caution

The report SAP_DROP_TMPTABLES should not be scheduled frequently (not daily or more frequent).

Is is intended for cleanups after special situations such as software upgrades, support packages implementations etc...

The report SAP_DROP_TMPTABLES has been further enhanced in SAP Note 2475675.

Purpose

The purpose of this page is to clarify the understanding of the program SAP_DROP_TMPTABLES.

Overview

With report SAP_DROP_TMPTABLES you can remove temporary objects.

There are DB objects such as tables, views, triggers and so on that have the /BI0/0 name prefix. These objects you can’t find in the ABAP Dictionary.

Those tables outside of the ABAP Dictionary are for performance reasons or because they cannot be defined there (as stored procedures or triggers).

All these objects have names that start with /BI0/0... followed by a number for the object type and an eight digit identification.  

Caution: See SAP Note 1139396

“The SAP_DROP_TMPTABLES report deletes all objects (except for the temporary hierarchy tables) without taking into account whether or not they are still in use. This can result in terminations of queries, compression and data extraction, for example, if these are running simultaneously.
If temporary objects prove to be inconsistent under DB02, you must execute report SAP_UPDATE_DBDIFF once. If you use the DB02 once again afterwards, you must make sure that the system updates the results. The report copies information about differences between definitions in the ABAP DDIC and in the DB catalog to table DBDIFF. DB02 includes the table when checking for inconsistencies.”

How to activate it?

Run transaction SE38  with program SAP_DROP_TMPTABLES  

Select the respective checkboxes.

Execute (choose F8)

Parameters

The following objects can be deleted:

  • Temporary Tables (Type 01/0P)
  • Temporary Views (Type 03/07)
  • Temporary Hierarchy Table (Type 02/08)
  • Temporary SID Tables (06)
  • Generated Temporary Reports  

Related Content

Related SAP Notes/KBAs

Notes describing and correcting program SAP_DROP_TMPTABLES are below:

1889541  "Error creating tmp table" in RSRT transaction
1829728  BW Housekeeping Task List
1718576  Migration from SAP HANA to another database system
1897142  SAP_DROP_TMPTABLES always drops hierarchy entries
1883124  SAP_DROP_TMPTABLES deletion of BWA/SAP HANA objects
1714492  Technical BW problems for queries with many hierarchies
1701123  SAP_DROP_TMPTABLES does not delete temporary BWA/HANA tables
1764610  Error 'RFC destination does not exist' when running SAP_DROP_TMPTABLES
1149665  RS_BW_POST_MIGRATION cannot be restarted during PSA