synchronising field changes between two table

[Former Member]

Hi guys,

I have a requirement were i need to use a field from one table (tableA) to update a field on another table (tableB). Everytime the field changes on tableA it should immediately also change on tableB. How do i go about doing this?

thanks

[Former Member]

hi,

you will have to use update statement depending on the business logic and based on field 1 from table a ,when ever there is a change in this table which is reflected programatically or thru data updation,u will have to take this in separate program with update logic and can be linked to background job periodically.

or if table A is updated with some program ,within the same program u can include update statement for simultaneous change updation in table B.

reward if helps !!!!

[Former Member]

hi mukund, thanks for your help, i have attached the full details of the requirement. I think i will use an exit in T-Code "PRMS" to update the relevan field in the tableB. the problem is that this scenario will only work if the field in tableA only gets updated via one transaction(PRMS).

-

---

Kindly note that there is a requirement to write a program for Company code 500 which will be able to achieve the following:

To populate the field “Previous Account number (LFB1-ALTKN) in the Employee Vendor master data T-code FK02 with data in the Sub-area field (BTRTL) in T-code PRMS.

Furthermore, whenever there is a change in “Sub-area field (BTRTL)”, it should be able to automatically update the “Previous Account number (LFB1-ALTKN)” in the Employee Vendor master data with the change to enable up to date information which will be required by payroll when processing payment via the Automatic payment program in FI.

There is already a program RPRAPA00 which is working on the similar basis and so can be referred to it.

Please feel free to ask me for any further information.