Convert String to Number and String in ABAP : Find here the different methods to convert String variable into Number, Quantity or Amount in SAP ABAP with sample code or SAP standard function template making easing to convert string.
You will find mainly how to Convert String to Number in ABAP, SAP ABAP Convert string to decimal in ABAP, Convert String to Quantity in ABAP and ABAP Convert String to Amount (Currency).
Table of Contents
In this part, I will try to explain different methods how to sap ABAP convert char to number:
First at all, let’s check if a string variable (or a char variable) contains really only number before trying to convert it.
Fortunately, SAP provides in Standard a useful function NUMERIC_CHECK
Here the signature of NUMBERIC_CHECK :
FUNCTION numeric_check. *"---------------------------------------------------------------------- *"Lokale Schnittstelle: *" IMPORTING *" STRING_IN *" EXPORTING *" STRING_OUT *" HTYPE LIKE DD01V-DATATYPE *"---------------------------------------------------------------------- ENDFUNCTION.
The HTYPE export variable can have:
Tips: CHECK lv_variable NA SY-ABCD : check if an ABAP variable doesn’t contain letters and none-numerical characters 😉
IF you are looking to convert string to integer in ABAP code, you should start by testing this function CONVERT_STRING_TO_INTEGER.
Here the signature of this function:
CALL FUNCTION 'CONVERT_STRING_TO_INTEGER' EXPORTING p_string = " IMPORTING p_int = " i EXCEPTIONS OVERFLOW = 1 " INVALID_CHARS = 2 " .
Unfortunately, it is not available on each system. It is shipped with ECC.
In order to convert in SAP ABAP String variable to Number or Integer, you can also use the standard Function CATS_ITS_MAKE_STRING_NUMERICAL.
Here a sample ABAP Code how to use it (source):
DATA : LV_STR TYPE STRING, LV_NUM LIKE CATS_ITS_FIELDS-NUM_VALUE. LV_STR = '123456789'. CALL FUNCTION 'CATS_ITS_MAKE_STRING_NUMERICAL' EXPORTING INPUT_STRING = LV_STR IMPORTING VALUE = LV_NUM EXCEPTIONS NOT_NUMERICAL = 1 OTHERS = 2. WRITE : LV_NUM.
An other method to convert string variable to numerical format is the function WOSI_CONVERT_STRING_TO_NUM.
Here the signature of this signature.
CALL FUNCTION 'WOSI_CONVERT_STRING_TO_NUM' " EXPORTING p_action = " wosit_functioncode p_string_100 = " char100 IMPORTING p_erfmg = " wosi_iseg-erfmg p_exvkw_posws = " wosi_iseg-exvkw_posws p_swert = " wosi_head-swert p_vkumg = " wosi_umb_item-vkumg EXCEPTIONS ERROR_IN_SY_MSG = 1 " .
If you prefer using the ABAP OO way, you can use the method read_container_co of the ABAP utility class (CL_ABAP_CONTAINER_UTILITIES).
Personally, I have never used before this method (but I used a lot the ABAP utilities classes to read the metadata of ABAP variables and do some generic programming in ABAP).
Here a sample ABAP code using this method (>source)
read_container_c" >data : int type i. data : char(10) type c value '123'. class cl_abap_container_utilities definition load. call method cl_abap_container_utilities=>read_container_c exporting im_container = char importing ex_value = int exceptions illegal_parameter_type = 1 others = 2. write : int.
Instead of using function modules or method’s classes, you can do convert string / char to Integer or numerical using sample ABAP Statement.
The MOVE Statement and WRITE Statement can do the job for you or even the affectation statement (=) will do the casting.
A very example ABAP Code snippet can be:
DATA: LV_STRING TYPE STRING. DATA: LV_INTEGER TYPE I. LV_STRING = '01234567890'. LV_INTEGER = LV_STRING. WRITE LV_INTEGER.
You may check also
The easiest way to convert a char variable to decimal is to use the + statement in order to sum a decimal variable and a string.
The ABAP engine will cast the string variable into a decimal and the result will be a decimal.
Here a sample ABAP program illustrating this method:
DATA: lv_string TYPE string. DATA: lv_decimal TYPE p DECIMALS 2. lv_string = '574,980.17'. TRANSLATE lv_string USING ', '. CONDENSE lv_string NO-GAPS. CLEAR lv_decimal. lv_decimal = lv_decimal + lv_string. WRITE:/ lv_decimal.
Once again, SAP provides this function WSAF_CONV_STRING_TO_DECIMAL to convert a string to decimal.
The signature of this function module is:
CALL FUNCTION 'WSAF_CONV_STRING_TO_DECIMAL' EXPORTING number_to_convert = " dynfnam decimal_property = " wsaf_s_table_defines IMPORTING decimal_15_3 = " wsaf_bracketlow decimal_13_3 = " wsaf_currsales decimal_11_2 = " wsaf_purchunit decimal_5_0 = " wsaf_scalefactor decimal_4_0 = " wsaf_expiration decimal_3_0 = " wsaf_availdays EXCEPTIONS INTERNAL_ERROR = 1 " WRONG_CHARACTERS = 2 " FIRST_CHARACTER_WRONG = 3 " ARITHMETIC_SIGN = 4 " MULTIPLE_DECIMAL_SEPARATOR = 5 " NUMBER_TOO_BIG = 6 " .
MOVE_CHAR_TO_NUM can do the job and make the conversion from Char to Decimal.
Look at the following sample (source)
DATA: lv_chr(4) type c, lv_num type p. CALL FUNCTION 'MOVE_CHAR_TO_NUM' EXPORTING CHR = lv_chr IMPORTING NUM = lv_num EXCEPTIONS CONVT_NO_NUMBER = 1 CONVT_OVERFLOW = 2 OTHERS = 3. IF SY-SUBRC <> 0. * MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO * WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4. ENDIF.
Let’s jump to the Quantity part. I want to make a confidence: the MENGE data makes my life much harder because of all the dump of illegal data type occurred to Quantity data type.
So let’s remove this pain and list some method how to convert String to Quantity or Amount variable.
PS: I will be called it try and not method because the functions are not available on every version of SAP.
The first method can be the function module CHECK_AND_CONVERT_NUMERICS to Checks whether a value is numeric and converts to a packed number
CALL FUNCTION 'CHECK_AND_CONVERT_NUMERICS' EXPORTING * dfeld = SPACE " Name of DDIC field dmzei = " Decimal points '.' or ',' dtype = " Data type of screen field * dypno = SPACE " d020s-dnum Screen number efeld = " Field with value in character format * fname = SPACE " Screen field name * progr = SPACE " d020s-prog Program name * imp_decimals = '0' " Explicit entry of decimal places (without DFELD) IMPORTING error = " Indicator for error message ifeld = " Wert in packed format messg = " message Message msgln = " Length of message . " CHECK_AND_CONVERT_NUMERICS
Here we are talking about ABAP OO again. Actually it is the standard nowadays.
The Class CONVERT_STRING_TO_QUANTITY have an interesting method to convert String to Quantity (source)
CONVERT_STRING_TO_QUANTITY" >DATA: ld_IV_TEXT TYPE STRING , ld_RS_QUANTITY TYPE REF TO IF_FDT_TYPES=>ELEMENT_QUANTITY. " ld_IV_TEXT = "<Populate with value> CALL METHOD CL_FDT_QUANTITY_CONV=>CONVERT_STRING_TO_QUANTITY( EXPORTING IV_TEXT = ld_IV_TEXT RECEIVING RS_QUANTITY = ld_RS_QUANTITY EXCEPTIONS CX_FDT_CONVERSION = 4 ).
The third try to convert String to Quantity is with function RS_CONV_EX_2_IN.
Here a sample ABAP code to figure out the use of the function RS_CONV_EX_2_IN (source):
DATA ls_tabfield TYPE tabfield. ls_tabfield-tabname = 'MARA'. ls_tabfield-fieldname = 'NTGEW'. CALL FUNCTION 'RS_CONV_EX_2_IN' EXPORTING input_external = '7.123,897' table_field = ls_tabfield IMPORTING output_internal = mara-ntgew.
Check more about the Special Output Formats on help.sap.com and make a focus on the Unit-specific Output Formats’s section.
The statement to be use is: WRITE <f> UNIT <u>.
Just try this ABAP snippet code
WRITE LV_STRING UNIT LV_UNIT to LV_QUANTITY.
This function /CWM/CONVERT_CHAR_TO_PACK will convert a char to pack ABAP type.
Here a same use of HRCM_STRING_TO_AMOUNT_CONVERT in order to convert in ABAP String to Amount
DATA: LV_num TYPE p DECIMALS 2. CALL FUNCTION 'HRCM_STRING_TO_AMOUNT_CONVERT' EXPORTING string = '1234567.19' decimal_separator = '.' thousands_separator = ',' IMPORTING betrg = lv_num. WRITE lv_num LEFT-JUSTIFIED.
The next method is PSSV_TEXT_INTO_FIELD_CURRENCY can be also be used to convert String to Amount in ABAP.
Here the signature of PSSV_TEXT_INTO_FIELD_CURRENCY.
CALL FUNCTION 'PSSV_TEXT_INTO_FIELD_CURRENCY' " EXPORTING i_amount = " i_currency = " IMPORTING e_amount = " EXCEPTIONS WRONG_AMOUNT = 1 " WRONG_CURRENCY = 2 " WRONG_DECIMAL = 3 " .
SAP ISU Tables for Technical master data, for Billing Master Data, Billing and invoicing Tables?…
SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd…
Dunning is the business practice of informing a customer of past due payment. Dunning letters…
SAP AP Tcodes & SAP AR Tcodes: House Banks Tcodes, Advance Payments or Down Payments,…
What are the main SAP Payment Terms Tables ? What are the related Tables in…
Work center consists of master data related to routing of products. It contains data related…