What's new in Customer Journeys?

Connect and learn more! ×
Which table stores material transaction history of a work order? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Which table stores material transaction history of a work order?

Accepted answer
320
Views
2
Comments

Summary:

Which table stores material transaction history of a work order?

Content (required):

Hi, there! I'm building a report to get material transaction history because it's not possible to download the data through standard Review Production Transaction History standard task due to large volume of data queried (Already, did a question here).

Digging into documentation, found WIE_MATERIAL_TRANSACTIONS_INT table. For testing purposes, I did the query using a work order number and found no data; however, I did same consultation using PTH standard task and got data.

As this table ends in suffix _INT, I assumed this is used as an interface table which data could be purged at any time, but I'm not really sure about this. Test show me I can't use that table, but don't know which table I can use.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!