cancel
Showing results for 
Search instead for 
Did you mean: 

how to add new record in exporting table that is used inside AMDP method?

hi experts,

how to add new record in exporting table that is used inside AMDP/amdp class method using importing parameters ?

im going to use INSERT commnd but its throwing error that u can't use insert/update/modify.

Pls. give me solution.

METHOD my_hana_procedure BY DATABASE PROCEDURE FOR HDB LANGUAGE SQLSCRIPT OPTIONS READ-ONLY .

e_view = select * from :i_view;

ENDMETHOD.

by using i_view i have to add new records in e_view.

0 Kudos

Hello,

I have a similar requirement - to insert a new record to a database table in an AMDP, not to the exporting table.

Could you please share how you overcame your issue so that I can find a direction?

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

roberto_forti
Contributor

Answers (1)

Answers (1)

horst_keller
Product and Topic Expert
Product and Topic Expert

You use "OPTIONS READ-ONLY" . Try without.

0 Kudos

Hi horst,

when i tried without options..it will threw dump when executing planing sequence(embedded AMDP class ).

horst_keller
Product and Topic Expert
Product and Topic Expert
0 Kudos

Well yes, but that's not an ABAP but a SQLScript issue. Read the error message.

0 Kudos

i'll try this also...as of now i did union all and get desired o/p in e_view(when i debug sqlscript i can see).....now the issue is its not updating/reflecting when i run my planning sequence.

e_view is using in exporting parameter,is this correct?