How do I get the IT0105 subtypes on a single line in my SAP Query output?

[Former Member]

For instance, if i select Email and System Username I get two lines per employee in the output. How can I get this on one?

I have been googling, and have found certain suggestions that I have explored without succes. One suggestion I tried out was creating local fields, but although I was able to create working local fields, the output remains the same.

I have also seen comments saying that it simply isn't possible. Is this true?

Anyone here able to help? Mind you, I am not an ABAP programmer, so I am looking for a solution using the standard Query transactions.

[former_member186049]

You need to create custom additional fieldS in the Infoset which requires ABAP programming and access to ABAP.

Refer to page 241 at the link here:

https://www.consolut.com/fileadmin/Medien/PDF/SAP_PrintDoku/en/BCSRVQUE/BCSRVQUE.PDF

Most likely you don't have this in the Production system, but you should be able to get your developers to do this for you.

In my organization we have done this many infotypes, including from both Date Specifications and Communications.

Here is a sample of the ABAP code to return system user name on one line:

data: LOC_SY-UNAME like pa0105-usrid.
CLEAR SYUNAME.
CLEAR LOC_SY-UNAME.
SELECT SINGLE USRID INTO LOC_SY-UNAME FROM PA0105 WHERE PERNR = P0105-PERNR AND ENDDA >= SY-DATUM AND BEGDA <= SY-DATUM AND SUBTY = '0001'.
IF SY-SUBRC = 0. SYUNAME = LOC_SY-UNAME.
ENDIF.