topic Re: LSMW-BATCH INPUT SESSION in Application Development and Automation Discussions

LSMW-BATCH INPUT SESSION

Former Member — Sun, 09 Dec 2007 18:32:09 GMT

Hi,

Can any one plz send me the steps for LSMW with BATCH INPUT SESSION Method.

Regards

Re: LSMW-BATCH INPUT SESSION

Former Member — Sun, 09 Dec 2007 19:29:52 GMT

Hi Lakshmi,

Step-by-Step Guide for LSMW using Batch Input Recording :

1) Maintain Object attributes : Choose radio button Batch Input Recording and click on the recording overview icon to record the R/3 transaction. Enter the Recording name

2) Maintain Source Structures : Give a name and a description to the source structure .

3) Maintain Source Fields : In this step, you need to list what fields are present in the source structure. The easiest way is to click on ‘Table Maintenance’ icon to enter Fieldname, Type and Length for each field

4) Maintain Structure Relations : Execute a step to ‘Maintain Structure Relations’. Since, there is only one Source and Target Structure, the relationship is defaulted automatically.

5) Maintain field mapping and conversion rule: If target field names and source fields are same then u can perform auto-mapping at utilities. Or else assign each source field to ur target field manually.

6) Maintain fixed values, translations, user-defined routines:

You can also maintain re-usable translations and user-defined routines, which can be used across conversion tasks. In this case, that step is not required.

7) Specify files : In this step, we define how the layout of the input file is. The input file is a [Tab] delimited with the first row as field names. It is present on my PC (local drive) as C:\XD02.txt.

😎 Assign files:

Execute step ‘Assign Files’ and the system automatically defaults the filename to the source structure.

9) Read data :

In this step, LSMW reads the data from the source file (from your PC’s local drive). You have the option to read only selected rows and convert data values to Internal format.

10) Display read data:

This step is optional. If required, you can review the field contents for the rows of data read.

11) Convert data:

This is the step that actually converts the source data (in source format) to a target format. Based on the conversion rules defined, source fields are mapped to target fields.

12) Display Converted data:

Again this is an optional step to view how the source data is converted to internal SAP format .

13) Create batch input session:

Once the source data is converted in an internal format, you can create a batch session to process updates.

14) Run Batch Input Session:You can execute the BDC session by Run Batch input session. Executing a batch input session is a standard SM35 transaction for managing BDC sessions. Once you have successfully executed the batch input session, the customer master records are updated in the system. You can confirm this by viewing the customer master records

check these links :

SDN blog:

/people/hema.rao/blog/2006/09/14/lsmw--step-by-step

Regards,

Satish

Re: LSMW-BATCH INPUT SESSION

Former Member — Mon, 10 Dec 2007 05:30:12 GMT

with screen shots

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

TIPS

How to develop a lsmw for data migration for va01 or xk01 transaction?

You can create lsmw for data migration as follows (using session method):

Example for xk01 (create vendor)

Initially there will be 20 steps but after processing 1 step it will reduced to 14 for session method.

1. TCode : LSMW.

2. Enter Project name, sub project name and object name.

Execute.

3. Maintain object attributes.

Execute

select Batch Input recording

goto->Recording overview

create

recording name.

enter transaction code.

start recording

do recording as per ur choice.

save + back.

enter recording name in lsmw screen.

save + back

Now there will be 14 steps.

2. MAINTAIN SOURCE STRUCTURES.

Here you have to enter the name of internal table.

display change

create

save + back

3. MAINTAIN SOURCE FIELDS.

display change

select structure

source_fields->copy fields.

a dialogue window will come .

select -> from data file

apply source fields

enter No. of fields

length of fields

attach file

save + back

4. MAINTAIN STRUCTURE RELATIONS

display change

save + back

5. MAINTAN FIELD MAPPING & CONVERSION RULE

display change

click on source field, select exact field from structue and enter

repeat these steps for all fields.

save+back

6. MAINTAIN FIXED VALUES, TRANSACTION, USER DEFINED

execute

save + back

7. SPECIFY FILES.

display change

click on legacy data

attah flat file

give description

select tabulatore

enter

save + back

8. ASSIGN FILE

execute

display change

save + back

9. IMPORT DATA.

execute

display change

save + back

10. DISPLAY IMPORTED DATA

enter ok, it willl show records only.

back

11. CONVERT DATA

execute

display change

save + back

12. DISPLAY CONVERTED DATA

execute

display change

save + back

13. CREATE BATCH INPUT SESSION

tick keep batch input folder

back

14. RUN BATCH INPUT SESSION.

sm35 will come

Object name will be shown here

select object & process

Re: LSMW-BATCH INPUT SESSION

Former Member — Mon, 10 Dec 2007 05:41:33 GMT

Hi,

Check the link updated in my blog.

http://theguruspeaksaboutsap.blogspot.com/2007/07/lsmw-step-by-step-demo-example-1-lsmw.html

Reward if helpful.

Regards,

Harini.S

Re: LSMW-BATCH INPUT SESSION

Former Member — Mon, 10 Dec 2007 06:50:03 GMT

Hi Lakshmi ,

Pls give me u'r mail ID so that i can forward some dcouments .

cheers!

gyanaraj

Re: LSMW-BATCH INPUT SESSION

Former Member — Mon, 10 Dec 2007 12:47:46 GMT

THANKS A LOT TO ALL ....WHICH HELPED ME OUT ALOT.