/SCWM/R_INITIALSTOCKUPLOAD - Initial Stock Data Transfer

Fill RESBD Structure from EBP Component Structure   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

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 SystemMigration 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 instructure /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 ofyour 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
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 numbersfor a stock item (item type 4). The serial numbers must be assignedto 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 type6, you have to specify the value of field ROW of the relevantstock 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 unitin the CWQUAN and CWUNIT fields. You must also fill out the CWEXACT field, to display whether the catchweight 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.

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 itscontents are in the storage bin 0001-01-01-01. You want the report to findthe numbers of the handling units from the previously defined internal number range interval, thus youdo 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:

BAL Application Log Documentation   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.


Length: 17629 Date: 20120524 Time: 023356     triton ( 208 ms )

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