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

[chhanda_sarkar]

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

[Sandra_Rossi]

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

[chhanda_sarkar]

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.

[Sandra_Rossi]

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

[Sandra_Rossi]

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.

[FredericGirod]

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

[chhanda_sarkar]

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.

[chhanda_sarkar]

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

[Sandra_Rossi]

frdric.girod

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

[Sandra_Rossi]

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 !

[FredericGirod]

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

[chhanda_sarkar]

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.

[Sandra_Rossi]

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