Upsert in AMDP

[former_member633271]

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

[Sandra_Rossi]

In AMDP you write code for the standard SAP database.

So, what is your database?

What is your syntax error?

UPSERT for HANA

[former_member633271]

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;