cancel
Showing results for 
Search instead for 
Did you mean: 

Mass update through LSMW

Former Member
0 Kudos

hi friends,

I want to do mass update in material master -units of measure in additional data of material.

It is not only to change ,

it should possible to update (create, change or delete) additional data corresponding to the values in the excel file

client is preferring LSMW with Batch input method.

I think these fields are not in Tables,it's available in SMEINH structure...

how to acheive this?? how much time it will take???

thanks

raj

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

In the LSMW of std Materil master batch input program you will find the structure BMMH6

this you can use to for additional data tab fields.

now you can try this for insert and change i don't know it will work for deleter or not.

Former Member
0 Kudos

how we do the recoding ??

supose in my case in excel sheet the first field is "observation".

in this observation collumn the value is X then system should delete the entire line...

kindly help me

regards

raj

Former Member
0 Kudos

Recording will not work for this either you create the BDC program or use std LSMW which i have wrote in my previous reply

Former Member
0 Kudos

Hi Charlie

I tested the uploading additional units of measure with LSMW recording and succesfully uploaded.

We can record and upload .

Thanx

Rammohan.

Former Member
0 Kudos

That will work if you have one line of alternate UOM but diff material will have more or less Uom

try one material with 1 Uom and another with more than one Uom.

Former Member
0 Kudos

hi,

anyway we planed to do with BDC..

clent needs report (after running BDC how many material is update & deleted ) also.

i never did bdc earlier...

how to do and which t code i will suggest to report???

how BDC will work

thanks

Edited by: raj rajan on Jun 4, 2009 6:54 PM

Answers (1)

Answers (1)

Former Member
0 Kudos

HI,

Maitain the Additional data in the relavant field of Excell file.

Do the LSMW as normal of 16 stpes , so it will up date.

Regards,

Andra