Query for finding all items that have no transactions

[Former Member]

Hello,

I tried looking to see if this has been posted before but I had no luck.

Basically, I want to be able to generate a list of all of my inventory items that have never had a transaction in SAP (so I can clean them out). I just want to see if someone already has something similar to this or knows of a quick way to do this.

Any help on this is very much appreciated.

Brent McDonell

[Former Member · Accepted solution]

Try this one:

Select t1.itemcode, t1.itemname, t1.onhand

from dbo.oitm t1

where t1.itemcode not in (select distinct t0.itemcode from dbo.oinm t0

group by t0.itemcode) and t1.InvntItem = 'Y'

Thanks,

Gordon

[Former Member · Accepted solution]

Hi Gordon,

This looks like it worked. Thank you for your prompt response and help with this.

Have a good day,

Brent