I am trying to create an HR Ad Hoc Query and one of the fields that I am trying to output is System User Name from infotype 0105 Communications. If I choose this field and do not choose the Communication Type, I get two records per employee - one record with the System User Name populated and one record with a blank value for System User Name.
If I choose the System User Name field for output and also make a selection on Communication Type (= subtype 0001), employees with no System User Name (i.e. no Infotype 0105, subtype 0001) are eliminated from the report.
I want the report to show all selected employees, including those without a System User Name; however, I do not want the same employee to appear on the report twice.
Has anyone else experience this problem? If so, have you figured out how to eliminate the extraneous record for each employee when you do not select the Communication Type?
Thanks in advance.