MODIFY Database table using Field Symbol Transporting fields

[balajishahrsap]

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

[former_member443654]

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.

[balajishahrsap]

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

[retired_member]

https://help.sap.com/http.svc/rc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abenopen_sql_writi...

[Sandra_Rossi]

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.