cancel
Showing results for 
Search instead for 
Did you mean: 

LSMW Error.

Former Member
0 Kudos

Hi,

While uploading customer master through lsmw i am facing one problem.

Ex: Sales office:001,002,003.

For few cusotmers there is no sales office defined.So i am leaving blank in excel and same in notepad.

Here problem is system automatically proposing 000 for the empty customers and throwing error as 000 not exist in sales office values.

Can anybody suggest me how to skip this error..

Accepted Solutions (0)

Answers (2)

Answers (2)

Lakshmipathi
Active Contributor
0 Kudos

Here problem is system automatically proposing 000 for the empty customers

It is not because of your LSMW recording but because of that field is set as mandatory in configuration.  Check in OBD2 and OB20 as well and change the setting to optional.

G. Lakshmipathi


Former Member
0 Kudos

Any suggestions on this pls...

former_member184771
Contributor
0 Kudos

In your excel file for the customer without sales office maintain a non zero value (via format cell i.e. nothing but the text value)  and then convert that in flat file and try 2 upload....hope it will work...

Try and let us know

Former Member
0 Kudos

dependant on the method you are using via lsmw to load the data you can pass a / which batch input recognises as blank field indicator.