topic LSMW problems in Application Development and Automation Discussions

LSMW problems

former_member384574 — Mon, 10 Feb 2014 19:22:59 GMT

Hello everybody!

I've a strange thing that's happening when I'm converting data on an LSMW. I'm using recording to SM30 for creating the entries on my customer table Z_TEST, my table contains 49 fields. The file is being reading correctly but, when I try to convert it there are three rows created per row read in the file... and then, when I try to create the BI the following message appears: BDC_INSERT, Transaction code .. is invalid.

Do you know if the LSMW doesn't allow to create a BI with 49 fields? There's any other way for data migration for customer tables?

Thank you so much in advance for all your help.

Regards,

Rebeca

Re: LSMW problems

Abhijit74 — Mon, 10 Feb 2014 19:59:00 GMT

Hello,

Have you seen the converted data? and checked if there is any large space is overlapped with the data.

Check the data into converted file.

Thanks & Regards,

Abhijit

Re: LSMW problems

former_member384574 — Mon, 10 Feb 2014 20:11:34 GMT

Hello Abhijit,

Yes I've checked the convert data, and the fields are too much longer, but I do not know why and how to solve this issue, also, as I told in the message, when the row is converted, it is splitted in two rows ... do you know how can I solve this issue?

Thanks a lot for your support.

Regards,

Rebeca

Re: LSMW problems

Abhijit74 — Mon, 10 Feb 2014 20:18:59 GMT

Hello,

Check your legacy file. If it is a text file then check for blank spaces over there. I think somehow blank spaces and double quotes are there inside your file. So, you have to remove that.

Thanks & Regards,

Abhijit

Re: LSMW problems

former_member384574 — Mon, 10 Feb 2014 20:49:19 GMT

Hello again,

Thank you so much for your support! I will check it tomorrow in the office and I will let you know my comments because I think I've checked and there's no blank or double quotes, but I will double check

If there isn't any of that characters, do you think there will be another problem?

Thank you so much for your help!!!

Regards,

Rebeca