EWM – Initial stock upload of Multi level Handling Units with respective products and batches.
AS a consultant we may come across few scenarios where customer or client ask us to upload the initial stock to EWM with multi level Handling Units with respective products and batches. As you know every consultant must have know that we upload through /SCWM/ISU transaction but we feel some discomfort in filling up the Upload CSV file format .
In this blog I will show the format and how to fill and upload to the system.
For this we will go with one example like One HU ( nested HU) is having multiple HUs in it and that individual Hus having the product with respective batch in it.
Nested HU – 900000100
Individual Hus in above Nested HU are – 300000100
To achieve this we have to go with following steps :
- Initial Stock Upload format with Detailed explanation of how to fill.
- Upload process
- Initial Stock Upload format with explanation.
SAP note 2483936 provides templates for uploading initial stock into SAP S/4HANA embedded extended warehouse management system.
In the downloaded input file from above SAP note , keep the header record and delete the remaining rows and enter data in the rows as follows for our case.
Row number 1 Populate the below fields:
POSTYPE, HUTYP, LGPLA, PMAT, EXTNO, HUIDENT, TOPHUIDENT, ROW
POSTYPE should be populated with value 1.
POSTYPE represents item category and value 1 means ‘Highest-level HU’. and fill above remaining files as below.
POSTYPE -1 enter only nested HU in all HU fields as shown above.
ROW NUMBER 2 Populate the below fields:
POSTYPE, MATNR, OWNER, OWNER_ROLE, BATCH, CAT, ENTITELED, ENTITLED_ROLE, QUAN, UNIT, LGPLA, HUIDENT, TOPHUIDENT, ROW
POSTYPE must be populated with value 4.
POSTYPE represents item category and value 4 means ‘Material’. And fill remaining fields as below.
As shown above in POSTYPE-2 fill HUIDENT filed as your Individual Sub HU( 300000100) and PARENTHUIDENT and TOPHUIDENT as your nested HU (900000100).
Repeat the POSTYPE-2 row for your all your sub HUs as shown above. ( 300000100,300000200 & 300000300).
Denote Row filed from 1 to till all your entries.
ROW NUMBER 4 Populate the below fields:
POSTYPE, MATNR, OWNER, OWNER_ROLE, BATCH, CAT, ENTITELED, ENTITLED_ROLE, QUAN, UNIT, HUIDENT, TOPHUIDENT, ROW, REFROW, SERNR
POSTYPE should be populated with value 6.
POSTYPE represents item category and value 6 means ‘Serial Number’.
As shown above POSTYPE-4 fill your material, qty, batch ,HU and remaining fields.
Save this file as a CSV file.
2) Upload process in to SAP:
As shown below go to transaction /SCWM/ISU.
Input warehouse number and select radio button for Local file , click the file icon to select our CSV file as below.
Now click on Upload .
If our CSV file do not contain any errors then once we click Upload button line items status will show as Green signal as shown in above .
Now we will click Execute button to upload in the system.
Stock is now uploaded in system we can see this HU string as shown below.
Conclusion: By above detailed explanation of CSV Upload file rows with fields , now you have got a basic idea of how to upload the multi levels HUs with respective products and batches in the system.
I love to hear your queries and comments on this blog .
References for preparing the CSV :