topic Re: Material Master Data upload - LSMW(Direct Input) in Application Development and Automation Discussions

Material Master Data upload - LSMW(Direct Input)

Former Member — Fri, 15 May 2009 08:16:13 GMT

Hi All,

I have few issues in LSMW direct input method.

1. While creating LSMW project system is not asking for any package (or) not creating anr TR. How can we assign Dev.Class(package) & create TR for all LSMW objects!

2. How to upload Excel sheet data through LSMW(DI). I am only able use .txt type files only. Can anybody tell me how to make use of Excel file for data upload in 'Specify files' step.

3. I want to write a output/log file into application server. With created material no, legacy material no(Need to pick from input file) & material description. How & where i need to write code for the same.

4. I have to input multiple plants for single material which will be specified in input file. How & where i need to write logic for the same!

I am able to create materials for but if we give 2nd & 3rd plants in 2nd & 3rd row with no other data i need to store those plants under same material in 1st row.

Can anybody solve my above issues in LSMW - Direct input(RMDATIND) method.

Thanks in advance.

Thanks,

Deep.

Re: Material Master Data upload - LSMW(Direct Input)

Former Member — Fri, 15 May 2009 08:27:32 GMT

when you create the LSMW its not asking the package (or) not creating anr TR.

once you create the LSMW , then goto EXTRAS in menu there you find the GENERATE CHANGE REQUEST clikc the its will ask he package and TR.

you can use only .txt file.

you can write ABAP code in step 5 Maintain Field Mapping and Conversion Rules

you have to append all your error one internal table and foloow the below logic

Open data set

Read dat set

Transfer

in LSMW itself in the STEP 5

Re: Material Master Data upload - LSMW(Direct Input)

Former Member — Fri, 15 May 2009 08:53:28 GMT

Hi,

Thank you for your quick reply.

1. I have 3 objects under same project. Will they be stored under same TR. If we hit 'Generate CR" once (or) we need to save each object under different TR! Also it is not having any task. is it correct!

Also it is not asking for any package/Dev.Class is that fine!

2. Are you sure we can't use excel files for data upload in LSMW! I am working in SAP ECC 6.0.

once again thanks for your quick reply.

Thanks,

Deep.

Re: Material Master Data upload - LSMW(Direct Input)

Former Member — Fri, 15 May 2009 09:27:18 GMT

any number of objects in one project will transfer all objects with single TR

not psoobile iwth XLS file to upload the data

its very easy to convert the data from Xls to txt file

copy the all entries in XLS file past the entries to txt file then you use TAB delimeter...

Re: Material Master Data upload - LSMW(Direct Input)

Former Member — Fri, 15 May 2009 09:40:43 GMT

Hi Kesav,

User wants to upload using .XLS only.

More so every time he will not be able to save the data in .xls into .txt.

.csv i tried but it is giving some junk characters.

Thanks,

Deep.

Re: Material Master Data upload - LSMW(Direct Input)

Former Member — Fri, 15 May 2009 09:51:24 GMT

no otherway..

Open your flat file in excel and then click 'save as' . in the dialog box that appears, you have to select the file type as 'text(tab delimited)' and then save it. it will be stored as a '.txt' file. Then in lsmw, when you specify the file, specify it as 'tabulator' .

Re: Material Master Data upload - LSMW(Direct Input)

Former Member — Tue, 19 May 2009 06:17:49 GMT

Hi,

I have few more clarifications.

1. I have one field (MARC-LOSGR) which is QUAN(13) in DB table. What will be the corresponding type in LSMW!

2. What will be the corresponding CUKY type in LSMW!

3. In LSMW tough i am selecting 'Start Direct Input Program' from user menu it is not displayed in the screen tough method i am using is 'Direct Input' only! Can anybody solve this!

Thanks in advance.

Thanks,

Deep.