How sale order change log tables are updated.
for example, I've an order number 1002.
I'm supposed to produce a change log statement to management every day.
but when i queried ado1 and adoc tables to know the changes made to the order for 25 - sep - 2012 then I got 495 rows.
I'm joining adoc and ado1 tables on docentry and objtype.
In where condition I've passed adoc.updatedate = '09/25/2012'
Can anyone please tell me how SAP maintains log ?