3659828 - Inconsistent Advanced Filter Search Behavior on Custom Business Object

• Leading zeros are considered when using search functionality on field based on a data type such as BusinessPartnerID field in the Advanced Filter of a custom Object Work List (OWL).
• Searching for an ID without leading zeros (e.g., 1048757) returns different results compared to searching with leading zeros (e.g., 0001048757)

• SAP Business ByDesign
• SAP Cloud Applications Studio
• SAP Cloud for Customer

• The issue arises due to the data type used in the custom Business Object (BO). You have selected a data type without the Alpha Conversion property enabled.
• Data types which have the Alpha Conversion property enabled, allow searches with or without leading zeros to return consistent results.

Create a new field using a data type such as BusinessPartnerInternalID instead of BusinessPartnerID.

OR

Harmonize the implementation by storing data in the expected format only to align with standard behavior.

businesspartnerid, leading zeros, advanced filter, custom owl, inconsistent search results, alpha conversion, businesspartnerinternalid, char data type, search behavior, sap bydesign, ui framework designtime , KBA , BC-SRV-FSI , Fast Search Infrastructure , AP-RC-BDS-EXT , ByDesign Studio Extensibility , Problem

SAP Business ByDesign all versions ; SAP Cloud Applications Studio all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions