topic Re: MODIFY Database table using Field Symbol Transporting fields in Application Development and Automation Discussions

MODIFY Database table using Field Symbol Transporting fields

balajishahrsap — Thu, 17 May 2018 12:52:23 GMT

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

Re: MODIFY Database table using Field Symbol Transporting fields

former_member443654 — Thu, 17 May 2018 13:37:08 GMT

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.

Re: MODIFY Database table using Field Symbol Transporting fields

balajishahrsap — Thu, 17 May 2018 13:55:49 GMT

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

Re: MODIFY Database table using Field Symbol Transporting fields

retired_member — Thu, 17 May 2018 15:50:40 GMT

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

Re: MODIFY Database table using Field Symbol Transporting fields

Sandra_Rossi — Fri, 18 May 2018 06:18:51 GMT

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.