Deletion log

[bizewski]

Good morning, everyone, how are you?

I’m building a data mesh with my SAP data, and I ran into an issue.

As a strategy, I used Kafka to collect my inserts and updates in real time. After that, the data is sent to BigQuery.

I had a case where a user created a purchase order with 5 lines, but the next day she deleted 4 of them.

Is there any type of record that shows me the deleted lines?

How does SAP B1 build the SELECT statement for the modification logs? Because in the system, I can see when a line was removed.

Thank you for your help.
Best regards,

[mgregur]

Hi,

SAP Business One uses log tables for previous instances of a document. It uses ADOC for header data and ADO1, ADO2 etc. for underlying tables. Note that you need to differentiate between documents by using ObjType.

BR,

Matija