Adding MANDT to a Field Group / Outer Join

[Former Member]

In order to facilitate an "Outer Join" (don't ask), I'd like to add the "client" field MANDT to a Field Group. I have not been able to do so. Anyone know how to overcome this?

I'm writing to query to ID all users IDs that do not have the AQW parameter and trying to do an outer join. But because there are many entries in USR05 for each user and I need to specify a "Selection Option" on Parameter ID, I cannot get the infoset / query to work. I was thinking if I ask to display USR05-MANDT, that users without an AQW paramater would show up in the query result with no USR05-MANDT value.

[Former Member]

How about a sub-query instead?

Rob

[Former Member]

What is a sub-query? This is ABAP Query.

[Sandra_Rossi]

did you use "CLIENT SPECIFIED" in the SELECT ?

[Former Member]

This is ABAP Query (using standard Joins in the InfoSet). How does "did you use "CLIENT SPECIFIED" in the SELECT" apply?

[Sandra_Rossi]

sorry, I didn't read well your question