We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!
CONVERT TEXT text INTO SORTABLE CODE hex.
The content of the operand text is converted to a sortable byte string and the result is assigned to the target field hex. The data object text itself remains unchanged.
The operand text must be of the type c or string. text is a character-like expression position. The following can be specified for hex:
The content of text must contain valid characters. The sortable byte string is defined as a platform-dependent string in such a way that a size comparison or standard sorting of multiple of these fields produces an order in which the source fields text are sorted according to the locale defined in the current text environment. The text environment is set when an internal session is opened or by using the statement SET LOCALE.
If the target field hex is of type x and its length is not sufficient for the byte string, an uncatchable exception is raised. If the length is greater than that of the byte string, it is filled with hexadecimal 0 on the right. The sufficient length for all platforms is calculated as 24 times the length of text plus 24, but can be significantly shorter for some platforms. If hex is of type xstring, its length is adapted automatically.
The statement CONVERT TEXT is mainly intended to fill an index column in internal tables where the column can be used to sort the lines of the table according to a locale. Since internal tables can also be sorted directly according to a locale using the addition AS TEXT of the statement SORT, CONVERT TEXT is particularly suited for the following cases:
The characters "a" and "Z" are compared directly after they have been converted by CONVERT TEXT.
While "Z" is in front of "a" for most code pages in direct comparisons, the comparison of the converted values returns the expected textual order. See also the
executable example for SORT for internal tables.
The characters "a" and "Z" are compared directly after they have been converted by CONVERT TEXT.
While "Z" is in front of "a" for most code pages in direct comparisons, the comparison of the converted values returns the expected textual order. See also the
executable example for SORT for internal tables.
Non-Catchable Exceptions
Leave us your contact details and we will call you back. Fields marked with * are mandatory.
We offer holistic SAP solutions from a single source to shape digital change and develop new business areas.
Switzerland
Schaffhausen
Germany
Mannheim, Düsseldorf, Munich
USA
Haverhill
Greece
Thessaloniki