Application Development and Automation 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: 
Read only

T000 table updates mail

Former Member
0 Likes
1,208

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!

1 ACCEPTED SOLUTION
Read only

ThomasZloch
Active Contributor
0 Likes
832

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

2 REPLIES 2
Read only

former_member206396
Active Participant
0 Likes
832

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

Read only

ThomasZloch
Active Contributor
0 Likes
833

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