Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from LCC352 on May 14 at 8:25 PM John - that might work if a statistic is used, but it won't work for a normal query. Since only one field would be filled for each row, you would still get two rows - one with a value for the first subtype, and another for the second. In each row, the subtype that didn't appear will be blank. 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. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today. _.____.__ |