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: 

Count Number of Devices on Functional Location

Former Member

‎2011 Feb 02 9:24 AM

0 Kudos
221

Hello Experts,

Can you please help let me know how can I count the number of Devices on a Functional Location.

I need the count of Active devices for a particular year. I can get it from the IL03 but I need to write a code to count this.

Thanks in advance.

Regards,

Pratap Sone

4 REPLIES 4

friedrich_keller
Contributor

‎2011 Feb 02 9:47 AM

0 Kudos
189

Hello Pratap,

you may want to use the EGERH table. There you will find the fields AB (from), BIS (to), EQUNR and DEVLOC (device location) in addition to the EINBDAT (installation date) and AUSBDAT (removal date) fields.

Cheers,

Fritz

Former Member
In response to friedrich_keller

‎2011 Feb 02 9:59 AM

0 Kudos
189

To be precise these are the back flow Preventive devices and the functional locations are Cross Connection Functional locations.

friedrich_keller
Contributor
In response to friedrich_keller

‎2011 Feb 02 10:09 AM

0 Kudos
189

Hello Pratap,

Please clarify whether you speak of equipments or IS-U devices.

Cheers,

Fritz

Former Member
In response to friedrich_keller

‎2011 Feb 02 10:53 AM

0 Kudos
189

Hello Fritz,

For this particular case I am talking about PM Devices that are created through IE01.

Regards,

Pratap Sone