Production Order Change Log Query

[Former Member]

Hello All,

Im looking for a way if it is possible to write a query that will access the change log of a production order. The reason that I am looking to do this is to see production orders that have had their due date changed one or more times, and to compare this against the OITM,LeadTime.

Thanks in advance

[former_member186095 · Accepted solution]

Hi,

In SAP B1 2007A SP01 PL10, there is a change log. You can check all the differences made by user in the pass in the change log.

the table is AWOR. The product no. is taken from OITM. You can use both table in order to find out the comparison

JimM

[Former Member · Accepted solution]

Thanks AWOR is what i was looking for.

[Former Member]

Hi,

I don't see any Production Order Change Log tables in our database, do you?

Thanks,

Gordon