Question Re: REPLACE function is not working in AMDP script to remove symbol from string. in Technology Q&A

REPLACE function is not working in AMDP script to remove symbol from string.

chhanda_sarkar — Tue, 19 Apr 2022 06:55:13 GMT

Hello All,

My requirement is to remove $ symbol from a string in AMDP method.

Example : if input lv_material = $$$$$$$$12345.

output should be lv_material = 12345

I am trying to replace $ symbol with space in AMDP but its not working. So please help me with a solution.

Thanks & Regards,

Chhanda Sarkar

Re: REPLACE function is not working in AMDP script to remove symbol from string.

Sandra_Rossi — Tue, 19 Apr 2022 07:24:48 GMT

I don't understand "it's not working", please explain what you get.

Re: REPLACE function is not working in AMDP script to remove symbol from string.

chhanda_sarkar — Tue, 19 Apr 2022 11:13:16 GMT

Hi sandra.rossi

using replace function I am getting the same string as an output. ie : $$$$$$$$12345.I should get : 12345.

I have attached my code screenshot also.

Re: REPLACE function is not working in AMDP script to remove symbol from string.

Sandra_Rossi — Tue, 19 Apr 2022 12:24:12 GMT

Please post the code as text instead of image, so that one can easily answer by testing your code.

Re: REPLACE function is not working in AMDP script to remove symbol from string.

Sandra_Rossi — Tue, 19 Apr 2022 12:38:36 GMT

No issue at my side:

CLASS zzsro_amdp DEFINITION PUBLIC FINAL CREATE PUBLIC .
  PUBLIC SECTION.
    INTERFACES: if_amdp_marker_hdb.
    CLASS-METHODS test EXPORTING VALUE(material) TYPE matnr.
ENDCLASS.
CLASS zzsro_amdp IMPLEMENTATION.
  METHOD test
        BY DATABASE PROCEDURE FOR HDB LANGUAGE SQLSCRIPT
        OPTIONS READ-ONLY.
    SELECT REPLACE( '$$$$1', '$', ' ' ) material into MATERIAL FROM dummy;
  ENDMETHOD.
ENDCLASS.

Test class:

CLASS ltc_main DEFINITION FOR TESTING DURATION SHORT RISK LEVEL HARMLESS.
  PRIVATE SECTION.
    METHODS test FOR TESTING.
ENDCLASS.
CLASS ltc_main IMPLEMENTATION.
  METHOD test.
    zzsro_amdp=>test( IMPORTING material = data(material) ).
    cl_abap_unit_assert=>assert_equals( act = material exp = '1' ).
  ENDMETHOD.
ENDCLASS.

Re: REPLACE function is not working in AMDP script to remove symbol from string.

FredericGirod — Tue, 19 Apr 2022 12:46:41 GMT

sandra.rossi could you check if your method return an exception ?

Re: REPLACE function is not working in AMDP script to remove symbol from string.

chhanda_sarkar — Tue, 19 Apr 2022 12:49:27 GMT

Hello sandra.rossi,

METHOD get_quota_based_on_duration_t BY DATABASE PROCEDURE

FOR HDB LANGUAGE

SQLSCRIPT OPTIONS READ-ONLY

USING ekko ekpo ekpo_distr /VWKS/NLP_CTR_QT dd07t but0id lfa1.

declare lv_material "$ABAP.type( matnr )" := substring( :iv_quota_duration_where, 1, 40 );

declare lv_bsakz "$ABAP.type( bsakz )" := substring( :iv_quota_duration_where, 41, 1 );

declare lv_valid_from "$ABAP.type( sy-datum )" := substring( :iv_quota_duration_where, 42, 8 );

declare lv_valid_to "$ABAP.type( sy-datum )" := substring( :iv_quota_duration_where, 50, 8 );

declare lv_plant "$ABAP.type( werks_d )" := substring( :iv_quota_duration_where, 58, 4 );

SELECT replace( lv_material, '$', ' ' ) "replace" from dummy;

ENDMETHOD.

This is my piece of code in that method.

Re: REPLACE function is not working in AMDP script to remove symbol from string.

chhanda_sarkar — Tue, 19 Apr 2022 13:08:52 GMT

Hello sandra.rossi,

Thanks a lot for your answer and for your valuable time to answers my query.

I am able to solve it by following your code.

I have replaced my piece of code with the below line and now I am getting my expected result.

select replace ( lv_material, '$', ' ' ) material into lv_MATERIAL from dummy;

Thanks & Regards,

Chhanda Sarkar

Re: REPLACE function is not working in AMDP script to remove symbol from string.

Sandra_Rossi — Tue, 19 Apr 2022 13:57:13 GMT

frdric.girod

I usually test my code before answering, it was the case here so there was no exception. Because of "using dummy" missing?

Re: REPLACE function is not working in AMDP script to remove symbol from string.

Sandra_Rossi — Tue, 19 Apr 2022 14:00:59 GMT

chhanda.sarkar

Each time you forgot to indicate the name of the exporting parameter (you didn't post the code METHODS ...), and I understand from your 2 last posts that you named it the same as the variable. Try to not use the same names the variables and parameters to avoid this kind of issue !

Re: REPLACE function is not working in AMDP script to remove symbol from string.

FredericGirod — Tue, 19 Apr 2022 14:01:26 GMT

I cannot test your code sandra.rossi, but I think, when you catch an execption and after put the ASSERT.. method, as SAP not run your ASSERT method, and not return an error, the test is considered as SUCCESS

I already had this kind of problem, in a project

Re: REPLACE function is not working in AMDP script to remove symbol from string.

chhanda_sarkar — Tue, 19 Apr 2022 14:12:29 GMT

sandra.rossi,

get_quota_based_on_duration_t IMPORTING VALUE(iv_quota_duration_where) TYPE gty_quota_duration_where

exporting VALUE(et_quota_data) TYPE gty_t_quota_amdp_output,

This is the method declaration part.

I Think problem was I did not use "Into" while using REPLACE function.

Re: REPLACE function is not working in AMDP script to remove symbol from string.

Sandra_Rossi — Tue, 19 Apr 2022 19:13:46 GMT

frdric.girod Got it, sorry for the bad catch. Let me edit my code/remove try/catch/endtry. But anyway it works.