SAP EWM Create Physical inventory Area in mass using LSMW

SAP inventory management system

Generally, we use LSMW to upload the master data or transaction data, when we want to use LSMW to upload the configurational Item in mass then it’s always a challenge, as for recording we require Transaction code and programs (for some configurational nodes which is not available).

Some projects have requirement to create many activity areas depending upon the different activity (like storing the product to different temperature), for such scenarios we need to activity different Physical activity area. Its then become difficult to create this physical activity area in mass manually and this is where LSMW helps to create these entries in bulk.

Creating a Legacy System Migration Workbench (LSMW) project in an SAP Extended Warehouse Management (EWM) system involves several steps. LSMW is a tool that supports data migration from non-SAP systems (“legacy systems”) to SAP systems. Below are the general steps to create and execute an LSMW project in SAP EWM:

In S4HANA 2021 and above its easy to create LSMW for configurational item also using recording as S4HANA provide the transaction code information for each configurational node.

Physical Inventory Area

SAP EWM operational workflow

If we want to upload the physical activity area in mass in system using LSMW then we can identify the Tcode using below path:

SAP supply chain execution dashboard

The highlighted one is the code we can use for recording.

SAP outbound delivery processes

LSMW to create physical inventory activity area to upload the configuration in masses.

Then follow the normal procedure to create the Projects information.

  1. Accessing LSMW:
    • Log in to your SAP EWM system.
    • Use transaction code LSMW to access the Legacy System Migration Workbench.
  2. Create a New Project:
    • In the initial screen of LSMW, click on “Create” to create a new project.
    • Enter the project name, subproject name, and object name. These names should be meaningful and describe the migration process.
SAP warehouse inventory analytics

PROGRAM – /LIME/SAPLPI_CUST

Define Object Attributes:

  • In this step, you define the object attributes. Choose “Batch Input Recording” if you want to record the transaction or “Direct Input” if you are loading data directly into SAP tables.
  • If you choose “Batch Input Recording,” create a new recording by specifying the transaction code (e.g., /SCWM/ADHU for handling units in EWM).
SAP inventory replenishment workflow

For recording use transaction code

SAP EWM storage type management
SAP goods issue management workflow
SAP logistics document processing
SAP warehouse process confirmation

Maintain Source Structures:

  • Define the structure of the source file. For example, if you are importing data from a CSV file, define the structure of this file here.

Maintain Source Fields:

  • Specify the fields in your source structure. This involves defining the mapping between the source file and the SAP system.
SAP stock transfer monitoring screen

 

Step 4 Assign relationship

Maintain Structure Relations:

  • Map the source structures to the target structures in SAP. This step establishes the relationship between the source data and the target data.
SAP inventory tracking dashboard

Auto Mapping of fields

Maintain Field Mapping and Conversion Rules:

  • Map the source fields to the target fields. This step involves detailed field mapping and defining any necessary conversion rules. Conversion rules are used to transform the source data to fit the target data requirements.
SAP warehouse order processing

Specify Files:

  • Specify the source file path and name. This is the file containing the legacy data you want to import.
SAP material storage configuration

Step-8

Assign Files:

  • Assign the source file to the source structure you defined earlier.
SAP material availability check screen

Step-9 Display Read Data:

  • In this step, read the data from the source file into the SAP system. The system will display how many records were read.
SAP warehouse stock overview screen

Step-12

Display Converted data

SAP warehouse automation interface

Step -13 Create Batch session.

Step -14 execute the batch input session.

SAP storage bin assignment process

 

Blog by

@SCMCLOUDBOOK Team

 

Become an SAP EWM Expert!
Master warehouse management with our hands-on SAP EWM training. Join SCM-Cloudbook’s expert-led sessions and elevate your career in the warehouse industry.

👉 Connect with us directly: Registration Link
📱 WhatsApp: (wa.link/04d8tw or ✆ +91-9289246569).
🖱️ SCM-CLOUDBOOK

for more blogs: Cloudbook Blogs: Stay Updated with the Latest News and Insights

Leave a Reply

Your email address will not be published. Required fields are marked *