By default there is a schema from which both ABAP and HANA can read say 'SAPCRD.
Our requirement is to write data in HANA into another schema say 'ZHWRITE'.
From HANA I'm able to call this procedure call "ZHWRITE"."ZPROC_WRITE".
But when we are trying to call write procedure "ZHWRITE"."ZPROC_WRITE" then we get Insufficient Privilege.
From this schema 'ZHWRITE' I'm able to read data in ABAP side but not able to insert data.Though in HANA side using same user I'm able to insert data also.
Is there any other privilege to be given so that write procedure can be called from ABAP stack ?
It is not possible for us to rewrite logic in AMDP as it is a very complex logic and we already invested lot of time in writing this procedure in HANA side.