topic Re: How to capture changes in key column values..? in Application Development and Automation Discussions

How to capture changes in key column values..?

arunneerolil — Mon, 19 May 2008 10:32:01 GMT

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

Re: How to capture changes in key column values..?

Former Member — Mon, 19 May 2008 10:34:44 GMT

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.

Re: How to capture changes in key column values..?

arunneerolil — Mon, 19 May 2008 11:02:56 GMT

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

Re: How to capture changes in key column values..?

Former Member — Mon, 19 May 2008 11:17:31 GMT

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.

Re: How to capture changes in key column values..?

Former Member — Mon, 19 May 2008 12:16:52 GMT

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.