SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Identify installations without devices

kvinkr
Participant

‎03-19-2010 12:07 PM

0 Kudos

Dear all,

Is there a way to list out installations which do not have any devices attached to them ?

With thanks & regards,

Vinodh

1 REPLY 1

Former Member

‎03-19-2010 3:47 PM

0 Kudos

Hello,

write a report (se38) or create a new sap-query (sq02 and sq01).

You need:

One left (leading) table for installation (example u201CENAL - Installationu201D or u201CEANLH - Install.Time Slice) and one right table for device or billing data (example u201CEASTS - Billing data: Installation Structure at Reg. Levelu201D or u201CEASTL - Billing data: Installation Structure at Device Levelu201D). Make a u201Cleft outer joinu201D.

When the right table is without a entry, you have found the installation you search.

I hope this answer can help you.

best regards