How can I transfer data from SAP HANA to virtual table?

You are making a basic mistake over here. A VORA virtual table does not support the traditional INSERT or UPDATE or DELETE statements. If you are planning to make any modification to data from VORA itself, then you need to use the APPEND command to add data or files to the table. But since you are trying from SAP HANA even this will not work for you. 

For your requirement, you need to have a HDFS file then use it for appending to the virtual table.