Skip to Content
-1

How to update specific fields of the database table from itab?

I have an internal table and want to update specific fields of the DB table based on values of the internal table. I tried both UPDATE and MODIFY clauses but it doesn't work.

The issue is that UPDATE accepts itab as a data source but doesn't allow specifying wanted fields, while MODIFY allows doing that with TRANSPORTING, but accepts only work area.

How can I update specific fields of the database table from itab?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 15 at 05:17 PM

    Hi,

    UPDATE Table name SET field name = 'modify'

    WHERE key fields = '100'.

    Regards,

    Venkat

    Add comment
    10|10000 characters needed characters exceeded

  • May 16 at 06:14 AM

    Did you consider

    • Selection of the whole structure in internal table (with some for all entries) then modify the internal table and last update the database
    • Creation of a view in database, and update this view
    Add comment
    10|10000 characters needed characters exceeded