SAP Knowledge Base Article - Public

3622224 - Code list restriction is not working on the Advanced Search of an OWL screen

Symptom

You have a custom field code list that you want to restrict.

When restricting a Code List field on the Advanced Search of, for example, Accounts OWL screen, and having the custom field created on another BO, like Sales Data, having also the Custom List Restriction (CLR) created based on the Sales Data BO as well, and the custom field is selected correctly.

However, the CLR doesn't work on the Advanced Search of the Accounts screen, but works on the Sales Data, and QC of the Accounts screen.

Environment

  • SAP Cloud Applications Studio
  • SAP Cloud for Customer

Reproducing the Issue

You have created the CLR and selected the field correctly.

  1. Go to Accounts OWL view.
  2. Open the advanced search.
  3. Look for your custom codelist field.
  4. There are values that should not be visible.

Cause

From the CLR created for "Sales Data" the same will be applied in the object creation.

E.g. Access the owl and create a new account. Hence the CLR will trigger and restrict the values desired.

From the Accounts OWL view, Advanced search option. It is necessary to create a CLR based on "Accounts" object.

So the field has to be extended to the desired BO, in this case, Accounts.

However, when creating the CLR for the Accounts BO, the field does not show in the options to be selected.

Resolution

As a next action from your end, create the new CLR based on the Accounts BO, however, the field is not shown.

For it to be shown, select the extension scenarios from the SalesArrangement BO - Root node:

  1. Account - Sales Data to Sales Document - General Information
  2. Account - General Information to Sales Document - General Information

The second will only be shown after the first is selected.

After this, you can be creating a code list restriction for the Account business object and the PDI extension field will be available for selection in the Code to Restrict field.

Keywords

code list restriction, advanced search, accounts owl, sales data bo, custom field, clr, pdi extension, restrict values , KBA , AP-RC-BDS-EXT , ByDesign Studio Extensibility , LOD-LE-RC-CLR , Code List Restriction , How To

Product

SAP Cloud Applications Studio all versions ; SAP Cloud for Customer core applications all versions