How do you retrieve an PM equipment using a linked FI asset number? (ABAP)

[oppenheim_jm]

More specifically...How do you retrieve an PM equipment using a linked FI asset number QUICKLY?

If I use ILOA/ITOB tables or V_EQUI view, the select statement takes upwards of two minutes.

Using the front-end (transaction code IE03) it takes less than a second to retrieve the equipment if specify the asset number.

Therefore, how can I retrieve an equipment number linked to an asset using a similar method to the front-end (IE03) to return the value quickly?

[raymond_giuseppi · Accepted solution]

Did you try to execute a trace of the IE03 transaction execution (ST12 ot ST05) you should easily find the view used in the standard transaction (check selection in its definition) 😉

[raymond_giuseppi · Accepted solution]

or just look at view M_EQUIA...

[oppenheim_jm · Accepted solution]

Thank you @Raymond_GIUSEPPI.

[oppenheim_jm · Accepted solution]

ST05 is exactly what I was looking for...and you are correct, it identified a select from M_EQUIA.