Trace SQL Database Table New Postings

[kenan_jaddeny]

Hi Community,

we want to detect the changes made on a sql database in a specific moment,

i.e. run a query after a journal entry posting is done, will result in changes on the following tables;

OJDT, JDT1, AJDT, ..

any ideas?

Regards,

[kothandaraman_nagarajan]

There is no such option from SSMS to get a list of table that affecting posting. For example, for simple case, if we update item name in item master data, the following tables are affected,

1. OITM

2. OBTN

3.OSRN

4. ITM1

5. ITM2 etc...

[kothandaraman_nagarajan]

In general for marketing documents the history log is added under ADOC,ADO1 tables.

For Business Parnter- ACRD

For Item master data- AITM etc..

[kenan_jaddeny]

Dear Nagarajan,

Thanks for your responses,

but as I clarified in my question, I want to get a list of tables that had changes without the need to investigate them manually one by one, or the need to save their names by heart,

what we need is, go to SAP B1 do some postings, then the SSMS should provide me a list with the tables that got affected by this posting,

Hope this made it clear,

[kothandaraman_nagarajan]

Give me an example.

[kenan_jaddeny]

As I clarified in my question, show the changes by table; OCRD, OCHO, ..

[kothandaraman_nagarajan]

Hi,

You can trace the posting by running SQL profiler from SQL server management studio.

Regards,

Nagarajan

[kenan_jaddeny]

I’m not able to get the changes per table