topic Re: Method to Upload the Materials Master. in Application Development and Automation Discussions

Method to Upload the Materials Master.

Former Member — Fri, 28 Jun 2013 04:46:13 GMT

Hi,

I am writing the code to upload the Materials Master. I know of a fe methodology.

1. LSMW.

2. Custom Program.

3. BAPI.

Recording/BDC might be used. But I want to Evaluate the Pros and cons, Because depending upon the material type ( MTART ) the views will be different and I may not be able to record the screens in BDC since it changes based on the Material type. I alos have the requirement for QM View and also the Altrenate UOM Screen.

I tried checking the BAPI but there is none for the MM upload. What reamains is the Custom program again in which I will have to write the BDC only.

The BAPI I tried finsing out are 'BAPI_STANDARDMATERIAL_CREATE' and BAPI_RETAILMATERIAL_CREATE but they do not have enough parameters to put in the data for all the view. Also it uses the CALL TRANSACTION MM01 Internally.

We fianlly decided to write a custom program.

Can any one tell me the best Method for the uplaod of the MM master and also how should I select the views based on the Material type.

Regards,

Deepak.

Re: Method to Upload the Materials Master.

Former Member — Fri, 28 Jun 2013 05:01:46 GMT

Hi Deepak,

You have to do BDC recording for each Material type and handle the screen sequence in your program accordingly.

Regards

Praveen

Re: Method to Upload the Materials Master.

Former Member — Fri, 28 Jun 2013 05:07:46 GMT

hi,

Use a BDC and nothing else.

Burzes

Re: Method to Upload the Materials Master.

Former Member — Fri, 28 Jun 2013 05:37:42 GMT

This message was moderated.

Re: Method to Upload the Materials Master.

matt — Fri, 28 Jun 2013 05:44:07 GMT

BDC is the last alternative when nothing else works. As it is reliant on the screen's not changing, it is not a stable solution. I've been using MAINTAIN_MATERIAL_DARK and the BAPIs for material maintenance for over 10 years.

If you are doing a data migration program, then use LMSW, and the material direct input procedure. To use anything else is re-inventing the wheel and a waste of time.

I repeat. Do not use BDC.

Re: Method to Upload the Materials Master.

matt — Fri, 28 Jun 2013 05:44:23 GMT

BDC is the worst solution. This is bad advice.

Re: Method to Upload the Materials Master.

former_member188827 — Fri, 28 Jun 2013 06:16:02 GMT

check "BAPI_MATERIAL_SAVEDATA"

Regards

Re: Method to Upload the Materials Master.

RaymondGiuseppi — Fri, 28 Jun 2013 06:16:41 GMT

In recent years I usually use BAPI_MATERIAL_SAVEDATA (with BAPI_STDMATERIAL_GETINTNUMBER).

Before I used report RMDATIND (LSWM 0020 Material Master, Direct Input) but only for initial loading or big batches of material.

Since 4.6C I don't use BDC when I can, I dislike upgrade projects with BDC to rewrite...

Regards,

Raymond

Re: Method to Upload the Materials Master.

Former Member — Fri, 28 Jun 2013 06:53:09 GMT

Hi Deepak,

Material Master Upload is very basic requirement and you should never ever go for BDC.

SAP has given amazing BAPIs for it.

I will give you two BAPIs/Cases

Case 1 :- Upload 1 material at a time

BAPI_MATERIAL_SAVEDATA

Pros - Good Error handling.

Cons - Comparatively poor performance

Case 2 :- Upload multiple materials at a time

BAPI_MATERIAL_SAVEREPLICA

Pros - Better Performance

Cons - For error handling you need to loop at the return table and segregate the error causes for every material.

Eg :-

Sample Snippet

*-- Head data

ls_headdata_s-function = 'INS'/'UPD' " use INS for new record, UPD for changing record.

ls_headdata_s-material = <uploaded file work area>-matnr.

ls_headdata_s-matl_type = <uploaded file work area>-mtart.

ls_headdata_s-ind_sector = <uploaded file work area>-mbrsh.

.......

APPEND ls_headdata_s TO lt_headdata_s.

*-- Client Data

ls_clientdata_s-function = 'INS'/'UPD' " use INS for new record, UPD for changing record.

ls_clientdata_s-material = <uploaded file work area>-matnr.

ls_clientdata_s-base_uom = <uploaded file work area>-meins.

.......

append ls_clientdata_s to lt_clientdata_s

*-- Similarly form all tables and pass.

CALL FUNCTION 'BAPI_MATERIAL_SAVEREPLICA'

EXPORTING

noappllog = gc_check

nochangedoc = gc_check

testrun = p_test

inpfldcheck = 'W'

IMPORTING

return = ls_ret

TABLES

headdata = lt_headdata_s

clientdata = lt_clientdata_s

clientdatax = lt_clientdatax_s

plantdata = lt_plantdata_s

plantdatax = lt_plantdatax_s

storagelocationdata = lt_storagelocationdata_s

storagelocationdatax = lt_storagelocationdatax_s

valuationdata = lt_valuationdata_s

valuationdatax = lt_valuationdatax_s

salesdata = lt_salesdata_s

salesdatax = lt_salesdatax_s

