most efficient, MODIFY / UPDATE?

[Former Member]

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.

[former_member223537]

Loop over it and modify.

Loop at itab.

MODIFY...

endloop.

[Former Member]

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

[Former Member]

Hi

loop

Modify along with TRANSPORTING option

endloop

Regards,

Arun

[Former Member]

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.

[Former Member]

I need to modify EANL (database table)

[piyush_mathur]

Hi Adible

loop on table

Modify table with TRANSPORTING field name

endloop

Piyush

[Former Member]

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

where condition is optional....

[Former Member]

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

[Former Member]

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.