Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from LCC352 on May 11 at 10:52 AM In my answer, I am assuming you want both pieces of information, otherwise, Jagan is correct - limit your selection to subtype and you're done. Although I'm not familiar wit IT0105, it certainly sounds like the table has at least two keys, PERNR and the subtype you mention. Since you're not limiting the subtype, the query yields 2 records. Although you can collapse the 2 records into 1, it can't be done in a simple ad hoc query. This would require code to accomplish. The other alternative is to download your result into Excel and use a pivot table to "flatten" the records. Use PERNR as the "rows" and the subtype as the "columns". Use the value associated with the subtype as the "values" in the pivot. Use "first" for the values in the pivot or else Excel will use "count" as the default. It all depends on whether this is truly ad hoc, or, if it's a typical ad hoc request that becomes a normal daily report. Lou
| | | ---------------Original Message--------------- From: nvpsrinivas Sent: Monday, May 11, 2015 8:04 AM Subject: Adhoc Query for IT0105 Hello I have a question related Adhoc query. While querying IT0105, for each of the subtype of IT0105 a separate line item is being generated. Where in we wanted only one line item for each employee. I mean, for each employee (PERNR) if the output selected is Email(stored in subtype 0010) and System User ID(0001) then the output is generated with 2 line items for that employee. How can I achieve to have a single line item for each PERNR for all the subtypes of IT0105? Can we achieve this? Please guide, NVP Srinivas | | Reply to this email to post your response. __.____._ | _.____.__ |