topic modify in Application Development and Automation Discussions

modify

Former Member — Mon, 14 May 2007 13:48:09 GMT

hi guys,

anyone can tell about modify statement with an example.

Re: modify

Former Member — Mon, 14 May 2007 13:50:39 GMT

Hi,

check this link

http://help.sap.com/saphelp_nw2004s/helpdata/en/9f/dba4b235c111d1829f0000e829fbfe/content.htm

rgds,

bharat.

Re: modify

Former Member — Mon, 14 May 2007 13:50:54 GMT

Hello

This statement changes the content of one or several itab_line or itab_lines lines that can be specified using the table key or the table index.

loop at ti into wa_ti.

wa_ti-field = 'test'

modify it from wa_ti index sy-tabix.

endloop.

Hope this help

Gabriel

Re: modify

Former Member — Mon, 14 May 2007 13:53:20 GMT

Modify statment will work both insert and Update..

Modify ztable from table int_table.

if you are changing non primary key,then it works like update..

if you are creating new record then it works like insert command.

Reward Points if it is helpful

Thanks

Seshu

Re: modify

Former Member — Mon, 14 May 2007 13:53:41 GMT

hi,

Changing a Line Using the Table Key

To change a single line in a table, use the MODIFY statement:

MODIFY TABLE <itab> FROM <wa> [TRANSPORTING <f1> <f2> ...].

The work area <wa>, which must be compatible with the line type of the internal table, plays adouble role in this statement. Not only it is used to find the line that you want to change, but italso contains the new contents. The system searches the internal table for the line whose tablekey corresponds to the key fields in<wa>.

The system searches for the relevant lines as follows:

Standard tables

Linear search, where the runtime is in linear relation to the number of table entries. Thefirst entry found is changed.

Sorted tables

Binary search, where the runtime is in logarithmic relation to the number of table entries.The first entry found is changed.

Hashed tables

The entry is found using the hash algorithm of the internal table. The runtime is

independent of the number of table entries.

If a line is found, the contents of the non-key fields of the work area are copied into thecorresponding fields of the line, and SY-SUBRC is set to 0. Otherwise, SY-SUBRC is set to 4. Ifthe table has a non-unique key and the system finds duplicate entries, it changes the first entry.

Re: modify

Former Member — Mon, 14 May 2007 14:00:06 GMT

modify is update + insert.

Re: modify

Former Member — Mon, 14 May 2007 14:02:54 GMT

thanks for everyone

regards

vijay

Re: modify

Former Member — Mon, 14 May 2007 14:03:11 GMT

thnks yaar