I'm using v7.60.6 and I am exploring the possibility of adding the GL Account Number to the Sales History BIA report similarly to what is found in the Sales Order Lines BIE report.  In trying to determine whether or not this is possible I have looked at vdvSalesOrderLine as well as the SalesOrderLine object within SM --> Maintenance --> "Maintain Business Insights Views / Context Menus" to see what is being done there to include tglAccount.GLAccountNo.

In looking into this I noticed something that I had not noticed there before, and that is that the tglAccount table is listed in the "Permanent Table" column in the "MBIV/CM" tool, but that table is not found in the vdvSalesOrderLine SQL view.  I guess I am surprised to see that.  I would've thought that any table listed in the "MBIV/CM" tool would also be part of the corresponding SQL view, but that is obviously not the case.  Apparently database fields can be added in "MBIV/CM" regardless of whether or not they exist in the corresponding SQL view.  Any thoughts about this?

Does anyone here know if the GL Account Number can be added to the Sales History BIA report?

Thanks.