help regarding LSMW

[Former Member]

hi ,

i am new to SAP. actually i am trying to update vendor master data for the following fields using LSMW.

LIFNR BUKRS EKORG KTOKK TITLE_MEDI NAME1 NAME2 SORT1

REMARK KUNNR STCD1 STCD2 BANKS BANKL BANKN BKONT LNRZA

AKONT ZUAWA QSSKZ QLAND QSREC ALTKN PERNR ZTERM TOGRU

REPRF ZWELS ZAHLS LNRZB HBKID INCO1 INCO2 KALSK WEBRE

WAERS BSTAE PARVW GPARN

in Maintain Object attributes i have declared it as standard batch/direct input using object (0040),method standard,program name(rfbikr00),program type (b)

while trying to upload it i am getting an error saying that transaction Xk01 is not supported. please help me regarding this and the method to upload the vendor master data into sap sys from a legacy sys in LSMW method.

[Former Member]

hi ,

i am new to SAP. actually i am trying to update vendor master data for the following fields using LSMW.

LIFNR BUKRS EKORG KTOKK TITLE_MEDI NAME1 NAME2 SORT1

REMARK KUNNR STCD1 STCD2 BANKS BANKL BANKN BKONT LNRZA

AKONT ZUAWA QSSKZ QLAND QSREC ALTKN PERNR ZTERM TOGRU

REPRF ZWELS ZAHLS LNRZB HBKID INCO1 INCO2 KALSK WEBRE

WAERS BSTAE PARVW GPARN

in Maintain Object attributes i have declared it as standard batch/direct input using object (0040),method standard,program name(rfbikr00),program type (b)

while trying to upload it i am getting an error saying that transaction Xk01 is not supported. please help me regarding this and the method to upload the vendor master data into sap sys from a legacy sys in LSMW method.

[Former Member]

Hi Deepthi,

I dont think you should get any problem in first step. Just enter the values for direct input. Did u enter anywhere xk01 ? Just try again. Its not a big problem.

Regards,

Varun.

[Former Member]

hi varun ,

thanks for the reply

can u tell me how do i define the structure do ineed to define separate structures for general vendor data and the bank data.can u tell me the brief description of uploading vendor master data form the legacy system using lsmw.plz help me out i am new to this feild.

with regards,

deepthi

[Former Member]

HI deephi

follow the below steps

4.4.2.2.3 Importing Vendor Master Data

Use

The purpose of this activity is to import vendor master data via LSMW using Batch Input.

Prerequisites

You have imported the LSMW project BP_AIO into your system.

Specifying LSMW Project Details

1. Access the activity using the following transaction code:

Transaction Code LSMW

2. Confirm the information message Welcome to the Legacy System Migration Workbench.

3. On the Legacy System Migration Workbench screen, enter the following values:

Field name Description User action and values Notes

PROJECT Name of data transfer project BP_AIO More than one subproject can be assigned to a project.

SUBPROJ Specifies the name of the subproject MM A subproject can have an unlimited number of objects

OBJECT Object name. An object corresponds to a business object. VENDORS_FINAL An object is assigned to a subproject

4. Choose Continue. The LSM Workbench: BP_AIO MM, VENDORS_FINAL screen is displayed.

You can change the default view from display mode to change mode. To do this, choose Double Click=Display.

Specifying an External File

If an external file has already been specified, only change the file name of the existing file. Do not add or create any additional files.

1. In the LSM Workbench: BP_AIO, MM, VENDORS_FINAL screen, start the process step Specify Files and go into change mode, if you are in display mode.

2. In the LSM Workbench; Specify Files (Change) view, go to the structure item Legacy Data - On the PC (Frontend). Double-click on the object file entry that is located directly under Legacy Data - On the PC (Frontend). The File on Front End: Maintain Properties entry screen is displayed. Enter the following values:

Field name Description User action and values Notes

File LSMW data file name Specify the path and name of the external data file or browse for the external data file

Name Object type Specify the name of the object type

File Contents Select the radio button

Data for One Source Structure

Separators Tabulator Check file for separators, if necessary

File Structure Choose Field Names at start of File

File Type Select the radio button

Record End Marker (Text File)

Code Page Select ASCII

3. Choose Continue, save your file settings and choose Back.

Assigning a File

Omit this activity if an external file has already been specified and assigned.

1. To assign an external file, double-click on the process step Assign File.

2. In the LSM Workbench: Assign File view, select the first line highlighted in yellow and choose Assignment. The file you have specified in the previous step is assigned. Repeat this for each entry highlighted in yellow until you have assigned the file assigned to each structure.

Importing Data from Files

