How to modify record in table 2 when updating a record in table 1 via SM30

[aris_hidalgo]

Hello experts,

I have a new requirement that whenever a user modifies a certain field(in this case, address field) and saved it, it would also update that particular record in table 2. Any help would be of great help to me.

Again, thank you guys and have a nice day!

[dani_mn]

Go and change the module pool program for the maintenance transaction of your table.

Save the table in PBO in an internal table and when user changes and press the save key. match the old with new one and if some modification is done change your second table according to it.

Regards,

Wasim Ahmed

[Former Member]

data: begin of itab.

address.

end of itab.

select address into table itab from zdbtab.

loop at itab.

update zdbtab2 set address = itab-addres where cond.

endloop.

[Former Member]

Hi viraylab,

1. For that u may have to use

table maintenance events,

and write abap code inside the routine.

regards,

amit m.

[aris_hidalgo]

Hi guys,

How will I know the particular record that the user modified? so that I will equate it to table 2 and modify it accordingly. Also, if its an event, what event is it?

Again, thanks guys for your time and take care!

[Former Member]

Hi again,

1. There are many events.

2. Then one which u can use will be

AFTER SAVE Event.

( the event code is 02)

3.

How will I know the particular record that the user modified

The CURRENT RECORD

is stored in EXTRACT.

3. U will h ave to use OFFSET to get the

primary key value of that table / or anything u want.

EG.

mykey = EXTRACT+3(10)

(BCOS 3 WILL BE MANDT FIELD

NEXT 10 EG WILL BE VBELN FIELD)

regards,

amit m.