Kontakt

Ansicht
Dokumentation

/SCWM/R_INITIALSTOCKUPLOAD - Initial Stock Data Transfer

/SCWM/R_INITIALSTOCKUPLOAD - Initial Stock Data Transfer

ROGBILLS - Synchronize billing plans   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
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 category 1 - Highest-lvl HU 2 - HU 3- Aux. pack. mat. 4 - Stock
MATNR   X X
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   X X
UNIT   X X
HUTYP X X  
LGPLA X   O
GR_DATE     O
GR_TIME     O
VFDAT     O
PMAT X X  
EXTNO O O O
HUIDENT X X X O
PARENTHUIDENT   X  
TOPHUIDENT X X X O
ROW X X X X
REFROW    
G_WEIGHT O O O
N_WEIGHT O O O
UNIT_GW O O O
T_WEIGHT O O O
UNIT_TW O O O
G_VOLUME O O O
N_VOLUME O O O
UNIT_GV O O O
T_VOLUME O O O
UNIT_TV O O O
G_CAPA O O O
N_CAPA O O O
T_CAPA O O O
LENGTH O O O
WIDTH O O O
HEIGHT O O O
UNIT_LWH O O O
MAX_WEIGHT O O O
TOLW O O O
TARE_VAR O O O
MAX_VOLUME O O O
TOLV O O O
CLOSED_PACKAGE O O O
MAX_CAPA O O O
MAX_LENGTH O O O
MAX_WIDTH O O O
MAX_HEIGHT O O O
UNIT_MAX_LWH O O O
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.

POSTYPE PRODUCT OWNER OWNER_ROLE ENTITLED ENTITLED_ROLE QUAN UNIT HUTYP LGPLA PMAT HUIDENT PARHUIDENT TOPHUIDENT ROW
1         PAL 0001-01-01-01 PALLET 1   1 1
2         BOX   BOX 2 1 1 2
4 Product01 BP01 BP BP01 BP 10 PC     2   1 3
4 Product02 BP01 BP BP01 BP 10 PC     2   1 4

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:

POSTYPE PRODUCT OWNER OWNER_ROLE ENTITLED ENTITLED_ROLE QUAN UNIT HUTYP LGPLA PMAT HUIDENT PARHUIDENT TOPHUIDENT ROW
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






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: 19311 Date: 20240426 Time: 204843     sap01-206 ( 121 ms )