Updated Database Table

[Former Member]

Hi

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]

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]

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]

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