Solution : https://service.sap.com/sap/support/notes/1646743 (SAP Service marketplace login required)
Key words : 
py  --action=12  --mode=0  --filter=1for dropping, naming pattern _sys_ss_ce_<guid>_tmptbl solution, py  --action=12  --mode=1  --filter=1please, naming pattern _sys_ss_ce_<guid>_tmptbl, naming pattern  _sys_ss_ce_<guid>_tmptbl, remaining _sys_ss_ce_<guid>_tmptbl tables, sap hana database instance, revision 17 temporary tables created, sap hana database, generate ddl statements
Related Notes : 
       
| 1523337 | SAP In-Memory Database 1.0: Central Note | 
| 1514967 | SAP HANA 1.0: Central Note |