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

LSMW - Structures for creating customer in R/3

Hi

I am trying to inport new customers records into R/3 system using LSMW. I failed to identify the structures and field information.

Please suggest me how to find the structures.

I will be thankfull if u could help me.

Urs shyam.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 27, 2005 at 08:39 AM

    Hi shyam,

    try with below links it may help you.

    http://www.sap-img.com/sap-data-migration.htm

    http://help.sap.com/saphelp_erp2004/helpdata/en/87/f3ae74e68111d1b3ff006094b944c8/frameset.htm

    hope this also helps you.

    Create project, Subproject, Object (freely definable, for the purpose of

    identification) – Use create icon in the menu. For example

    Project FI Finance

    Subproject GL GL MASTER

    Object GL GL Master

    2. Continue F8, Now you will see series of steps. Select the step and execute

    it (Ctrl-F8). In each steps, we will do some activity and save it. Then

    system prompts for the next activity.

    3. Maintain object attributes. By default the screen in display mode, Click

    on ‘pencil button’ to get into change mode. (This is applicable to upto the

    activity assign files). In this screen select ‘Batch input recording’ and

    in ‘Recording’ give name (freely definable) sal ‘GL01’ and click on Overview.

    In this screen button (Recordings overview). Now click on create button for

    recording. Give name and description, Now it will ask for the transaction

    code, enter the transaction code and enter the data, the way you want fill in

    the SAP screens/fields with legacy data. Then save the transaction. Now save

    again to save the recording. After that you select the button ‘default all’,

    then save it. And come back, now the cursor is on next activity.

    4. Maintain source structures. Here create the structure by specifying name

    (freely definable).

    5. Maintain source fields. In this screen, click on ‘copy fields’ (Ctrl+F8),

    here select ‘From data file(field names in 1st line)’. Now the system asks

    for the file, select your text file, the system will copy the fiedls from

    text file (tab delimited file. It contains field names in the first row).

    Save it.

    6. Maintain structure relations. Generally, we need not do anything here.

    7. Maintain field mapping and conversation rules. Here put the cursor on the

    field and click on source field, now you can see the list of field available,

    from which select one which is equal to the field on which you out the

    cursor. You can also write coding (ABAP Code) on any field for the purpose of

    validation of data. Save it.

    8. Maintain fixed values, translations, user-defined routines. Here also you

    can maintain values, if required.

    9. Specify files. In this screen, place the cursor on Legacy data, then click

    on create button. The system asks for the file name, (the text file, in which

    the legacy data is there), enter the file name, description and select Data

    for one source structure (table), delimiter as ‘Tabulator’, file structure

    as “Field names at the beginning of the file”.

    10. Assign files. The file name you specified in earlier step comes

    automatically here, If the file name does not come, then click

    on ‘assignment’ button and assign the file.

    11. Read data. Here specify the ‘transaction number’ (the number not less

    than the number of rows in the text file). Execute it.

    12. Display read data. Here, you can see the values, how the system read the

    data.

    13. Convert data. Here specify the ‘transaction number’ (the number not less

    than the number of rows in the text file). Execute it.

    14. Display converted data. Here, you can see the values, how the system

    converted the data, after interpreting conversion rules specified in the

    earlier steps. This is the data that is actually goes into SAP, once the

    Batch Input session is run.

    15. Create batch input session. Specify the ‘batch input session’ name for

    identification and also select the ‘keep session’.

    16. Run Batch Input Session. Select the batch input and click ‘Process’, from

    there select ‘foreground’ or ‘background’. Now the program runs and update

    the data in to SAP. You can analyze the batch input for the successful

    postings, errors.

    reward points for helpful answers and close the thread if your question is solved.

    regards,

    venu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 27, 2005 at 08:48 AM

    If you are using IDOCS you will ahve to convert your source file into following structures. These can be seen in SE11 .

    E1KNA1M

    E1KNA11

    E1KNVVM

    E1KNVPM

    E1KNVIM

    E1KNB1M

    E1KNVKM

    You can also display in SE30 IDOC type DEBMAS03.

    Cheers

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 27, 2005 at 08:59 AM

    Shyam,

    Search for any Transaction exist that feeds the customer records into the R/3. If you find one, go with the BDC way of inserting the Data into the R/3.

    Thanks

    Kam

    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.