topic Re: modify database table in Application Development and Automation Discussions

modify database table

Former Member — Wed, 31 Oct 2007 09:06:28 GMT

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

Re: modify database table

Former Member — Wed, 31 Oct 2007 09:13:31 GMT

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

Re: modify database table

Former Member — Wed, 31 Oct 2007 09:15:34 GMT

also no need of endselect

Re: modify database table

Former Member — Wed, 31 Oct 2007 10:57:05 GMT

no not working

Re: modify database table

former_member404244 — Wed, 31 Oct 2007 11:03:04 GMT

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