2008 Dec 04 11:23 AM
hi all,
the client has come up with a new requirement.
He wants to receive a mail on his outlook (company id) whenever there are changes in the values of table T000.
Since table T000 is very critical (Client management), the changes in this table are not desired frequently. Also changes in this table can be fatal to entire system. Though very few people have authorization to change values in this table, client wants a mail to be triggered whenever there is a change in this table. so, he wants to develop ABAP utility that will trigger mail to his office id as soon as there is a change in values of the table.
i have very less experience in ABAP, but i could come up with following ideas:
***************************************************
1. As there table is being logged, i guess the entries must be being monitored through CDPOS/CDHDR... but i dont know exactly how these 2 tables work with each other.. would be great if u could provide some documentation and how to go about the same.
2. i heard there is some concept called change pointer in idocs, but i dont know how exactly it works.. please guide me if above requirement can be done using the same.
3. is there anything possible using workflows? i dont have any idea about workflows.. please guide, client wants mail on his email id and not in SAP Business workplace.
***************************************************
Really appreciate if you could throw light on any of the above option.
thanks in advance!
2008 Dec 04 11:48 AM
Changes to table T000 are being logged in DBTABLOG, not in CDHDR/CDPOS. You can quickly access the entries for "T000" since there is a secondary index for that field.
A rather easy solution would be to poll the new entries in DBTABLOG e.g. daily (either by custom program or by RSVTPROT) and send an appropriate email.
How to send an email -> there is probably 100 threads on this topic...
Thomas
Changes to table T000 are being logged in DBTABLOG, not in CDHDR/CDPOS. You can quickly access the entries for "T000" since there is a secondary index for that field.
A rather easy solution would be to poll the new entries in DBTABLOG e.g. daily (either by custom program or by RSVTPROT) and send an appropriate email.
How to send an email -> there is probably 100 threads on this topic...
Thomas
2008 Dec 04 11:37 AM
Chinmay,
Check the following:
check the table CDHDR, Generally OBJECTCLAS field contains table name if there is change in table...
***Not applicable to all cases, but in somecases table name wil be stored in this field.
And you can also use fields -> utime, udate, username
And if CHANGE_IND = 'U' change
= 'I' Insert
= 'D' Deletion
Please check once, may helpful to you.
Ram
2008 Dec 04 11:48 AM
Changes to table T000 are being logged in DBTABLOG, not in CDHDR/CDPOS. You can quickly access the entries for "T000" since there is a secondary index for that field.
A rather easy solution would be to poll the new entries in DBTABLOG e.g. daily (either by custom program or by RSVTPROT) and send an appropriate email.
How to send an email -> there is probably 100 threads on this topic...
Thomas
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |