Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

identify the changed rows in std sap tables

Former Member
0 Kudos
369

Hi All, I have a requirement wherein we are required to pick the changed data records from std SAP tables. These needs to be picked up by Informatica( no SAP enhancments like IDOCS etc), hence, need to find ways to identify rows which have been changed in these tables. Please share your views on this requirement. All suggestions are welcomed. Please let me know if you need more clarifications.

an e.g. - we have a field 'Changed On' in EKPO which can be used(i suppose) to check if the field is changed, but there is no such field in EKKO, so how to proceed in such cases.

PS: CDHDR and CDPOS is an option but due to the large no of entries in these tables, we are keeping this option on hold.

TIA.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
273

Hi Deepak,

I hope SAP note # 395569, which you can find on the SAP Service Marketplace answers you questions.

Thanks and Regards.

5 REPLIES 5

former_member213851
Active Contributor
0 Kudos
273

Hi Deepak,

You may refer below link:

http://wiki.sdn.sap.com/wiki/display/ABAP/ABAP+-+Data+Change+Tracker+for+Custom+Tables

Or

You may write code to notify the table field changes using Events.

This code will trigger mail with details such as Original Field contens , Updated field contents,

Date  -Time and User name and terminal from whrere changes are being done.

This method can be used for Critical tables like T000 (Clients).

For that go to Table Mainntnace Generator.

On Menu path : Environment->Modifications ->Event

Click New Entries

Now select Event from (02 and 05 ) and write the code inside Editor for above Logic.

For trggering mail for Alert Notification, you may use FM so_document_send_api1 or cl_document_bcs .

Best Regards,

Sachin

0 Kudos
273

Hi Sachin, Thanks for your promopt reply. But, we are not doing any SAP enhancments/coding. So can not create such events.

0 Kudos
273

Hi Deepak,

Please follow the below link. Contents are somewhat related to your topic.

http://scn.sap.com/community/erp/blog/2012/02/13/change-documents-for-sap-objects

Thanks and Regards.

Rajender Patyal

raymond_giuseppi
Active Contributor
0 Kudos
273

- You could also look at Change Pointer (Master Data Distribution). (But if you don't want IDoc...)

- You could reduce CDHDR/CDPOS volume of data if you correctly identify objects (SCDO) and use a short date/time range.

Regards,

Raymond

Former Member
0 Kudos
274

Hi Deepak,

I hope SAP note # 395569, which you can find on the SAP Service Marketplace answers you questions.

Thanks and Regards.