LSMW – Step by Step

Basic technique is Import data from Spreadsheet / Sequential file, convert from source format to target format and import into R/3 database. LSMW not part of standard R/3, if we need this product email lsm@sap.com

Advantages of LSMW:
    • Most of the functions are within R/3, hence platform independence.

   • Quality and data consistency due to standard import techniques.

   • Data mapping and conversion rules are reusable across projects.

   • A variety of technical possibilities of data conversion.

   • Generation of the conversion program on the basis of defined rules

   • Interface for data in spreadsheet format.

   • Creation of data migration objects on the basis of recorded transactions.

   • Charge-free for SAP customers and partners.

Working With LSMW:
Use TCODE LSMW

Objects of LSMW:
  •Project   – ID with max of 10 char to Name the data transfer project.

  • Subproject   – Used as further structuring attribute.

  • Object   – ID with max of 10 Characters, to name the Business object .

  • Project can have multiple sub projects and subprojects can have multiple objects.
  • Project documentation displays any documentation maintained for individual pop ups and processing steps

User Guide: Clicking on Enter leads to interactive user guide which displays the Project name, sub project name and object to be created.

Object type and import techniques:
  • Standard Batch / Direct input.

  • Batch Input Recording

      o If no standard programs available

      o To reduce number of target fields.

      o Only for fixed screen sequence.

    • BAPI

    • IDOC

      o Settings and preparations needed for each project

Preparations for IDOC inbound processing:
    • Choose settings -> IDOC inbound processing in LSMW

    • Set up File port for file transfer, create port using WE21.

    • Additionally set up RFC port for submitting data packages directly to function module IDoc_Inbound_Asynchronous, without creating a file during data conversion.

    • Setup partner type (SAP recommended ‘US’) using WE44.

    • Maintain partner number using WE20.

    • Activate IDOC inbound processing.

    • Verify workflow customizing.

Steps in creating LSMW Project:
    • Maintain attributes – choose the import method.

    • Maintain source structure/s with or without hierarchical relations. (Header, Detail)

    • Maintain source fields for the source structures. Possible field types – C,N,X, date, amount and packed filed with decimal places.

    • Fields can be maintained individually or in table form or copy from other sources using upload from a text file

    • Maintain relationship between source and target structures.

    • Maintain Field mapping and conversion rules

    • For each Target field the following information is displayed:

      o Field description

      o Assigned source fields (if any)

      o Rule type (fixed value, translation etc.)

      o Coding.

      o Some fields are preset by the system & are marked with Default setting.

    • Maintain Fixed values, translations, user defined routines – Here reusable rules can be processed like assigning fixed values, translation definition etc.

    • Specify Files

      o Legacy data location on PC / application server

      o File for read data ( extension .lsm.read)

      o File for converted data (extension .lsm.conv)

    • Assign Files – to defined source structures

    • Read data – Can process all the data or part of data by specifying from / to transaction numbers.

    • Display read data – To verify the input data being read

    • Convert Data – Data conversion happens here, if data conversion program is not up to date, it gets regenerated automatically.

    • Display converted data – To verify the converted data

Import Data – Based on the object type selected
    • Standard Batch input or Recording

      o Generate Batch input session

      o Run Batch input session

    • Standard Direct input session

      o Direct input program or direct input transaction is called

BAPI / IDOC Technique:
    • IDOC creation

      o Information packages from the converted data are stored on R/3 Database.

      o system assigns a number to every IDOC.

      o The file of converted data is deleted.

    • IDOC processing

      o IDOCS created are posted to the corresponding application program.

      o Application program checks data and posts in the application database.

Finally Transport LSMW Projects:
    • R/3 Transport system

      o Extras ->Create change request

      o Change request can be exported/imported using CTS

    • Export Project

      o Select / Deselect part / entire project & export to another R/3 system

    • Import Project

      o Exported mapping / rules can be imported through PC file

      o Existing Project data gets overwritten

      o Prevent overwriting by using

    ‘Import under different name
’

    • Presetting for Inbound IDOC processing not transportable.