LSMW(Direct Input) Material master issues

[Former Member]

Hi,

I have few issues on Material master-LSMW(Direct Input-RMDATIND) data upload(creating materials).

1. Can i upload excel sheet for uploading data! What option i have to choose in 'specify files' for this!

2. I am using fields MBRSH, MTART, MAKTX, MEINS, BISMT, MATKL, MAGRV for mapping.

But when i tried to upload in last step-start direct input program with Lock Mode-'N' it is giving error as

'Plant data does not exist'. Because this is for 'Basic Data' i though no need to input plant.

3. MATNR field is not needed for creation right as it is auto generated!

4. I have to do seperate object for this project for 'Sales organization data' & Plant Data is there any checks needed for the same!

Can anybody give solutions for the above!

Thanks in advance.

Thanks,

Deep.

[Former Member]

Hello ,

I think Plant field is mandatory when u r creating the material ...

Regards

[shishupalreddy]

Hello ,

I think Plant field is mandatory when u r creating the material ...

Regards

[Former Member]

2nd issue is resolved. Plant is not required for basic data.

I have one more issue.

6. My flat file is having 2 records, But i am able to create material for 1st only. For 2nd record it always says material type does not exist. Any special check we need to do to process multi records!

[shishupalreddy]

Hello,

Check if the Material type is specified in u r file ....

REGARDS

[Former Member]

1. Now i am trying to process 4 records it is creating 3 records.

It is always skipping 1st record in flat file.

Any check required!

2. Also i want to write a output file(log file) to my presentation/application server with all material no's created & material descriptions. Where can i do the same!

3. Can anybody tell me how to upload using excel sheet.

Thanks,

Deep.

Edited by: Deep on May 14, 2009 3:21 PM