Inventory upload is must for task for lots of project during cut-over tasks. There are many method to upload initial stock. In this blog, I’m covering inventory upload option using MBBM transaction with LSMW with all details.
Note: MBBM can be used directly (without LSMW or BDC), if you can manage excel format for each fields available in structure BMSEG with exact same length. But generating that excel becomes another task. With LSMW method, you don’t have to worry about that.
Use structure BMESG as a reference to create source fields in LSMW.
Here you can use auto-field mapping, as LSMW source fields are defined same as BMSEG.
Sometimes you can’t see technical fields, for example – session.
Change this setting to display technical fields.
Default setting of loading program creates all lines from your file in one session. Default session name is ‘Stock’.
For individual material document posting change default session field MAPPE to value from your mapping file for “Session”. This way every line from the file creates one material document.
Shown below are default values
Conversion rule. (I did not have any conversion rules)
Important notes, as I spent good amount of time to understand this step.
- For LSMW using method for program RM07MMBL, it only allows you to place file on application server. PC (frontend) option can’t be use.
- Converted Data path can’t be same as Legacy Data path. It must be different.
File – logical file path
For Logical path & Logical File – you must open client & that should prompt you to create new file path directly from LSMW.
Reference documentation –
On creation it will give warning message as shown below
Once client is open to allow changes, it should create logical path automatically as shown below.
Crucial part is done.
Now verify data in LSMW Step 7-11.
Create Batch Input session.
Hence following the above outlined steps of the blog post you can upload inventory using MBBM LSMW method, with very minimal help from ABAP team!
Thank you for reading, hope it helped!