Change Log- Is there a way to run reports based on the change log?

[Former Member]

Hello experts,

I would like to run reports or queries withe the change log.

I know the table is ADOC. But can you get the instances there? or the changes?

Please advise

[Former Member · Accepted solution]

There are no specific reports that I know of native to SAPB1. However, if you are technical and know SQL, you can use the ADOC Table and its related tables of ADO1, ADO2... ADO14 to create your own reports.

Randy Davis

Denver, CO

[Former Member · Accepted solution]

Hello Randy,

Thank you fo your information.

I thought it was only one table ADOC.

How the child tables work? are they per object type?

Thanks

[Former Member · Accepted solution]

Hi,

You are partially right.

ADOC table is a huge table including all marketing documents history. Unlike other "O" tables, ADOC and its child tables covers more than one object type. You may search the forum to find some of the existing query that includes this table.

Thanks,

Gordon

[Former Member · Accepted solution]

Hello Gordon,

I don't understand very well how this works.

Is there any documentation regarding how ADOC an its child tables work?.

I want to track changes of the Sales Quotation. So I entered Select (all fields) FROM ADOC to Where T0.ObjType = '23'.

But i don't see the instances......per document..

Do I need to link it with another table? and how do I know with which one?

Thank you

[Former Member · Accepted solution]

Try this and select some field to check:

SELECT T0.Loginstanc,* FROM ADOC T0

INNER JOIN ADO1 T1 ON T0.DocEntry=T1.DocEntry

Where T0.ObjType = '23' AND T0.DocDate > [%0\]

[Former Member · Accepted solution]

OK. Il try. Thank you!

[nikunjmehta2290 · Accepted solution]

I have similar issue. Do you have found the solution?