Show TOC

Function documentationInitial 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 Start of the navigation path SAP ERP Next navigation step SAP Oil & Gas Next navigation step SAP Oil & Gas (IS-Oil Downstream) Next navigation step Integration of SAP Oil & Gas with SAP CRM Next navigation step F&A Pricing in Integration with SAP CRM Next navigation step Legacy System Migration Workbench End of the navigation path.

Prerequisites

  • 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.

Features

Note 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.

End of the note.

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

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

(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

Specifying HU Numbers

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 Start of the navigation path Cross-Process Settings Next navigation step Handling Units Next navigation step External Identification Next navigation step Define Number Ranges for HU Identification End of the navigation path.

Specifying Serial Numbers

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.

Specifications for Catch-Weight-Relevant Products
  • 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.

Example

Example of a File Structure for the Stock Data Transfer

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:

ITEM_CAT(Item Category)

PRODUCT (Product)

OWNER(Owner)

OWNER_ROLE(Owner Role)

ENTITLED(Party Entitled to Dispose)

ENTITLED_ROLE(Role of Party Entitled to Dispose)

QUAN(Quantity)

UNIT(Unit)

HUTYP (HU Type)

LGPLA (Storage Bin)

PMAT(Packaging Material)

HUIDENT(HU Identification)

PARHUIDENT (Higher-Level HU Identification)

TOPHUIDENT(Highest-Levell HU Identification)

ROW(Row)

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:

ITEM_CAT(Item Category)

PRODUCT (Product)

OWNER(Owner)

OWNER_ROLE(Owner Role)

ENTITLED(Party Entitled to Dispose)

ENTITLED_ROLE(Role of Party Entitled to Dispose)

QUAN (Quantity)

UNIT(Unit)

HUTYP (HU Type)

LGPLA (Storage Bin)

PMAT(Packaging Material)

HUIDENT(HU Identification)

PARHUIDENT (Higher-Level HU Identification)

TOPHUIDENT(Highest-Levell HU Identification)

ROW(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