Thank you for the inquiry DMKM,

This forum presumes you have Sage Enterprise Intelligence as your reporting solution? 

One approach to finding the tables you need is to trace the data selected for a single work order when using the WIP Cost Inquiry function, within Sage X3 ERP.  This function will provide variance information. Personally, I prefer SQL Profiler trace as the 'OpenLog' trace will provide 4GL queries without the actual variables used in the queries. Then, since I know the value displayed for the variance on the screen, I can search this value in the profiler trace. This should provide me the query used to pull the variance. There can be more than one of the same value, so there is some interpretive work to be done.

If you want more direct assistance, the best resource is your Sage Business partner. If you just want assistance running the SQL Profiler trace, contact your local support team. Others in the community may provide additional input.

Note for building the SEI report: as with many data elements in Sage X3, there could be text translation to consider. Review the out of the box data models containing the ATEXTRA table links for useful references if needed.

There is a WIP valuation report in Sage X3 that will show you the variances BUT only after the work order has been finalized (how would it know for sure before that?)