Skip to Content
0
Feb 17, 2006 at 09:27 AM

How to update one column of a Z-table from an internal table

1557 Views

Hi,

Is it possible to update one column of a Z-table from the values found in an internal table, WITHOUT looping through the internal table and using update set values .. where...

For performance reasons, i would like to use:

update ztable from itab.

Problem with that, is that all columns are adjusted.

example:

my ztable has 3 columns & the following entries:

column1(key) column2 column3

A 1 0

B 2 0

C 3 0

my internal table contains the following

column1 column3

A X

C Z

result should be

column1(key) column2 column3

A 1 X

B 2 0

C 3 Z

Thx in advance for your help,

i will reward points