Skip to Content

How to query two different BO and display the data in OWL

Hello Colleague,

In one of my requirement I need to query two different BO and display the data in OWL result screen . Using the standard OWL component i can bind query of only BO search query . I need to search first BO based on the some of search criteria and then query another BO with the result list obtained in first query and using remaining search parameter .

For example

In OWL screen we will have the following search parameter .

i First Name

ii Last Name

iii Relationship Attribute

When user enters all the search parameter and clicks "Go" the following logic should be executed.

i. Query Business Partner BO and get all contacts matching the First Name and Last Name criteria.

ii. Now query the second BO(custom one) passing the search result found in step i. above and Relationship Attribute search criteria provided to get the final match list and display the contact and their relationship attribute information.

Thanks in advance.

With regards,

Saurabh Kumar Pandey.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2015 at 12:01 PM

    Hi Saurabh,

    could you please be a bit more precise about the relationship between the BOs? Esp: are there associations between the BOs?

    If there is an association between the two BOs you can create a custom query which could solve your issue.

    Best regards,


    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Saurabh,

      As the on BO is the SAP BO BusinessPartner and the other one is a customer BO I assume that the custom BO is a kind of enhancement of the SAP BO and will refer to the resp. BusinessPartner via the same ID (or any other key)

      Therefore Ludgers argument makes the key:

      You can define an association 1:1 from the custom BO to the BusinessPartner and build your query on arguments which are accessble via this association.

      You will only get hits if the BusinessPartnwer instance meets the search criteria.



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.