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 comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    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,

    Ludger

    Add 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.

      HTH,

      Horst