3634879 - Temporary tables are not being deleted automatically in SAP Datasphere

Temporary tables with the prefix DT__ or DIS__ are not being deleted automatically after the execution of data loads in SAP Datasphere. It is observed that these tables are consuming a significant amount of disk and memory resources. 

SAP Datasphere

1. In Space Management, click on "Monitor"
2. On the Monitor page, under "Table Details" it is possible to see tables with prefix DT__  or DIS__ consuming disk and memory resources, even though the associated Data flow or Replication Flow may have already failed or completed. 

Temporary tables are internal objects created automatically during the execution of data loads in SAP Datasphere. When these objects are not deleted automatically, their removal must be performed manually by the SAP support team.

To request deletion of a temporary table, follow these steps:

1. Open a customer case in SAP4ME and manually change the Component to EIM-DS-DI before submit the case.
2. Provide the full name of the temporary table.
3. Request manual deletion of the object.

temporary tables, DT table, DT__, orphaned, internal tables, shadow tables, M_CS_TABLES, DIS__  , KBA , EIM-DS-DI , DI, DWC, Data Suite usage of DS-Lite , DS-SM , Space Management , Problem