topic Re: Updating/Inserting Virtual Table entries from ECC in Application Development and Automation Discussions

Updating/Inserting Virtual Table entries from ECC

lakshmanjk — Tue, 17 May 2022 07:55:17 GMT

Hello Gurus,

We have created a new virtual table in our system with reference to a table from non-SAP system and we are able to read the data successfully from this virtual table using AMDP query and display the output. I would like to know if it is possible to update the existing records and insert new records to this virtual table from the same AMDP or ABAP. The table definition remains same and no change to the definition as explained in ALTER VIRTUAL TABLE. If so, how can we achieve that using AMDP or ABAP code. Thanks for your inputs in advance.

Thanks

Lakshmanan J K

Re: Updating/Inserting Virtual Table entries from ECC

Sandra_Rossi — Tue, 17 May 2022 09:36:03 GMT

Did you do a quick test directly using HANA SQL, before asking for AMDP/ABAP?

Re: Updating/Inserting Virtual Table entries from ECC

lakshmanjk — Tue, 17 May 2022 09:47:35 GMT

Hi Sandra,

No I didn't. I am looking for options to update using AMDP class by MODIFY/UPDATE/UPSERT commands.