11-11-2013 9:21 AM
Hi Experts,
In table maintenance view, we can add new data, delete old data or modify existing data. We can maintain the change log in header table CDHDR and item table CDPOS.
Is there any way to get to know the update indicator (CDPOS-CHNGIND, Change type (U, I, E, D)) dynamically if we write any code in table maintenance event like 02?
Because I need to use 02 event for TMG. From this event I want to maintain the change log. In this event I want to know the update indicator( U,I,E,D).
Any possible solution would be gratefully accepted.
Thanks & Regards,
Arindam Samanta.
11-11-2013 9:36 AM
Hi,
If I had understood your question properly, you want to know the change indicator before its being updated in CDPOS table right?
In that case, you could fetch value_old from CDPOS and compare with your current value.
You will come to know whether it is a insert / delete / update operation.
Best Regards,
Abirami
11-11-2013 9:48 AM
Please put a break point and check these two internal tables EXTRACT and TOTAL. Extrack will have the indicator for you which line is changed.
Nabheet
11-11-2013 2:58 PM
Hi Nabheet,
I checked these two tables. Both have the same value. How to get the old value in this situation?
I tried one select statement to get old value from Database table. But here also I did not get old value.
Thanks & Regards,
Arindam Samanta.
11-11-2013 3:06 PM
Actually you are checking after the data is saved in database event. What ypu can do is use thw before save event and call your change document stuff in update task to make sure they are written if data is saved actually