cancel
Showing results for 
Search instead for 
Did you mean: 

Lsmw recording

Former Member
0 Kudos

Hi Experts,

I want to upload data for TCODE ME41 with multiple service items by using LSMW recording method. can anyone give me the detailed steps to do.

Accepted Solutions (0)

Answers (6)

Answers (6)

former_member188685
Active Contributor
0 Kudos

1) Now go to LSMW, Create Project, sub project and object.

2) In the process step 1 Maintain Object Attributes

Select the Batch input recording radio button, Go to, GOTO -> Recording Overview, Create the recording name and description.

It will ask the transaction code, for this give the transaction code created above.

Record the table entries and save the recording. After coming back give the recording name in the above screen. Then go to recording overview. Go in change mode and Press Default all button on the Application tool bar. Back and save.

3) In the next step of the LSMW, Create the Source structure.

4) In the next step of the LSMW, Maintain Source Fields, attach the table fields to the above source structure.

5) In the step ‘Maintain Field Mapping and Conversion Rules’ go in the change mode and press Extras - > Auto-field mapping. Then save and come back.

6) In the step ‘Specify Files’, give the uploading file name.

Regards

vijay

Former Member
0 Kudos

U have to get this coding block in LSMW,with this u can upload multiple line items .

what u have to do is , do a recording with no of possible entries (say 20 items ), so it will create loop nothing but page down in that table control.

sample code :


                                                                                5  MP058600 2000                                                                                
BDC_CURSOR                     Q0586-PINVT(12)                                                                                
BDC_OKCODE                     /00                                                                                
Q0586-PINVT(01)                                     PINVT_01             Proposed investment                    
                Q0586-PINVT(02)                                     PINVT_02             Proposed investment                    
                Q0586-PINVT(03)                                     PINVT_03             Proposed investment                    
                Q0586-PINVT(04)                                     PINVT_04             Proposed investment                    
                Q0586-PINVT(05)                                     PINVT_05             Proposed investment                    
                Q0586-PINVT(06)                                     PINVT_06             Proposed investment                    
                Q0586-PINVT(07)                                     PINVT_07             Proposed investment                    
                Q0586-PINVT(08)                                     PINVT_08             Proposed investment                    
                Q0586-PINVT(09)                                     PINVT_09             Proposed investment                    
                Q0586-PINVT(10)                                     PINVT_10             Proposed investment                    
                Q0586-PINVT(11)                                     PINVT_11             Proposed investment                    
                Q0586-PINVT(12)                                     PINVT_12             Proposed investment                    
                BDC_SUBSCR                     SAPMP50A                                                                                
5  MP058600 2000                                                                                
BDC_CURSOR                     Q0586-PINVT(12)                                                                                
BDC_OKCODE                     /00                                                                                
BDC_SUBSCR                     SAPMP50A                                                                                
5  MP058600 2000                                                                                
BDC_CURSOR                     Q0586-PINVT(11)                                                                                
BDC_OKCODE                     /00                                                                                
Q0586-PINVT(01)                                     PINVT_13             Proposed investment                    
                Q0586-PINVT(02)                                     PINVT_14             Proposed investment                    
                Q0586-PINVT(03)                                     PINVT_15             Proposed investment                    
                Q0586-PINVT(04)                                     PINVT_16             Proposed investment                    
                Q0586-PINVT(05)                                     PINVT_17             Proposed investment                    
                Q0586-PINVT(06)                                     PINVT_18             Proposed investment                    
                Q0586-PINVT(07)                                     PINVT_19             Proposed investment                    

Regards

Prabhu

rao_peram@yahoo.com

PIH

Former Member
0 Kudos

Hi Silviya,

in case of multiple line items upload, it is advisable not to use LSMW as it requires an additional program logic for incrementing the line for every item..so its better u go for a BDC for the same...

REgards..

Bikash

Former Member
0 Kudos

Hai Silviya

Go through the following Links & Steps

LSMW

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

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

http://sapabap.iespana.es/sapabap/manuales/pdf/lsmw.pdf

http://www.sap.info/public/INT/int/glossary/int/glossaryletter/Word-17643ed1d6d658821_glossary/L#Wor...

Go through the following 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

😎 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

Thanks & regards

Sreeni

Former Member
0 Kudos

HI

GOOD

GO THROUGH THIS LINK WHICH WILL GIVE YOU DETAIL INFORMATION REGARDING THE STEP BY STEP PROCEDURE OF LSMW RECORDING.

YOU CAN USE ACCORDINGLY FOR THE TCODE ME41

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

http://www.qsands.com/QSandS_LSMW.pdf

http://www.sap4.com/viewlink-29.html

THANKS

MRUTYUN