custom report

Hi Experts,

Could you please share to me the custom report of inventory audit report generated using SQL query.

The report is expected simialr with inventory audit report. In the query, we need that the item group is also displayed.

I see that I can not display the item group name in the SBO std inventory audit report. We use SAP B1 2007A SP01 PL10. Please help me. Thanks

John Ed