Solution : https://service.sap.com/sap/support/notes/1139396 (SAP Service marketplace login required)
Summary :
In SAP BW, the system utilizes dynamic and predefined database objects prefixed with '/BI0/0' for various operations such as query execution and data processing from InfoProviders. These objects include temporary tables that store intermediate query results or are used in handling external hierarchies. Unlike older versions before BI 7.x, these tables are integrated within the ABAP Dictionary, making them accessible via transactions like SE11. Following BI 7.x enhancements, the management of these temporary tables focuses on self-maintenance, not requiring regular manual deletion using reports like SAP_DROP_TMPTABLES except under exceptional circumstances. Caution is advised as indiscriminate deletion could disrupt ongoing system operations.
Key words :
open hub read processes, terms business information warehouse, run report sap_drop_tmptables manually, temporary object types exist, run report sap_drop_tmptables, open hub functionality, report sap_drop_tmptables regularly, sap_drop_tmptables report deletes, bw open hub, execute report sap_update_dbdiff
Related Notes :
| 1168412 | Temporary Indexes on BIA with BI 7.X |
| 514907 | Processing complex queries (data mart, and so on) |
| 449891 | Temporary database objects in BW 3.x |