Skip to Content
0
Dec 30, 2010 at 05:08 AM

How to update key fields???

4172 Views

I have created a table ztable with fields field1,field2,field3,field4,field5,field6.

the key fields are field1,field2,field3,field4,field5.

Records in ztable:

FIELD1 FIELD2 FIELD3 FIELD4 FIELD5 FIELD6

1 2 3 4 5 6

1 2 3 5 6 7

now i want to modify 1st row with field4 = 9.

and second row with field 4 = 10.

Please suggest how can i update field4.

since field 4 is a key field new line are inserted .

FIELD1 FIELD2 FIELD3 FIELD4 FIELD5 FIELD6

1 2 3 4 5 6 ....................................old

1 2 3 5 6 7................................old

1 2 3 9 5 6..............................new

1 2 3 9 6 7.............................new

Could anyone help me with a soultion.

Regards,

Rachel

Edited by: Rachel@sap on Dec 30, 2010 6:10 AM