LSMW Error while reading the data from the flat file??????

[Former Member]

Hi all,

I am doing LSMW and I have got a error while reading the data from the flat file which is present in Desktop. The file is .xls type and I saved as tab delimitor file. When I run the READ DATA step of the LSMW, I get the error which say GENERATION CANCELLED: REASON: SYNTAX ERRORS. I clicked the help tab and it says MESSAGE NO:/SAPDMC/LSMW_OBJ_070031.

Let me know what can be the problem. I checked my source structure and target structure, everything looks fine, but I cant read the data????

I will really appreciate your input and award points.

Thanks and waiting for your reply.

-Ken C

[Former Member]

Hi all,

I am doing LSMW and I have got a error while reading the data from the flat file which is present in Desktop. The file is .xls type and I saved as tab delimitor file. When I run the READ DATA step of the LSMW, I get the error which say GENERATION CANCELLED: REASON: SYNTAX ERRORS. I clicked the help tab and it says MESSAGE NO:/SAPDMC/LSMW_OBJ_070031.

Let me know what can be the problem. I checked my source structure and target structure, everything looks fine, but I cant read the data????

I will really appreciate your input and award points.

Thanks and waiting for your reply.

-Ken C

[Former Member]

Hello Ken,

Please do the following. In LSMW after you select your project, sub-project and object, you go to the next screen, where you do all your source structure definition, mapping etc with a bunch of readiobuttons. In the application toolbar, you will see a button 'Personal Menu'. Press that and in the subsequent pop-up screen, select the checkbox for 'Display Read Program' and press enter.

Now you should be able to see an additional readiobutton with the same description. Double click on that and it will take you to the program. Do a syntax check on that program and see where it points to for this error. If you cannot resolve it based on that information, please let us know what the syntax check error is .

Srinivas

[Former Member]

Hi Srinivas,

Thanks for your helpful answer. I have awarded the points and thanks once again.

Also, I have a question which I have put forward to the forum regarding the Batch input. Please give your input...

Regards,

-Ken.

[Former Member]

Can you please close the post as this is answered?

Regards,

Srinivas

[Former Member]

Hello Srinivas,

I am Venu here. I have got the same error while uploading a file. You said that an extra radio button appears and doubble click on it and check the syntax. Idid not seen any button. Can you please guide me where i can see the extra button and how to check the syntax? I have checked the box displayread data.

Thanks in adv.

Venu.

[Former Member]

I get the same error when I run the READ DATA step. I tried running the Generate/Display read program (activating the option in the user menu) and get the same error again - "syntax errors". I have no way to know where the error is.

I will appreciate any help.

Thanks,

Ivá

[Former Member]

Hi Ivan,

I had the same problem, but found the solution:

Re: LSMW Read Data error
In LSMW 5th step i.e. mapping, please press the check syntax push button. If you see the message "The conversion program could be generated successfully." then you will not encounter such problem.

After I pressed the check syntax button, it showed me the syntax errors and I could correct them...

regards,

jozef

[former_member770065]

Hi Jozef

It got solved. Thank You..

[snowgirl]

Hi jaiminiks ;

I have the same error would you tell me how you solved it.

thnx

[former_member919262]

Hi Snow girl,

I checked the syntax in the program and everything was OK. I got the message: The conversion program could be generated successfully

In my case there was an issue with the format of my CSV file, the coding was set as ANSI instead of UTF-8, and somehow the information was not being read correctly.

I hope it helps,