且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SAP C4C,CRM和S4HANA的Saved Query使用介绍

更新时间:2022-09-07 11:07:50

Saved query is a feature which enables customer to customized query according to their special business requirement.


Saved Query in C4C

In C4C suppose I would like to make the value help for UI field “customer” to issue query with search parameter “Role” equals to “Customer” by default, I can simply choose “Customer” from drop down list and click button “Save Query”.


SAP C4C,CRM和S4HANA的Saved Query使用介绍

In Add Query dialog, type a name for this saved query and set it as default query.

SAP C4C,CRM和S4HANA的Saved Query使用介绍

Next time I click F4 on “Customer” UI field, this saved query will be issued by default as expected.

SAP C4C,CRM和S4HANA的Saved Query使用介绍

By following the same approach I add another saved query “only Distributor” for UI field “Distributor”:

SAP C4C,CRM和S4HANA的Saved Query使用介绍

And Now I can switch between different saved query for different UI field.

SAP C4C,CRM和S4HANA的Saved Query使用介绍

Saved query in CRM

The idea in CRM is exactly the same as in C4C.


Specify the required search parameter value, choose a name for this saved query and click Save button.


SAP C4C,CRM和S4HANA的Saved Query使用介绍

Once done, next time after you open the value help, you could load your saved query from drop down list:

SAP C4C,CRM和S4HANA的Saved Query使用介绍

And the saved query will be launched with specified search parameter maintained previously.

SAP C4C,CRM和S4HANA的Saved Query使用介绍

Saved Query in S/4 HANA

Again the same idea here. Click “Adapt Filters” button to enter the UI where you can specify your own Saved query:


SAP C4C,CRM和S4HANA的Saved Query使用介绍

Here I plan to model a Saved Query for “Not Closed” Sales Orders:

SAP C4C,CRM和S4HANA的Saved Query使用介绍

And save this query as a variant:

SAP C4C,CRM和S4HANA的Saved Query使用介绍

Next time when I perform Sales Order search, I can then switch between standard query and my saved query from drop down list:

SAP C4C,CRM和S4HANA的Saved Query使用介绍

Further reading

Jerry’s blogs regarding the comparison how CRM and Cloud for Customer implement a given feature using different approaches:


OData Service backend implementation in C4C, CRM and S4 HANA

Excel export in CRM and C4C

Saved query in C4C, CRM and S/4 HANA

Direct navigation in CRM WebUI, CRM Fiori and C4C

Formatted Text Edit in CRM and Cloud for Customer

How Table column resize works in CRM and Cloud for Custome