materialdescription = lt_materialdescription_s

unitsofmeasure = lt_unitsofmeasure_s

unitsofmeasurex = lt_unitsofmeasurex_s

internationalartnos = lt_internationalartnos_s

materiallongtext = lt_materiallongtext_s

taxclassifications = lt_taxclassifications_s

extensionin = lt_extensionsin_s

extensioninx = lt_extensionsinx_s

returnmessages = lt_return2.

Call BAPI_TRANSACTION_COMMIT.

Please revert if you do not understand. I have my code also which you need i can mail you.

BR.

Re: Method to Upload the Materials Master.

venkateswaran_k — Fri, 28 Jun 2013 07:04:14 GMT

I generally use '

BAPI_MATERIAL_SAVEDATA

It is a working solution for me for many implementations....

Yes, It is comparitively slow, but considering the case as a one time job during materdata upload phase, we generally go with this BAPI...

Do not use BDC in this case....

Regards,

Venkat

Re: Method to Upload the Materials Master.

Former Member — Fri, 28 Jun 2013 07:49:20 GMT

Hey there,

The last weeks i imported material with LSMW. Therefore you can use the BMV0 where you got a quit good logging function.

Cons:

If you customize the transaction mm01 that some field are not showen for specific material you will run into trouble. The filed PRDHA wasn't displayed in mm01 for some types of material, so i got the error:

The field MARA-PRDHA is not ready for input and was therefore not initialized

Haven't tried the bapis right now.

Regards,

Nikolaus

Re: Method to Upload the Materials Master.

Former Member — Fri, 28 Jun 2013 09:07:16 GMT

Hi Deepak,

for uploading the MM records, you can use the LSMW, in that use direct input method (Object:0020), you can get lot of option and it will give you the structure for all the views and you can select the required fields and one important thing is only map the required source structure to target structure (if you map all the source structure to target structure then it will ask to input data which you may not required).

Please let me know for any clarification.

Regards,

Santosh.

Re: Method to Upload the Materials Master.

Former Member — Fri, 28 Jun 2013 09:15:29 GMT

Hi Nikolaus,

please map the source structure with the target structure and target structure is BMMH1 - Material Master: Transfer of Main Data, in this structure the filed is present (PRDHA-Product hierarchy- Type:CHAR, Length: 018)

Please let me know for any clarification.

Regards,

Santosh.

Re: Method to Upload the Materials Master.

Former Member — Fri, 28 Jun 2013 11:23:01 GMT

Hello Santosh,

Thanks for help, but I already "solved" this problem. I displayed the field again and was able to map it and transfere the data.

But before i done this, i tried to map the field with the value of the *.csv i used, with an empty sting ('') or with the NODATA sign, but everything without success.

Best regards,

Nikolaus

Re: Method to Upload the Materials Master.

Former Member — Tue, 24 Sep 2013 07:51:16 GMT

Hello Ankit,

Will you be be able to share the codes for uploading mass material master. I want to extend material master from storage location to storage location managed warehouse and WH views.

We have huge list of material master so we want the fastest way to upload material master. Which will be a faster way to extend material master for storage location and WH views:

1. Bapi - BAPI_MATERIAL_SAVEREPLICA

2. LSMW Standard batch input method

Faster reply will be really helpful

regards

Anand

Message was edited by: Suhas Saha

Re: Method to Upload the Materials Master.

Former Member — Tue, 24 Sep 2013 07:51:50 GMT

Hello Ankit,

Will you be be able to share the codes for uploading mass material master. I want to extend material master from storage location to storage location managed warehouse and WH views.

We have huge list of material master so we want the fastest way to upload material master. Which will be a faster way to extend material master for storage location and WH views:

1. Bapi - BAPI_MATERIAL_SAVEREPLICA

2. LSMW Standard batch input method

Faster reply will be really helpful

regards

Anand

Message was edited by: Suhas Saha

Re: Method to Upload the Materials Master.

Former Member — Tue, 24 Sep 2013 09:00:41 GMT

Hi Anand,

Please open a new thread since it will get your query more visibility. As far as code i concerned, mention your email id and i will send my code.

BR.

Re: Method to Upload the Materials Master.

madhu_vadlamani — Tue, 24 Sep 2013 09:14:37 GMT

Hi Anand,

Lsmw Standard batch\Direct input methods is really good. I used this one to upload more than 50 k materials with one by one views.You can get all most all the fields which we can see in material master .

Regards,

Madhu.

Re: Method to Upload the Materials Master.

Former Member — Tue, 24 Sep 2013 09:46:45 GMT

Hello Madhu,

I want to extend the material master not create a new material master so I am wondering if we can use standard batch\Direct input method or not, as i only want to extend sloc and WH views.

Hello Ankit,

I want to upload more than 500,000 material master in background. Using BAPI how to upload so many materials in background as I think BAPI don't execute in background and then we also need log to analyse in case of any errors.

regards

Anand

Message was edited by: Matthew Billingham - email address removed

Re: Method to Upload the Materials Master.

Former Member — Tue, 24 Sep 2013 10:09:21 GMT

Hi Anand,

As requested please open a new thread. BAPIs(just another function module) are used in programsand can be run in both foreground/online or background mode.

BR.