In the technical settings for the table:
Check the check box for Log Data Changes.
1) Check the check-box for log changes option in technical settings for the table.
2) The table which has all the log data is DBTABLOG
Message was edited by: Ravi Kanth Talagana
there is a way.
keep a fild called 'VERSION' in ur ztable.
initially, whn a record a newly created the version will be 1.
each time an activity happens to tha record in the ztable,just increment the version.
so in the later stage, the highest version will be the recent record.
u can c the the chnges on looking the version.
hope u got an idea.
if helepd mark points
you have 2 options :
1) enable logging which requires 2 changes - tbale should be marked for logging and logging should be switched ON on server.
2) if your table is updated by your program only you can create new change document object, generate necessary function modules and then call function module to create change log document (cdhdr/cdpos tables), then you can use another FM to read/display this changelog.
You can find futher info on change documents by searching SAP help on "Change documents".
I would select option 2).
Hope this helps.
Do you want to achieve the same effect like PO's change log？
(I.E. Storing header data's change log in talbe CDHDR,
Storing items's change log in table CDPOS)
Implementing such requirement,the following two steps is necessary:
1,Data element'change log should be falged.
2,Go to tcode SCDO,Generating maintenance function module.
For further details,read these Reference Article :