1. To import the data from the assigned files, double-click on the process step Import Data.

2. Choose Execute without entering any values. Go back to the Process Step list

Converting Imported Data

1. To convert the imported data, double-click on the process step Convert Data.

2. Choose Execute without entering any data. Go back to the Process Step list.

Creating Batch Input Session

1. Double-click the step Create Batch Input Session.

2. In the Batch Input interface for Vendors screen, choose Execute, confirm the messages which are displayed. If a batch input session was created successfully the message Session 1 session name VENDORS_FINA was created is displayed.

Running Batch Input Session

1. Double-click the step Run Batch Input Session.

2. On the Batch Input: Session Overview screen, select the session you have created in the step before. If the batch input session was created correctly, New is displayed in the column Status.

3. Choose Process.

4. In the dialog box Process Session vendors_Fina, choose a processing mode.

5. Choose Process.

6. In case of foreground processing, select Enter till the data is imported.

7. In case of background processing, the system message 1 session transferred to background processing is displayed.

8. In case of errors, solve them and run through the process again.

Possible problems might be:

• Configuration does not fulfill the master data requirements (CATT and manual processing of the transaction would also fail)

• External master data file is not stored as tab separated file

• Other data inconsistencies

Result

You have created vendor master data.

regards

kishore

[Former Member]

hi kishore,

thanks for the reply

actually i dont have the SAP Best Practices documentation CD to upload the BP_AIO project. can u suggest some other method.

regards,

deepthi.

[Former Member]

Hi Deepti,

After completing the step one, do the following:

1) Go to step 2(Maintain source structures). Click on button "Create Structure". Give any name and description to the structure. Save.

2) Go to step 3(Maintain source fields). Select the structure and click on button "Create field". Specify the first field(Eg LIFNR), description, length and type. Don't change the Type from C(Char).

Select the first field(LIFNR) and click on button "Create field". Specify the second field(Eg BUKRS), description, length and type. Again, don't change the Type from C(Char). Follow the same procedure to create the structure for all the fields in the incoming file. Save.

3) Go to step 4(Maintain structure relations). Select the first structure(BGR00) and click on button "Relationship". It will relate the structure created by you in step 2 to the structure BGR00. Repeat this for all the structures(Eg BLF00, BLFA1..etc). Save.

4) Go to step 5(Maintain field mapping and conversion rules). Select field TCODE of structure BLF00 and click on button "Constant". Give XK01.

Select field LIFNR of structure BLF00 and click on button "Source field". Select field LIFNR from the structure you created in step 2.

Repeat this to map all the fields which needs to be mapped with the fields of incoming file. Save.

5) Go to step 6(Maintain fixed values, translations, user-defined routines). Don't do anything. Save.

6) Go to step 7(Specify files). Select "Legacy data On the PC (frontend)" and click on "Create" button. A pop up window will ne open. Select the file path using F4 help. Specify the description, Delimiter and Fiel Structure. Save.

7) Go to step 8(Assign files). File assignment will be shown. Don't do anything. Save.

😎 Just execute the remaining steps one by one and your process will be completed.

Hope it helps.

Regards,

Neeraj Gupta

[Former Member]

hi neeraj,

thanks for the reply .

if i am using recording technique to record xk01 i am not getting these fields

AKONT ZUAWA QSSKZ QLAND QSREC ALTKN PERNR ZTERM TOGRU

REPRF ZWELS ZAHLS LNRZB HBKID INCO1 INCO2 KALSK WEBRE

WAERS BSTAE PARVW GPARN

is this screen disabled or how do i need to activate this screen.

regards

deepthi

[Former Member]

Hi deepthi,

u need not record the transaction as u r using direct input method.

Also, the names of these variables may differ in these 2 cases, ie transaction & direct input structures.

Hope it helps,

Regards,

Bikash

[Former Member]

hi bikesh,

thanks for the help it was very help ful to me.

but i am getting the following error.

03/16/2006 Batch Input Interface for Vendors 1

-

---

FB012 Session 1 : Special character for 'empty field' is /

FB007 Session 1 session name VENDOR5 was opened

FB109 Trans. 1 : Transaction xk01 is not supported

FB016 ... Last header record ...

FB014 ... BLF00-STYPE 1

FB014 ... BLF00-TCODE xk01

FB014 ... BLF00-LIFNR Best1

FB014 ... BLF00-BUKRS /

FB014 ... BLF00-EKORG /

FB014 ... BLF00-KTOKK 0001

FB013 ....Editing was terminated

[Former Member]

Hi Deepti,

I am also facing the same problem in LSMW..this same error I am getting now.Did u solve this problem? If yes kindly send the solution as soon as possible.

Thx..