topic Re: most efficient, MODIFY / UPDATE? in Application Development and Automation Discussions

most efficient, MODIFY / UPDATE?

Former Member — Tue, 16 Oct 2007 08:44:09 GMT

Hi,

I need to modify (empty) 1 field for all enteries in table EANL?

What is the most efficient way to do it?

tnx,Adibo.

Re: most efficient, MODIFY / UPDATE?

Former Member — Tue, 16 Oct 2007 08:47:38 GMT

Loop over it and modify.

Loop at itab.

MODIFY...

endloop.

Re: most efficient, MODIFY / UPDATE?

Former Member — Tue, 16 Oct 2007 08:51:21 GMT

Hi,

Refer to the following example.It is updating a table(ZCBU) with the field sfid for all entries in the table.

SELECT cbu sfid FROM zcbu INTO TABLE zcbu_temp_update

FOR ALL ENTRIES IN zcbu_update WHERE cbu = zcbu_update-cbu.

LOOP AT zcbu_update.

UPDATE zcbu SET sfid = zcbu_update-sfid

WHERE cbu = zcbu_update-cbu.

IF sy-subrc = 0.

count = count + 1.

ENDIF.

ENDLOOP.

Hope this helps.

Reward if helpful.

Regards,

Sipra

Re: most efficient, MODIFY / UPDATE?

Former Member — Tue, 16 Oct 2007 08:53:17 GMT

loop

Modify along with TRANSPORTING option

endloop

Regards,

Arun

Re: most efficient, MODIFY / UPDATE?

Former Member — Tue, 16 Oct 2007 08:54:47 GMT

Hi,

To modify a single field for all the entries in the table try this,

UPDATE dbtab set field = space.

Reward if useful.

Thanks,

Muthu.

Re: most efficient, MODIFY / UPDATE?

Former Member — Tue, 16 Oct 2007 08:55:21 GMT

I need to modify EANL (database table)

Re: most efficient, MODIFY / UPDATE?

piyush_mathur — Tue, 16 Oct 2007 08:56:06 GMT

Hi Adible

loop on table

Modify table with TRANSPORTING field name

endloop

Piyush

Re: most efficient, MODIFY / UPDATE?

Former Member — Tue, 16 Oct 2007 08:59:25 GMT

Update EANL set <field name> = <value> [where <condn>].

where condition is optional....

Re: most efficient, MODIFY / UPDATE?

Former Member — Tue, 16 Oct 2007 09:04:00 GMT

Hi,

isn't possible to use tcode EL59?

I think it's better to modify a sap-table via BDC, TCODE, BAPI etc.

as via abap.

Regards, Dieter

Re: most efficient, MODIFY / UPDATE?

Former Member — Tue, 16 Oct 2007 09:04:04 GMT

Hi,

To empty the contents of the particular field name use this logic.

LOOP AT ITAB.

CLEAR ITAB-'give fieldname here' .

MODIFY ITAB TRANSPORTING 'give fieldname here' .

ENDLOOP.

Pls reward me points if it is useful.

Thanks & Regards,

D. Ramya.