Skip to Content
avatar image
-1
Former Member

Updating a DB table using AMDP or SQL script

Hello All,

I have a seldom problem. Just to give some back ground.

1. We have a Z DB table with 126 fields(Yes exactly 126) having 3 key fields which has like 250+ million entries.

2. I need to update four fields in the Z table(Step1) from a CDS view which has 7 fields( 3 key fields of the ZDB table + four fields which need to be updated) .

Here is the problem.

Here is my code approach.

a. lt_tab = data from the CDS_VIEW.(which will fetch like 20 million entries)

I'm not sure how to approach the updating part. I cannot use MODIFY as I have to get the entire table data(which is huge performance).

Just for Info we are using HANA DB.

Any recommendation and Suggestions are highly appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 06 at 05:36 AM

    Either you fetch the data into an internal table and then use UPDATE SET of Open SQL or you stay on the DB and update directly there in AMDP without loading to ABAP. The latter should be better in performance. But there is no use in first loading the data to ABAP and then pushing them back to AMDP.

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Horst,

      As mentioned by you,

      Either you fetch the data into an internal table and then use UPDATE SET of Open SQL 

      Can you please elaborate on how to use Internal Table with UPDATE SET.

      As I could see in the documentation that, UPDATE SET works only if all the records has a common WHERE clause value for a column:

      capture.png (5.8 kB)