Shulou(Shulou.com)05/31 Report--

SAP CRM WebClient UI order search of the various conditions of the implementation principle and performance test is what, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can get something.

CRMS4_SERVHSRCH INNER JOIN CRMS4_SERVISRCH ON CRMS4_SERVISRCH~OBJECT_ID = CRMS4_SERVHSRCH~OBJECT_ID

Take a look at line 6 below. Since the product id is already available in the Item view, why do we need to connect it in the title view here?

Is it because we need to display some fields in the title view in the results list?

(1) Please also refer to the screenshot above, see the second line: the title and the object type of the project appear here.

Why does OBJECT_TYPE need them?

(2) in the Sold to Party ID search scenario, INTERNAL JOIN on CRMS4D_PARTNER is still used:

CRMS4_SERVHSRCH INNER JOIN CRMS4D_PARTNER ON CRMS4D_PARTNER~OBJECT_ID = CRMS4_SERVHSRCH~OBJECT_ID

Now that Sold to Party ID is available in the header CDS view, why do we still need to do an inner join on the CRMS4D_Partner?

In the Sold to Party Name scenario, the functional module BUPA_Search_2 converts the value specified by the standard Sold_to_Party_Name to the partner ID.

Then search for Partner ID based on the field Sold_to_Party in the Header CDS view.

There is another way to avoid bupa_search_2 calls.

I built this approach in a prototype I completed last year:

Define an Association_Partner to BP CDS view I_BusinessPartner in my Header view.

If we do not make any queries on the associated fields, there will be no performance loss.

How to generate WHERE statements dynamically

Select this option, for example:

Sync with Carsten

Current performance of QGP/504:

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.