modify database table

[Former Member]

my code updates a database table zbh_test but only 1 entry ie, the 4th record

i want all the entries of my internal table, only the header data is getting updated

types:begin of str,

mandt type vbak-mandt,

vbeln type vbak-vbeln,

erdat type vbak-erdat,

user type sy-uname,

end of str.

data:itab type table of str with header line.

data:wa_itab type str.

start-of-selection.

select mandt vbeln erdat from vbak into table itab package size 10.

endselect.

loop at itab.

itab-user = 'bhanum'.

modify itab.

endloop.

modify zbh_test from table itab.

commit work.

please let me know

[Former Member]

Hi Bhanu,

do like this

types:begin of str,
mandt type vbak-mandt,
vbeln type vbak-vbeln,
erdat type vbak-erdat,
user type sy-uname,
end of str.

data:itab type table of str.
data:wa_itab type str.

start-of-selection.
select mandt vbeln erdat from vbak into table itab package size 10.
endselect.



loop at itab into wa.
wa-user = 'bhanum'.
modify itab from wa.
endloop.

modify zbh_test from table itab.
commit work.

<b>Reward Points if it helps,</b>

Satish

[Former Member]

no not working

[Former Member]

also no need of endselect

[former_member404244]

Hi,

change ur code..

start-of-selection.

select mandt vbeln erdat from vbak into corresponding fields of table itab package size 10.

loop at itab into wa_itab.

wa_itab-user = 'bhanum'.

modify itab from wa_itab.

clear wa_itab.

endloop.

modify zbh_test from table itab.

if sy-subrc eq 0.

commit work.

endif.

Rewrad if helpful.

Regards,

Nagaraj