BDC_INSERT error while doing LSMW

[#1]

Hi All,

I have created an LSMW to change the description and material group of some material codes. I ran this LSWM 2 time and it worked without an error. Yet when i try to process it nowat the point where i choose "Create Batch Input Session" i get the error BDC_INSERT, Transaction code .. is invalid.

I have checked the file many times and i can't seem to find what is wrong. Appreciate if someone could let me know why this error comes and how to solve it.

Thanks,

Savindi

[Former Member]

Hi, Have a look in the 'Display Converted Data' step of LSMW of all the records. If you notice carefully, instead of finding one record for one row, you will find one row being spilled onto another row or you might find large space in a single record. To rectify this, go to your data sheet in excel format to the row where you found large space. You will notice that in a single cell of a particular column, between 2 words there is extra space. Delete the extra space, save the file and the run LSMW again.

Ykc