Items no data

[kedalenechong]

Hi All

How is it possible to shortlist all Item Codes that have been created yet without any historical transactions?

Kedalene

[gergely_tyukos]

Hello kedalene.chong,

Please kindly attach screenshots about the case for better understanding.

Thank you.

Best Regards,

Gergely Tyukos

SAP Support

[Johan_H · Accepted solution]

Hi Kedalene,

Please give this query a try:

SELECT i.ItemCode, i.ItemName
FROM OITM i
WHERE 
i.ItemCode NOT IN (select distinct ItemCode from ADO1 where isnull(ItemCode, '') <> '') 
AND
i.ItemCode NOT IN (select distinct ItemCode from ADO9 where isnull(ItemCode, '') <> '')

(I think) ADO1 contains sales document rows and ADO9 contains purchase document rows. There may be other ADO tables for other transaction types.

Regards,

Johan

[kedalenechong]

Hi Johan

seems correct, thanks!