Solution : https://service.sap.com/sap/support/notes/1701123 (SAP Service marketplace login required)
Summary :
The SAP Note addresses an issue with the SAP_DROP_TMPTABLES report, which previously could not remove temporary hierarchy tables from BWA or SAP HANA databases. The update provides the necessary source code allowing for the deletion of these tables under the "Temporary Hierarchy Tables(02)" selection. Upon execution, the report either displays a success or error message. Moreover, users faced an error message prompting an RFC destination or indicating a job cancellation due to an "ERROR_MESSAGE". This bug is resolved by implementing respective Support Packages detailed in accompanying SAP Notes for SAP NetWeaver BW 7.30 and 7.31.
Key words :
terms hier cl_rsdrh_hier_cache_trex temp rsddtmptab rsddtmptab_cleanup error_message reason, delete temporary hierarchy tables, solution sap netweaver bw 7, system exception error_message, delete temporary tables, temporary hierarchy tables, sap netweaver bw 7, sapbwnews nw bw 7, sap nw bw 7, missing source code
Related Notes :
| 1712334 | Important Notes for SAP BW powered by HANA on SP7 |
| 1680998 | |
| 1680997 | SAPBWNews NW BW 7.30 ABAP SP8 |
| 449891 | Temporary database objects in BW 3.x |