3724798 - Searching for 'Old Contract Number' field value in 'Manage Contract' App does not return the contract - SAP S/4HANA Cloud Public Edition

• When attempting to search for contracts in App 'Manage Contract' by 'Old Contract Number' field, the search does not find the contract in question.

SAP S/4HANA Cloud Public Edition

1. Access the 'Manage Contract' App.
2. Click into the 'Contract number' box to expand search criteria.
3. Input the legacy contract number into the 'Old Contract Number' search field.
4. Click on 'Go'.
5. No results are shown.

• The field for contract numbers is defined as CHAR type with a length of 20 and utilizes ALPHA conversion.
• Legacy contract numbers that are numeric and less than 20 characters in length receive leading zeroes up to the 20-character limit in the underlying database table. These leading zeroes are not visible in the front-end interface, causing exact searches to fail.

1. Retry the search by placing an asterisk (*) at the front of the legacy contract number.
2. Note the following scenarios for searching legacy contract numbers:

• If the legacy contract number starts with a letter, wildcards at the start of the search term are unnecessary, as text does not contain leading zeroes at the database level.
• If the legacy contract number is numeric and exactly 20 characters in length (or includes leading zeroes added on the front-end), wildcards are not required.
• If the legacy contract number is numeric and less than 20 characters in length, include a wildcard (*) at the start of the search term.

legacy contract number, old contract number, contract search, manage contract, alpha conversion, wildcard search, search criteria, RE-FX , KBA , RE-FX-CN-2CL , Contract (Public Cloud) , RE-FX-2CL , Flexible Real Estate Management (Public Cloud) , Problem