Device and current installation's table

[former_member230043]

Hi Expert,

I have some queries below

1 - Which table should refer for MSN and current installation its attached with.

2 - Which table should refer for MRU and Portion assigned to it.

If there is no one individual table please explain the method to find it.

Thanks

Veer

[ivor_martin · Accepted solution]

Hi,

EANLH gives you the MRU for a given Installation.

TE422 will map the Portion to the MRU.

For Device to Installation linkage, check EASTL, EGERH and EGERS. You will need the Logical Device number to find the Equipment number of the Meter.

I hope this helps.

Regards,

Ivor Martin

[former_member230043]

Hi Ivor,

Thanks for your prompt reply ,

I have some more queries.

Is there any table which stores MSN no of device?

I have tried to fatch the report using sq01,02,03, is there other easy way for this.

Onc again

Thanks

Veer

[ivor_martin]

Hi,

The Manufacturer Serial Number is stored in table EQUI.

Try using SQVI (Quick Viewer) and use Table Joins (if you have access to the tcode).

You will have to join EASTL to EGERH and then EGERH to EQUI.

I hope this helps.

Regards,

Ivor