Program for Material Master

[Former Member]

Dear All,

i have a requirement in which i need to develop a LSMW/BDC/BAPI for updating material master.

the user will upload an excel sheet with all the necessary fields in a specified format (if BDC is used).

i came across a t-code MMZ1 for creation of a material. the tcode is similar to MM01.

the difference i observed was that that in MM01 the views are of dynamic nature whereas in MMZ1 the views are of static nature.

i request all to further differentiate between MM01 and MMZ1 and also if i go for LSMW, which tcode will be more appropriate? MMZ1 or MM01 and why?

Thanks & Regards,

[JL23 · Accepted solution]

Thousand times answered

you must not load material masters using recording method.

SAP has a predefined direct input method in LSMW, as well as BAPI method for LSMW, and an IDOC method to be used in LSMW.

Pleanty of options, just do not use recording.

MMZ1 is a transaction from the last millenium, its advantage is that the view selection is not dynamic like in MM01, hence it is easier for recording.

however in material master the fields are dynamic, one field becomes mandatory if in another field is a certain value. You cannot control this in a recording, except you create for every variance a sepearate recording.

All this is not needed if you use one of the SAP given methods.

[Former Member · Accepted solution]

Many thanks for your reply. i will be really helped if you can suggest any SAP methods u discussed in detail for my purpose.

[sjeevan · Accepted solution]

If you do a google search you will find a lot of SCN links and third party website (some including screen shots) about how to upload material master using direct input (RMDATIND)

In Maintain Field Mapping and Conversion Rules maintain transaction code as MM02 for updating material master.

Like for example

http://scn.sap.com/thread/1653619

[BijayKumarBarik · Accepted solution]

Hi,

You want update material master ie...after materials are created,you need to change the values of a field for several materials, so then better use t.code:MM17.

The t.code: MMZ1 is used to extend  materials from one plant to another plant  (for used material) only.

The t.code: t.code MM01  is also used to extend  materials from one plant to another plant.

As you needed you can go for t.code: MM17 or can develop a recoding method LSMW/BDC Or use BAPI

Regards,

Biju K

[JL23 · Accepted solution]

as always in SAP, the 1 at the end of a transaction is create, the 2 is change.

so MMZ2 is the very old change transaction