Query from master data

[Former Member]

I am trying to create a structure to create a query as follows from 0EMPLOYEE master data. I have ceated a BI infoset with 0EMPLOYEE and using that to create this query. This query is intened to be used as the receiver query in RRI.

Sender Query (query1):

Employee Distribution by perfromace rating

Performance Rating Before_Min Below Above Total

*********************************************************************

Receiver Query (query2) : this should feed the employees used in query1 and get their attributes in a query

Employee Last_Name First_Name, Annual_Salary

A

B

....

Qns:

1, What is the best approach to get this?

2. How do I create a characteristic query for Employee (without key figures) as in qurey-2

Amy help is apprecaiated.

Thanks in advance

[Former Member]

All you have to do is create an InfoSet query to get the desired data from your 0EMPLOYEE InfoSet. Key figures are not required. The only trick here is to be sure you turn off the Zero Suppression in the query properties screen. Otherwise, you will get no data.

Lastly, set-up this query as your jump target in transaction RSBBS.

Hope this helps...

Bob

[Former Member]

Hi Bob,

Thanks for your message. I got the receiver query working by configuring the infoobject as a infoprovider and getting "# of records" as the dummy KF into the query and hide it. I need to clean up to supress results reow.

For connectign to this query as RRI, in the assignment details, do I use it as an Infoobject - parameter for 0EMPLOYEE or any other setting. I used the above settings and see more employees in the list than I had expected. i don't see the employee ids being passed on from Q1 to Q2 to provide a reduced result set when I limit the scope in q1 (eg: by filtering using the org unit or personnel area).

Any clues?

Thanks

Raj

[Former Member]

It depends on whether or not you are using the same InfoObjects in the sender and receiver. If so, it will "automatically" match them up. If not, you should map them on the Assignment Details screen to indicate which ones go together (e.g. 'Company Code' to 'Sales Org').

It may also have something to do with whether or not you are drilling down and/or filtering by 0EMPLOYEE (and/or 0SALESORG?) in the sender query. I have seen results similar to yours that I could not explain, but never have gotten around to investigating.

Hope this helps...

Bob