Initial Stock Data Transfer
You can use report /SCWM/R_INITIALSTOCKUPLOAD
to perform an initial stock data transfer in Extended Warehouse Management (EWM). There are two ways to copy existing data:
You upload a local comma-separated values file (CSV file), which contains the data that EWM is to copy.
The structure of this file must correspond to the fields of structure /SCWM/S_STOCK_UPLOAD_EXT
. When EWM imports
the data, the system ignores the first line of this file, as it usually contains the column headers.
You upload a file from an application server, which contains the data that is to be transferred by EWM.
In this case, EWM uses a connection to the Legacy System Migration Workbench (LSMW). For more information about the LSMW, see SAP Library under .
You have defined all storage bins for which you want to transfer stock data. In Customizing for EWM, choose Master Data
.
If you use the LSMW for the data transfer, you must select object 0225 Warehouse Stock (EWM)
in the LSMW. Work through the individual process steps sequentially in LSMW.
Note
If you are using a template for your product numbers, you have to specify the products in file you want to upload without this template.
When EWM imports the data, the system checks the data. If the data contains no errors, you can then post it in EWM. If the data contains errors, EWM displays the error messages in a log.
If you want to copy existing data using a file, you can map the physical structure of your stock in the file. You can import different item categories, for example:
Stock directly in storage bins
Stock in handling units (HUs) in storage bins and stock in nested HUs in storage bins
HUs with auxiliary packaging materials in storage bins
You can specify valid UoMs for the given product in the column UNIT. If you specify an alternative UoM other than the base UoM, the system creates the stock in that UoM. This alternative UoM can be used for processes connected to the stock-specific UoM feature.
The following table shows the different item categories that you can use in the file. All fields that you must specify for the respective item category are marked with an X, and all field that are optional are marked with an O. If you want to upload stock to HUs, you must specify the storage
bin in the column 1 Highest-Level HU
. If you want to load stock without HUs, you must specify the storage bin in the column 4 Stock
. This is indicated in the following table with an (X)
symbol.
You can map the hierarchy of an HU using the fields HUIDENT
, PARHUIDENT
and TOPHUIDENT
.
Item Category |
1 Highest-Level HU |
2 HU |
3 Auxiliary Packaging Material |
4 Stock |
|---|---|---|---|---|
|
x |
x |
||
|
x |
|||
|
x |
|||
|
O |
|||
|
x |
|||
|
O |
|||
|
O |
|||
|
O |
|||
|
O |
|||
|
x |
|||
|
x |
|||
|
O |
|||
|
x |
x |
||
|
x |
x |
||
|
x |
x |
||
|
x |
(X) |
||
|
O |
|||
|
O |
|||
|
O |
|||
|
x |
x |
||
|
O |
O |
O |
|
|
x |
x |
x |
O |
|
x |
|||
|
x |
x |
x |
O |
|
x |
x |
x |
x |
|
||||
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
O |
O |
O |
|
|
||||
|
O |
|||
|
O |
|||
|
O |
|||
|
O |
You can set the value X in the file in the column EXT_NO
. This allows EWM to use the specified external numbers for HUs. Prerequisite for this is that the external number lies within an external number range interval
that you have defined in Customizing for EWM under Define Number Ranges for HU Identification
. For more information, see Customizing for EWM under .
If you specify item category 6
in the file, you can specify serial numbers for a stock item with item category 4
by connecting the values in columns ROW
and REFROW
with
each other. To do this, proceed as follows:
If you specify a serial number with item category 6
, you must specify in the row of the serial number in field REFROW
the value of the field ROW
in the row of the related stock item as a reference
to item category 4
. By doing this, you assign the serial number to a stock item that is valid for the data that you want to process.
Count the columns ROW
up for every data row so that the row is unique.
You must also specify the serial number in the SERID
field.
If the stock item belongs to a product that is relevant for Catch Weight, you must specify the catch weight quantity and its unit in the fields CWQUAN
and CWUNIT
.
If you want to display the fact that the catch weight quantity was measured, you must specify the CWEXACT
field.
You can also make no entries in all of the above fields. In this case, EWM calculates the catch weight quantity and uses the planned factor from the product master for it.
You want to map a pallet that contains a box. This box contains 10 pieces of product 01 and 10 pieces of product 02. The pallet and its contents are located in storage bin 0001-01-01-01. You do not make an entry in the column EXT_NO
. EWM assigns
numbers for the HUs from the internal number range interval that you previously defined in Customizing for EWM. The following list shows you the required fields that you must specify in the file:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 |
PAL |
0001–01–01–01 |
BOX |
1 |
1 |
1 |
||||||||
2 |
BOX |
BOX |
2 |
1 |
1 |
2 |
||||||||
4 |
Product01 |
BP01 |
BP |
BP01 |
BP |
10 |
PC |
0001–01–01–01 |
||||||
4 |
Product02 |
BP01 |
BP |
BP01 |
BP |
10 |
PC |
0001–01–01–01 |
You want to bring the same stock mentioned in the example above to storage bin 0001-01-01-01, however, you do not want to use HUs. The following table shows you the data that you need to enter to achieve this:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4 |
Product01 |
BP01 |
BP |
BP01 |
BP |
10 |
PC |
0001-01-01-01 |
1 |
|||||
4 |
Product02 |
BP01 |
BP |
BP01 |
BP |
10 |
PC |
0001-01-01-01 |
2 |