2020 Jan 03 12:00 AM
2020 Jan 03 8:35 PM
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.