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
Showing results for 
Search instead for 
Did you mean: 

How do I create a report to display counts of equipment by portion?

0 Kudos
258

I need to create a report to show ISU equipment types by portion?

1 REPLY 1

NTeunckens
Active Contributor
0 Kudos
145

See if the Standard Transactions "EL41" or "EL43" provide a good alternative.

If you have to do the Development, you could link tables "EANL" "EANLH" "EASTL" "EGERR", as you would join the IS-U Installations (and the MeterReadingUnit) through LOGIKNR-Field with the Equipment Tables. The IS-U Config Table "TE422" holds both Portion (PORTION) and MRU (TERMSCHL).

Please see the linked PDF for some of the main ISU-Tables (link) that will help you in developing the Query ...
Keep it as a local Document for future Developments ...
It really is a Key-Resource for Development / Querying in IS-U.

On a side Note :

If you need the amount of EquipmentTypes, this doesn't sound like a report that is very 'Transactional'. So either you need more data than "just" the number of EquipmentTypes <X-Y-Z>, or I would consider this as a report to be developed as part of a BW-Effort on Assets rather than an 'Operational' report ...


Hope this helps

Nic T.