Hi Purnachander,
1. LSMW does not support direct reading of microsoft Excel files. When the documentation speaks of 'spreadsheet', they mean SAP generic spreadsheet format, which in the PC world, it is pretty much the same a the so-called 'tab-delimited' format.
If you are using Excel, your best bet is to save your spreadsheets as CSV or Tab delimited (if CSV, make sure you use the same character (such as comma ',') as a delimiter in both Excel and in the LSMW file definition).
2. I can't tell your problem from your info. There can be many many reasons. I can say that creating BOMs using the direct input method is by far the best method. I will admit that it is tricky. Since you are new at this, I recommend that you just use one input file, which includes both header and item data for a single-level-single item list of BOMs. Once you have overcome the normal initial problems, you can then expand to more complex boms. Only use multiple input files when you fully understand what they do and how LSMW treats them.
All master data (and most transactional data) can be input with LSMW. As mentioned by one of the other readers, some companies create custom BDCs instead. Unfortunately, these companies usually have to at some point engage a programmer with each client. With LSMW, a functional analyst can create LSMW projects that can be carried from client to client, Once you become expert in LSMW, no other Legacy data translation tool is needed.
Regards
Uday
Bluesky
