We checked the query and it contains references to existing objects in new schem1 which are moved with Catalog object import.

We already tried with create any HANA right on SAPABAP1 schema and kind of assigned SAP ALL authorization to HANA DB user which we are using to import catalog object.

I tried importing on same HANA rev 110 it worked fine there. Could this error be related to HANA Rev 97 and 110 difference?

Again we created schema on rev 110 and importing this on REv 97 . I know this shouldn't be the practice from higher to lower release but we download the latest stuff and Rev 97 was in Archive mode on SAP SMP to download.