3066899 - Records Are Not Returning while Filtering the ID Mapping for Integration Using Column Filter

While filtering the ID mapping for integration, you get the warning message "The data cannot be displayed completely. Sorting and Filtering are not reliable since the number of hits is too large. Reduce the number of search hits by restricting the search criteria." when you have more than 10000 records. Then, you are using the column filter but you notice that the stored data is not returning as expected and you have displayed less data.

SAP Cloud for Customer

1. Go to the Administrator work center.
2. Go to the ID Mapping for Integration work center view.
3. Open Edit ID Mapping for Integration option.
4. Select Mapping of as desired - for example Business Partners.
5. Select the used System Instance ID.
6. Click on Go button.
7. Warning message "The data cannot be displayed completely. Sorting and Filtering are not reliable since the number of hits is too large. Reduce the number of search hits by restricting the search criteria." appears.
8. Under ID column filter by *1234* (where 1234 means the Business Partners ID).

Result: The records are less than stored in the Business Partners work center view.

The filter on column ID searches only on the first 10000 records displayed and hence the result does not contain all the expected Business Partners.

As a resolution the user needs to search the content via ID field in the advanced search following the steps:

1. Go to the Administrator work center.
2. Go to the ID Mapping for Integration work center view.
3. Open Edit ID Mapping for Integration option.
4. Select Mapping of as desired - for example Business Partners.
5. Select the used System Instance ID.
6. Under ID field fulfill with *1234*
7. Click on Go button

The result brings all business partners with 1234 in the ID content (Please be informed the 1234 can be in the beginning, middle or end of the Business Partner ID content).

ID Mapping for Integration, Missing ID Mapping, Filter , KBA , LOD-CRM-INT-ERP , Integration of C4C with ERP , How To