SAP BW Temporary database objects

[Former Member]

what are SAP BW temporary database objects, why and how are they created and what is the consequences of deleting them? thanks

[Former Member · Accepted solution]

Hi Niten,

The program would remove the temporary database objects. You would need to consult your BASIS before you execute this program.

Bye

Dinesh

[j_vandersterren]

Hello Niten Shah,

Some routines are dynamic routines. These are created during runtime. They are created locally (=$TMP). When the proces ends with an error they stay local in the system. You can delete these, but I would not recommend this to you.

There are also some local objects when you create queries in the productive system. You don't want to delete this ones.

Regards,

Jos.

[Former Member]

Thanks for that. I need to run the program SAP_DROP_TMPTABLES what will this delete?