topic Re: Updated Database Table in Application Development and Automation Discussions

Updated Database Table

Former Member — Sun, 13 Jun 2010 13:43:38 GMT

I am basically BW Consulatnat,

I wanted to updated some field in Standard Table, fro example

we have A B C D E F fields are their in our table

i wanted to updated data from B to D, A to F

but should not delete data from B and A ,

please some one provide me the code

Thanks,

GAL

jitendra_it — Sun, 13 Jun 2010 14:12:00 GMT

hi Gal,

suppose 'dbtab' is ur database table .

hope following code will help u.

data: itab type table of dbtab.

data: wa type dbtab.

select A B C D E F from dbtab into table itab.

loop at itab into wa.

wa-D = wa-B.

wa-F = wa-A.

modify itab from wa.

clear wa.

endloop.

modify dbtab from itab.

Former Member — Sun, 13 Jun 2010 19:20:49 GMT

Hi,

We are not supposed to do the direct table update for any standard table.

I don't know which is the case, but I think this can be done without any update in standard table.. (e.g. during extraction)

I suggest you ask in BW forum.. or explain in more details your problem

regards,

Paulo Carvalho

Former Member — Sun, 13 Jun 2010 20:02:24 GMT

Moderator message - Please do not ask or answer basic questions - thread locked Rob