Skip to Content
author's profile photo Former Member
Former Member

LSMW

HI all

How can i upload data from txt file from application server through LSMW into database table???

thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 17, 2008 at 10:42 AM

    Go thro these steps..

    Using Tcode MM01 -- Maintain the source fields are

    1) mara-amtnr char(18)

    2) mara-mbrsh char(1)

    3) mara-mtart char(4)

    4) makt-maktx char(40)

    5) mara-meins char(3)

    the flate file format is like this as follows

    MAT991,C,COUP,Srinivas material01,Kg

    MAT992,C,COUP,Srinivas material02,Kg

    AMT993,C,COUP,Srinivas material03,Kg

    MAT994,C,COUP,Srinivas material04,Kg

    MAT995,C,COUP,Srinivas material05,Kg

    goto Tcode LSMW

    give Project Name

    Subproject Name

    object Name

    Press Enter -


    Press Execute Button

    It gives 13 radio-Button Options

    do the following 13 steps as follows

    1) select radio-Button 1 and execute

    Maintain Object Attributes

    select Standard Batch/Direct Input

    give Object -- 0020

    Method -- 0000

    save & Come Back

    2) select radio-Button 2 and execute

    Maintain Source Structures

    select the source structure and got to click on create button

    give source structure name & Description

    save & Come Back

    3) select radio-Button 3 and execute

    Maintain Source Fields

    select the source structure and click on create button

    give

    first field

    field name matnr

    Field Label material Number

    Field Length 18

    Field Type C

    Second field

    field name mbrsh

    Field Label Industrial Sector

    Field Length 1

    Field Type C

    Third field

    field name mtart

    Field Label material type

    Field Length 4

    Field Type C

    fourth field

    field name maktx

    Field Label material description

    Field Length 40

    Field Type C

    fifth field

    field name meins

    Field Label base unit of measurement

    Field Length 3

    Field Type C

    save & come back

    4) select radio-Button 4 and execute

    Maintain Structure Relations

    go to blue lines

    select first blue line and click on create relationship button

    select Second blue line and click on create relationship button

    select Third blue line and click on create relationship button

    save & come back

    5) select radio-Button 5 and execute

    Maintain Field Mapping and Conversion Rules

    Select the Tcode and click on Rule button there you will select constant

    and press continue button

    give Transaction Code : MM01 and press Enter

    after that

    1) select MATNR field click on Source filed(this is the field mapping) select MATNR and press Enter

    2) select MBRSH field click on Source filed(this is the field mapping) select MBRSH and press Enter

    3) select MTART field click on Source filed(this is the field mapping) select MTART and press Enter

    4) select MAKTX field click on Source filed(this is the field mapping) select MAKTX and press Enter

    5) select MEINS field click on Source filed(this is the field mapping) select MEINS and press Enter

    finally

    save & come back

    6) select radio-Button 6 and execute

    Maintain Fixed Values, Translations, User-Defined Routines

    Create FIXED VALUE Name & Description as MM01

    Create Translations Name & Description as MM01

    Create User-Defined Routines Name & Description as MM01

    after that delete all the above three just created in the 6th step

    FIXED VALUE --MM01

    Translations --MM01

    User-Defined Routines --MM01

    come back

    7) select radio-Button 7 and execute

    Specify Files

    select On the PC (Frontend) -- and click on Create button(f5)

    give the path of the file like "c:\material_data.txt"

    description :

    -


    separators as select comma radiao- button

    and press enter save & come back

    8) select radio-Button 8 and execute

    Assign Files

    Save & come back

    9) select radio-Button 9 and execute

    Read Files

    Execute

    come back

    come back

    10) select radio-Button 10 and execute

    Display Imported Data

    Execute and press enter

    come back

    Come back

    11) select radio-Button 11 and execute

    Convert Data

    Execute

    come back

    Come back

    12) select radio-Button 12 and execute

    Display Converted Data

    Execute & come back

    13) select radio-Button 13 and execute

    Start Direct Input Program

    --select the Program

    --select continue button

    --go with via physical file

    --give the lock mode as 'E'

    and execute

    Refer these links,

    lsmw

    http://www.sapgenie.com/saptech/lsmw.htm

    http://service.sap.com/lsmw

    http://www.sapbrain.com/TUTORIALS/TECHNICAL/LSMW_tutorial.html

    http://www.scmexpertonline.com/downloads/SCM_LSMW_StepsOnWeb.doc

    for specifying application server file.....

    In the Specify file step double click on the following option

    Legacy Data On the R/3 server (application server)

    Enter the application server file name with full path and description.

    Like /tmp/test.txt

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 17, 2008 at 10:46 AM

    Step-by-Step Guide for using BAPI in LSMW

    Note! The screen prints in this article are from ECC 5.0. They may differ slightly in other versions.

    Introduction:

    This document details the usage of BAPI in LSMW. We have used the example of migration of the purchase order data into SAP.

    Pre-requisites:

    It is assumed that the reader of this article has the minimum knowledge required on the Business Object, BAPI, Message Types and IDoc Types.

    Step-by-Step Procedure:

    Details of the BAPI used in this scenario:

    Business Object: BUS2012

    Method: CreateFromData

    Details of Message Type and Basic IDoc Type:

    Message Type: PORDCR

    Basic IDoc Type: PORDCR02

    Let’s have a look at the BAPI first, before proceeding to the LSMW:

    1. Go to Transaction BAPI

    2. Click on Search Button

    3. Enter the value “BUS2012” and select “Obj.type(Technical Object Name”

    4. Press ENTER

    5. Following screen appears:

    6. On the left side of the screen, Expand the “PurchaseOrder”.

    7. Select “PurchaseOrder” and double-click on the same for details.

    Building LSMW using BAPI:

    1. Go to Transaction LSMW.

    2. Enter the Project, Subproject and Object information and click on CREATE.

    3. Enter the descriptions for Project, Subproject and Object.

    4. Now select Settings à IDoc Inbound Processing

    5. “IDoc Inbound Processing” screen appears. Enter the required details as shown below:

    6. Click on “Activate IDoc Inbound Processing”.

    7. Click on “Yes” when prompted for “Activate IDoc Inbound?”

    8. Hit on “Back” to return to the main screen.

    9. Click on Continue (F8). Following Screen appears:

    10. Select the Step 1 “Maintain Object Attributes” and select “Execute”.

    11. Select the radio button “Business Object Method” and enter the following details:

    Business Object: BUS2012

    Method: CreateFromData

    Hit ENTER

    12. Save and click on BACK button. Following information message is displayed.

    13. Now select step 2 “Maintain Source Structures” and click “Execute”.

    14. In this step, we need to maintain the source structure. In our example, lets consider the example of a file with 2 structures Head and Item data as shown below:

    Click on Create and name the source structure as HEADERDATA. Now select HEADERDATA and click on “Create” again to create the child structure. Following popup appears:

    Select “Lower Level” and click on Continue. Enter the Item data structure name.

    Click Save and hit BACK button to go to the main screen.

    15. Select step 3 “Maintain Source Fields” and hit execute.

    16. Enter the fields as shown below:

    17. Click SAVE and return to main screen.

    18. Select step 4 “Maintain Structure Relations” and click Execute.

    Select E1PORDCR and click on CREATE RelationShip. Following screen appears:

    Select HEADERDATA and hit ENTER

    Similarly do the same for the structure E1BPEKKOA, E1BPEKPOC and E1BPPEKET.

    Click Save and return to main screen.

    19. Select the step “Maintain Field Mapping and Conversion Rules” and click on execute. Maintain the Field Mapping as seen below:

    20. Select step 7 “Maintain Source Files” and provide the link for the test file created. (Create a test file with the same structure as defined earlier).

    Save and return to main screen.

    21. Select the step “Assign Files” and click on Execute.

    Assign the file provided to the source structure. Here the same file is provided for both the structures.

    Save and return to the main screen.

    22. Select the step “Read Data” and click on Execute.

    Click on Execute.

    Return to the main screen.

    23. Select the step “Display read data” and click on execute.

    Click on the structure name to get the field level values.

    24. Return to main screen and now select “Convert Data”.

    25. Return to the main screen and select “Display Converted data”.

    26. Return to main screen and select “Start IDoc generation”.

    27. Now select the step “Start IDoc Processing” on the main screen.

    28. Return to main screen and click on “Create IDoc overview”. Here the data record and status records of the IDoc could be viewed

    It is given in screen shot.

    http://www.saptechnical.com

    http://smoschid.tripod.com/How_to_do_things_in_SAP/How_To_Use_LSMW/How_To_Use_LSMW.html

    http://www.scmexpertonline.com/downloads/SCM_LSMW_StepsOnWeb.doc

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 17, 2008 at 10:45 AM

    can you be more specific on what you're trying to load?

    also, subject is too broad, forum is wrong (belongs under "Data Transfers")

    next

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 17, 2008 at 10:47 AM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.