SAP® Documentation

Single view

/SCWM/R_INITIALSTOCKUPLOAD - Initial Stock Data Transfer

General Material Data   General Material Data  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

You can use this report to perform an initial stock data transfer from an old system into the Warehouse Management system.

Either you transfer the data using the Legacy System Migration Workbench, or you create a file in .CSV format (Comma Separated Values) that contains the data to transfer.

During the import, this report checks the data available. If the data contains no errors, these can be posted/updated in the system. If the data contains errors, the report lists the error messages in a log.

Integration

Prerequisites

If you transfer the data using the Legacy System Migration Workbench, you must select the object 0225 Warehouse Stock (EWM). You then process the individual work steps in sequence.

If you transfer the data by creating a .CSV file, the structure of this file must match the fields in structure /SCWM/S_STOCK_UPLOAD_EXT. During the data import, the system ignores the first line of this file, since it normally contains the column headers.

You can use this report to import various item categories, in order to map the physical structure of your stocks, for example, stocks directly in storage bins, stocks in (nested) handling units, handling units in storage bins, and handling units with auxiliary packaging materials in storage bins.

The following table shows you the various item categories with their mandatory (X) and optional (O) fields. You can map the hierarchy of a handling unit using the fields HUIDENT, PARHUIDENT, and TOPHUIDENT.

Item category1 - Highest-lvl HU2 - HU3- Aux. pack. mat.4 - Stock
MATNR XX
OWNER  X
OWNER_ROLE  X
BATCH  O
CAT  X
STOCK_DOCCAT  O
STOCK_DOCNO  O
STOCK_ITMNO  O
STOCK_USAGE  O
ENTITLED  X
ENTITLED_ROLE  X
COO  O
QUAN XX
UNIT XX
HUTYPXX 
LGPLAX 
GR_DATE  O
GR_TIME  O
VFDAT  O
PMATXX 
EXTNOOOO
HUIDENTXXXO
PARENTHUIDENT X 
TOPHUIDENTXXXO
ROWXXXX
REFROW  
G_WEIGHTOOO
N_WEIGHTOOO
UNIT_GWOOO
T_WEIGHTOOO
UNIT_TWOOO
G_VOLUMEOOO
N_VOLUMEOOO
UNIT_GVOOO
T_VOLUMEOOO
UNIT_TVOOO
G_CAPAOOO
N_CAPAOOO
T_CAPAOOO
LENGTHOOO
WIDTHOOO
HEIGHTOOO
UNIT_LWHOOO
MAX_WEIGHTOOO
TOLWOOO
TARE_VAROOO
MAX_VOLUMEOOO
TOLVOOO
CLOSED_PACKAGEOOO
MAX_CAPAOOO
MAX_LENGTHOOO
MAX_WIDTHOOO
MAX_HEIGHTOOO
UNIT_MAX_LWHOOO
SERID
CWQUAN  O

CWUNIT,,,,,,,,O

CWEXACT,,,,,,,,O

ZEUGN  O 

In addition, you can use item type 6 to specify serial numbers for a stock item (item type 4). The serial numbers must be assigned to a stock item for the data being processed. For this, specify a link using columns ROW and REFROW. You must count up the ROW column for each line of data. If you specify a serial number using item type 6, you have to specify the value of field ROW of the relevant stock item (item type 4) in the REFROW field. You must also specify the serial number in the SERID field.

If the stock item involved is a catch weight product, you must enter the catch weight quantity and unit in the CWQUAN and CWUNIT fields. You must also fill out the CWEXACT field, to display whether the catch weight quantity is measured (A) or not measured (B). Alternatively, you can leave all these fields blank. The catch weight quantity is then calculated based on the planned factor from the product master.

If the stock is located in a pallet storage and the storage bins are subdivided, you must enter the storage bin including the suffix for example 0070-01-01/1. If the sub bins do not exist yet, they will be created according to the section of the bin type and the HU type that is determined.

Features

Selection

Standard Variants

Output

Activities

Example

You want to map a pallet that contains a box. The box should contain 10 pieces of the products Product01 and Product02. The pallet and its contents are in the storage bin 0001-01-01-01. You want the report to find the numbers of the handling units from the previously defined internal number range interval, thus you do not set EXT_NO. When you set EXT_NO, the report takes the numbers of the handling units from the previously defined external number range interval.

Note that the following example only lists the required fields in the structure.

POSTYPEPRODUCTOWNEROWNER_ROLEENTITLEDENTITLED_ROLEQUANUNIT HUTYPLGPLAPMATHUIDENTPARHUIDENTTOPHUIDENTROW
1    PAL0001-01-01-01PALLET1 11
2    BOX BOX2112
4Product01BP01BPBP01BP10PC  2 13
4Product02BP01BPBP01BP10PC  2 14

To place the stock from the above example into storage bin 0001-01-01-01 without using handling units, you merely need to make the following entries:






SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.

Length: 19191 Date: 20191215 Time: 064536     sap01-206 ( 42 ms )

Our Service

Looking for Support? Questions?

The

Consolut

Callback-Service

Leave us your contact details and we will call you back. Panels marked with * are mandatory.

POSTYPEPRODUCTOWNEROWNER_ROLEENTITLEDENTITLED_ROLEQUANUNIT HUTYPLGPLAPMATHUIDENTPARHUIDENTTOPHUIDENTROW
4Product01BP01BPBP01BP10PC 0001-01-01-01  1
4Product02BP01BPBP01BP10PC 0001-01-01-01  2