Updating a DB table using AMDP or SQL script

[Mkatta]

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.

[former_member244496]

For UPDATE in AMDP/HANA see SAP Note 2241598.