topic Re: Changes in tables in Application Development and Automation Discussions

Changes in tables

Former Member — Fri, 15 May 2009 09:19:18 GMT

Hi all,

I need to notify a non-SAP system of every change made in some customizing and master data SAP tables. The system must be notified on-line as soon as the change is saved (without XI). Any ideas?

Thanks

Re: Changes in tables

Former Member — Fri, 15 May 2009 12:52:26 GMT

Yes its possbile. For standard check if there is any Change Document Object Defined. For Custom you will have to define the Change document thru SCDO Tcode.

Once the change documents are generated You need to create the change pointer tables thru BD52 transaction, again for Custom table you will have to write change pointers manually by Using Change pointer function modules like CHANGE_POINTERS_CREATE, Then schedule the RBDMIDOC to create the IDOC from change pointers.

Refer [this|https://help.sap.com/saphelp_nwmobile71/helpdata/en/2a/fa018f493111d182b70000e829fbfe/content.htm] for more information.

There are significant efforts achiving it all.

Regards

Shital

Re: Changes in tables

Former Member — Fri, 15 May 2009 13:08:06 GMT

Hi..

Also explore using the table maintenance events like AFTER_SAVE , BEFORE_SAVE etc by creating custom views..

Re: Changes in tables

Former Member — Fri, 15 May 2009 14:54:07 GMT

Hi!

It depends on how these tables are maintained. If it is SM30 see tip above. If it is using "real" transactions consider finding a BAdI or User Exit or Enhancement Point to implement your notifications. Worst case you could think about a modification.

Change pointers as outlined above can also be used but I think you will spend much more effort on implementing this variant. And for SM30/SM31 maintenance you can forget this alternative.

Regards,

Volker

Re: Changes in tables

Former Member — Sun, 17 May 2009 15:49:53 GMT

Hi,

Where can I explore these events?

Thanks

Re: Changes in tables

Former Member — Sun, 17 May 2009 15:57:55 GMT

Refer https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8129f164-0a01-0010-2a8e-8765287250fc.

Re: Changes in tables

Former Member — Sun, 17 May 2009 16:24:52 GMT

Thanks,

BUT, what can I do if the event already exists in a standard manner? I need a specific event (AFTER_SAVE 02 ) so if the event has been created for the table I need I can not create a new entry for my code.

Re: Changes in tables

Former Member — Sun, 17 May 2009 17:10:56 GMT

As per 3rd screen of the document you have to specify the FORM name for 02 i.e. save and write code there to write change pointers.

Re: Changes in tables

Former Member — Sun, 17 May 2009 17:17:43 GMT

Hi Shital,

it is not possible to save and create your own form for an event that already exists.

Re: Changes in tables

Former Member — Sun, 17 May 2009 18:12:47 GMT

Hi Shital,

Can you please give me more detials on SCDO. I have created a change doc object. Everything I will beed to do is custom.

What are the rest of the steps I need to preform?

I will I know the IDOC structure?

Re: Changes in tables

Former Member — Sun, 17 May 2009 19:31:55 GMT

get some info:

http://sample-code-abap.blogspot.com/2008/02/applying-change-document-technique-on.html

https://www.sdn.sap.com/irj/scn/wiki?path=/display/abap/change+document

thanq