Skip to Content
-3

MODIFY Database table using Field Symbol Transporting fields

Hi Experts,

Please let me know if we will be able to modify a database table using <Field-Symbols> by transporting 1 or 2 fields.

When we use MODIFY (lv_table) FROM TABLE <f_tab>, it wipes out all the fields except the manipulated fields and key fields

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • May 17 at 01:37 PM
    -2

    Hi Bala,

    first check <Field-Symbols> values in debugger before modify. if values are not assigned in firld symbols get it assigned and manipulate with new values. Generally, Before manipulating the fields first get the old values and try to manipulate the field values which you want new values it, will get updated.

    Add comment
    10|10000 characters needed characters exceeded

  • May 17 at 01:55 PM
    -3

    Hi Naresh,

    Is it not possible like how we do with a Normal internal table with Modify statement

    MODIFY DB FROM TABLE IT_TAB TRANSPORTING FIELD1

    Add comment
    10|10000 characters needed characters exceeded

  • May 17 at 03:50 PM
    Add comment
    10|10000 characters needed characters exceeded

  • May 18 at 06:18 AM

    You may use MODIFY to update a subset of columns only by creating an updatable database view with only this subset of columns and use MODIFY (viewname)... Of course the field symbol must refer to a table type with the same components as the view.

    Note that this answer is valid also for "normal" internal tables, not for field symbols only.

    Add comment
    10|10000 characters needed characters exceeded