|
Created by: |
SAP |
|
Underlying SAP report: |
SAP_DROP_TMPTABLES |
|
Client-dependent: |
No |
|
Settings as variant: |
Yes |
|
Support for RecycleBin: |
No |
|
Recommended for HANA pre-migration Housekeeping: |
Yes |
In SAP BW, there are dynamically created temporary database objects such as tables or views. They are created during query execution or other processes that read data from BW InfoProviders.
With BI 7.x, these objects are always created in the ABAP dictionary.
These objects have a name that starts with the “/BI0/0” prefix followed by one alphanumeric character for the object type and a numerical eight-digit identifier:
-
/BI0/01: Temporary tables used in connection with a query processing. They are used once – the system usually deletes them automatically (unless a dump occurred in the process) and the names are reused.
-
/BI0/02: Tables that are used for external hierarchies.
-
/BI0/03: No longer used.
-
/BI0/06: Similar to “/BI0/01”, but tables are not deleted from the SAP DDIC.
-
/BI0/0D: Tables are used in context with the Open Hub function. They are not allowed to be deleted.
-
/BI0/0P: Tables occur as part of optimized pre-processing that contains many tables. These tables can be reused immediately after releasing them.
With BI 7.x, temporary table management has been improved. Now it provides the report SAP_DROP_TMPTABLE to remove temporary objects.
We do not recommend executing this report on a regular basis. It might be useful to run it manually in certain exceptional situations when many temporary objects have been created.
The report SAP_DROP_TMPTABLES deletes all objects (except for the temporary hierarchy tables) without taking into account whether or not they are still in use. For example, this can result in the terminations of queries, InfoCube compression and data extraction.
