Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 13, 2016 at 05:56 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded