on 05-26-2006 3:58 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi silviya,
Check the Help for LSMW steps.
http://www.scmexpertonline.com/downloads/SCM_LSMW_StepsOnWeb.doc
http://www.sap-img.com/sap-data-migration.htm
http://www.sapgenie.com/saptech/lsmw.htm
http://www.allsaplinks.com/lsmw.html
http://www.sap-img.com/sap-data-migration.htm
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.sapbrain.bravehost.com/LSMW/lsmw_steps.html
http://www.esnips.com/doc/7582d072-6663-4388-803b-4b2b94d7f85e/LSMW.pdf
regards,
Naveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.