Supply Chain Management Blogs by Members
Learn about SAP SCM software from firsthand experiences of community members. Share your own post and join the conversation about supply chain management.
cancel
Showing results for 
Search instead for 
Did you mean: 
INTRODUCTION :

Stock upload is a key activity in any SAP EWM project. Sometimes we may get automated methods to build a file but sometimes we must build it from scratch. That’s where this blog will come handy. There could be many ways of building the stock upload csv file and this is one of the method.

SCENARIO :

In this example we are using Single level HU upload with external SSCC number range.

Assuming from business users we get the file in below format:










































































































































SSCC/HU Material Qty UOM Batch Stock type Bin
150333327080313301 250327 120 CS 2304250327 F2 A100
150333327080313370 250327 120 CS 2304250327 F2 A101
150333327080313448 250327 120 CS 2304250327 F2 A102
150333327080313455 250327 120 CS 2304250327 F2 A103
150333327080313653 250327 120 CS 2304250327 F2 A104
150333327080313806 250327 120 CS 2304250327 F2 A105
150333327080313813 250327 120 CS 2304250327 F2 A106
150333327080318887 250881 120 CS 2308250881 F2 A107
150333327080319495 250881 120 CS 2308250881 F2 A108
150333327080319518 250881 120 CS 2308250881 F2 A109
150333327080320064 250881 120 CS 2308250881 F2 A110
150333327080320149 250881 120 CS 2308250881 F2 A111
350333327276044334 203373 120 CS 2305203373 F2 A112
350333327276044341 203373 120 CS 2305203373 F2 A113

In a reference ISU file format, we can see the key indicators:

  1. No of Records in ISU file

  2. HU numbers in HUIDENT and TOPHUIDENT field are duplicated in both the lines. Also, in storage bins are duplicated in both 1st and 2nd row per record.

  3. Material, Batch, quantity fields have 1st line as blank.

  4. Different material can have different packaging materials.



Fig1.ISU Template


Let’s try to address the above requirements:

  1. Create the number of rows *2 as number of HU’s in ISU file from the reference file. In our example we have 14 HU’s so we should have 14*2 =28 rows in ISU file



Fig2.ISU with HU records lines


2. HU numbers in HUIDENT and TOPHUIDENT field + Storage bins

  • In this case we copy the SSCC/HU numbers from Fig1. Stock upload file from Business into an excel in same column back-to-back 2 times. As shown in highlighted yellow and green. This can be done for storage bin also.



Fig3.HU no back to back




  • Add numbers from 1 to n in series in column B for both yellow and green highlighted Hus.



Fig4.Numbers added in series




  • Select the column A and click on ‘sort and filter’ , and sort A to Z.



Fig5.Sort Column A




  • Select ‘Expand selection’ in the pop-up.



Fig6.Expand sorting




  • The HU’s are duplicated back-to-back. We can copy paste the values in ISU file



Fig7.HU duplicated


 

3. Material, Batch, Quantity fields have 1st line as blank.

  • Similarly for Material, Batch, and quantity we can prepare another excel worksheet. Copy the value there in column A only once. And put number series in column B from 1 twice and sort the column B using expand selection. Use the same process for others as shown for material.



Fig8.Material copied with number series in column B




  • Sort the column B and expand the selection. This will show 1st line as blank, and 2nd line with an entry.



Fig9.Sorted material




  • Finally insert a blank row on the top of the excel and copy paste the entry in ISU.



Fig10.Insert blank row




  • At this point the ISU will look like below. For Stock type party entitled, BP use simple drag and drop excel or above options in case its different.



Fig11.ISU till now


 

4. Different material can have different packaging materials.

This could be in same excel file or different as this could be needed for packspec uploads also. Hence assuming it is in different file. In this case we will do ‘vlooup’ function to get the respective packspec into the isu file.


Fig11.Packaging material table


Fig, Pack mat table

  • Keep the cursor on packmat row and type =vlookup to trigger the excel function

  • Look up value ‘material in ISU file column B, in table array A:B in pack mat table, column index =3, value = 0 or false



Fig12.Vlookup function




  • This will bring the correct packaging material from pack mat table.

  • Drag till the end and paste the value and delete N/A values

  • Our final ISU file is ready for upload.



Fig13.Final ISU


 

Save it in .csv format and it is ready to be loaded using /SCWM/ISU transaction. Please keep a note on HU fields and keep them in text format.

Hope you have enjoyed reading this blog to build ISU file formatting using excel. Please like, comment with your valuable feedback. Thanks.

 

Please note :

  • Refer SAP note for csv file : 974852 - Stock data transfer using transaction /SCWM/ISU

  • All the images above taken from Microsoft office 365- Excel. Copyright protected with microsoft.com


 

Please follow SAP EWM Community links:

– Related topics –

https://blogs.sap.com/2019/11/18/initial-stock-upload-ewm-scwm-isu/

https://blogs.sap.com/2014/05/19/initial-stock-upload-in-ewm/

– Ask questions about SAP Extended Warehouse Management and follow (https://answers.sap.com/tags/01200615320800000705)

– Read other SAP Extended Warehouse Management and follow blog posts (https://blogs.sap.com/tags/01200615320800000705/)

 

 
Labels in this area