Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
kaushal_sharma
Active Participant

Hi Friends this is my first blog in SCN.

There are so many method to upload initial stock i.e. LSMW, BDC.

Apart from these method one more method I would like to share with all of you, which is direct excel file upload. To upload this method nowhere LSMW is required. Actually here this process will bypass all the way LSMW configuration and directly it will upload excel sheet (csv) and upoad the stock using batch input.

Configuration


T-Code: FILE

Process

Here we will use BMSEG structure to prepare Excel file which is going to be uploaded further.

Note: Each and every field must be included in this sheet. Value of fields must be equals to field length.

SaveAs Excel file into CSV extension and re-open file in text format and remove comma (,) with space from text and save, close file.

Now run T-Code: CG3Z

Give the location of source file on frond end (from your system).

Target file on application server as shown in screen shot.

Now run the T-code: MBBM

It will create and run batch input and upload the stock.

Hope this document is helpful.

Best regards,

Kaushal Sharma

7 Comments