Using UPDATE statement in native sql OR SQL script for AMDP

[Former Member]

Hello HANA experts,

I want to update a custom database table from a internal table in an AMDP method, as we know that the AMDP method only accepts native SQL or SQL script.

Can any one please suggest how can I update the complete custom DB table from an internal table.

example in SAP ABAP ECC where I can write is

Update ZDEMO_TABLE from table i_demotab.

where ZDEMO_TABLE is the database table and i_demotab is the internal table.

Please suggest how can I update DB table using native SQL or SQL SCRIPT also using modify and insert commands in native SQL.

Thanks,

rg

[xiebryant]

Hi Ramya,

You could try this code.

If you have other solutions, please share it.

Bryant

[amol_samte]

Check below blog...

Calling internal table inside AMDP

Regards,

Amol