Change Log

[Former Member]

Hi,

In sap b1 change log process is there. suppose we made the changes in any document we can see the detail from change log. i need some doubt it is possible in sap? while i am installing the can i get the installation detail like date  and crystal report changes and again import into the sap that date and changes detail is it possible. what ever we changes in sap i need to get that detail is it possible ?? using SQL we get this detail???

[kothandaraman_nagarajan · Accepted solution]

Hi Ramesh Kannan,

I think it is not possible to create query for all changes that made in SAP business one.

For standard layout history in SAP, you can use RDOC table to view some useful information.

Thanks & Regards,

Nagarajan

[Former Member]

Hi,

If you only need Document change, it is highly possible by query ADOC/ADO1 table. Those tables include all document change history. But the installation detail may never be saved in any tables so that it is not possible to get them through SQL.

Thanks,

Gordon

[KennedyT21]

Hi Ramesh...

You required to check with the RDOC for the Report changes but where as other details you required to check with the History table which starts with the A...

Hope Helpful

Regards

Kennedy