Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Upsert in AMDP

0 Kudos
1,070

Hi,

I want to update or insert DB table inside AMDP.

Used below syntax

upsert zrfcdetails ( RFCDEST,RFCTYPE) values (1, ARRAY (SELECT RFCTYPE FROM :LT_TMP) );

But getting syntax error

Can someone let me know the exact syntax

2 REPLIES 2

Sandra_Rossi
Active Contributor
412

In AMDP you write code for the standard SAP database.

So, what is your database?

What is your syntax error?

UPSERT for HANA

0 Kudos
412

I found the solution for this issue.

Below is the sample syntax for update and insert via AMDP.

upsert zrfcdetails select * from :lt_tmp;

insert into zrfcdetails select * from :lt_tmp;