Mass upload to /SCWM/BINMAT - Maintain fixed Bins

[jaymin_thakkar05]

Hi Aall,

Is there any way to upload fixed bin mappings using CSV file etc?

I know the transaction /scwm/binmat but here we can't upload for all fixed bins through csv etc.

I tried using LSMW / SHDB ,but as on subscreen ALV grid is there which is not possible to record.

Please suggest alternate solution or if any bapi/fm available.

[JuergenPitz · Accepted solution]

Hi,

pls see http://scn.sap.com/thread/3604732.

Brgds

Juergen

[jaymin_thakkar05 · Accepted solution]

Hi,

Ya i read ur comment, but I did not understand which tool you are talking about.

Can you let me know which tool can be used & how can I open as I am new to EWM, this is my first object.

[JuergenPitz · Accepted solution]

Hi

in the EWM system easy access menu, under Interfaces --> Migration from LE-WM, you find several transactions for migrating data.

/scwm/mig_product (warehouse product migration) is the one described in the documentation.

I have never done that myself, so never looked at the details.

Brgds

Juergen

[roman_svoboda]

you can do it directly in /SCWM/BINMAT by copy&paste from excel

1) change mode

2) right click on first column (as in excel maintained)

3) insert with overwrite

[shimank_jain3]

Hi Jasmin,

There is an easy way for mass data upload by excel file into SAP ECC / EWM system.

Below is the steps to be followed for the uploading process :

1. First create the recording for the transaction like ( /N/SCWM/MAT1 )
2. Download your recording into word file.
3. Replace the Input fields with ( MERGE FIELDS Columns in MS Word )

          ( MS Word -> Insert -> Quick Parts -> Field ).

   4.  Create your Excel file with your input records.

   5.  Upload the Excel sheet into MS Word file by step-by-step wizard tool.

   6.  Copy the newly generated file into NOTEPAD File and save it.

   7.  Import the file into SAP System by the help of Created Recording and execute, all the excel data          may upload into SAP System.

Thanks,

Shimank Jain

[jaymin_thakkar05]

Hi Shinmank,

I know how to upload mas data by excel file for "other like transaction".

My question is for /SCWM/BINMAT. Please suggest for the transaction I mentioned, as going further in the transaction data is being updated in database through ALV grid,and as maybe you would be knowing that we cannot record the steps of ALV Grid as it is a Enjoy Control.