Skip to Content
Jan 22, 2019 at 05:45 AM

SQ02: Functional Location - Maintenance Item Query

241 Views Last edit Jan 21, 2019 at 09:26 PM 2 rev

Hi Gurus,

I am hoping this can be done through Ad-Hoc, as I do not have access to write any ABAP.

I am trying to a list of all Functional Locations, regardless of if the following criteria are met. If that Functional Location appears in either a) an Object List that is attached to a Maintenance Item or b) the Functional Location field of the Maintenance Item, then I would like to be able to identify that.

In Plain English, I would like to identify which Functional Locations are on a Maintenance Item; whether that's in the Functional Location Field of the Item or the Object List that's attached to the item, from a full list of FLs. The problem is, in my attempts, I've ended up with Object Lists that appear to be associated with Maintenance Items that they're not attached to. That is, there will be multiple lines containing the same Maintenance Item Number, with different Object List Numbers.

I have tried creating joins of many combinations between IFLOT - OBJK - MPOS, but I typically end up with a reduced Functional Location List.

I guess my main question is - is this possible in SQ02? And if so, I would like to understand the logic of the solution, as I've been missing the mark repeatedly. Any help would be greatly appreciated.