How to capture changes in key column values..?

[arunneerolil]

Hi All,

I want to capture the changes in key column values in a table and extract the changed values/records on the fly and sent it across to other system using a interface.

• My query here is how to capture the changes in the values on the fly(as an when it happends) and capture that values..

Please give your inputs..

I was searching the SDN and other resources and came across Field EXITS and BTEs..Not sure if they are of any help..

Please clarify this aswell..

Rgds,

Chem

[arunneerolil]

Hi All,

I want to capture the changes in key column values in a table and extract the changed values/records on the fly and sent it across to other system using a interface.

• My query here is how to capture the changes in the values on the fly(as an when it happends) and capture that values..

Please give your inputs..

I was searching the SDN and other resources and came across Field EXITS and BTEs..Not sure if they are of any help..

Please clarify this aswell..

Rgds,

Chem

[Former Member]

Hi,

The key fields in a table are non-editable. Do you mean creating new entries?

If so, you can use Change pointers for getting the changes made in a table. Search on this name, there are lots of threads!!!

Thanks and Regards,

Lakshmi.

[arunneerolil]

Hi Lakshmi,

Hmm its not a key filed in SAP but this is some field/fields that is used to send the data to the interface..More of interface oriented requirement.

It shud capture both New records(insert) aswell as changes to the existing records dynamically..

More precisely, when ever this event occurs on the table PA0000 we have a call a web-service to sent the data to other system.

Please advice.

Regards,

Chem

[Former Member]

Hi Chem,

You can try the BADI HRPAD00INFTY. This BADI is called for all Infotype changes in PA30. This should also be triggered for any changes in PA0000. There are 3 methods available. BEFORE_OUTPUT, AFTER_INPUT, IN_UPDATE.

BEFORE_OUTPUT will be called before any changes are made, IN_UPDATE will be called after changes are saved.

I think you can make use of this method to trigger the web service.

Thanks and Regards,

Lakshmi.

[Former Member]

Hi,

There is option to log the data changes in a table, while creating the table, in the technical settings, check the Log data changes checkbox at the end that will record all the data changes ie update and delete happens for that table.

The log information can be viewed in transaction SCU3.

Thanks,

Muthu.