topic Re: To write code in LSMW. in Application Development and Automation Discussions

To write code in LSMW.

Former Member — Tue, 26 Oct 2010 10:07:59 GMT

Hello Gurus,

We have created LSMW, in which when we upload the file, the file which we are uploading contains the entry of MAKTX field in double quotes only, thats why in the MAKTX field we are getting the string with double quotes, which is causing the problem.

So in the field mapping , we want to remove the double quotes for the field in LSMW.

For example : the line is "7"" casting test"".

we want to remove the first and last double quote from the value of MAKTX in lsmw.

Please let me know how we can write the code to remove this double quote from the string for the field MAKTX in LSMW?

Thanks

Re: To write code in LSMW.

Former Member — Tue, 26 Oct 2010 10:20:58 GMT

Hi,

while mapping the field maktx in lsmw with structure,you can remove the quote and assign the field

Re: To write code in LSMW.

Former Member — Tue, 26 Oct 2010 10:32:27 GMT

hello,

The file contains so many entries and user will not going to remove quotes each time he/she upload the data.

So we have to write some code to remove quotes each time we will process the file.

So how can to write the code for the same in field mapping?

Re: To write code in LSMW.

Former Member — Tue, 26 Oct 2010 10:36:46 GMT

Go to the field mapping / conversion rules section and just double click in the mapping for MAKTX. There you can add your code.

Re: To write code in LSMW.

Former Member — Tue, 26 Oct 2010 10:48:46 GMT

i had written code in the field mapping , in the coding section of MAKTX field, but it does seem to be working.

i had declare the variables and even put the loop statement there, but its not working.

the code is :-

DATA : string(100) TYPE c,

stringf(100) TYPE c,

len TYPE i,

len2 TYPE i,

len3 TYPE i,

count TYPE i,

count2 TYPE i,

l_string(100) TYPE c.

string = bgr001-maktx.

len = strlen( string ).

DO len TIMES.

IF string+count(1) = '"'.

IF stringf = '"'.

len2 = strlen( l_string ).

len3 = len2 - 1.

IF l_string+len3(len2) NE '"'.

l_stringcount2(1) = stringcount(1).

ENDIF.

ELSE.

l_stringcount2(1) = stringcount(1).

ENDIF.

stringf = string+count(1).

count = count + 1.

count2 = count2 + 1.

ENDDO.

SHIFT l_string LEFT DELETING LEADING space.

bmmh1-maktx = l_string.

can you please tell me how we can debug it?

or is there something wrong in it ?

Re: To write code in LSMW.

Former Member — Tue, 26 Oct 2010 11:34:34 GMT

You want to change

"7"" casting test""

into

7 casting test

If you want to debug, just hardcode BREAK-POINT in your code.

Re: To write code in LSMW.

Former Member — Wed, 27 Oct 2010 04:28:53 GMT

Yes you are correct , i want to change the way you had written , and i also put the break-point statement as well but still it does not stop at that point.

Is that i m missing something or what else is required?

Re: To write code in LSMW.

Former Member — Wed, 27 Oct 2010 05:31:01 GMT

My above code is working correctly now, i can see that in display converted data, double quotes gets deleted.

Thank you all for your help.

Re: To write code in LSMW.

Former Member — Wed, 27 Oct 2010 05:32:02 GMT

I got the answer to my problem.

Re: To write code in LSMW.

Former Member — Wed, 27 Oct 2010 10:34:29 GMT

Tip: get rid of all that coding as you can do it with 1 line: it's just confusing.

replace all occurrences of '"' in string with space.