LSMW - Structures for creating customer in R/3

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

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

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